INTRODUCTION FOR ANALYZING AND VISUALIZING DATA WITH POWER BI (ADVANCED LEVEL)

Data visualization using Power BI allows you to represent information digitally and graphically, to
convey the results of data analysis. In this course, the trainer will guides you through the advanced
capabilities of the service. She shows how to work with calculations, leverage the DAX language,
create advanced queries, and use the M language to improve the querying process. She demonstrates how to import data from various sources, compose advanced formulas, manage the
fields and columns in tables, use X-factor functions, use conditional statements, filter results, design charts, and more.

TARGET AUDIENCE
This course is for individuals whose job responsibilities include creating complex Excel reports, as
well as conducting advanced analytics and data science.

LEARNING OUTCOME
After completing this course, students will be able to:

• Perform advanced analytics with DAX
• Manage the connection among Power BI Desktop, Power BI Cloud & Power BI Mobile
• Work with parameters
• Perform Data Fetching using R scripts
  Set Row-Level Security
• Use Python & R in Power BI
• Use M Query to query data sources, clean and load the data
• Manage different data relationships
• Share data analysis
• Connect different data sources

PREREQUISITES
Basic-Intermediate Power BI Skils

COURSE OUTLINE
Module 1: Data Analysis Expression (DAX)

• What is DAX?
• Measures vs. Calculated Columns
• DAX Creation
• Aggregation Function
• Row based calculations

Module 2: MORE ON DAX

• Using CALCULATE Function
• FILTER in CALCULATE Function
• ALL, ALL SELECTED, ALLEXCEPT
• Using Logical Operators
• Formatting & Commenting
• Using VariablesTime Intelligence

Module 3: Data Transformation

• Power Query Editor
• About References and Duplicating
• Mathematical Operations
• Run R Script
• Using Parameter for dynamic data transformation
• What is M Formula
• Values, Lists & Tables in M Formula
• Functions in M Formula

Module 4: Data Model (Relationship)

• Why Data Model is important?
• Data Normalization
• Data Denormalization
• Relationship creation
• One-to-many relationship
• One-to-one relationship
• Many-to-many relationship
• Cross filter direction
• Data Visualization
• Creating Visuals
• Use External Visuals
• Work with Custom Visuals
• Filter Pane
• Cross filtering
• Syncing slices across pages
• Buttons & Actions
• Get data using R Script & R Script Visual

Module 5: Power BI & Python

• Introduction to Python
• Setting up Python
• Data Transformation using Python
• Visualization using Python
• Wring Python Script

Module 6: Power BI Cloud

• Introduction to Power Bi Service
• Your workspace in Power Bi Service
• Connecting Power BI Desktop & the Cloud
• Datasets and Reports in the cloud
• Updating reports from Power BI Desktop
• Using Data Gateway
• Sharing to Power Bi Mobile App

Module 7: Row-Level Security (RLS)

• Row-Level Security in the cloud
• Dynamic Row-Level Security
• Dynamic Many-to-many RLS
• Hierarchical Row-Level Security

HOW TO SEND US AN ENQUIRY?

1. Fill in the form below and submit it to us. A popup message “Thank you for your message, our sales person will contact you soon.” will appear after a few seconds.
2. Initiate a conversation via live chat on the bottom left of our website by stating: ‘Hi, my name is [your-name]. I’ve already submitted the form for this training.’
3. We’ll promptly reach out to you regarding the training you’re interested in.