Data Modelling and Analysis with Excel Power Pivot

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.

• Navigate the Power Pivot interface and menu options
• Import and prepare data with Power Query
• Load and analyze more than a million rows in Power Pivot
• Create relationships between tables of data
• Build PivotTables, PivotCharts and dashboard views from the data model
• Write DAX measures such as year to date and previous month
• Use sets to analyze your data

• 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

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.

This webinar is designed for Business professionals, Business owners, Financial Controllers, Accountants, and anyone who requires doing data analysis. This event is aimed at users of Excel (2010, 2013, and 2016 for Windows) who wish to learn about Power Pivot and Power Query. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot Tables.

• Business users who analyze data with Excel or create management reports
• Excel users who want to analyze large data sets and create relationships between tables
• Excel users who know how to Pivot Tables and Pivot Charts
• Excel users who wish to create interactive dashboards
• Accountants
• CPAs
• CFOs
• Financial Consultants
• Controllers

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.