Data Modelling and Analysis with Excel Power Pivot

Excel 2013 was a game changer for any Excel user. 

Excel 2013 provides new technologies and tools for the business user to easily analyze data to create powerful reports and dashboards in a fraction of the time of traditional spreadsheets.

This course is for all business users who want to learn how to create management reports, analyze data and create interactive dashboards using Excel 2013.

In this course we learn the following:

​Power Query

• Cleaning up Data
• Merging Data
• Appending Data
• Grouping Data
• Loading data to PowerPivot

Power Pivot

• Create relationships between Tables
• Manage millions of rows of data
• Custom Calculations, Key Metrics and KPIs
• Analyzing Data with Pivot Tables
• Analyzing Date data

Power View

• Creating Tables and Cards
• Visualizing data with Graphs
• Creating Interactive dashboards
• Filter and Ask Questions of your Data
• Powerful data analysis with ScatterPlots and BubblePlots
• Visualize Geographical data and maps

Power Map

• Mapping Data with Power Map
• Changing the Method of Visualization
• Changing the Method of Aggregation
• Mapping Data over Time
• Creating Tours

This course will provide you with an easy to follow step by step approach to using the new Business Intelligence technology in Excel 2013.

WHAT'S IN THE COURSE?

• Almost 3 and a half hours of content, 40 lectures and downloadable training data files
• Learn the new Business Intelligence technologies in Excel 2013
• Analyze data and create reports in a fraction of the time of spreadsheets
• Learn to manage millions of rows of data in Power Pivot
• Create new powerful calculations, KPIs and Key Metrics
• Create new table relationships for reporting and dashboards
• Use Power View to create interactive dashboards and analyzing data
• Learn to use Power Query to import, merge, clean and transform data
• Use Power Map to visualize and analyze geographical data

COURSE REQUIREMENTS:
Excel 2013

/

• 1
• 2
• 3
• 4
• 5

So clear and easy to understand. The lessons were laid out logically and methodically.. I went back a second time and mimicked his steps which helped to better understand Power everything :-) Thank you Ian I will seek out your other training courses based on how much I learned with this class.

/

• 1
• 2
• 3
• 4
• 5

/

• 1
• 2
• 3
• 4
• 5

This course explained the PowerPivot, PowerView and PowerMap concepts with easy-to-understand examples. I definitely liked the delivery and pace of the course. Highly recommended.

/

• 1
• 2
• 3
• 4
• 5

/

• 1
• 2
• 3
• 4
• 5

Great introduction to "BI" within Excel 2013. Great one stop shop to learn the beginnings of the BI stack within Excel 2013 and how all the pieces fit together. Much easier than googling and trying to figure it all out yourself.

/

• 1
• 2
• 3
• 4
• 5

/

• 1
• 2
• 3
• 4
• 5

Mapping the data and creating a video of how the data evolves over time- wow! Ian makes this powerful tool look so easy to operate.

/

• 1
• 2
• 3
• 4
• 5

/

• 1
• 2
• 3
• 4
• 5

Awesome explanation with great video quality. Thanks for making such a nice course. I am very happy to buy your courses after lot of search of this course on net.

/

• 1
• 2
• 3
• 4
• 5

• 0
• 1
• 2
• 3
• 4