Excel - Power Pivot

Customized training content NEW
Marketing | Finance | HR | Operations | Cross-Functional

Extend the power of Excel and discover an agile, cost-effective approach to business intelligence. With a focus on real-world scenarios, problem-solving, and data modeling, this training shows you how to perform complex data analysis improves your Excel power-user skills.

...

DataTraining.io has transformed the way we do our analysis and reporting.

...

The instructors were first rate professionals and extremely skilled. They answered all questions very thoroughly and handled the different levels of experience among the participants very well.

...

The team from DataTrainingio was very flexible and organised a training last minute for us. They are very professional and friendly and provided a great two-day training.

Get Offer

expert trainers tailored content follow-up support high-quality training material certificate

Objectives


This training will enable you to build reporting solutions with Power Pivot. It provides you with a solid understanding of Power Query, Power Pivot, and building dashboards that can be shared across your organization.

Topics


  • Overview of Power Pivot, Power Query, and Power View
  • Loading data from external sources
  • Using the DAX Language
  • Refreshing the PowerPivot data model

  • Understanding DAX calculations
  • Understanding calculated columns and fields
  • Handling errors in DAX expressions
  • Formatting DAX code
  • Common DAX functions
  • Using basic DAX functions

  • Understanding the basics of data modeling
  • Relationships in depth
  • Understanding normalization and denormalization
  • Star Schemas
  • Over Denormalization

  • Connecting to data and creating a query
  • Data cleaning
  • Data structure
  • Query operations

  • SharePoint and PowerPivot integration
  • Licensing and setup
  • Publishing a workbook to SharePoint
  • Using the PowerPivot gallery
  • Connecting Excel to a SharePoint Excel data model
  • Creating a Power View report
  • Managing the PowerPivot data refresh

  • Why is CALCULATE needed?
  • Using CALCULATE inside a row context
  • CALCULATE rules

  • Building a calendar table
  • Aggregating and comparing over time
  • Closing balance over time
  • Computing moving averages

Agenda


Day 1

09:00 – 11:30
Introduction to Power Pivot
11:30 – 12:30
DAX Fundamentals
12:30 – 13:30
Lunch
13:30 – 15:00
Data visualization
15:00 – 17:00
Data Modeling

Day 2

09:00 – 11:30
Power Query
11:30 – 12:30
Publishing to SharePoint
12:30 – 13:30
Lunch
13:30 – 14:30
Filter context and CALCULATE
14:30 – 15:30
Time calculations
15:30 – 17:00
End-to-End Case

FAQ


We do not guarantee a specific instructor per course but we make sure your training is led by an expert in the field. Our trainers have experience across different industries and unique knowledge of applications of the analytical tools.

Everything. Really- no tricks here, it is the price excluding VAT. And it is the end price, no extra travel cost or allowance cost for the trainer, no location charges or other hidden traps. What you see is what you get.

It is common for the course participants to approach us with their specific problems based on company data. It is often sensitive data and we would like to make sure you can feel save and secure about it. Therefore, we always recommend signing an NDA and send it along as our pre training preparation package.

Inhouse training (at your office) and Open registration trainings are conducted in English unless specifically agreed otherwise; however, support is provided in English, Dutch, Polish, and German.

At the end of the training you will receive a certificate of completion, which specifies the learned contents of the seminar.

Yes it is possible, however it may generate additional cost depending on the magnitude of changes. We would like to discuss it case by case to find an optimal solution. If you are interested in developing a training based on your data drop us a line.

We are flexible and will adjust to your needs as we go. The instructor can quickly recognize the level and learning curve of the group and adjust the pace, cases and topics as needed during the training. Usually 10% of the course outline is moderated during the training.

Inhouse training means we come to your office to conduct training. Therefore, having a dedicated room where all participants feel comfortable is important. Alternatively, in extraordinary circumstances, we could arrange a training location for your team but this would come at additional expense. The Open Registration means you join a training in one of our locations and join participants from different companies at a designated training location.

  1. Once you inquire offer, we will send you a pdf document with exact course outline and our offer.
  2. If you like it, you confirm the booking via email and we block the training dates that suit you.
  3. We follow-up with pre training preparation and setting up all the details so that the training can run smoothly.

Other Excel Trainings