Excel - Business Intelligence with Power Pivot and Power Query

On Demand Webinar

Webinar Details $219

  • Webinar Length: 100 Minutes
  • Guest Speaker:   Mike Thomas
  • Topic:   Business Administration, Finance, Taxation and Accounting, Business Skills, Software
  • Credit:   ATAAA 1.5, ATATX 1.5, ATAOP 1.5

All Access Membership

Do you work with "Big Data"? Do you import, manipulate and analyze massive datasets in Excel? If so you’ll already be familiar with the limitations of Excel. Power Pivot and Power Query, two free add ins for Excel, are designed to get you past these limitations, allowing you to import and work with 1-million-plus-row datasets from virtually any source.

If you ever need to create pivot tables from multiple datasets, Power Pivot is your friend. No more vlookup. No more multiple consolidation ranges. If you’ve been frustrated by other limitations of pivot tables then Power Pivot is for you. Simply put, Power Pivot takes pivot tables and data analysis to the next level. If you’re a fan of pivot tables, you’ll love Power Pivot.

Power Query can save you a ton of time when working with imported data. In many cases when you get data from external sources, it needs work on it before it can be used. Although this can be done using Excel functionality, Power Query is a lot faster, can handle much more data, and is repeatable with a couple of clicks. 

If you work with, analyze and generate reports from large datasets, having a good understanding and working knowledge of Power Query and Power Pivot is a must!

Topics covered

  • Installing Power Pivot
  • Data Models
  • Creating relationships in Power Pivot
  • Importing data into Excel from external sources
  • Introduction to DAX formulas
  • Power Query data sources
  • Cleaning data
  • Transforming data
  • Merging data
  • Un-pivoting data

This event is aimed at users of Excel (2010, 2013 and 2016 for Windows) who wish to learn about Power Pivot and Power Query. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating pivot tables.

ATAAA Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in administrative.

ATATX Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in accounting.

ATAOP Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in operations.

Guest Speaker

  • Mike Thomas

    Mike Thomas

    Mike Thomas has worked in the IT training business for 26 years. His expertise and experience covers designing and delivering training courses, creating written training materials (Quick Reference Guides and step-by-step tutorials), recording and editing video-based tutorials and providing support t [...]

    View Full Profile

Webinar Survey Overall Rating

This webinar received a total of 8 survey responses. Attendees have given an average rating of 4.5 stars out of a possible 5, reflecting the quality and value of the content presented.

Average rating

4.5 / 5
Webinar Presentation
How many of the objectives of the event were met?
4.8 Stars
How useful was the information presented at this event?
4.6 Stars
Overall, how satisfied were you with this event?
4.4 Stars
Speaker Performance
Overall, how satisfied were you with this presenter?
3.7 Stars
How closely did the presenter follow the schedule?
4.8 Stars

Reviews From Webinar Survey

Our webinars are crafted to deliver exceptional value and insight to business professionals. To ensure we meet and exceed your expectations, we conduct thorough post live webinar surveys. Below, you'll find genuine feedback from attendees, sharing their thoughts on the event and the speaker's performance. These reviews highlight our commitment to continuous improvement and excellence in providing top-tier educational experiences.

Aurora R.
March 4, 2019
4.5 / 5
Webinar Rating:
4.3 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
no comment
Aurora R.
March 4, 2019
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
no comment
Aurora R.
March 4, 2019
3.6 / 5
Webinar Rating:
4.0 Stars
Speaker Rating:
3.0 Stars
Do you have any other comments, questions or concerns?
Seems like there was a lot of material covered and it was just about all new to me. Presentation may have tried to cover to much material for me
Aurora R.
March 4, 2019
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
no comment
Aurora R.
March 4, 2019
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
The presenter was very knowledgeable . . and pleasant. He covered all topics, sometimes multiple times when asked to repeat steps . . . and even covered additional topics when a question was presented.
Aurora R.
March 4, 2019
3.4 / 5
Webinar Rating:
3.7 Stars
Speaker Rating:
3.0 Stars
Do you have any other comments, questions or concerns?
I would have preferred for presenter to show the steps twice so we could try to duplicate his steps. The files sent ahead of the webinar was a big help.
Aurora R.
March 4, 2019
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
Wonderful job on showing demonstration of Power Pivot and Power Query. Really helps when you talk about the different years of EXCEL when you give an example, as my home and my work have two different years of EXCEL. Thanks!
Aurora R.
March 4, 2019
4.2 / 5
Webinar Rating:
4.7 Stars
Speaker Rating:
3.5 Stars
Do you have any other comments, questions or concerns?
no comment