DAX Power Pivot & Data Modelling in Excel 2016: How to Analyse Data with Excel 2016's Data Analysis Tools

Learn the Undeniable Benefits of Power Pivot in 10 Easy Steps

Power Pivot – it’s now 2 words, not one – dispenses with the cost of Business Intelligence and Data Analysis consultants and hands over the power to YOU the end user.
Gone are the days of waiting for IT to provide the data you need to manipulate and report on only to find what’s been provided isn’t what you asked for…
Import the data directly into Excel – "hey, this isn’t new…", I hear you cry, "…we’ve always been able to do that!"
BUT, Power Pivot laughs in the face of the 1M row threshold in Excel worksheets.
Power Pivot brings new capabilities that enables manipulation of hundreds of millions of rows of data.
Creating relationships between tables of data negates the need for VLOOKUP. Reducing the time it takes to shape your data - is one of the major benefits of this awesome tool.
Data Analysis, Business Intelligence and Insights emerge with Measures.
These portable calculations are created with Power Pivot’s Data Analysis Expressions (DAX) formula language and can be dropped into ANY pivot table – yes, that’s right – they can be dropped into ANY pivot table.
Well constructed DAX measures, simplify the reporting process and transform the typical end user into super-hero status that will propel you with a new skill-set that is in very short supply and very high demand.
There is no programming involved with DAX - your Excel formulas experience has set you up nicely for the next step in your Excel journey.
Once you get a handle on DAX, there's no going back - you'll be creating all your pivots in Power Pivot - you really don't have to a have millions of rows of data to enjoy the benefits of Power Pivot and DAX

•Download the step-by-step User Guide and exercise files as you follow along in the Group Work exercises
•Embed and consolidate your knowledge with the follow-up Practice Exercises and Solutions
•Join the 1% of Excel users that have seized the day and have become excited again about Excel
•Take the next logical step in both your Excel experience and career path
•Get noticed for your efficiency and reporting skills
•Get that promotion
•Go for that ideal job

Thanks for taking the time to check out my eBook/Course. I can't wait to help you take the next step in developing your Excel skills.
I have used Excel 2016 to demonstrate this fantastic tool but you can follow along in Excel 2010 & 2013 - I'll do my best to point out the differences.

Get the basics right and everything else will fall into place.

I give you the fundamental basis to build upon - a strategy I have adopted over 20 years of teaching thousands of Excel students. You won’t even realise, in the process of learning new and invaluable skills, you will be Data Modelling!

Power Pivot is available with Office 365 ProPlus, Office Professional Plus, Excel 2016 Standalone, and Office 2016 Professional
Certain versions of Excel 2013, please check your version.
Excel 2010, Power Pivot is available as a separate download.

The eBook/Course uses Excel 2016 for screenshots, capabilities and naming conventions.