Neste curso os formandos terão os conhecimentos necessários para:
- Criar e gerir Reports em Reporting Services;
- Introduzir e manipular dados em Power BI;
- Criar modelos de Dados e manipulá-los em DAX;
- Criar apresentações;
- Dashboards em Power BI.
Analyzing and Visualizing Data with Excel and Power BI
Porto
a 17 Set 2021
09h30 - 17h30
Destinatários
Todos aqueles que pretendam criar soluções em Self-Service Business Intelligence com reports e Dashboards interativos.
Pré-Requisitos
- Conhecimentos de bases de dados relacionais, Bons conhecimentos de Excel, são recomendados.
- Serão necessários conhecimentos de Inglês e não tem requisitos a nível de habilitações académicas.
Programa
- Introduction to Reporting Services
- Implementing reports
- Configuring reports
- Creating Mobile Reports
- Introducing Power BI
- Power BI Data
- Shaping and Combining Data
- Introduction to DAX
- Understanding Evaluation Contexts
- Using Date Functions
- Interactive Data Visualizations
Introduction to Reporting Services
Implementing reports
- Building Reports (Table, Matrix, Charts)
- Creating Parameters
- Understanding Report Execution
Configuring reports
- Configuring Server Side Connections
- Snapshots
- Subscriptions
- Understanding Cache
Creating Mobile Reports
- Creating Report Items
- Building Mobile Reports
Introducing Power BI
- Power B.I. Tools
- Creating & Publishing to Power B.I.
Power BI Data
- Import & Direct Query Modes.
- Importing Data to Power B.I.
Shaping and Combining Data
- Converting & Shaping Data
- Merge and Union Data
- Advanced Shaping
Introduction to DAX
- What is DAX?
- How it works…
- Simple Dax Expressions
Understanding Evaluation Contexts
- Understanding Evaluation Contexts
- CALCULATE & ALL Functions
- FILTER & other functions.
Using Date Functions
- Date Functions.
- Time Intelligence Functions
Interactive Data Visualizations
- Building Visualizations
- Filtering Visualizations
- Building Reports
- Creating Dashboards
