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.
Calculate DiscountI will bring my own PC (less $33.00)
I will book and pay 10 business days before the course (less $38.30)
If you are currently resident in South Africa you will need to pay VAT at 15%.
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.
- Microsoft Power BI Desktop
- Microsoft Excel Power Pivot
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
- M Language and ETL
- What is Power Query?
- Query Folding
- How Power Query helps with data acquisition
- Editing M Query
- Understanding M
- Simple M Language Example
- Data Types Examples
- M Functions
- Text Functions
- Text.PositionOf Text.Range
- Table and Record Functions
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.
|Thu 13 Feb 2020||Woodmead||1 day||Provisional|
|Thu 12 Mar 2020||Woodmead||1 day||Scheduled||Book Now|
|Thu 14 May 2020||Woodmead||1 day||Provisional|
|Thu 11 Jun 2020||Woodmead||1 day||Provisional|
|Thu 16 Jul 2020||Woodmead||1 day||Provisional|
|Thu 13 Aug 2020||Woodmead||1 day||Provisional|
|Thu 10 Sep 2020||Woodmead||1 day||Provisional|
|Thu 15 Oct 2020||Woodmead||1 day||Provisional|
|Thu 12 Nov 2020||Woodmead||1 day||Provisional|
|Thu 10 Dec 2020||Woodmead||1 day||Provisional|