Overview

Power Query is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis

This course will introduce all the Business Intelligence technologies including: Power BI, DAX, Data Modelling (Power Pivot), M. We will go through a methodology for automating all your reporting needs and how to create beautiful reports and dashboards giving you a 360 degree view of your business.

Course Objectives

The course also covers Reconciliation techniques using excel functions, pivot tables, power query and new reconciliation tools like the Inquire Addin

  • Describe the interface for the Power Query tool

  • Apply Power Query to automate the report update process.

  • Construct an Advanced and automated reconciliation tool using the Power Query application

Featured Testimonial

“Its been very exciting experience for me. I enjoy the simplicity and practical experience garnered so far. Thank you very much for this”

STANLEY ALOZIE

“Very Knowledgeable And Has Passion For The Course And Profession He Was On Point Throughout The Course ”

Olugbenga Ajayi

“Good Overall, Articulate And Knowledgeable Very Professional And Has Ability To Impact Knowledge Excellent Performance, Well Paced And A Strong Personality ”

oluwatoyin yomi-akeredolu

Some of Our Clients

Course Curriculum

Here's what you'll learn...

  • 1
  • 2

    Download Exercise & Lab Files

    • Introduction to Power Query - Exercise Files & Labs

    • Discussion

  • 3

    The Reporting Infrastructure

    • The Reporting Infrastructure

    • Lab 01 - How Excel Works

    • Reporting Framework & the 7 Golden Rules of Data

    • The role of the Control & Report Sheets

    • How Excel Works

      FREE PREVIEW
    • Managing Dates, Validations & Format Styles

    • Report update with Power Query

    • Chapter Quiz

    • Discussion

  • 4

    Get Data with Power Query

    • Get Data with Power Query

    • Lab 02 - Get Data with Power Query

    • Getting External Data into Excel

    • Connect to Excel Files in a Folder

    • Consolidate Excel Workbooks

      FREE PREVIEW
    • Transform Data Types

    • Loading your Query to Excel

    • Chapter Quiz

    • Discussion

    • Instructions

    • Before you go...

    • How to Attach your Certificates to your LinkedIn Profile

Instructor

David Brown

FCA, Microsoft MVP

David has worked with and taught Excel and financial modelling to over 4,000 people in the last 22 years. He is the Managing Partner of dbrownconsulting where he runs the Consulting Division.He is a Fellow of the Institute of Chartered Accountant of Nigeria & a Financial Analyst with over 16 years experience working as a Business intelligence, Financial Modelling & Tax Consultant with Arthur Andersen, KPMG & dbrownconsulting.He is also an International Consultant to the World Bank on Oil Revenue Modelling and is a registered financial adviser.David attained the Master Trainer & Master Instructional Designer designation from the Association for Talent Development (ATD).He is passionate about Financial Modelling, Business Intelligence and Analytics especially with Microsoft Power BI and Excel and regularly host meetups and speaker event in Nigeria and around the world.