Data Modelling and Analysis with Excel Power Pivot
Learn to load and clean large datasets with Power Query, model them in Power Pivot with table relationships, and build PivotTables, dashboards and DAX measures.
Speaker
Tom Fragale
Microsoft Office trainer · 30+ years in computing
Overview
Excel's size limits and manual data entry from multiple sources frustrate anyone who works with data. This 75-minute Excel Power Pivot training shows how Power Pivot and Power Query solve those problems inside Excel, without database access or IT help.
Power Query is the tool for finding, connecting to, importing and cleaning data, removing unwanted rows and columns, trimming spaces, and merging or splitting fields, with saved query definitions for reuse. Power Pivot then models that data, handling more than a million rows from almost any source.
You'll learn the Power Pivot interface, table relationships, PivotTables, PivotCharts and dashboard views, DAX basics and measures such as year to date, and sets.
Why attend: Power Pivot lets you build PivotTables from multiple datasets without VLOOKUP or multiple consolidation ranges, and work with data far beyond normal worksheet limits. It can transform how you report and analyze. The session suits business professionals and owners, controllers, accountants, CPAs, CFOs and financial consultants with intermediate Excel skills who know formulas and PivotTables.
What’s covered
- The Power Pivot interface and menu options
- Importing and cleaning data with Power Query and saving query definitions
- Loading data into Power Pivot for analysis
- Analyzing more than 1 million rows of data
- Creating relationships between tables
- Building dashboard views from Power Pivot
- Creating PivotTables and PivotCharts from Power Pivot
- DAX formula language principles
- DAX measures such as year to date, month to date and previous month
- Using sets to analyze data
Who should attend
What you get
About the speaker
Tom Fragale is a computer professional with over 30 years of professional experience. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.
Staci Warne · 60 min
Cathy Horwitz · 180 min
Craig Brody · 60 min