DATA MODELING & ANALYTICS
POWER QUERY & POWER PIVOT
Analyze huge data sets (millions of rows) with speed with Excel’s Power Pivot
You’ll agree with me that a bigger chunk of your reporting is spent getting your data ready
Retrieving, reshaping and/or combining data from various sources can be a great time waster, leaving you with little or no time to analyze for insights –that is missed opportunities!
If you’re looking for a way to automate the very mundane tasks (without coding –using point and click features on the ribbon!) …
…and yes, most probably VBA or Excel Macros is not your thing
You need this course!
Power Query will keep sequential record of the steps you do the first time and will repeat them with new data –NO RE-WORK! You simply hit the Refresh button when new data knocks
Power Pivot on the other hand will take the cleaned data and allow you to create measures/calculations that you can use for your report
And the best part?
The formulas are done ONCE and are re-usable EVERYWHERE!
You can therefore focus on turning data into insight –and yes –no more office sleep overs and late-night rush reports
…and did I tell you?
3 Expert-Led Days of Empowering You to Save Time by Eliminating Repetitive Tasks
The learner is assumed to be familiar with lookup formulas, Pivot tables and Pivot charts in Excel.
Versions & compatibility:
- If you have Excel 2013 or 2016 Professional Plus edition, Power Pivot 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, Power Query is in-built, and is available in the Data menu >>>Get & Transform.
- Carry your laptop with MS Office (2010 and above) installed.
- Tea/Coffee, Snacks and Meals are provided in this training.
- Parking is available
Sharing is Caring
Share this course on your social profiles
Power Pivot, commonly referred to as the Data Model is an Excel add-in that helps you to create normal Pivot reports that draw data from a variety of sources. It allows you to extend Excel capabilities in two ways: (1) You can connect to multiple data sources, create relationships and report as one, and (2) You get access to powerful formulas built on a language called DAX (Data Analysis Expressions) making calculations such as YTD and prior year comparisons very easy.
Click here for details on Excel versions compatibility
Power Query enhances and simplifies tasks that revolve data access, cleaning, segmenting, grouping and merging. It is a free add-in available in MS Excel 2010 and above. In Excel 2010 and 2013 you download and install for free. With Excel 2016, 2019 and Office 365, it’s inbuilt into the Data menu as Get & Transform