Boost your skills with this class, ideal for Power and Microsoft 365 users. Learn Power Query for shaping data, Power Pivot for data modeling, and present data with Excel PivotTable and PivotCharts.
This class is designed to get you up to speed using tools easily accessible to Power Users and all Microsoft Office users including Microsoft 365. First you will learn how to use Power Query to shape data that can be found in various data sources. Next you will learn the basics of creating data models using Power Pivot. Finally, you will learn the best ways to present your data by building reports using Excel PivotTable and PivotCharts. You will also learn how to make the self-service BI solutions you create scalable across your entire enterprise environment.
Course Outline ( Free Preview)
Power BI with Excel - What you need to get started
Module 01 - Class Introduction
Module 02 - Leveraging Power Query for Data Cleansing
Module 03 - Building Data Models with Power Pivot44 min.
Module 04 - Building Analytical Calculations with DAX40 min.
Module 05A - Designing Excel Reports (PivotTables and PivotCharts)26 min.
Module 05B - Designing Excel Reports (Connecting to Power BI Datasets)7 min.
Devin Knight is President of Pragmatic Works and has spent the past 18 years helping organizations successfully adopt Microsoft technologies through a combination of consulting, training, and executive enablement. His areas of expertise include Microsoft Copilot, Power BI, and the Power Platform, where he works with organizations to improve productivity, drive data-informed decision making, and accelerate business outcomes. Throughout his career, Devin has partnered with organizations of all sizes to help bridge the gap between technology investments and real-world business value, ensuring teams not only understand the tools available to them but also how to apply them effectively in their day-to-day work.
A passionate educator and advisor, Devin has led thousands of training sessions, workshops, and consulting engagements ranging from hands-on user enablement to enterprise-wide adoption initiatives. He is a strong advocate for democratizing technology and believes that powerful tools should be accessible to everyone, not just technical specialists. Known for translating complex concepts into practical, easy-to-understand solutions, Devin helps executives, business users, and technical teams alike build confidence with emerging technologies and apply them in ways that create measurable impact. His approach focuses on helping organizations establish the skills, processes, and culture necessary for long-term success.
Devin is a frequent speaker at industry events, including the Power Platform Community Conference and Days of Data, where he shares proven strategies for technology adoption, analytics modernization, and AI transformation. Through his speaking, consulting, and training work, he has helped thousands of professionals increase the value they receive from Microsoft technologies while fostering a culture of continuous learning, innovation, and data-driven decision making. His mission is simple: make technology approachable, practical, and valuable for every person in the organization.
**This class will be taught using the Power BI Service found at:**
- https://app.powerbi.com (Commercial Use)
- https://app.powerbigov.us (GCC Customers)
- https://app.high.powerbigov.us (GCC High Customers)
- https://app.mil.powerbigov.us (DoD Customers)
