Data Analytics and Visualization with Power BI
About This Course
Dive into the world of data analytics and visualization with our comprehensive WSQ-endorsed course on Power BI. This course is designed to teach you how to turn complex data into compelling visual stories. You'll learn to navigate the Power BI interface, connect to various data sources, and create interactive dashboards. Practical exercises and real-world examples are integrated into the curriculum, ensuring you'll gain actionable skills.
By the end of this course, you'll be proficient in using Power BI to analyze data, create visualizations, and develop interactive dashboards that can inform business decisions. Whether you're a business professional looking to upskill, a data enthusiast, or someone in a decision-making role, this course equips you with the tools and knowledge to make data-driven decisions effectively.
What You'll Learn
- perform data transformation techniques using Power BI
- create data visualization to portray data trends and correlations
- develop dashboards and scoreboards
- create dynamics data visualization
- create data model for strategic visualization and mapping
- perform data analytics and queries with DAX
Course Outline:
Topic 1 Get Started on Power BI
Overview of Power BI Desktop and Service
Import/Connect Data into Power BI
Transform Data
Combine Data
Filter Data
Topic 2: Create Data Visualization
Create Data Visualizations
Format Visuals
Create Power BI Reports
Topic 3 Create Dashboard and Scoreboard
What is Dashboard and Scoreboard
Create Dashboard
Customize Dashboard
Topic 4: Create Dynamic Visualization
Create Dynamics Charts
Create Interactions
Create Visual Hierarchies
Topic 5 Create Data Model
Overview of Data Model
Data Relationships
Calculation and Measures
Topic 6 Data Analytics with DAX
Overview of DAX Language
Perform Data Queries and Analytics
Entry Requirements
Knowledge and Skills
• Able to operate computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
• Positive Learning Attitude
• Enthusiastic Learner
Experience
• Minimum of 1 year of working experience.
• Minimum 18 years old