Sumários

28 Abril 2026, 11:00 • André Ferreira Gomes

ERP Data Import and Cleaning
Handling raw data issues (text, nulls, duplicates, formatting)

Data Modeling and Relationships
Building a star schema with fact and dimension tables

Business Needs to Visuals
Revenue trends and EBIT vs Budget analysis

Dashboard Development
Creating structured report pages with charts, cards and slicers

23 Abril 2026, 11:00 • André Ferreira Gomes

Power BI Foundations
Introduction to Power BI Desktop interface and workflow

Data Import and Transformation
Loading Excel, CSV and folder data sources with Power Query

Data Modeling Basics
Creating relationships and simple dimension tables

First Visualizations
Building cards, charts, matrices and slicers in Power BI

21 Abril 2026, 11:00 • André Ferreira Gomes

Dashboards and Data Visualization
Role of dashboards, reports and visual decision tools

Dashboard Design Principles
Clear KPIs, audience focus and effective layout

Data Modeling for BI
FACT and DIM tables, star schema and relationships

Self-Service BI and Power BI
Interactive dashboards for faster management decisions

16 Abril 2026, 11:00 • André Ferreira Gomes

Data-Driven Management
Using evidence-based decisions instead of intuition alone

Digitalization of Management Control
BI, analytics, AI and integrated data systems

Analytics Levels
Descriptive, diagnostic, predictive and prescriptive analytics

Benefits and Barriers
Real-time insight, better decisions, data quality and change challenges

14 Abril 2026, 11:00 • André Ferreira Gomes

Purpose of Transfer Pricing
Internal pricing systems for divisional transactions and accountability

Transfer Pricing Methods
Market price, cost-based, variable cost and negotiated prices

Behavioral and Performance Effects
Impact on divisional profit, autonomy and goal congruence

International Dimension
Tax optimization and arm’s-length compliance principles