(PB102) Advanced Power BI with DAX and M



Kursarrangør: Profitbase AS
Sted: Akershus, Bærum / Sandvika
Akershus
Kursadresse: Martin Linges vei 25, 1364 Fornebu (kart)
Type:Åpent kurs / gruppeundervisning
Undervisningstid: På forespørsel
Varighet: 2 dager
Pris: 8.000

Vi tilbyr kurs i (PB102) Advanced Power BI with DAX and M.

Course Outline:

Module 1 - Data Modeling:
• Overview and purpose
• Facts and dimensions
• Relationship direction and cardinality
• Associative entities ("many-to-many" relationships)
• Preparing for row-level security

Module 2 - Power Query "M" and the Query Editor:
• Data cleanup and transformation
• Pulling structured and unstructured data from Excel spreadsheets, application exports, and websites
• Connecting to relational databases, such as SQL Server, MySQL, SAP HANA, and Oracle
• Creating your own dimensions from flat-file data
• Common operators and functions
• Creating your own custom functions
• Leveraging data from document-oriented sources (e.g. JSON and XML)
• Mashing up data from different sources

Module 3 - DAX:
• Relational measures and calculations
• When to use calculated columns vs measures
• Leveraging quick measures
• Time intelligence patterns on calendar periods and fiscal periods
• Implementing row-level security

Prerequisites and basic training:
• Attendees will need a solid grasp of Power BI Desktop´s basic functionality
• We can provide full basic training "Dashboard in a Day" or short-session refreshers