MS POWER BI TRAINING - ADVANCED

Description:  

This course is designed to familiarise the attendees with Advanced features in MS Power BI used for Advanced analytics and data understanding, as well as more advanced concepts used for model building. It instructs participants whom collaborates with key stakeholders across verticals to identify business requirements, cleans and transforms data, and then designs and builds data models using MS Power BI generating useful analytics that would aid in generating insights from the dataset.

Objectives: Using appropriate data, introduce delegates to:  

• Customize Power BI visuals using Python and R
• Role Level Security using Nested Measure Functions with Logic Operators
• Importing Data Types while navigating Power Query Editor using M Code & Mathematical functions
• Data Modelling using the above with Star & Snowflake Schema
• Time Intelligence Modelling
• Building models to represent these relationships, with Python and R

Outcome:

Delegates will leave the sessions with an excellent theoretical and practical understanding of Power Query and writing Custom Expressions using DAX & M Code, but also integrating R and Python. Applying these in an operational and business context.

Session 1: Customization of Visuals & R or 

Python Visuals

Session 2: Building Measures, CALCULATE & SELECTEDVALUE functions and more

Session 3: M Coding with Power Query Editor

Session 4: Modelling with DAX Code, Star Schema, Snowflake Schema & Time Intelligence

Four, 1.5-hour Sessions

09:00 – 10:30 Lesson(s) 

10:30 – 11:00 Break 

11:00 - 12:30 Lesson(s) 

Prerequisite:

Introduction to MS Power BI Training for Beginners, Intermediate or MS Power BI Fundamentals Training