Introduction to Power BI Desktop
  • Important Concepts
  • Introduction to Power BI
  • Power BI Set up
  • Importing Data into Power BI Desktop
  • Data Import Practice
  • Where is the data stored?
Cleaning up the data
  • The Eleven Commandments of Good Data
  • How to clean up cross-tab data
  • How to clean up multiple cross-tab data
  • Combine Multiple cross tabs in Power Query
  • Combining Data from multiple Sheets or Files
  • Import data from PDF
  • Power BI Data
Creating a Cohesive Database
  • Eliminating VLOOKUP using Relationships
  • Adding Calculated Columns
Working with Dates
  • Working with Dates Overview
  • Creating a custom Date Table
Creating Reports in Power BI Desktop
  • Creating reports
  • Filtering Reports
  • Publishing Reports to Power BI Portal
  • Keeping the Reports updated
  • Viewing the Data behind the Visualization
  • Quiz Time
Working with DAX
  • Calculated Columns
  • Text Grouping and RELATEDTABLE
  • Bin Analysis
  • New Measure or New Column - Which one to use when?
  • Time Intelligence - Comparing current data with the past
  • Dax Quiz
Practical Scenarios
  • Comparing Budget vs Actuals
  • Use AI to understand rise and fall of business parameters
Powerful Features of Power BI
  • Facebook Analytics
  • Natural language Q&A: Just type a question and create a report
  • Row Level Security - Controlling who can see what in Power BI
  • Power BI Process Quiz
Putting it all together
  • Excel and Power BI Integration
  • Putting it all together