Excel: Creating a Dashboard with Power Query (Office 365/Microsoft 365)
Offered By: LinkedIn Learning
Course Description
Overview
Learn how to create data-rich Excel dashboards using Power Query.
Syllabus
Introduction
- Dashboard project overview
- What you need to know before starting
- Download files to follow along
- Prepare a draft of the Excel dashboard
- Import master data from external workbook with Power Query
- Import data from a text file with Power Query
- Create the data model and define relationships in Power Pivot
- Create logic for the latest and previous month in Power Query
- Set up calculations with PivotTables for the latest month
- Link Excel shapes to the data and linked picture trick
- Top three sales managers and numbers: Sort data in PivotTable
- Linked table for sales by product category
- Excel PivotChart for monthly sales
- Pivot Slicer connected to multiple PivotTables
- Finalize the dashboard
Taught by
Leila Gharani
Related Courses
Intro to StatisticsStanford University via Udacity Introduction to Data Science
University of Washington via Coursera Passion Driven Statistics
Wesleyan University via Coursera Information Visualization
Indiana University via Independent DCO042 - Python For Informatics
University of Michigan via Independent