Excel as a BI Tool - Power Pivot and Power Query 101


Wednesday, January 30, 2019   |   10:00 AM PST | 01:00 PM EST   |   Duration: 90 Minutes      

Live

One Dial-in One Attendee

Price: US$150.00


Corporate Live

Any number of participants

Price:US$290.00


Duration: 90 Minutes  

Recorded

Access recorded version,
only for one participant ?

Price: US$190.00

Corporate Recorded

Access recorded version,
Any number of participants ?

Price: US$390.00

By attending this webinar you will learn how to Import Data into Power Pivot why and how.
Mike Thomas   Product Id : 502263
  Instructor : Mike Thomas

  More Trainings by this Expert


Overview:

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)

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).

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

Areas Covered in the Session:

  • 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 Will Benefit:
  • Anyone who wish to learn about Power Pivot and Power Query


Speaker Profile
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 He 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 organisations 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.




Your Recently Viewed Webinars

Payment Methods

Contact Us

NetZealous LLC,
161 Mission Falls Lane, Suite 216,
Fremont, CA 94539, USA.

Information

  Refund Policy
  +1-800-447-9407
  support@compliance4All.com