Learn how to build a comprehensive Excel dashboard using advanced features in this 36-minute tutorial. Master Power Query for data cleaning and importing, create a Power Pivot Data Model, and construct multiple PivotTables for revenue analysis. Explore DAX measures, implement slicers for interactive filtering, and design charts to visualize data effectively. Discover techniques for grouping dates, naming PivotTables, and creating cross-tabulated tables. Apply conditional formatting, paste linked pictures, and add finishing touches to your dashboard. Gain practical skills in data refresh and query editing to maintain an up-to-date dashboard. Perfect for Excel users looking to enhance their data visualization and analysis capabilities.
Overview
Syllabus
) Introduction.
) Power Query to Clean, Transform & Import Text Files (From Folder feature).
) Import Data into Power Pivot Data Model.
) PivotTable #1: for Month & Year Revenue.
) Group Dates in PivotTable based on Data Model: Automatically adds Columns to Data Model Table..
) First DAX Measure: "Formula for PivotTable".
) Add Slicer to Multiple PivotTables.
) Chart #1: Line Chart for Month and Year Data.
) Name PivotTables.
) PivotTable #2: Revenue for each SalesRep. Name Pivot. Connect to Slicer..
) Chart #2: Bar Chart for SalesRep Revenue.
) PivotTable #3: Create Year PivotTable. Name Pivot. Connect to Slicer..
) Create Text Label for Chart #2 based on PivotTable #3 and Slicer..
) PivotTable #4: Cross Tabulated Table for Product and Region..
) Conditional Formatting for PivotTable #4..
) Paste Linked Picture of PivotTable in Dashboard.
) Add formatting and Alignment to Dashboard.
) Add new Text Files to Folder and Refresh Dashboard.
) Edit Query to remove data from Dashboard..
) Summary.
Taught by
ExcelIsFun
Related Courses
Related articles
Reviews
4.3 rating, based on 3 Class Central reviews
-
ExcelIsFun's course on building Excel dashboards is a comprehensive and invaluable resource for anyone looking to enhance their data visualization skills. The instructor provides clear, step-by-step instructions on how to create dynamic dashboards using PivotTables, Charts, and Conditional Formatting.
-
GT. Emeraldy RamadhanWow, this was an amazing video. I have learned so much in so little time.
It really shows the power of Excel.
Thank you for doing this, you are doing a fantastic job. -
Nice explanation of creating pivot table .
Easily understanding.
All over its good to do this course 🙂
