Microsoft Power BI Data Analyst Associate (PL-300)
About This Course
This comprehensive Microsoft Power BI Data Analyst Associate (PL-300) course equips participants with the skills to apply predictive data modelling techniques, prototype algorithms, and manage interactive data visualisations using Power BI, one of the industry's leading tools. The course delves into data aggregation, machine learning techniques to unearth new insights, and the assessment of these insights for impactful organisational improvements. Participants will learn to clean, transform, and load data efficiently, design robust data models, and create measures using DAX to facilitate effective decision-making and predictive analysis.
Covering a broad spectrum of advanced topics, the curriculum includes optimizing data models for performance, creating compelling and informative data visualizations, and developing data-driven stories through Power BI reports and dashboards. Learners will gain hands-on experience in performing analytics, working with AI visuals, and managing workspaces and datasets in Power BI. Additionally, the training provides insights into implementing row-level security to ensure data integrity and confidentiality. By the end of the course, participants will be proficient in leveraging Power BI's capabilities to drive data analysis and visualisation projects, contributing to their organisation's data-driven decision-making processes.
What You'll Learn
- Apply predictive data modelling techniques to identify patterns across multiple datasets using Power BI
- Create prototype algorithms to make decisions on patterns
- Manage the creation of interactive data visualisations using industry-standard tools in line with organisational procedures.
- Apply data aggregation and machine learning techniques to gain new insights into data.
- Assess relevant insights from mined data and determine their impact on the organisation for ongoing improvements.
Course Outline:
Learning Unit 1: Get Started on Data Analytics with Power BI
Topic 1 Discover data analysis
Topic 2 Get started building with Power BI
Topic 3 Get data in Power BI
Topic 4 Clean, transform, and load data in Power BI
Topic 5 Design a data model in Power BI
Learning Unit 2: Create prototype algorithms to make decisions on patterns
Topic 6 Introduction to creating measures using DAX in Power BI
Topic 7 Optimize a model for performance in Power BI
Learning Unit 3: Data Visualisation
Topic 8 Work with Power BI visuals
Topic 9 Create a data-driven story with Power BI reports
Topic 10 Create dashboards in Power BI
Learning Unit 4: Data Mining and AI Analytics
Topic 11 Perform analytics in Power BI
Topic 12 Work with AI visuals in Power BI
Learning Unit 5: Power BI Performance
Topic 13 Create and manage workspaces in Power BI
Topic 14 Manage datasets in Power BI
Topic 15 Implement row-level security
Entry Requirements
Knowledge and Skills
• Able to operate using computer functions
• Able to operate using computer functions
• 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