PowerPivot / Excel Power BI
Course
Online
Description
-
Type
Workshop
-
Level
Beginner
-
Methodology
Online
-
Duration
2 Days
-
Start date
Different dates available
Excel can do so much more than simple pivot tables! This two-day course will show you how to:
create simple, elegant data models in PowerPivot;
use these data models to create pivot tables based on multiple tables;
use Power Query to build queries to extract, transform and load data;
start to use the DAX language for more in-depth analysis of data;
analyse time series data ("compare this month's sales with the same period in the previous quarter");
create and display KPIs in Excel;
create Power View reports within Excel based on your data models; and
create and show Power Maps (including making videos of trends over time).
Note that you'll need to be using Excel 2013 Professional Plus or Office 365 ProPlus to be able to use the Power BI (Power Business Intelligence) features within Excel.
Important information
Documents
- Excel PowerPivot-Excel Power BI.pdf
Facilities
Location
Start date
Start date
Reviews
Subjects
- PowerPivot data models
- Pivot tables using PowerPivot
- Using Excel tables
- Using other data sources
- Getting data (Power Query)
- Transforming data (Power Query)
- Calculated columns
- Measures
- DAX basics
- The CALCULATE function
- Calendars
- Date Functions
- Hierarchies
- KPIs
- Perspectives
- Power View
- Power BI Desktop overview
Teachers and trainers (1)
Andrew Gould
Senior Trainer
Course programme
- Importing SQL Server tables
- Filtering rows/columns
- Data and diagram view
- Hiding from client view
- Relationships
- Drill-down vs Quick Explore
- Slicers and timelines
- Controlling what you see
- Creating and naming tables
- Adding to data models
- Importing Access and Excel
- Importing cubes
- Pasting from the clipboard
- Querying databases
- Web pages and XML files
- Splitting columns
- Merging and inserting columns
- Other transforms
- Creating calculated columns
- Using the RELATED function
- BLANK and SWITCH
- The all-important query context
- Implicit calculated fields
- AutoSum fields
- Creating in Excel and PowerPivot
- The DAX Studio add-in
- Calculating ratios
- Aggregate X functions
- Replacing filters
- Using ALL
- Using VALUES to edit filters
If time
More advanced DAX functions- Using FILTER to filter tables
- Ranking
- The EARLIER function
- Creating in Excel or SQL
- Linking to calendars
- Sorting months
- Multiple date tables
- Period to date
- Fiscal year calculations
- Parallel periods
- Semi-additive measures
- Creating hierarchies
- Pros and cons
- Relative KPIs
- Absolute KPIs
- Creating perspectives
- Viewing parts of a model
- What Power View is
- Why not to use it!
- Importing data
- Visualisations
- Simple drill-down
- Publishing dashboards
If time
Power BI Desktop maps- Localising data
- Types of map
Additional information
PowerPivot / Excel Power BI