Data Analysis and Visualization with Excel Power Pivot and Power BI

This course is to equip trainees with Data Analysis and visualization skills using Excel Power Pivot and Power BI Applications

Description

PowerPivot and Power BI are Microsoft applications to manage, analyze and visualize even millions of records of huge data seamlessly. This course is to equip trainees with Data Analysis and visualization skills using Excel Power Pivot and Power BI Applications. Trainees will be able to import data from various sources, clean, transform, model and visualize that data. They will also learn to create dashboard reports of datasets to present patterns, trends and analytical insights from data and share it with colleagues and stakeholders.


Key takeaways

  • Power Pivot and Power BI Application Interfaces
  • query editor
  • Data Model
  • Data Dashboards in Power BI service
Targeted Audience

Data Analysts, Finance and Accounts Professionals, Database report generators etc

Duration

2 Days (14 Hours)

Mode of delivery

Virtual

Course Content

After completing this course, trainees will be able to gain following skills:

  1. Well Familiarized with Power Pivot and Power BI Application Interfaces
  2. Able to import data in Power Pivot and Power BI applications from different data sources like Excel, Access, Text, SQL etc
  3. Able to clean and transform data using query editor
  4. Able to create Data Model by creating data relationships
  5. Able to perform calculations in Data model to get deep insight of data
  6. Create Visually appealing Data summary Reports using PowerPivot and Power BI to present patterns, trends, analytical insights from data
  7. Some Advanced Functionalities like creating KPIs, Working with Date and Time related Data
  8. Creating Data Dashboards in Power BI service
  9. Share Visual data reports