Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Business Intelligence with Microsoft Excel(Ian)
Introduction
Introduction to Excel Business Intelligence Technologies (2:58)
Activating Addins (2:20)
Working with Power Query
Introduction to Power Query
Power Query Interface (8:39)
HR Master
Cleaning and Transforming Data with Power Query (14:39)
Download the Append Data Files
Appending Data with Power Query (9:22)
Download Merge Data Files
Merge Data with Power Query (8:53)
Sales Data
Using the Group By Feature (8:06)
Load Data to Power Pivot (10:14)
Working with Power Pivot / Data Model
Introduction to Power Pivot
Introduction to Power Pivot (1:49)
Download the Employee Master Training File
Loading Data into PowerPivot (7:28)
Creating Relationships (3:41)
Analyzing Data with Pivot Tables (8:56)
Calculated Columns (12:11)
Calculated Fields (11:33)
Pivot Tables and Pivot Charts (14:29)
Creating Interactive Dashboards (14:31)
Excel Power View
Introduction to Power View
Introduction to Power View (4:12)
Tables and Tiles in Power View (8:15)
Visualization Column and Bar Charts (14:27)
Visualizations Line (5:55)
Interactive Dashboard (9:54)
Using Filters in Power View (6:03)
Download the Sales Training Data Source
Creating Scatterplots in Power View (7:12)
Creating ScatterPlots over Time (4:24)
Mapping Data (7:49)
Power Map
Power Map
Introduction to Power Map (3:00)
Mapping Data in Power Map (3:39)
Changing the Method of Visualization (5:31)
Mapping Over Time (1:42)
Changing the Method of Aggregation in Power Map (4:43)
Creating Tours of Power Map Data (3:03)
Conclusion
Conclusion (0:50)
Changing the Method of Aggregation in Power Map
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock