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.
COURSE OBJECTIVES
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 CONTENT
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
