Dive into a comprehensive 1-hour 37-minute tutorial designed for Business Analysts, Data Analysts, and professionals seeking to enhance their data processing and visualization skills using Microsoft's 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 become proficient in constructing and navigating live dashboards and interactive reports. Explore topics ranging from data analytics and licensing options to resolving common errors and optimizing performance with Excel files and Power Pivot Data Models. Gain hands-on experience with exercise files and discover the implications of working with locally stored versus cloud-based Excel files in Power BI.
Overview
Syllabus
Start
Introduction
Data Analytics
Licensing Options
Products and Services
Accessing Course Exercise Files
Reviewing Exercise File Data
Getting Data from Multiple Sources
Getting Data from Excel
Saving
Touring Report View
Touring Data View
Touring Model View
Starting New Instances of Power BI Desktop
Splash Screen
Getting Data from Access Database
Selecting Related Tables
Viewing Table Relationships and Settings
Accessing a Web URL
Getting Data from the Web
Web Authentication and Loading Tables
Exploring Web Data Inconsistencies
Optimizing Performance with Excel Files
Optimizing Performance with Power Pivot Data Model
Connecting to Underlying PivotTable Data
Importing from Power Pivot Data Model
Resolving Data Load Error
Resolving Data Path Error
Resolving Refresh Error
Exploring Power View Visualization Error
Implications of Locally Stored vs Cloud Based Excel Files
Locally Stored Excel Files
Refreshing In-Desktop and In-Service
Cloud-Based Excel Files
Publishing Cloud-Based Files to the Service and Refreshing
Conclusion
Taught by
Learnit Training
