Get a Quote
Course Enquiry
Contact US
Leading Edge Training

Microsoft Power BI Desktop Advanced Course Course Details


This course:

  • Makes use of the free Microsoft Power BI Desktop application
  • Concentrates on the creation of data models and the manipulation of data: o Transforming Data Sets o Data Cleansing o Data Mashup o Creating Data Models o Extending the data with Calculated Columns and Measures o Analyzing data over Time
  • Gives the delegates an overview of using diverse data sources, as well as an introduction to the creation of Organizational Content Packs
  • Will make some use of DAX

Audience:

IT staff, technical business analysts, database administrators, data analysts, BI specialists, knowledge workers, and those involved in the maintenance of the master data model of the company

Pre-Requisites:

The Power BI Desktop course is a pre-requisite for the course. Alternatively, delegates should have at least 3 months experience in using Power BI Desktop for creating reports and dashboards The delegates be experienced in accessing different data sources, including Excel workbooks and Microsoft SQL Server. The delegates may have experience in building data models, using ETL, cleaning data and creating new data columns and measures.

Duration:

3 day

Price:

$660.00 If you are currently resident in South Africa you will need to pay VAT at 14%.   *Discount available

PC Hire:

$75   *Bring a PC

Note: information may change without notice.

About Microsoft Power BI Desktop Advanced Course

You are an experienced user of reporting systems, and need to use Microsoft Power BI to define and extend data models for use by business users of Power BI Desktop You need to define data models, enhance data with calculated columns and measures, clean data, use ETL and analyze data over time

Course Outline


Course Outline: 

  • Loading data with Power BI Desktop (Review)
    • Text files
    • Excel workbooks
    • Microsoft Access databases
    • SQL databases
    • Google Analytics
    • Web pages containing tables
    • Microsoft SSRS and SSAR
    • ODBC drivers
  • Transforming datasets
    • Power BI queries
    • Query or Load
    • Dataset shaping
    • Filtering data
  • Data Cleansing
    • View full data record
    • Grouping records
  • Data Mashup
    • Extending data
    • Duplicating columns
    • Splitting columns
    • Merging columns
    • Custom columns
    • Index columns
    • Merging data
    • Appending data
    • Change the data structure
    • Managing the transformation process
    • Managing queries
    • Pending changes
    • Copying data from Power BI Desktop
  • Creating a data model
    • Data modelling in the Power BI Desktop environment
    • Data model or query
    • Managing Power BI Desktop data
    • Power BI Desktop data types
    • Formatting Power BI Desktop data
    • Preparing data for dashboards
    • Sorting data in Power BI Desktop tables
    • Adding hierarchies
    • Designing a Power BI Desktop data model
  • Extending the data model with calculated columns
    • Types of calculations
    • New columns
    • Concatenating column contents
    • Tweaking text
    • Simple calculations
    • Calculating across tables
    • Using functions in new columns
    • Simple logic: IF() function
    • Making use of the formula bar
  • Adding measures to the data model
    • First measure: number of cars sold
    • Basic aggregation in measures
    • Using multiple measures
    • Cross-table measures
    • Advanced aggregations
    • Filter context
    • Filtering data in measures
    • Simple and complex filters
    • Calculating percentages of totals
    • Filtering on measures
    • Displaying rank
    • Notes on using measures
    • Calculation options
  • Analyzing data over time
    • Simple date calculations
    • Adding time intelligence to a data model
    • Creating and applying a date table
    • Applying time intelligence
    • Comparisons with previous time periods
    • Comparison with a parallel period in time
    • Rolling aggregations over a period of time
  • Managing data sources (overview)
    • On-premise gateways
    • Refreshing data
    • Organizational content packs
    • Security
    Managing Power BI environments (overview)
    • PBIX files
    • Microsoft OneDrive and Dropbox
    • PowerBI.com and PowerBI.com Pro

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Light finger meals are supplied for part time courses.

Scheduled Dates


To apply for a booking, click on the relevant "Book Here" link below.
Note: places are only fully secured once payment has been made.

Start DateDuration 
Wed 16 Aug 20173 daysBook Here
Wed 18 Oct 20173 daysBook Here

Provisional Dates

These dates have not yet been confirmed. If you are interested in attending please click here to enquire.

Start DateDuration
Tue 13 Jun 20173 days