An Intermediate Programme on Business Intelligence and Data Analytics using Power BI and Excel

Description

Microsoft Power BI has been recognized as one of the leaders for Analytics and Business Intelligence Platform in the Gartner Magic Quadrant for many consecutive years. It lets you connect, transform, analyze, and visualize data very efficiently, which will enable any finance, accounting, tax professionals to perform more powerful data analytics in almost real time.

This is an intermediate level workshop designed specifically to allow you to develop advanced skills to collect data from various sources, transform data, and create measures using Microsoft Power BI and Microsoft Excel in more complex scenarios. After completing this hands-on and highly engaging workshop, you will be able to prepare data using advanced query editor, organize and create relationships between data sets, create measures using DAX, import data model from Excel, design, create, and share reports in Power BI.

Drawing from his valuable background in Accounting and Tax, the Trainer will be using Profit and Loss, Balance Sheet or POS data in the examples and hands-on exercises. This will facilitate learning and allow you to directly apply your knowledge learned in the workplace.

What you will learn

By the end of the workshop, you will :

  • Be able to get data from various sources in Microsoft Excel and in Power BI
  • Be able to prepare large amount of source data efficiently in Microsoft Excel and in Power BI
  • Be able to create and use more complicated DAX measures in Microsoft Excel and in Power BI
  • Be able to share reports in Power BI Service

Programme Outline

Module 1: Connecting to other data sources

  • Database
  • Folder
  • Web
  • API

Module 2: Advanced data transformation techniques (M)

  • Merge vs. append
  • Merge vs. data modelling
  • Cardinality
  • Pivot and unpivot
  • Parameter
  • Custom function

Module 3: Advanced measures (DAX)

  • Implicit vs. explicit measures
  • Calculated column vs. measure
  • Filter context & cross filtering
  • Common DAX functions
  • Iterator DAX functions

Module 4: Publishing and sharing reports

  • Importing data model from Excel
  • Report vs. dashboard
  • Filtering options
  • Report interactions
  • Bookmarks
  • What-if analysis
  • Sharing

Prerequisites

You should ideally have:

  • A basic knowledge in common Excel functions such as IF, SUMIF, VLOOKUP, HLOOKUP, and
  • A basic knowledge in Excel pivot tables and pivot charts, and
  • A basic knowledge in relational database, or
  • Have attended the “Practical Introduction workshop in Business Intelligence and Data Analytics using Power BI” conducted earlier

Laptop Requirements

Your laptop should be:

  • Internet-enabled, and installed with Microsoft Excel 2013 or newer version
  • Installed with Microsoft Power BI Desktop. The steps to download and install are as follows:
  1. Go to the official Power BI webpage (https://powerbi.microsoft.com/en-us/desktop/) and click “Download Free” button to start the download process.
  2. Once download is complete, run the installation file.
  3. When you open Power BI Desktop, you will be asked to log in to your Office 365 account. For this workshop, you don’t need to log in. Simply close the window by clicking “x” in the upper right-hand corner.

Target Audience

Finance, accounting, or tax professionals with some baseline knowledge and fundamental skills in data analytics and would like to be able to perform complicated data transformation, calculation, and visualization in Microsoft Power BI and Excel.

Expert Speaker

John Kim

John leads the business intelligence service practice of A Tax Advisor Pte Ltd. He provides a variety of solutions (e.g., technology and data strategy, data transformation and integration, process improvement and automation, and data analytics services) and business process outsourcing services to corporate finance and tax departments.

He utilizes over fifteen years of combined experience in corporate financial reporting and analysis, corporate tax compliance and provision, executive financial dashboard management, technology and performance improvement, data modeling and warehousing, and ERP integration to assist corporate finance and tax functions with improving performance and managing business risk using business intelligence.

Before joining A Tax Advisor Pte Ltd, John was part of EY’s Tax Technology and Transformation group (formerly known as Tax Performance Advisory) in Washington, New York City and Singapore.

Prior to joining EY, John was a financial analyst in charge of the development of Business Objects tools, data modeling and warehousing, and executive financial dashboard management for a global manufacturing company in the United States.

This is a 2-days webinar to be conducted on 13 - 14 August 2020

  • Aug 13
    Thu, 1:30 PM SGT - Fri, 5:00 PM SGT Online
    • $363.80 incl. GST (7%)
    • PD hours: 7

Coming Soon

All Coming Soon >>

One-Connection-One-Fee

Our webinars operate on a 'one-connection-one-fee' basis, so you can have your whole team participate together in a boardroom setting for one cost effective price, using one registered log-in connection. The registered attendee will receive a CPD certificate.

Recordings

Like the topic but can’t make the time? Register for the Live Session and you’ll receive the Recording regardless! Recordings are provided for webinars with a duration of 3 hours and less.