Data Visualisation Using Microsoft Power BI For Beginners
In this data age, the ability to extract value from data is highly sought after by both individuals and organisations. And it takes hard technical skills to manage the large datasets and extract insights from the data, but it comes to nought unless the insights can be clearly and quickly communicated to the intended audience. Data visualisation 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 visualisation has very become an indispensable part of the analytics toolkit today.
Microsoft Power BI is a cloud-based business analytics tool that requires no capital expenditure or infrastructure support regardless of the size of the business. It aims to provide end-users with interactive visualisations and business intelligence capabilities with an easy-to-use interface to create reports and dashboards. Power BI is also capable of seamless integration with existing applications, extracting business intelligence rapidly and accurately, publishing reports securely, and its lack of memory and speed constraints.
This workshop aims to provide a broad but practical overview of the entire analytics value chain, with a focus on using data visualisation to convey intended messages from the data to an audience. You will learn the fundamentals of visualisation and get your hands “dirty” building different visualisations using Microsoft’s Power BI (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.
- Appreciate the impact that data visualisation has on the realisation 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 Power BI navigation
- Gain practical experience in creating key features of Power BI functionality such as charts, timelines, maps, etc.
- Develop an interactive dashboard and learn to gain insights from it
This workshop is designed for managers, professionals and staff at all levels who want to learn to 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 and some prior knowledge of data analytics would be helpful.
Participants are required to bring a laptop with internet connectivity and Power BI installed.
- Data Analytics: An Overview
- What is Analytics?
- Data Analytics Value Chain
- 6-Steps Framework
- Data Visualisation in Action
- A Famous Visualisation History
- Selecting the Right Chart
- What are the steps to build a good chart?
- 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
Data Expert: Joanna Tan
A seasoned leader in Human Resource Business Partnering with more than 25 years of diverse industry, Joanna has experience with reputable multinational and local corporations such as Sage Software, Hasbro, Apple, IBM, Rockwell Automation and Wing Tai Holdings. She has proven success in managing and rolling out major organization change initiatives involving various key stakeholders especially with the sales and marketing teams in driving revenue and margin optimization using business metrics and intelligence.
Joanna currently consults and leads engagements to help FYT clients build HR analytics capabilities across many sectors and regions, including technology, government, pharmaceutical, sales & finance across the Asia Pacific Region. She also has a strong background in talent management and development, organization design, change management as well as employee engagement. Joanna holds a Bachelor’s Degree in Arts with National University of Singapore and a Graduate Diploma in Business Administration with Singapore Institute of Management. In addition, she is accredited in Advanced Certificate in Training and Assessment (ACTA v5).
Data Expert: Michael Lee
Michael Lee is an associate of FYT Consulting Pte Ltd. An IT professional by training with more than 25 years of consulting & practical experience across many functions (sales, client management, business operations & customer service) throughout various roles (Vendor, Systems Integrator, Distributor and Enduser) in both the public & private sector.
Prior to joining FYT Consulting, Michael has done consultancy and process re-engineering for several SMEs. He has also conducted numerous training sessions on Virtual Teaming for international banks and corporations. In addition, he has made many speaking engagements in Customer & Partner events, as well as in major international Sales Conferences.
Michael has managed the Asia Pacific Sales Operations for Linksys, a division of Cisco Systems. His portfolio included the day-to-day operations within the Asia Pacific. He was also running the China sales for almost a year. Prior to that, Michael led the Asia Pacific Sales Operations for Cisco System and the Business Operations for Customer Service in Asia Pacific & Japan in Cisco. In addition, he headed a global Metrics & Business Intelligence team comprising members from the Asia Pacific, Europe and the Americas. Before joining Cisco, Michael worked for Peoplesoft, AT&T GIS, SAP and National Computer Systems (SCO). Michael holds a Bachelor’s degree in Computer Science & Mathematics as well as an MBA from the National University of Singapore
“Mr Michael Lee is more than qualified for this job, he has very in-depth knowledge on power bi as well as other similar software such as tableau, and able to answer participant questions on the difference between these 2 software.”
Simon Chang, Accountant, Energy Market Company
“I’d recommend the trainer because the trainer understands what he is going through, not just by the books, but by knowledge. He is patient and able to guide people through the technical aspects but yet makes it fun and experiential :-). I will recommend this course to my colleagues and friends as this is really a good course to get started on power bi visual and understanding the basics and eventually progressing. This course will help me at work as now I do not need to rely only on the IT to get the data up on power bi but I can start my own data analysis project from the start.”
Jayne Chua, Executive, Hope Church Singapore
“Mr Michael was very engaging throughout the entire session. Even though it was a very technical course, it wasn’t boring and mundane. The lesson was very fun and achieved all of our learning objectives. Yes! I would recommend this course. We are able to create different types of charts, graphs and analytical tools using Power BI which is more effective than Microsoft Excel.”
Chua Wei Lin, Assistant Manager, JTC Corporation