Skip to main content
Get a Quote
Course Enquiry
Contact Us

Details

Business Intelligence has its own unique requirements from a data model. Data must be structured in such a way as to serve the business goals of the system.

A Data Model is created from disparate sources using ETL (Extract Transform Load) in Power Query (used by Microsoft Products like Power BI and Excel). Power Queries are written in a formula language called M.

In this course, we will discuss some of the principles of data modeling and practically write M Language Power Queries.   After this course you will be able to:

  • Design a data model
  • Write M Language Power Queries.
  • Create Data Models using disparate sources.

Base Cost

$383.00

Calculate Discount

  I will bring my own PC (less $33.00)
  I will book and pay 10 business days before the course (less $38.30)

Total

$
If you are currently resident in South Africa you will need to pay VAT at 15%.

Duration:

1 day

Brochure:

Download Brochure


Information may change without notice.

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. Contact hours are between 9am to 4pm.

Audience

Users of:

  • Microsoft Power BI Desktop
  • Microsoft Excel Power Pivot

Pre-Requisites

The Power BI boot camp 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.

Course Outline / Curriculum

  • Data modeling
    • Star schema design principals
    • Active and inactive relationships
    • Relationship directions
    • Hierarchies
  • M Language and ETL
    • What is Power Query? 
    • Query Folding 
    • How Power Query helps with data acquisition 
    • Editing M Query 
    • Editor 
    • Understanding M 
    • Simple M Language Example 
    • Types 
    • Values 
    • Data Types Examples 
    • M Functions 
    • Text Functions 
    • Text.Select 
    • Text.PositionOf Text.Range 
    • Table and Record Functions 
    • Table.ToRecords 

Schedule Dates and Booking

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

Start Date Branch Duration  
Thu 16 Jan 2020 Woodmead 1 day Book Now
Thu 13 Feb 2020 Woodmead 1 day Book Now
Thu 12 Mar 2020 Woodmead 1 day Book Now
Thu 14 May 2020 Woodmead 1 day
Thu 11 Jun 2020 Woodmead 1 day
Thu 16 Jul 2020 Woodmead 1 day
Thu 13 Aug 2020 Woodmead 1 day
Thu 10 Sep 2020 Woodmead 1 day
Thu 15 Oct 2020 Woodmead 1 day
Thu 12 Nov 2020 Woodmead 1 day
Thu 10 Dec 2020 Woodmead 1 day