Who it's for: Business Analysts, Data Analysts, and everyone in between looking to take the next step in data processing and visualization.
What it is: Power BI is Microsoft’s business analytics platform. It’s designed from the ground up to take mass sets of data and organize, analyze, and visualize it using live dashboards and interactive reports.
What you'll learn: In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.
- Introduction (5:13)
- Data Analytics (2:19)
- Licensing Options (2:05)
- Products and Services (2:36)
- Accessing Course Exercise Files (0:15)
- Reviewing Exercise File Data (1:15)
- Getting Data from Multiple Sources (1:56)
- Getting Data from Excel (2:07)
- Saving (2:33)
- Touring Report View (4:54)
- Touring Data View (2:14)
- Touring Model View (2:23)
- Starting New Instances of Power BI Desktop (2:00)
- Splash Screen (3:03)
- Getting Data from Access Database (4:33)
- Selecting Related Tables (2:36)
- Viewing Table Relationships and Settings (4:28)
- Accessing a Web URL (2:02)
- Getting Data from the Web (2:27)
- Web Authentication and Loading Tables (3:18)
- Exploring Web Data Inconsistencies (2:06)
- Optimizing Performance with Excel Files (2:19)
- Optimizing Performance with Power Pivot Data Model (1:39)
- Connecting to Underlying PivotTable Data (2:11)
- Importing from Power Pivot Data Model (3:29)
- Resolving Data Load Error (3:06)
- Resolving Data Path Error (3:27)
- Resolving Refresh Error (2:43)
- Exploring Power View Visualization Error (3:22)
- Implications of Locally Stored vs Cloud Based Excel Files (0:28)
- Locally Stored Excel Files (2:09)
- Refreshing In-Desktop and In-Service (2:45)
- Cloud-Based Excel Files (5:55)
- Publishing Cloud-Based Files to the Service and Refreshing (4:47)
- Conclusion (0:50)