Power BI Training 2

Improve Your Report-Building Process with Power Pivot

A FREE Power BI and Excel add-in that:

  • Links different data sources easily without VLOOKUP().

  • Makes dynamic time-intelligence calculations a breeze e.g. Same Period Last Year, Year-To-Date, Last 12 Months Rolling Average.

  • Enables on-demand complex slicing and dicing to answer your ever-changing business questions.

 

But first, What's in it for you? 


Save HOURS of self study. We give you the boost you need.

Learn exciting ways to add value to your data. We’ve carefully tailored our courses to feature all important aspects of Excel’s Power Pivot. This includes learning how to build sexy, insightful, dashboards. In just 2 days, you’ll gain useful skills to help you achieve maximum efficiency. 

Get inspired through personalised engagement.

Our Power Pivot training class focuses on interaction, coupled with a hands-on approach. Discuss your Excel pains with us and address your challenges. We’ll guide you to sustainable solutions as you engage in class and with our coach. You'll have access to expert advice on how to get your data talking for you.

Free consultation to ensure you're on the right track.

We care about your success: it’s important to us that you show off those new Excel ninja skills at work. Learning is a continuous process, so if you need extra advice or have more questions on Power Pivot, we've got you covered. Reach out to us anytime for a no-frills 90 mins post class session.

Unless you try to do something beyond what you have already mastered, you will never grow.
— Ronald E. Osborn
 

 Course Overview

(Upcoming classes 12 & 13 September 2019, 7 & 8 November 2019) - Singapore


 

What you learn:

Effective use of Power BI and Excel’s Power Pivot to:

  1. Combine data from multiple separate tables and data sources with a simple drag-and-drop action to build relationships in Power Pivot’s Data Model.

  2. Create versatile Key Performance Indicator (KPI) measures with DAX formulas by writing them once and reusing them indefinitely, everywhere in your reports e.g. Total Sales Year-To-Date.

  3. Choose and format suitable charts created from Power Pivot tables for meaningful data visualisation.

  4. Set up slicers that change your report filters on-the-fly to give different business perspectives.

 
 
Topic Learn how to... Power Pivot / Excel tools
1. What is Power Pivot?
2. Why is it important to ask the right questions before designing the reports?
◾ Unlock possibilities with Power Pivot
◾ Appreciate implications of starting with the right questions
◾ Power BI and Excel versions with Power Pivot
◾ Test drive a finished dashboard
3. How to import your data? ◾ Familiarise with data sources
◾ Differentiate attribute vs. metric
◾ Load data from various sources
◾ Create date table to enable time intelligence DAX functions
◾ Get data from Workbook, Folder, Text / CSV
◾ Shortcut function to create data series
4. How to integrate your different data sources without using VLOOKUP()? ◾ Familiarise with data hierarchy
◾ Create relationships between different data sources
◾ Power Pivot data model relationships
5. How to build your questions? ◾ Write common Key Performance (KPI) measures only once and re-use them throughout report e.g.:
• Total Revenue (current year, last year);
• Revenue Growth (year-on-year percentage and absolute change);
• Actual vs. Budget.
◾ Create calculated columns to group data by criteria
◾ Commonly used DAX expressions and formulas e.g.:
• CALCULATE;
• DATESINPERIOD;
• DATESYTD;
• DISTINCTCOUNT;
• DIVIDE;
• FILTER;
• IF;
• RANKX;
• SAMEPERIODLASTYEAR;
• SUM;
• SWITCH;
• TOPN
6. How to assemble your answers in a Power Pivot table? ◾ Differentiate Power Pivot vs. Pivot table
◾ Where to put attributes and metrics in Power Pivot tables
◾ Power Pivot table’s Field List (Filters, Columns, Rows, Values)
7. How to make it easy to discover your answers? ◾ Choose and format suitable charts and tables meaningfully to spot trends and outliers ◾ Power Pivot tables and PivotCharts
8. How to get your answers quickly from reports when the questions keep changing perspectives? ◾ Change the report context to suit your question’s perspective e.g. change in base year, category, sales channel, market ◾ Slicers
◾ Filters
 
 

What you get:

  • Course materials

  • Light refreshments

  • FREE 90-minute after-class consultation session. If you need some extra help to implement what you have learned in our classes, we've got you covered! You'll receive customised advice on which specific functions / set-up you should consider applying to your report-building process.

Learn 1 tool and use across 2 platforms

This course will be conducted primarily in Excel. A bridging video will show you how to use Power Pivot in Power BI.

Need an extra boost? Consider our 2-in-1 course!

FREE e-book and additional consultation session if you register for both Power BI 2 and Power BI 1 training classes now.

 
 
 

What others say:

 
 
 
lightdotlab review past participants