Embark on a comprehensive 2-hour tutorial designed for Business Analysts, Data Analysts, and professionals seeking to enhance their data processing and visualization skills using Microsoft Power BI. Learn the fundamentals of building queries, preparing data for analysis, and creating relationships across multiple databases using Power Pivot. Master essential functions to elevate your data analysis capabilities, and gain proficiency in constructing and navigating live dashboards and interactive reports. Explore topics such as querying data from various sources, normalizing concepts, merging queries, creating basic visuals, customizing visualizations, and working with map, card, and gauge visuals. Engage in hands-on labs to reinforce your learning and apply newly acquired skills in real-world scenarios.
Overview
Syllabus
Start
Introduction
Downloading Software
What is Power BI?
Course Trajectory
Introduction to Part 1
What is a Query or Power Query?
Querying Data
Query Excel Files
Normalizing Concepts
Appending Queries
Querying Web Pages
Merging Queries Part 1
Merging Queries Part 2
Normalizing Data
Lab - Querying Data and Analyzing Results
Limitations of Excel's Pivot Tables
Introduction to Power BI Desktop
Querying
Creating Basic Visuals
Customizing Basic Visuals
Map Visuals
Card Visuals
Shapes and Text Boxes
Slicers
Gauge Visuals
Lab - Creating Reports
Lab - Walkthrough Part 1
Lab - Walkthrough Part 2
Conclusion
Taught by
Learnit Training
