2-Hour Virtual Seminar on Excel as a BI Tool – Power Pivot and Power Query 101

Power Pivot and Power Query are free addins for Excel, written by Microsoft (in fact in Excel 2016 and later Power Query is built into the application and not an addin at all).

Power Pivot puts the “power” into Pivot Tables (hence the name!), removing many of limitations and frustrations that many advanced users find with Pivot Tables (such as creating pivot tables from multiple lists and creating pivot tables from large datasets)

Why You Should Attend:

Power Query is used to import data into Excel from other sources (such as CSV files, text files, web pages, databases or SharePoint) and then clean that data to make it useable (cleaning refers to things like removing duplicate rows, removing blank rows, removing unnecessary columns, converting case, changing date formats and more).

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!

Seminar Agenda:

  • Importing data into Power Pivot – the why and how
  • Using the Data Model to create and manage relationships
  • The benefits of using the Data Model
  • Creating a Pivot Table from related Excel tables
  • Creating a Pivot Table from related data sources (including external sources)
  • An introduction to the DAX formula language to create simple calculated columns
  • Using the Query Editor to clean and transform data

Who Should Attend:

This training is aimed at users of Excel (2010 and above 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.

IMPORTANT NOTE: Power Pivot and Power Query may not be available for your version of Excel. If you are unsure whether this training is relevant for your version of Excel, please check with your IT department.
IT3285

Mike Thomas

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac.

In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials.

He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.

Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors.

In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

membership

JUST RELEASED
SEMINARS
&
WORKSHOPS
 





  • Login Information with Password to join the session, 24 hours prior to the webinar
  • Presentation Handout in .pdf format
  • Presentation from the Speaker
  • Feedback form
  • Certificate of Attendance
  • Recording access Information with Password to view the webinar, will be sent 24 hours after the completion of the Live webinar.
  • Presentation Handout in .pdf format
  • Certificate of Attendance
.