DAX Power Pivot – 10 Easy Steps for Beginners Online Video Course
If your goal is to enter the wold of BI, Data Mining and or Data Analysis you have to take this course. All of these environments and roles demand the skills you are about to learn.
Microsoft PowerPivot is an add on for Excel that provides Business Intelligence functionality and reporting within the familiar environment of Excel.
This capability enables manipulation of hundreds of millions of rows of data with the capacity to provide business insights and shorter decision making cycles laughing in the face of the million row threshold of regular Excel
To start with the course focuses on importing data into Power Pivot to create the Data Model. You will learn about calculated columns and other DAX related concepts that will show you how to “shape” the data.
Next, you will create relationships between tables of data negating the need for VLOOKUP. Reducing the time it takes to “shape” your data – is one of the major benefits of this awesome tool.
With the data model in place, next you delve into the world of DAX measures. These are Data Analysis EXpressions functions that build the formulas to provide the business insights that decision makers and stakeholders dream of.
There is no programming involved with DAX – your Excel formulas experience has set you up nicely for the next step in your Excel journey.
Throughout the course we work together building the data model and measures. At the end of each step you have an opportunity to practice creating your own measures to help you consolidate, embed and reinforce everything you have learned. I provide a solutions video lecture before moving on to ensure you’re on track and ready to move on.
I provide all the files you need to follow along and a fully supporting, screen-shot enriched 78 pg. user guide pdf packed with all the steps and practice exercises with solutions.
Power Pivot is the perfect tool for those working in finance, statistics, project, business and market analysis or any data reporting role who have a need to create and produce Business Intelligence style dashboard reports.
What will I learn in this course:
- Import data into the Power Pivot Data Model using Excel 2016
- Import and edit data from Microsoft Access and Microsoft Excel
- Build Relationships between Data Tables
- Create Hierarchies for end-user filtering convenience
- Shape the Data Model with Calculated Columns & Measures
- Build custom DAX Expressions to drop into any pivot
- Create Dashboard worthy reports with Slicers and Presentation tips
- Import existing Excel data and Link Excel data into the Data Model
- Create Calculated Columns and Measures in the Data Model
- Create Measures in Excel
- Create Calculated Columns with RELATED() & RELATEDTABLE() DAX Functions
- Create Measures using the COUNT() & DISTINCTCOUNT DAX Functions
- Create Measures using the CALCULATE() DAX Function to modify the Filter Context of Pivot Tables
- Create static values for Ratio creation with CALCULATE() & ALL() DAX Functions
- Create a Date Table (Calendar) in Excel and Relate to the Data Model for Time Intelligence functionality
Improve Your Career Prospects. Acquire New Skills. Get Noticed!
Will the 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.
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.
Online Course Snippets…
DAX Power Pivot 10 Easy Steps for Beginners – Table Properties Table Preview Not Available
DAX Power Pivot 10 Easy Steps for Beginners – CALCULATE() with DATE() & MONTH()
Don’t Put It Off Any Longer. Start Now. With Me. Today
Take the first steps to a new and rewarding future by clicking on the TAKE THIS COURSE button, located below and receive a WHOPPING 67% DISCOUNT – on demand, life-time access with a full 30 day money-back – no quibble – guarantee!
If you have been putting this off but want to make a change – then seize the day my friend!
Let me take you by the hand and gently welcome you into the wonderful world of DAX & Power Pivot.
I’ll be your guiding light and show you the ropes…
If you have purchased the DAX Power Pivot & Data Modelling in Excel 2016 eBook on Amazon and need the workbook files and user guide:
Please submit your name and email to receive your files
We hate SPAM too – your details are important to us that’s why we keep them safe