Data Visualization with PowerBI

Learn Data Visualization and PowerBI Skills to Extract Value from Data

In this data age, the ability to extract value from data is a highly sought after by both individuals and organizations. It takes hard technical skills to manage the large datasets and to extract insights from the data, but it eventually 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 become an indispensable part of the analyticstoolkit. PowerBI was cited one of the top data visualization tools in 2019 and 2020; being a product of Microsoft, it offers interoperability with their range of software, making PowerBI skills indispensable as well.

About the workshop

This 1 Day workshop aims to provide a broad but practical overview of the analytics value chain; with a focus on data visualization and role that it plays in it. The workshop will also provide an introduction to PowerBI; from which delegates will apply data visualization concepts using the software to explore large data sets, assemble data visualizations and build interactive dashboards. Delegates will also be exposed to other PowerBI resources available in the market.

Learning outcomes

• Appreciate the impact that data visualization has on the realization of value in analytics; particularly in today’s data driven world

• Understand the key principles and elements of building an impactful data visual

• Understand the basics of PowerBI navigation

• Gain practical experience in creating key features of PowerBI functionality such as charts, timelines and maps

• Develop an interactive dashboard and learn to gain insights from it

Target Audience

• Analysts or Professionals with Analytics responsibilities, who are looking to be more effective in presenting complex data to audiences

• Managers responsible for managing and supervising a team of analysts

• All other professionals with a keen interest in developing strong foundations in data analytics

• Some prior knowledge in MS Excel and analytics could be helpful, but not required

Logistics Requirements

Participants are required to bring their own laptops with Ms Excel and PowerBI preinstalled.

Course outline

1. What is Analytics and what it takes to create sustainable value chain

• This segment seeks to define what analytics is and isn’t, why it matters in today world and what it takes to build sustainable value.

2. The Analytics value chain and the role of Data Visualization

• Introduction to the 6 steps to conducting analytics. Delegates will see how the analytics process really works; and appreciate the role of Data Visualization along the value chain.

• Conveying the message through Data Visualization

• Key principles in Data visualization

• Thought process in selecting the right visualization for the intended message

• Finding the right message

• The required comparison to convey the message

• Selecting the right visualization

3. Introduction to Power BI

• Preparing and Loading Data

• Working with multiple Tables

• Interacting with Data

4. Power BI Charts

Course Fees (Incl GST)

SCAL member: $385.00

Non-member: $435.00

Speaker Profile

Derrick Yuen, MBA, BEng

Founder and Principal Consultant

Derrick consults and leads engagements to help clients liberate their data for analytics, to glean relevant and actionable insights from their data; engagements span across many sectors, functions and regions including Pharmaceutical, FMCG, Government, Human Resources, Finance & F&B across the Asia Pacific region

Prior to establishing FYT, Derrick led the formation and establishment of the Global People Analytics Centre of Excellence (COE) for a multinational healthcare company with >US$30 Billion revenue. He is also an experienced management and analytics consultant with top-tier firms, multinational corporation and government agencies, spanning various functions, sectors and geographies

He is also an ACLP certified Associate Trainer with the Civil Service College, Aventis School of Management and BCA Academy, specifically focused in developing and delivering analytics related curriculum

Derrick holds a Bachelor’s degree in Civil Engineering from the National University of Singapore as well as an MBA from the University of Southern California.