Learn the Amazing Capabilities of Power Query, Power Pivot And Power BI

Thursday, Jul 28, 2022 at 9:00 AM to Friday, Jul 29, 2022 at 5:00 PM AEST

Register Now

Registration

Sale ended

Super Early Bird Fee Partial Approval - $1,595.00

sales ended

Early Bird Fee Partial Approval - $1,695.00

Sale ended

Standard Fee Partial Approval - $1,795.00

Enter your discount code

  • Subtotal (excluding fees and discounts)
  • Fee
  • Total amount

Thursday, Jul 28, 2022 at 9:00 AM to Friday, Jul 29, 2022 at 5:00 PM AEST

Powers BI (including Power Query & Power Pivot) is the biggest Excel news items in the last 10 years. They give Excel users the power to draw information out of multiple sources, link it together then perform calculations on it that can then be sliced & diced any way you want.

This hands-on course is focused on real-world techniques utilizing the amazing capabilities of Power Query, Power Pivot and Power BI.

The course covers the core elements needed to get an understanding of what Power BI, Power Pivot and Power Query can do. You will use Power Query to extract and shape data and then load it into Power Pivot.  You will build a complex Power Pivot Model from scratch, write DAX formulas and set up interactive reports.

The second day delves deeper into all of the topic areas demonstrating how to get the most from these amazing tools.  You will learn extra advanced Power BI features and get a more in-depth understanding of Power Query and Power Pivot reporting techniques

Learning Objectives:

  • Understand how Power BI builds on the functionality of Excel’s native tools, such as Pivot Tables, slicers and key analytical functions
  • Be able to import data from a variety of electronic sources and relate them quickly to deliver key information in minutes not weeks
  • Utilize best practice database design, realizing the power of the Data Model by using LOOKUP lists and efficient database design
  • Provides an introduction to Power BI Data Analysis Expressions (DAX) language

Agenda:

Days 1 & 2:

  • Power BI & Power Pivot Introduction
  • In-depth Power BI & Power Pivot Models
  • Power Query
  • In-Depth Power Query
  • Power BI Desktop & POWERBI.com

Prerequisites:

  • This is an intermediate course and users should already be comfortable with Excel to get the most from this course.
  • Participants should be familiar with functions & concepts such as VLOOKUP and SUMIFS.
  • The focus of the course on Power BI in Excel 2013/2016 and is also applicable to Power BI Desktop.

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Examination:

There is no exam for this course.

Note: If you would need any assistance, let me help you to get registered. Reach us at: info@mountskills.com

Mountskills_inc

Mount Skills is known as one of the world's leading competency developers that brings a unique approach to building specialized training programs. Mount Skills training divisions offer the same level of expertise and experience, which makes us stand out from the competition. Through our training courses, we help transform your organization for the better. By adopting advanced Techniques and New Ways of Working, we empower your staff with the knowledge and guidance to understand, engage with, and influence change. In-Class training programs are designed for individuals, who seek more personalized training experience and hands-on training requirements wherein Virtual Live is immersive learning, guided by the subject matter experts. All our classroom training sessions can be conducted On-Site at your workplace or a location that you choose, for the convenience and peace of mind of your employees. We help you develop any skill you need for any role. Participants will greatly benefit from our skill-set.

Contact the Organizer View other events