Business Intelligence and Data Analytics using Power BI: A Practical Introduction for Finance, Accounting and Tax Professionals

Description

For information regarding CCH Learning Events Covid-19 Health and Safety Practices, please click HERE. 

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.

Microsoft Power BI 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 hands-on workshop is a practical introduction to Microsoft Power BI and will help you to develop the basic skills to start analyzing and visualizing data with Power BI. After completing this highly engaging workshop, you will be able to prepare and organize data, create relationships between data, design and create reports in Power BI. Drawing from his valuable background in Accounting and Tax, the Trainer will be using Profit and Loss, Balance Sheet and 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.

A more advanced workshop in Power BI will be conducted subsequently if you wish to take your skills further after this session.

What you will learn

By the end of the workshop, you will :

  • Learn the basic skills to start analyzing and visualizing data with Power BI
  • Be able to prepare and organize data, create relationships between data, design and create reports in Power BI
  • Be able to change the data source and refresh the reports in Power BI

Programme Outline

Getting started with Power BI
What is business intelligence?
What is Power BI?
How do you carry out data analysis?

  • Prepare source data
  • Organize source data
  • Analyze and visualize data

Prepare source data with Power Query
What is the Power Query (M)?
How do I connect to an Excel workbook?
How do I connect to a CSV file?
How do I edit a query?
How do I format data?

Analyze and visualize data
How do I navigate the Power BI visualization canvas?
How do I insert and format visualizations?

Organize source data with data modelling and DAX
What is data modelling?
What are related tables?
What is DAX?
What are calculated columns? What are measures?

Analyze and visualize data from data model
How do I view reports, data, data model?
How do I add and use filters and slicers?

Create multiple reports
Filtering options
Report interactions
Bookmarks

Laptop Requirements

Your internet-enabled laptop should be 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 and tax professionals who would like to develop baseline knowledge and fundamental skills in Microsoft Power BI

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 face-to-face event to be conducted on 22 October 2020

  • Oct 22
    Thu, 9:00 AM - Thu, 5:00 PM Hotel Venue to be Advised
    • $535.00 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.