The course is divided into the following modules:
Module 1: Data Storytelling I: Contexts and Visual Elements
Content
Theory and main topics:
- Welcome and course presentation.
- Data Storytelling Chapter I: The Importance of Context.
- Data Storytelling Chapter II: Choosing an Effective Visual Element.
- Decision support systems.
Power BI Hands-on:
- Let's Practice: Practical exercises related to the topics covered in the session.
- Development of 2 exercises with a Power BI manual (using the flipped classroom methodology)
Module 2: Management by Objectives and Data VIZ
Content
Theory and main topics:
- Data Visualization: Data Viz & Storytelling
- Which graph is the most appropriate?
- Strategy, Management by Objectives and SMART Goals
- Power BI project development methodology: Get Data, Data Preparation, Data Modelling, Data Visualization and Data Reporting.
Power BI Hands-on:
- Let's Practice Storytelling with Data: Practical exercises related to the topics covered in the session.
- Development of 3 exercises with a Power BI manual (using the flipped classroom methodology)
2. Project development methodology with Power BI
- Get Data
- Data Preparation
- Data Modelling
- Data Visualization
- Data Reporting
Module 3: AI in Power BI
Content
- Introduction to using AI in Power BI
- Questions and answers, Key influencing elements, Hierarchical scheme and Narrative
- General Review
Module 4: Data Storytelling II: UX/UI
Content
Theory and main topics:
- UX / UI (User Experience and User Interface)
- Data Storytelling Chapter III: Disorder is Your Enemy!
- Data Storytelling Chapter IV: Focus Attention on Your Audience.
- User experience design
Power BI Hands-on:
- Resources and workshop with the Figma vector graphics editor
- How to add a custom background in Power BI
Module 5: Fundamentals of Business Intelligence and Databases
Content
Theory and main topics:
- Preparation for obtaining the international certification: Business Intelligence Foundation Certification
- Fundamentals for Database Design
- General Review
Power BI Hands-on:
- Database Design – Basic Level.
Module 6: Power BI – DAX
Content
Theory and main topics:
- Power BI – DAX: DAX Projects
- Columns and Measures (Indicators)
- Date, Conditional, Logical, and Text Functions
- Related Function, Mathematical and Statistical Functions
- Calculate function, All/Filter function, SUMX function
Power BI Hands-on:
- DAX Projects
Module 7: Integrative Project
Content
Integrative Project