Working with Data Models in Excel 2013+
Duration: 90 Minutes
Many Excel data crunchers mourned the loss of easy access to PowerPivot as Excel 2013 was released. However, one of its most powerful features, the ability to analyze multiple related datasets, is now included in most versions of Excel as part of the data model. A data model lets you take two different datasets joined by at least one common element and analyze them in pivot tables and pivot charts. Even if you never used PowerPivot, but have employed various other complex, convoluted, and, ultimately unwieldy methods, you'll appreciate the simple elegance of this new feature. Certified Microsoft Excel expert, Melissa Esquibel, will take you through the fundamentals of this toolset, then show how to leverage it with some of Excel's newest BI (Business Intelligence) tools.
Objectives of the Presentation
Why Should you Attend
- What the data model is
- Making sure your data is in the right shape to leverage data models
- How to create relationships
- Uncover and resolve common issues in analyzing data in data models
- Get comfortable with some of the new data crunching technology now in everyday Excel
- When PowerPivot is the right answer
- How the data model is related to the new BI toolset
If you have spent hours trying to perform analyses on multiple datasets, frustrated that the methods are either lacking in features, are too complicated, or not terribly durable from refresh to refresh, you will appreciate knowing the simplicity and logical solution of Excel's new data model.
Who will Benefit
- Preparing data for inclusion in a data model
- Establishing data connections
- Creating data relationships
- Using the PivotTable features with a data model
- Creating additional visual elements with the data model
- Troubleshooting relationships and report issues
- How to employ and manage the data model in PowerPivot
- An introduction to PowerBI
- Which license/version goes with which features?
- Data Analyst
- Marketing Analyst
- Database Administrators
- Logistics Analyst
- Financial Analyst
- Web Analytics Specialist
Melissa is a Microsoft Certified Trainer and Excel Expert who has worked with spreadsheet tools since their earliest forms. In her work as a Microsoft Experience Center facilitator for Microsoft, she introduced many organizations to PowerPivot. She regularly presents topics and writes content on Excel's advanced features with the goal of ensuring that her students, attendees, audiences walk away with real world application for their new skills.