Excel: Power Pivot, Power Query and DAX - Improov

Excel: Power Pivot, Power Query and DAX

Discover Excel’s most powerful analytical tools

l

3 workshops

OF TRAINING

Live online

VIRTUAL CLASS

$497.00

6 HOURS OF CONTENT

Contact Us

TO RESERVE

Learn how to use Power Pivot and the basics of Power Query and DAX to manage large amounts of data from multiple sources.

 

The Excel Advanced Level on Power Pivot, Power Query and DAX is an introduction to Excel’s most powerful analytical tools. The Excel user who works with multiple data sources and large data sets will see a significant increase in productivity and quality of reports. This level allows you to become more comfortable with the pivot table tools and turn them into interactive dashboards, as well as discovering the power of the Power Pivot extension. It is a gateway to Microsoft’s new analytical tools and new ways of managing data.

At this level, you’ll learn how to join multiple data sources to make dashboards. You will also discover how to fetch data from multiple sources and schedule manipulations of that data with Power Query. You will also get a taste of the computational power of DAX (Data Analysis Expressions) to create complex calculations that are not accessible with basic pivot tables.

This level is offered in 3 workshops of 2 hours each, online with expert instructors. It requires a commitment from the participants because of the intensity of its content, both during and between workshops. In order to stay on track, they will need to ensure that they have fully integrated the first two workshops before moving on to the third. Even if this level is demanding, the benefits it will bring are worth it and any advanced Excel user will find it worthwhile.

ARE YOU MORE THAN 7 WANTING TO TAKE THE SAME COURSE?

We offer private lessons. Contact us for more information.

WHAT YOU WILL LEARN

  • Producing interactive and professional dashboards
  • Joining multiple data sources with Power Pivot
  • Automating the import of data tables with Power Query
  • Understanding basic concepts and best practices in databases
  • Using DAX metrics to generate complex calculations

TRAINING PROGRESSION

Power Pivot and dashboards
Databases, Power Query and DAX
DAX measures
Format
Workshop with instructor
Workshop with instructor
Workshop with instructor
Duration
120 minutes
120 minutes
120 minutes

Excel: Power Pivot, Power Query and DAX

Workshop 1: Power Pivot and Dashboards
  • Essential concepts and best practices in databases
  • Introduction to the data model
  • Joining data from multiple sources in Power Pivot
  • Creating an interactive dashboard from these multiple sources
  • Joining multiple sources to slicers and timelines
  • Pivot charts
Workshop 2: Databases, Power Query and DAX
  • Using Power Query to automate importation of and normalize data
  • Understanding the different tools in Power Query to manipulate data
  • In-depth understanding of table relationships and filter direction
  • Basic concepts of DAX and Power Pivot measures
  • Differentiating between calculated columns and DAX measures
Workshop 3: DAX measures
  • Best practices for creating DAX measures
  • Linking data with RELATED and RELATEDTABLE
  • Aggregation DAX functions: SUMX, AVERAGEX, COUNTX, etc.
  • Enhancing filtering capabilities with FILTER
  • Creating versatile, reusable and powerful analyses

TESTIMONIALS FROM THE IMPROOV COMMUNITY

5.0 254 reviews

  • Avatar Jeffrey Vaillancourt ★★★★★ il y a un an
    This was a very useful training! I have feel I am more productive with the skills I picked up in this course. Benoit was great and very personable.
  • Avatar Corinne Dulude ★★★★★ il y a un an
    François is knowledgeable and understood what I needed in the one-on-one hour I won with him. Can't wait to practice all the best practices I've learned. Thank you!
  • Avatar Chris Wonnell ★★★★★ il y a un an
    Francois and Improov helped me stay organized professionally (Gmail), and understand how to use Google Drive. The virtual training sessions were clear, concise, and informative. I would recommend training with Improov.

Improov logo formation cours training

Want tips and tricks on how to improve your professional efficiency?

Sign up to receive information that will help you optimize your time and master your everyday technological tools.

You have Successfully Subscribed!