Power query and power pivot for Excel Training in Sydney on 11th -12th Jul

Certificate: Course Completion Certificate || Language: English

Duration: 2 Days || Credits: 16 || Course Delivery: Classroom

Refreshments: Snacks, Beverages and Lunch included in a classroom session

Course Overview

Power BI (including Power Query & Power Pivot) are 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 understand what Power BI, Power Pivot and Power Query can do. You will use Power Query to extract and shape data and 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

Target Audience:

• Excel users & analysts that focus on extracting, re-organizing, and analyzing data
• Excel users & analysts involved in creating visualizations & data modeling
• Anyone interested in saving huge amounts of time in automating the work involved in creating recurring reports and dashboards

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
• Utilise 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
• 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.

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader) eBook download and activation instructions

Host or Publisher Mount Skills