This course aims to teach users the foundational concepts of building queries and preparing data for analysis using Power BI. Participants will learn to build relationships across multiple databases using Power Pivot, utilize useful functions to enhance data analysis, create live dashboards and interactive reports, and more. The course is designed for business analysts, data analysts, and individuals interested in advancing their skills in data processing and visualization. The teaching method includes hands-on exercises and practical demonstrations.
Overview
Syllabus
Start
Introduction
Loading Sample Data and Making Workspace Premium
Downloading Report Builder and Creating Paginated Reports
Sorting Reports in Design View
Adding Report Headers and Making Them Repeat Across Pages
Making Column Headers Repeat Across Pages and Publishing Reports
Reviewing Paginated Reports - Print Preview and Export Options
Paginated Reports Recap
Introduction to Performing Advanced Analytics
Accessing a Sample Desktop File from the Service
Advanced Analytics - Grouping
Advanced Analytics - Binning
Advanced Analytics - Drill Down and Up
Advanced Analytics - Analyze Feature
Data Insights Through AI Visuals
Creating Animated Scatter Charts
Using Visuals to Forecast Values
Creating Custom Analytics Visuals
Conclusion
Taught by
Learnit Training
