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.

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

Particular of Jeremy Poon

Jeremy has more than 30 years of commercial and professional experience, which include leadership roles across many sectors and geographies; such as telecommunication, hospitality MICE and government across Asia Pacific.

Prior to joining FYT, he led the application of the MVNO license with IDA for a large multinational company and worked with command, control & communication solutions.

Jeremy consults and leads engagements to help clients build analytics capabilities in their organizations. He brings his broad & extensive experience and makes the topic come to life with realistic examples and practical applications.

Jeremy has a 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 (IHRP).