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
MongoDB for DevelopersMongoDB University Data Wrangling with MongoDB
MongoDB via Udacity Intro to Point & Click App Development
Salesforce via Udacity SAP Business Suite powered by SAP HANA
SAP Learning Desarrollo de Aplicaciones Web: Conceptos Básicos
University of New Mexico via Coursera