Course overview:

• Introduction to Business Intelligence
• General workflow in Microsoft Power BI
• Importing data and data manipulation (Excel, CSV, SQL, R, Python, Facebook, web etc.)
• Data Cleaning In Power BI
  • Web scrapping
  • Using Parameters
  • Query Properties
  • Advanced Editor- Code basics
  • Managing data
  • Group by, Merging and appending datasets
• Conditional Formatting
• Filters (Advanced, Basic, Top N, Visual level, Page level and Report level)
• Editing Relationships among Visuals
• DAX working principles
  • Measures and new columns
  • Calculate(), SUM(), Count() and other fundamental functions
  • Calculations on variables
  • New Quick Measures
• Modelling variables
• Types of reporting and building consistent dashboards (Risk, KPI, HR, Marketing)
• Sharing Reports on web and Power BI service
• Editing dashboards in Power BI service and manually
• Interactive Presentations
• Working in sample dashboards
• Sales orders/ Sales Store/ Sales Center- Sales Analysis Case