Visão Geral

Após realizar este Curso Power BI Dashboard Você será capaz de:

• Conecte-se, importe e transforme dados de várias fontes.
• Definir regras de negócios e KPIs.
• Explore dados com ferramentas de visualização poderosas.
• Crie relatórios impressionantes.
• Compartilhe painéis com sua equipe e parceiros de negócios e publique-os na web.

Objetivo

Curso Power BI Dashboard

Materiais

Conteúdo Programatico

Lab 1 – Accessing and Preparing Data

1. Accessing Data
2. Data Preparation

Lab 2 – Data Modeling and Exploration

1. Power BI Desktop Layout
2. Power BI Desktop Exploration
3. Joins and Visuals
4. Create a formula to do join of many to many
5. Show result in Visual
6. Filter the Visual to show Top 5 manufactures by Revenue
7. Grouping
8. Make a Tree Map and show filtering of other Visuals
9. Filter the page by Group Field
10. Create a Date Hierarchy Visual
11. Edit Interactions
12. Add in a Slicer
13. Add a Date Table for calculations
14. Make a Quick Hierarchy on other fields
15. Add a Matrix Visual
16. Calculate  - Same Period Last Year Formula

Lab 3  - Data Visualization– Make it Fancy

1. Conditional Format for the Matrix Visual
2. Change dropdown to slicer buttons
3. Change the Revenue by Year Chart to a combo line and clustered
4. Make a Gauge Visual
5. Try out Themes
6. Format country Visual
7. Page Formatting

Lab 4 – Look at the solution and publish

1. Publish online
2. Create a workspace online, publish to the Workspace
3. Pin Visuals –
4. Ask a question of the Dashboard

Lab 5 Make an app

1. In the final lab, attendees will apply what they learned by making an app.