The course is organized into 6 modules and is developed from an integrative project that progresses gradually in each module, allowing the concepts to be applied throughout the course.
The course methodology is established, introducing the use of Power BI within the data analysis process. Using a practical case study, a dataset is explored to understand its structure and build an initial exploratory prototype, incorporating basic visualization concepts.
Main topics:
- The role of Power BI in data analysis
- Workflow in analytical projects
- Power BI Desktop work environment: report views, data, and model
- Basic exploration through visualizations
- Principles of report design for decision-making
Power BI Hands-on:
- Construction of a functional exploratory prototype
- Setting up basic visualizations and interactions
- Defining the project approach: objectives, initial metrics, and business questions
Data preparation is addressed as a key step in transforming raw data into analyzable structures. Power Query is used to connect, clean, transform, and integrate data.
Main topics:
- Power Query environment and step-by-step transformation logic
- Connection to data sources
- Data cleaning and standardization
- Data transformation and structuring
- Data integration: combining and appending tables
- Best practices in data preparation processes
Power BI Hands-on:
- Cleaning, transforming, and structuring the dataset in Power Query
- Integration of multiple sources (combining and appending tables)
- Project progress: clean and structured dataset
The data model is built, defining relationships, structure, and organization for analysis, applying concepts of fact tables and dimensions, star schema, granularity, and filters. The model is then implemented and validated in Power BI as the basis for analysis.
Main topics:
- Difference between prepared data and data model
- Fact and dimension tables
- Creation and management of relationships between tables
- Cardinality and direction of filters
- Star model and comparison with unstructured models
- Data granularity
Power BI Hands-on:
- Data model construction (tables, relationships, and star schema)
- Validation of relationships, cardinality, and filter direction
- Project progress: validated model for analysis
Measures are developed in DAX for building metrics and indicators, from basic functions to the use of contexts and advanced functions related to the data model. Concepts such as CALCULATE, filter and row contexts, iterative functions, and time intelligence analysis using calendar tables are applied. As a result, indicators and KPIs are implemented in Power BI as the basis for the analysis.
Main topics:
- Basic functions for aggregation and creation of measures
- Filter context and use of CALCULATE
- Row context and iterator functions
- Filter functions applied in measurements
- Relationship between the data model and the behavior of the measures
- Construction and use of a calendar table for time intelligence analysis
- Good practices in defining measures
Power BI Hands-on:
- Building measures in DAX for key indicators
- Development of KPIs and analytical metrics (including the use of CALCULATE)
- Project progress: metrics and indicators defined
Visualization principles focused on the effective communication of results are developed, along with the use of AI-assisted analysis tools available in Power BI.
Main topics:
- Selection of charts and interactivity in dashboards
- Design of dashboards geared towards decision-making
- Storytelling and user experience (UX) in reports
- Navigation and interaction to facilitate analysis
- AI-assisted analytics in Power BI
Power BI Hands-on:
- Dashboard design and construction
- Implementation of interactivity and navigation
- Project progress: final dashboard
The development of a complete case is consolidated by integrating all stages of the analysis in Power BI, from data preparation to the presentation of results.
Main topics:
- Comprehensive validation of the model and metrics
- Final adjustment of the decision-oriented dashboard
- Interpretation and communication of findings to business users
- Publication and distribution of reports in organizational environments
- Using Power BI Service: publishing, updating, and sharing reports
Power BI Hands-on:
- Development of the integrative case consolidating all stages of the analysis
- Construction and adjustment of the final dashboard oriented towards decision making
- Project progress: presentation of results