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

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.

PLACES ARE GOING FAST

Reserve your spot, change your daily life now.

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

Format
Power Pivot and dashboards
Workshop with instructor
Databases, Power Query and DAX
Workshop with instructor
DAX measures
Workshop with instructor
Duration
Power Pivot and dashboards
120 minutes
Databases, Power Query and DAX
120 minutes
DAX measures
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

HYBRID CLASSES: A CONCEPT ADAPTED TO TODAY’S REALITY THAT IS CHANGING THE WORLD OF CORPORATE TRAINING

LIVE WORKSHOPS WITH AN INSTRUCTOR

Direct access to your instructor to answer all your questions and teach you key concepts.

  • Expert, motivating and friendly instructors
  • Dynamic and stimulating workshops, focused on practical exercises with real-life situations
  • Direct access to your instructor to answer all your questions
  • Workshops of 60 to 120 minutes that can easily be adapted to various schedules

HIGH QUALITY ACCOMPANYING VIDEOS

Access to the complete program via online capsules with exercises to complete at your own pace.

  • Access to a complete online video program with practical exercises
  • Logical and structured path to optimal learning
  • Allow participants to learn at their own pace via an easy-to-use platform
  • Professional production studio allowing us to partner with organizations to customize the content and look of the videos

FULL ONE-YEAR SUPPORT

Enjoy a full year of support and access to our expert instructors!

  • A full year of access to our expert instructors
  • Access to an online community and to questions already asked on the forums
  • Personalized and impeccable customer service

TESTIMONIALS FROM THE IMPROOV COMMUNITY

5.0 226 reviews

  • Avatar Jeffrey Vaillancourt ★★★★★ il y a 6 mois
    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 4 mois
    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 6 mois
    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.

YOU WOULD LIKE TO FORM A GROUP?

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!