FVC2315. Data Modeling Made Easy: Supercharge Your Excel Spreadsheets

You don’t need a computer science degree to build a database for a complex data analysis. In this hands-on session, learn how to unlock Excel’s under-utilized data transformation and data analysis capabilities. With Excel’s Power Query and Power Pivot, you can perform more advanced tasks including data modeling, automation and business intelligence. Unlock Excel’s big data capabilities, where millions of lines of data can be loaded into a single spreadsheet.

Learning Objectives:

• Analyze when and why to leverage Excel’s Power Query and Power Pivot for data analysis
• Distinguish among the many capabilities of these tools, and determine what resources you can leverage to learn more
• Apply use cases for these tools and what differentiates them from the other methods of data analysis