Course Description

Overview 

Power BI is one of the most powerful self service business intelligence platform. 

It is absolutely essential tool for data professionals. 

Who should Attend 

Commerce Graduates / PG, MBA etc. who are perusing for career in Accounting & Finance. 

Finance & Accounts executives seeking career advancement in Business Intelligence and Data Analytics. 

Course Duration – 20Hrs

Course Contains 

  • Introduction- Power BI Query Editor. 
  • Connect & Extract Data- Types of connectors, various data sources. 
  • Data Transformation- Basic Transformation, Date, Text, Numeric tools, grouping, conditional columns, Data cleaning, Merge & Append Queries. 
  • Creating Data Models- Data (“Fact”) Tables vs. Lookup (“Dimension”) Tables  Creating Power BI Table Relationships, Connecting Multiple Data Tables. 
  • Adding Calculated Fields & understanding DAX. 
  • Designing Interactive Power BI Dashboards 

The course will help you:- 

  • To Understand the business intelligence workflow from end-to-end & develop professional-quality business intelligence reports from scratch. 
  • To understand how to Extract the raw data & Transform it into professional interactive Dashboards.  

Learning Method 

  • Interactive e-learning sessions, online Assignments based on real life scenarios.  

Certification 

  • On successful completion, participants will receive a certificate from Acecom Skills Development.