PBE – Power BI Essentials

1. Introduction to Data Storytelling: Learn how data storytelling transforms complex information into clear, actionable insights. Discover the power of effective visualisation in decision-making, helping businesses identify trends and patterns effortlessly. Master key storytelling principles, including selecting the right visuals, maintaining clarity, and crafting compelling narratives. Understand how to tailor insights to different audiences, ensuring data-driven decisions resonate across all stakeholders.
2. Getting Started with Power BI: Gain a solid foundation in Power BI by exploring its ecosystem, interface, and core functionalities. Learn how Power BI Desktop, Service, and Mobile work together to deliver seamless data visualisation and reporting. Master the process of connecting to various data sources, including Excel, databases, and cloud services, to build dynamic dashboards. Navigate the Power BI interface efficiently, understanding key components like report view, data view, and model view to optimise your workflow.
3. Data Cleaning & Preparation: Ensure data quality and reliability by mastering essential data-cleaning techniques in Power BI. Learn how to handle missing values, duplicates, and inconsistencies to improve data integrity. Use Power Query to transform and shape raw datasets through filtering, merging, and restructuring. Apply these skills to a real-world case study, gaining hands-on experience in preparing clean, structured data for insightful analysis and reporting.
4. Data Modelling in Power BI: Build robust data models by establishing relationships between tables and selecting the right schema design. Learn when to use star and snowflake schemas for optimal performance and efficiency. Create calculated columns and measures using DAX to enhance reporting and analysis. Master key DAX functions to perform aggregations, time-series analysis, and custom calculations, unlocking deeper insights from your data.
5. Fundamentals of Data Visualisation: Create clear, engaging visualisations that effectively communicate insights. Learn to choose the right chart types for comparisons, trends, and relationships. Apply best practices in colour, layout, and interactivity to enhance readability and user experience. Reduce cognitive load by simplifying visuals and focusing on key insights. Avoid common design mistakes to ensure accuracy and clarity in data storytelling.
6. Creating Interactive Dashboards: Learn to design dynamic Power BI dashboards that provide deeper insights and enhance decision-making. Build interactive reports using slicers and filters for user-driven analysis. Utilise drill-throughs and bookmarks to explore layered insights seamlessly. Design KPI dashboards with clear layouts, focusing on key metrics for business performance. Create engaging, data-driven dashboards tailored to real-world business needs.
7. Advanced Visualisations & Customisations: Take your Power BI skills to the next level with advanced visualisation techniques. Learn to create complex visuals like heatmaps and waterfall charts for deeper insights. Use DAX to develop custom metrics tailored to business needs. Enhance reports with AI-powered visuals, such as key influencers and decomposition trees, to uncover hidden patterns. Elevate your dashboards with interactive and data-driven storytelling.
8. Storytelling with Data: Learn how to transform data into compelling stories that resonate with all audiences. This module covers how to structure reports for maximum impact, craft engaging narratives with Power BI, and present insights in an easily digestible format for non-technical stakeholders. Discover techniques to highlight key findings and create visually compelling stories that enhance decision-making.
9. Publishing & Sharing Reports: Learn how to efficiently publish, manage, and share Power BI reports. This module covers the process of deploying dashboards to Power BI Service, managing user access for collaboration, and automating data refreshes for smooth reporting workflows. Master how to ensure your reports remain up-to-date and accessible to the right stakeholders at all times.

Beginners:

Ideal for those new to Power BI and data visualisation. This module introduces foundational skills, from understanding the Power BI ecosystem to creating your first visualisations and reports.

Intermediate Learners:

Designed for individuals with basic Power BI knowledge, this module covers more advanced features, including data modelling, custom visuals, and interactive dashboards to deepen your analytical capabilities.

Business Professionals:

Perfect for professionals who need to harness Power BI to create insightful reports and dashboards that drive business decisions. Focuses on practical applications of Power BI for business intelligence and data-driven decision-making.

Students & Data Enthusiasts:

Ideal for students and anyone interested in enhancing their data analysis and visualization skills. Whether for academic projects, personal learning, or career growth in data fields, this module provides a solid understanding of Power BI.

No Prior Experience Needed:

While no specific prerequisites are required, basic knowledge of data analysis concepts or familiarity with business intelligence tools will be beneficial for making the most of this module.

Registration Process:

• You can register from here.
• Fill out the registration form with your details (name, email, and payment information).
• Once registered, you will receive a confirmation email with course access instructions.

Start Date:

• The course starts on specific dates, which are published on our website.
• Sessions are conducted live through Google Meet.
• New start dates for upcoming cohorts are updated regularly on our website.
• You can also reach out to us via WhatsApp or email to inquire about the next session’s start date.

Course Duration:

• Total Duration: 6 weeks
• Total Class Hours: 30 hours

Class Schedule:

• Classes are held on Monday, and Wednesday.
• Each class session lasts 2.5 hours.
• The classes are scheduled from 6:30 PM to 9:00 PM.
• Estimated study time outside class: 3-5 hours per week to complete lessons, assignments, and interactive activities.

Course Access:

• Live sessions are hosted via Google Meet.
• After registering, you will receive a link to join the sessions.
• All course materials, including session recordings and resources, are accessible after each live session.