INTRODUCTION

Welcome to the “Data Analytics Foundation using Power BI” training program. In this intensive 2-day course, participants will delve into the world of data analytics, starting from foundational concepts and progressing to advanced techniques using Microsoft Power BI. Led by expert instructors, each session will combine theoretical knowledge with practical hands-on exercises to equip participants with the skills and insights needed to effectively analyze, visualize, and communicate data-driven insights. Whether you’re new to data analytics or looking to enhance your existing skills, this training will provide you with the tools and knowledge to harness the power of data and make informed decisions. Join us on this transformative journey and unlock the full potential of data analytics with Power BI

 

LEARNING OUTCOME

At the end of the course, the participants will be able to:

• Acquire a comprehensive understanding of data analytics principles, techniques, and methodologies.
• Develop proficiency in using Power BI for data analysis, visualization, and reporting.
• Gain practical skills in importing, cleaning, transforming, and modeling data to derive actionable insights.
• Master advanced data manipulation and visualization techniques to handle complex data sets effectively.
• Interpret data insights accurately, apply statistical analysis, and forecast trends for informed decision-making.
• Utilize storytelling techniques to communicate data-driven narratives and engage stakeholders effectively.
• Design impactful presentations and reports using Power BI to convey insights clearly and persuasively

 

COURSE CONTENT

SESSION 1 : INTRODUCTION TO DATA ANALYTICS

• Understanding data analytics and its applications.
• Types of analytics: descriptive, diagnostic, predictive, and prescriptive.
• Real-world examples showcasing the impact of data analytics.

SESSION 2 : OVERVIEW OF POWER BI

• • Introduction to Power BI: features, capabilities, and editions.
  • Exploring the Power BI interface: ribbons, panes, and views.
  • Differentiating between Power BI Desktop, Service, and Mobile.

SESSION 3 : DATA IMPORT AND TRANSFORMATION

• • Connecting to various data sources: Excel, databases, web services.
  • Understanding data loading options and best practices.
  • Applying basic data cleaning and transformation techniques using Power Query Editor.

SESSION 4 : INTRODUCTION TO DATA VISUALIZATION

• • Principles of effective data visualization.
  • Overview of Power BI visualizations: charts, graphs, maps.
  • Creating basic visualizations to represent imported data.

SESSION 5 : ADVANCED DATA TRANSFORMATION

• • Advanced data cleaning and shaping techniques.
  • Handling complex data structures: hierarchies, relationships, etc.
  • Implementing custom calculations and transformations using DAX.

SESSION 6 : ADVANCED DATA VISUALIZATION

• • Customizing visualizations for improved clarity and interactivity.
  • Exploring additional visualization types and features.
  • Designing interactive dashboards and reports for effective data communication.

SESSION 7 : DATA MODELLING BASICS

• • Introduction to data modeling: tables, relationships, measures.
  • Implementing basic data modeling techniques in Power BI.

SESSION 8 : PRACTICE AND Q&A

• • Hands-on exercises to reinforce learning.
  • Addressing participant queries and clarifications.

SESSION 9 : DATA ANALYSIS TECHNIQUES

• • Interpreting data insights and trends.
  • Applying statistical analysis and forecasting techniques.
  • Identifying patterns and outliers in data sets.

SESSION 10 : STORYTELLING WITH DATA

• Constructing compelling narratives using data.
• Incorporating storytelling elements into data presentations.
• Engaging stakeholders through effective data storytelling.

SESSION 11 : PRESENTATION AND STAKEHOLDER COMMUNICATION

• Designing impactful presentations using Power BI reports.
• Best practices for presenting data insights to stakeholders.
• Addressing stakeholder questions and feedback effectively.

SESSION 12 : FINAL PROJECT AND CONCLUSION

• Participants apply learned skills to create a comprehensive data analysis project.
• Group presentations and peer feedback session.
• Recap of key learnings and distribution of certificates

 

METHODOLOGY

An adult learning approach using a combination of lectures and simulation, exercises, hands-on with close supervision by the trainers, presentation, management games & group discussions

 

WHO SHOULD ATTEND?

Head of department, Managers, IT department, HR personel

 

TRAINER

Hazry Hidzir or

Shamsiyah Abdul Kadir or

Fakhrul Syahmir

 

FEES (WITHOUT ACCOMODATION)

RM1,100.00 per pax

Early Bird RM1,000.00 per pax

(20 days before program)

2 pax RM 1,050.00 per pax

3 pax > RM1,000.00 per pax

(This fees is inclusive of 2 morning tea breaks, 2 lunch , 2 afternoon tea breaks, notes and certificate of attendance for the participants)