$594 – $742.50

Microsoft Power BI for Excel Workshop on May 15, 2018

Event Information

Share this event

Date and Time

Location

Location

Barangaroo

International Towers Three

300 Barangaroo Ave

Sydney, NSW 2000

Australia

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

Microsoft Power BI for Excel Workshop

CMBI's one day, tutor-led "Introduction to Power BI" training workshop provides you with hands-on experience of Power BI for Excel.

Through a series of practical exercises, we guide you through Power BI's core components, including Excel Power Query, Excel Power Pivot, and Power BI Desktop.

During the workshop you will learn how to:

  • Automate data import and cleansing with Power Query, so you can focus on turning data into information.

  • Integrate data from multiple different data sources with Power Pivot to provide a robust and flexible organisation-wide data model that simplifies your analysis and reporting.

  • Extend the capabilities of Pivot Tables in Excel and create impressive reports and dashboards in both Excel and Power BI Desktop.

This introductory workshop is a must for business professionals requiring practical techniques for tackling real-world data and reporting challenges. We guarantee you'll want to apply these new skills as soon as you walk out of the training room.

Cost

Early Bird Price: $540 + GST (20% off the full price ticket if booked and paid for by April 30, 2018)

Full Price: $675 + GST

Date & Venue

Time: 9:00am to 5:00pm

Date: Tuesday May 15, 2018

Location: International Towers in Barangaroo, Sydney (five minutes walk from Wynyard station in Sydney's CBD)

Small Class Sizes

A small group size - maximum 5 attendees - means everyone gets the one-on-one support they need to complete the practical exercises. It also encourages active participation, collaboration, and questions throughout the session.

Who Should Attend This Workshop?

  • Experienced Excel users seeking new skills and tools to better manage, manipulate and present data in Excel

  • Managers and decision-makers looking to improve their organisation's Business Intelligence capabilities with Microsoft's Power BI tools

Post-Training Support & Materials

Our course materials support learning and re-enforcement well beyond the workshop. Each attendee receives a USB of annotated videos covering all the concepts and techniques introduced during the workshop. We also provide email support for any questions arising from the workshop or training materials.

Visit the Learning and Support Materials page on the CMBI website to view an example of our post-training support videos.

Prerequisites & Suggested Experience

  • Attendees looking to improve their technical skills should be familiar with Excel PivotTables and functions such as SUM, IF and VLOOKUP.

  • Non-technical decision makers are also welcome to attend and can participate in the exercises or simply observe the capabilities demonstrated by each of the workshop tasks.

Detailed Workshop Outline

Introduction to Power BI

  • What is Power BI?

  • Overview of the different products in the Power BI family

Introduction to Power Query

  • What is Power Query?

  • Overview of the Power Query environment

Extracting, Transforming & Loading Data with Power Query

  • Extracting data from a variety of different data sources

  • Cleansing & transforming data

  • Taming unstructured data with Unpivot

  • Loading the transformed data to Excel or Power Pivot

Integrating Data with Power Query

  • Grouping data

  • Merging data

  • Appending multiple data sets together

  • Appending files in a folder location together

Creating Self-Service Workbooks with Parameters

  • Creating & maintaining parameters in Power Query

  • Creating & maintaining parameters in Excel

  • Pros and cons of the two approaches

  • Refreshing parameterised queries

Introduction to Power Pivot

  • What is Power Pivot?

  • Overview of the Power Pivot environment

  • Loading Data into Power Pivot

Creating calculated columns & measures in Power Pivot

  • Calculated Columns

  • Creating measures using DAX

  • Understand the capabilities of the CALCULATE statement

Data Modelling with Power Pivot

  • Creating relationships between multiple tables in your data model

  • Exploring typical relationship types

  • Working with multiple tables in an Excel Pivot Table using Power BI

Presenting Data in Excel

  • Power Pivot tables

  • Slicers and Timelines

  • Conditional Formatting

  • Excel Charts and Graphs

Creating Visualisations in Power BI Desktop

  • What is Power BI Desktop?

  • Overview of the Power BI Desktop interface

  • Loading a Power Pivot Data Model into Power BI Desktop

  • Creating Visualisations with Power BI Desktop

Download the detailed Workshop outline Download the detailed Workshop outline


Contact Us

For more information on the training and other services we offer, contact Julie McGowan via CMBI's contact page.

FAQs

How can I contact the organiser with any questions?

For questions or more information contact Julie on:

Email: julie@cmbi.com.au

Via our website: http://www.cmbi.com.au/

What equipment do I need to bring to the workshop?

We encourage workshop attendees to use their own laptops for the duration of the workshop. That way, you are learning Power BI on the version of Excel that you will be using back at your desk. However, if you do not have your own laptop, or would prefer to use one of CMBI’s for the day please contact Julie at julie@cmbi.com.au to discuss what options are available.

Prior to the workshop, attendees must ensure they have Excel 2010, 2103 or 2016 installed on their laptop, and the Power Query and Power Pivot Add-ins are installed and working (if required). A step-by-step guide on how to do this will be provided to all attendees ahead of the workshop.

What are the closest parking facilities near the venue?

The closest public parking facilities within walking distance of Barangaroo are:

Is my workshop registration transferrable to another person if I am unable to make it?

Yes, your place in the workshop is fully transferrable to another person in the event you are unable to make the original date. Just let CMBI know and we will update the registration details.

What's the refund policy?

Attendees may cancel up to 7 working days before the course date and receive a full refund or credit for a future course. Attendees who cancel less than 7 working days prior to the course date will receive credit for a future workshop.

Share with friends

Date and Time

Location

Barangaroo

International Towers Three

300 Barangaroo Ave

Sydney, NSW 2000

Australia

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved