
About this Course
Syllabus
About this Course
Power BI is a business intelligence and data visualization platform. It enables the creation of analytical reports and interactive dashboards using many different data sources.
The course focuses on advanced capabilities that PBI offers, including – complex visualizations, advanced data modeling, working with DAX, Python integration and more.
Audience
The course is mainly intended for analysts, data scientists and BI professionals who are experienced in Power BI and want to deepen their knowledge and enhance their capabilities
Prerequisites
Previous experience and background in Power BI
- Group Categorical Data
- Bin Numeric Data
- Using Formulas
- Dynamic Titles
- Using the Analytics Pane
- Custom Tooltips
- Create Report Drillthrough
- Apply Filters
- Create and Configure Buttons
- Create and Configure Bookmarks
- Create a State Analysis
- Chapter Introduction – Advanced Power Query
- Custom Combine Files from Folder
- Rebuild Combine Files from Folder
- Running Totals
- Grouped Index
- Build Dynamic Elements
- DAX Functions for Advanced Data Modeling
- Visual Dimension & Measure
- Multi-Relationship Visual Dimension
- Dynamic Date Hierarchy Drill
- Dynamic Metric Selection
- Create & Configure Filter Dimension in Power Query
- Create the Category – Filter DAX Measures
- Generate a Summary with a Smart Narrative
- Create & Configure Q&A Visual
- Analyze to Explain the Increase or Decrease
- Identify Key Influencers
- Using Decomposition Tree
- Detect Anomalies
- Forecast Future Values
- Generate Insights
- Download & Connect Python to Power BI
- Create Data with a Python Script
- Import External Data with Python
- Run a Python Script in Power Query