Create Interactive Dashboard using MS Excel in 2 hours Adding Slicers Part 1
Create Interactive Dashboard using MS Excel in 2 hours
0% Completed
Basics of Dashboard
Welcome to the Course and Resources!!!
Reading
Content
Video - 00:2:16 mins
Visualization Game
Video - 00:4:29 mins
Importance of Visualization
Video - 00:7:56 mins
What is Dashboard
Video - 00:4:9 mins
Types of Dashboard
Video - 00:4:25 mins
Key Benefits of Dashboard
Video - 00:4:47 mins
Things to be considered before creating Dashboard
Video - 00:4:57 mins
Preparation for Dashboard for our Data
Data Description
Video - 00:2:1 mins
Derive Parameters for Dashboard
Video - 00:2:57 mins
Strategy to Display Parameters in Dashboard
Video - 00:7:36 mins
Creating Blank Structure for Dashboard
Video - 00:6:8 mins
Complete Header of Dashboard
Video - 00:00:58 mins
Pivot Table and Charts
Create Measures for Dashboard
Video - 00:7:30 mins
Prepare Summary of Top 5 Items
Video - 00:5:24 mins
Prepare Summary for Geo Map and Pie Chart
Video - 00:4:53 mins
Create Bar Chart for Top 5 Items Part 1
Video - 00:8:34 mins
Create Bar Chart for Top 5 Items Part 2
Video - 00:2:31 mins
Creating Dashboard in Excel
Updating Dynamic Measures in Dashboard
Video - 00:4:26 mins
Creating and Updating Pie Chart in Dashboard
Video - 00:9:47 mins
Creating Geo Map andd Trick to make it Dynamic
Video - 00:3:15 mins
Add Calculative Measure on Dashboard
Video - 00:2:54 mins
Overview of Interactivity using Slicers
Video - 00:2:12 mins
Adding Slicers Part 1
Video - 00:4:55 mins
Adding Slicers Part 2
Video - 00:2:49 mins
Way forward
Overview of BI and BI Tools
Video - 00:7:42 mins
Announcements Course Info
PreviousNext