Data Analysis Fundamentals - PivotTables, Power Query & Data Model

Data Analysis Fundamentals - PivotTables, Power Query & Data Model

Dive into the fundamentals of data analysis and business intelligence in Excel 2016 with this comprehensive 1 hour 43 minute video tutorial. Master essential skills including sorting, filtering, and creating PivotTables. Explore advanced features like Power Query for data cleaning and transformation, and Power Pivot for handling large datasets. Learn to build custom styles, use slicers for dynamic filtering, and create relationships between tables in the Data Model. Practice importing and combining multiple text files with over a million records, and discover how to efficiently update and refresh your data analyses. By the end of this tutorial, you'll be equipped with powerful tools to manipulate, analyze, and visualize large datasets in Excel 2016.