Business Intelligence and Data Analytics using Power BI: A Practical Programme for Professionals, Managers and Executives

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.

Microsoft Power BI lets you connect, transform, analyze, and visualize data very efficiently, which will enable Professionals, Managers and Executives 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. The practical examples and hands-on exercises used in the workshop 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.

This workshop qualifies for 7.0 CPE hours in Information Technology (Category 5).

Target Audience

Professionals, Managers and Executives who would like to develop baseline knowledge and fundamental skills in Microsoft Power BI

Expert Speaker

John Kim

John is a US Certified Public Accountant licensed in New York State, and currently leads a Finance Transformation Advisory. 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 was formerly a director of EY’s Tax Technology and Transformation group (formerly known as Tax Performance Advisory) in Washington DC, New York City, and Singapore.

John utilizes over fifteen years of combined experience in corporate finance/tax technology and performance improvement, finance/tax operating model design, finance/tax technology roadmap design, executive financial dashboard design and management, finance/tax data modeling and warehousing, ERP finance/tax integration to help corporate finance and tax functions improve performance and manage business risks using business intelligence.