Power BI Desktop

Duration: 1 month

Cost R 8 500 (vat inclusive)

Non credit bearing

Who should attend

CA, Managers ,Business intellegence analysts,etc

Course modules

1.     Getting started

What is Power BI Desktop?
Overview
Quickstarts
Connect to data in Power BI Desktop
Sample data for Power BI
Retail Analysis sample
Sales and Marketing sample
Importing data
Excel as a source
Web as a source
CSV as a source
Entering data directly
Importing Excel Workbook
DirectQuery
SQL Server as a source
Which to use and when (Importing data; DirectQuery; Live Connection)?

2.     Data Transformation

About Query Editor

The Power Query Editor (EXCEL & POWER BI)
Basics data transformation

3.     Building the Data Model

Power Pivot MS EXCEL
Create and manage relationships with Power BI
Creating a new relationship
Editing relationships

4.     Leveraging DAX

Apply DAX basics
Columns Calculations
Basics: Calculated measures

5.     Visualizing Data

Create and use basic area charts
Create card visuals (big number tiles)
Create and use combo charts
Create and use doughnut charts
Create and use KPI visuals

6. Introduction to Dashboard

Differentiate between dashboard and report
Create the dashboards
Import entire report into dashboard

Learning resources

“All training material are available online per each module
To access learner pack click on www.sannahholding.co.za/modules”
4.course management
The course comprises formal lectures, practical case studies and presentations by specialists from industry.

Course fee

“Deposit Fee R 1000,
Cost R8 500.00 (vat inclusive) per individual payable in 4 equal instalment ”

enrolment and enquries

Submissions can be done electronically or in person. An application form and a certified copy of the ID / passport document must be submitted. send your electronic submission electronically to info@sannahholding.co.za Application accepted throughout the year