GRC-101FT: An Analytical Journey with Microsoft Power BI [Fastrack]

Name: GRC-101FT: An Analytical Journey with Microsoft Power BI [Fastrack]
Brand: GemRain

RM3,000.00

Choose Date

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. It is part of the Microsoft Power Platform.
 
 
Training Duration: 2 Days
Certificate Of Completion Available
Group Private Class
VILT Class Available
SBL-Khas Claimable
 
Download Course Outline
 
Looking for function and formula for Power BI, may visit Conquering DAX 2019 [Fastrack] or may check out the entire series and blogs at Honing Your Skills On Microsoft Power Platform

This instructor-led adventurous workshop is designed for audiences to be equipped with the necessary knowledge and skills to kickstart their analytical journey with Microsoft Power BI. You will be guided from the stage of connecting data, transforming data, and visualizing your data.
After completing this course, students will be able to:

Describe key features of Microsoft Power BI

Understand how data are connected to Microsoft Power BI

Massage, cleanse, format and transform data

Visualizing data using reports and dashboards
Module 1: Microsoft Power BI as a Service

What is Power BI?

The Power BI service and its ecosystem

Product and subscription information

Familiarizing with Microsoft Power BI app and service

Module 2: Getting to Know Your Data

Using Excel as a Power BI data source

Using databases as a Power BI data source

Understanding the Power BI dataset

Importance of table relationships

Module 3: Data Transformations using Power Query

Power BI Desktop queries

Cleansing data and transformations

Consolidation of data through appends and merges

Module 4: Introduction to DAX

What is DAX?

Calculated columns vs. measures

What are quick measures?

Performing simple calculations

Module 5: Visualizing Your Data

Creating Power BI reports

Creating Power BI dashboards

Common visuals and their usage

Selections and Bookmarks