Auldhouse Anywhere

Auldhouse Anywhere

Our range of Auldhouse Anywhere courses enable you to join live classroom training online – saving you time and money on travel.

Find out More
E-Learning

E-Learning

Discover the benefits of taking a course online at your own pace.

Find out More
Webinars

Webinars

Auldhouse deliver a number of vendor specific webinars. Webinars give you an effective training option with the freedom to attend from virtually anywhere.

Find out More

Building BI in Excel

Code:
BBIE
Days:
2 Days
Price:
$1,500 excl GST
Code:
BBIE
Days:
2 Days
Price:
$1,500 excl GST
Overview:
In this 2-day course, you will learn how to leverage Power Query and Power Pivot to build full business intelligence solutions from text files and databases, creating refreshable and maintainable solutions. Developed by a CPA with real world experience who is also a renowned Power Query expert, this course works through best practices of sourcing data, building calendar tables, using time intelligent DAX measures, and creating dashboard reports that can be refreshed with two clicks.
Download Course Outline
Course Outline (PDF)

Objectives:

In this 2-day course, you will learn how to leverage Power Query and Power Pivot to build full business intelligence solutions from files and databases, creating refreshable and maintainable solutions. Developed by a CPA with real world experience who is also a renowned Power Query expert, this course works through best practices of sourcing data, building calendar tables, using time intelligent DAX measures, and creating dashboard reports that can be refreshed with two clicks.

Target Audience:

Anyone who needs to pull data into Excel, clean it up and/or consolidate it, and build reports.

Prerequisites:

Participants must have experience using PivotTables. Some exposure to PowerPivot and Power Query is an asset, but not required.

Additional Information:

This is a hands-on course. Participants should bring a laptop running one of the following:

  • Excel 2013 Professional Plus1 or Excel 2013 ProPlus1 with Power Query installed2
  • Excel 2016 Professional Plus1 or Excel 2016 ProPlus1
  • Excel 20193
  • Excel 365 (installed via an Office 365 subscription)

Trainer profile: https://mvp.microsoft.com/en-us/PublicProfile/36828

Register now for this course

Please take special note of the course prerequisites as it is important that you meet these requirements before attending the course. If you have any questions about dates or locations please dont hesitate to make an enquiry contact us on 0800 835 835.

No classes currently scheduled in your location?Enquire about this course

Interested in a private class? Enquire about a private class