LARGE DATA ANALYSIS WITH POWER PIVOT & POWER QUERY
Give your data meaning. Analyze huge data sets (millions of rows) with speed in with Excel’s Power Pivot
Probably you spend too much time doing lookups of data from various tables for use in a pivot table, uh! Would you want to handle millions of rows of data (say 100 million plus, but am sure you deal with a fraction of that) in a familiar environment –Excel? Would you like to automate that manual process of reshaping your data and unifying it –all with no single line of code? How about being able to monitor your regional/branch/department budgets versus actuals all in one interactive Pivot report?
Look no further for this course just addresses this and much more.
Each month/week/day you just need to update your source data, and press Refresh All –no formula re-work!
In this module you will learn:
- Importing and shaping your data with Power Query –automated with no VBA!
- Creating relationship between different source tables
- Supercharged calculations with Data Analysis Expressions (DAX) –extend the capability of Excel
- Interactive reports and dashboards –Power Pivot report tables, charts and slicers
The learner is assumed to be familiar with lookup formulas, Pivot tables and Pivot charts in Excel.
Versions & compatibility:
Not all version of Excel include Power Pivot. If you have Excel 2013 or 2016 Professional Plus edition, PowerPivot is already built-in and all you need to do is enable it from File >>>Options >>>Ad-ins >>>COM add-ins. For Excel 2010, Power Pivot is available for free download and installation.
Power Query is a free download add-in for Excel 2013 and 2010. With Excel 2016, it is in-built, and is available in the Data menu >>>Get & Transform.
I recommend if you could install MS Office 2016 Professional Plus.
Can others access my reports?
Yes, anyone with any version of Excel will be able to view and slice the reports generated by PowerPivot, even if they don’t have it installed. However, they won’t be able to make major structural changes unless they install.
What you get:
18 hours of practical sessions
A step-by-step guide
After-course instructor support
Certificate of participation
Do you have 8 or more staff who could benefit from this program?