Power BI Certified Data Analyst Training

Welcome to the Power BI Certification.

Power BI is a business intelligence tool that gets data from different sources, such as Excel, JSON, PDF, etc., and can be analyzed and converted to meaningful reports, dashboards, charts, etc. This assists in making business decisions by tracking performance.

Power BI was developed by Microsoft in 2011 to analyze and visualize a large amount of data and generate meaningful insights helpful for organizations in scaling. Power BI Desktop version is freely available and, in this tutorial, we will understand it thoroughly with examples.

Features of Power BI

• Data Visualization: Create interactive reports and dashboards with a wide range of visualizations.
• Data Connectivity: Connect to various data sources like Excel, databases, and cloud services3.
• AI-Driven Analytics: Use AI to uncover patterns and insights in your data.
• Custom Visualizations: Create custom visualizations using R and Python.
• Power Query: Easily source and transform data.
• Data Refresh: Automatically refresh data to keep reports up-to-date.
• Mobile App: Access reports and dashboards on the go with the Power BI mobile app.
• Integration with Microsoft Products:Seamlessly integrate with other Microsoft products like Excel, SharePoint, and Azure.
• Collaboration: Share reports and collaborate with others in real time.
• Security: Robust security features to ensure data protection and compliance.

Note: In this course, we will work on the Tableau Desktop with a 14-day trial version.

Course Lessons

The Tableau course consists of 32 lessons divided into 11 sections:

Power BI – Overview & Setup

1. Power BI – Introduction & Features
2. Power BI – Types and Components
3. Power BI vs Tableau vs Excel
4. Power BI vs Power BI Pro vs Power BI Premium
5. Install Power BI on Windows 10
6. Install Power BI on Windows 11

Power BI – Get Data

7. Get Data from Excel

Power BI – Visualizations

8. Create a Gauge Chart
9. Create a Column Chart

Power BI – Cards

10. Create a card
11. Format the cards
12. Update the cards

Power BI – Tables

13. Create a Table
14. Format the table
15. Table Conditional Formatting

Power BI – Filters

16. Create a Filter

Power BI – Slicer

17. Create a slicer
18. Select multiple values from a slicer
19. Set a chart with a slicer

Power BI – Data Transformation

20. What is Data Transformation
21. Group rows
22. Pivot columns
23. Create custom columns

Power BI – DAX

24. What is DAX
25. DAX Calculated Tables
26. DAX Calculated Columns
27. DAX Measures

Power BI – Reports and Dashboards

28. What is a Report in Power BI
29. Create a Report and Publish in Power BI Service Account
30. Create a Dashboard from Report in Power BI Service
31. Subscribe to Report

Power BI – Update to a newer version

32. Update Power BI

Let us begin!