New user? Register as member

2-Day Power BI Essentials: Visualizing Data for Beginners

Designed for individuals with little to no prior experience in data analytics or business intelligence tools, this hands-on course introduces the fundamentals of Microsoft’s powerful data visualization platform, and guides learners through the process of connecting to data sources, transforming data, and creating reports.

Course Pre-requisites

This is a beginner Power BI course

• No pre-requisite is required.
• Participants are required to bring their own laptop PC or MacBook for the practical hands-on portions of the workshop.
• Participants will require access to download and install Power BI Desktop software from Microsoft.

Objective

Outline

Day 1

Introduction to Power BI

• Overview of business intelligence and data visualization concepts
• What is Power BI and why it matters
• Components of Power BI: Desktop, Service, and Mobile
• Understanding the Power BI interface and views
• Power BI workflow: From data to dashboard

Managing and Preparing Data

• Connecting to different data sources (Excel, CSV, SQL, etc.)
• Introduction to Power Query Editor
• Data transformation basics: cleaning and shaping data
• Merging and appending data
• Handling missing or inconsistent data

Modeling Data

• Understanding data relationships
• Creating and managing relationships between tables
• Data model design best practices
• Using calculated columns

Day 2

Exploring and Visualizing Data

• Introduction to visualizations
• Creating charts, tables, and slicers
• Using filters and drill-down capabilities
• Designing interactive dashboards
• Publishing and sharing Power BI reports

Introduction to DAX (Data Analysis Expressions)

• What is DAX and why use it
• Creating calculated columns vs. measures
• Basic DAX functions (SUM, AVERAGE, COUNT, etc.)
• Using logical and text functions in DAX
• Time intelligence basics in DAX

Who should attend

This course is intended for

• Professionals from non-technical backgrounds such as marketing, finance, HR, and operations who are seeking to enhance their analytical capabilities.
• project managers, and anyone looking to make data-driven decisions through clear, interactive reports

Methodology

Participants engage in immersive, hands-on learning experiences, where they apply advanced development techniques and workflow design principles in simulated business scenarios. Instructors provide personalized guidance and feedback, fostering an environment conducive to skill mastery and knowledge retention.

Profile of Peter Goh

Peter Goh embarked on his illustrious teaching journey in 1990, assuming the role of an IT Instructor in secondary schools. His commitment to education led him to serve at Tanjong Katong Girls' School and subsequently Anderson Secondary School, where he imparted fundamental IT and internet skills to students. Throughout his evolving career, Peter has donned multiple hats in the IT domain, holding positions such as Systems Administrator, Programmer, Systems Architect, IT Project Manager, and Chief Technology Officer.

Peter's extensive expertise is underscored by a plethora of certifications, including Certified Scrum Product Owner (CSPO) and Certified Scrum Master (CSM) from the Scrum Alliance, Certified Cloud Practitioner from Amazon Web Services (AWS), and Certified Azure Fundamentals from Microsoft. Additionally, he boasts a WSQ ACTA certification, demonstrating his prowess as a trainer.

Demonstrating his prowess as a seasoned developer, Peter has contributed to diverse projects for prominent entities like the Peoples' Association and ST Engineering, as well as small to medium-sized businesses such as Fancl, Olam, Heinz, Watsons, KBox, and Sakae Sushi. His portfolio encompasses the development of web-based applications and native mobile apps for both Android and iOS platforms. Leveraging his proficiency, Peter has also conducted training sessions on various programming languages, including Java, C#, Swift, Angular, React, and Flutter, along with courses on systems and cloud topics. He imparts knowledge at Authorized Training Organizations (ATOs) and serves as an adjunct faculty member at Ngee Ann Polytechnic.