The only course you need to learn PowerPivot with DAX introduction
Power Pivot is an Excel add-in, available in Excel 2010 and certain versions of Excel 2013 and later. You can use Power Pivot, with its own DAX functions to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily. Power Pivot is the gateway to business intelligence and data all within Excel.
This course has been designed to take the novice Powerpivot user to a level where they are comfortable working with Power Pivot Models, using Pivot tables and charts along with carrying out DAX calculations and using DAX time intelligence functions.
This course consists of 5 modules, each with learning activities, and workbooks to download. To make sure you get the most out of this course, the learning material is made up of both videos and articles to reinforce what is covered.
Module 1 Get your head around the basics of Powerpivot, learn how to link a table and work with that table and find out how you can get data into powerpivot to work with it. If you are new to Power Pivot this module will show you around, so you become more familiar with the user interface and become more confident adding data to a power pivot model.
Module 2 Powerpivot allows you perform calculations across different tables of data. In order to do this, you must link the tables together by means of relationships. Relationships can be difficult to understand at first and they are a big change to working in Excel.
Module 3 The pivot table is by far one of the most useful ways to analyse and visualize your data in Excel. Powerpivot allows you quickly insert a pivot table or chart from multiple tables to analyse or slice and dice like never before.
Module 4 Powerpivot allows basic to complex data modelling and calculations to be carried out across multiple tables of data. It does this via its powerful calculation engine using Data Analysis eXpressions. Understanding the basics of DAX is a necessity for the use of Powerpivot.
Module 5 How often do you see comparisons in accounts and reports such as Same period last year and running totals over time? DAX is equipped with a suite of time intelligence functions that are not found in excel. These functions will allow you quickly analyse your data over different time period
My Name is Paula, and I am a qualified CPA with over 20 years’ experience in Accounting and Business. I have worked across a broad range of industries and levels of seniority. During this time I used Excel as my spreadsheet tool of choice, attending many courses and regularly updating my skills. It was my love for Excel that started my journey as an e-learning educator. As a manager and an Accountant, I noticed a skills gap amount Accountants and finance staff in Excel. In 2010 I launched www.theexcelclub.com with 1 course aimed at this market. I am now the author and presenter of many online courses and can boast that I have thought almost 50,000 students!
Highly Recommended Course. Easy to Understand, Informative, Very Well Organized. The Course is Full of Practical and Valuable for Anyone who wants to Enhance their Skills. Really Enjoyed it. Thank you!!