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
What you will learn in this course:
path of satisfaction simply unfold before you? Not exactly! There’ll be exercises
to guide you, practice tasks to accomplish. Because, no matter what secret
method others covet, there’s no magic wand. Journeying to the top requires
effort and expertise.
BUT YOU HAVE THE VISION TO SEE THE WAY AND THE STRENGTH TO FORGE AHEAD
With careful, considered application of thought, plus a drizzle of creativity, the new ingredients you bake in 2017 can see you rise higher than ever
Thanks for taking the time to check out my 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. If you have any questions about the course, feel free to message me here or check out the FREE preview lectures to learn more.
Take the first steps to a new and rewarding future by clicking on the TAKE THIS COURSE button, located on the top right corner of the page.
Hierarchies are created in the Pivot Table Field List
Gilly Dow is an MS Office Master, a Certified Microsoft Excel Expert and Training Consultant with 20 years experience working for the US Military, NHS and multiple private sector companies. Gilly have trained thousands of students from IT Security, MS Office, SAP and Clinical Healthcare applications. GD Teach has been founded especially for Udemy to reach out to a wider audience and deliver practical, step-by-step, quality training that makes a difference to you and your job satisfaction.