Working with Data Models in Excel 2013+ 2016

Topics

• Establishing data connections
• Preparing data for inclusion in a data model
• Using the PivotTable features with a data model
• Creating data relationships
• Troubleshooting relationships and report issues
• Creating additional visual elements with the data model
• An introduction to PowerBI
• How to employ and manage the data model in PowerPivot
• Which license/version goes with which features?

Who should Attend

Attendees with job titles such as:

• Marketing Analyst
• Data Analyst
• Database Administrators
• DBA
• Financial Analyst
• Logistics Analyst
• SEO
• Web Analytics Specialist