New user? Register as member

Power BI for Beginners ( 1 day workshop)

“Data is the new oil” - The Economist, May 2017

In this data age, the ability to extract value from data is a highly sought after by both individuals and organizations. And it takes hard technical skills to manage the large datasets and extract insights from the data, but it comes to naught unless the insights can be clearly and quickly communicated to the intended audience. Data visualization provides a graphical representation of the data to communicate key insights quickly and effectively; even to those who are less numerically inclined. To this end, data visualization has very become indispensable part of the analytics toolkit today.

This workshop aims to provide a broad but practical overview of the entire analytics value chain; with a focus on using data visualization to convey intended messages from the data to an audience. Attendees will learn the fundamentals of visualisation and get their hands “dirty” building different visualizations using Microsoft’s PowerBI (cited in Gartner’s magic quadrant as one of the top platforms for business intelligence in 2019). This is targeted at professionals and managers in non-analyst roles but may be required to work with or make sense of data and presenting data in their work.


Participants are required to bring their laptops with Power BI preinstalled. Please click the link to install Power BI. It is essential. (https://powerbi.microsoft.com/en-au/desktop/)

Objective

By the end of this course, the participants would be able to：

• Appreciate the impact that data visualisation has on the realization of value in analytics; particularly in today’s data driven world
• Understand the basics of Power BI navigation
• Gain practical experience in creating key features of Power BI functionality such as charts, timelines and maps
• Develop an interactive dashboard and learn to gain insights from it

Outline

Data Analytics: An Overview
• What is Analytics?
• Data Analytics Value Chain

Data Visualisation in Action
• A Famous Visualisation History

Introduction to Power BI
• Preparing and Loading Data
• Working with multiple Tables
• Interacting with Data

Power BI Charts
• A step-by-step approach to building charts, histograms, tree maps, timelines and maps
• Hands-on exercises on Power BI

Self Service Analytics using Dashboards
• Designing Dashboard Fundamentals
• Class Exercise: Building interactive dashboards on Power BI
• Class Exercise: Gaining Insights from the dashboard
• Learning from Others

Who should attend

This workshop is designed for managers, professionals and staff at all levels who want to learn make a bigger impact with their analysis. The course is suitable for participants across all industries and job functions. Participants are required to have basic MS Excel skills; some prior knowledge of data analytics would be helpful.

Methodology

Trainer takes a practical approach to analytics, and therefore the workshop emphasizes practical analytic skills through learning of key principles and analytics skills. A combination of lectures and hands-on exercises are designed to enable participants to acquire those practical skills. This workshop utilises Power BI for the computer-based exercises.

Testimonials

Profile of Jeremy Poon

B. Eng, IHRP-CA, Principal Consultant

• Jeremy leads engagements to help clients build practical analytics capabilities. His clients span several functions, sectors and geographies including Manufacturing, Electronics, Telecoms, Education and Government across Asia Pacific.

• With over 30 years of commercial and professional experience, including leadership roles across many sectors and geographies; including telecommunication, hospitality, MICE and government across Asia Pacific.

• Notably, Jeremy was at the forefront of the Info-Comm Technology world; including Telecommunications, Smart Cities, IoT, Command, Control and Communications (C3) with dashboard solutions; and represented ST Telemedia bidding for Singapore 2nd Full-Service Base Operator license, with NTT, BT and Singapore Power for the pre-qualification and main bid tender leading to the formation of Starhub Ltd.

• Jeremy Bachelor’s degree in Electrical & Electronics from the National University of Singapore as well as a Certified Associated from the Institute for Human Resource Professionals.