Data Visualisation Using Power BI For Beginners
In today’s data-driven world, the ability to extract value from data is highly sought after by both individuals and organisations. 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.
Microsoft Power BI is a cloud-based business analytics tool which 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 data visualisation. 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.
- Gain an overview of the data analytics landscape
- Understand the key principles and elements of building an impactful data visualisation
- Understand the basics of Power BI and how to navigate it
- Gain practical experience in creating key features of Power BI functionality (charts, maps, etc.)
- Learn the fundamentals of dashboard designing
- Develop an interactive dashboard on Power BI and learn to gain insights from it
This course is for professionals and individuals with an interest to learn and improve their understanding and skills in data visualisation, particularly in creating visualisations and dashboards using Microsoft Power BI. This course is suitable for beginner-level participants across all industries and job functions.
Participants are required to bring a laptop with:
- Internet/wifi connectivity
- Microsoft Power BI (an installation guide will be sent prior to the course date)
- 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
“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, 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, JTC Corporation