Visão Geral

Este Curso Comprehensive Data Analytics using Power BI, oferece uma formação completa e prática em Data Analytics utilizando Power BI, cobrindo desde os fundamentos da análise de dados até modelagem avançada, DAX, segurança, performance, visualização, dashboards, dataflows, scorecards, distribuição e relatórios paginados. O treinamento prepara o profissional para atuar como Data Analyst corporativo, desenvolvendo soluções analíticas escaláveis, seguras e orientadas à tomada de decisão.

Objetivo

Após realizar este curso Comprehensive Data Analytics using Power BI, você será capaz de:

• Compreender o ecossistema Microsoft Data Analytics
• Preparar, transformar e modelar dados no Power BI
• Criar cálculos avançados utilizando DAX
• Desenvolver relatórios e dashboards interativos
• Aplicar técnicas de analytics avançado e AI visuals
• Implementar segurança com RLS e OLS
• Otimizar modelos para alta performance
• Criar e gerenciar dataflows escaláveis
• Distribuir conteúdo analítico de forma segura
• Criar relatórios paginados corporativos

Publico Alvo

• Data Analysts
• Business Analysts
• Profissionais de BI
• Engenheiros de Dados iniciantes
• Profissionais de TI e Analytics
• Usuários avançados de Excel
• Gestores que atuam com dados

Pre-Requisitos

• Conhecimentos básicos de informática
• Noções de análise de dados
• Familiaridade com Excel
• Não é obrigatório conhecimento prévio em Power BI

Materiais

Conteúdo Programatico

Module 1: Get Started with Microsoft Data Analytics

1. Data Analytics and Microsoft
2. Getting Started with Power BI
3. Power BI Desktop Overview
4. Roles in Data Analytics
5. Tasks of a Data Analyst
6. Power BI Products and Services
7. Power BI Service Overview

Module 2: Prepare Data in Power BI

1. Getting Data from Data Sources
2. Identifying Data Sources
3. Connection Methods and Performance
4. Connecting to Power BI Dataflows

Module 3: Clean, Transform, and Load Data in Power BI

1. Data Shaping and Transformations
2. Data Quality and Deduplication
3. Merge Queries
4. Append Queries
5. Data Profiling Tools
6. Advanced Transformations
7. Loading and Optimizing Data

Module 4: Design a Data Model in Power BI

1. Data Modeling Fundamentals
2. Model Components
3. Fact and Dimension Tables
4. Star Schema
5. Snowflake Schema
6. Performance-Oriented Modeling

Module 5: Create Model Calculations using DAX in Power BI

1. Introduction to DAX
2. Calculated Columns
3. Calculated Tables
4. Measures
5. Basic DAX Functions
6. Time Intelligence Functions

Module 6: Create Reports in Power BI

1. Report Design Principles
2. Visual Selection
3. Formatting and Layout
4. Interactivity and User Experience

Module 7: Create Dashboards in Power BI

1. Dashboard Creation
2. Pinning Visuals
3. Dashboard Tile Alerts
4. Using Q&A for Dashboards

Module 8: Perform Advanced Analytics in Power BI

1. Advanced Analytics Concepts
2. AI Visuals
3. Scatter Charts
4. Decomposition Trees
5. Key Influencers Visual

Module 9: Implement Security in Power BI

1. Power BI Security Overview
2. Workspace Security
3. Dataset and Report Security
4. Row-Level Security
5. Object-Level Security

Module 10: Create Calculation Groups

1. Calculation Groups Concepts
2. Managing Calculation Groups
3. Using Calculation Groups in Reports

Module 11: Optimize Model Performance in Power BI

1. Performance Optimization Strategies
2. Import vs DirectQuery
3. Composite Models
4. Query Folding
5. Performance Analyzer
6. Aggregations
7. Incremental Refresh

Module 12: Create and Manage Scalable Power BI Dataflows

1. Power BI Dataflows Overview
2. Dataflow Use Cases
3. Best Practices
4. Creating and Consuming Dataflows

Module 13: Understanding Scorecards and Metrics in Power BI

1. Scorecards and Metrics Overview
2. Metrics Hub
3. Manual and Connected Metrics
4. Sharing and Subscriptions

Module 14: Understanding Apps in Power BI

1. Power BI Apps Overview
2. App Licensing
3. Publishing Apps
4. Distributing and Updating Apps
5. Installing and Deleting Apps

Module 15: Distribution and Sharing Options

1. Sharing Dashboards and Reports
2. Embedding in PowerPoint
3. Sharing Scorecards and Apps
4. Exporting Reports
5. Analyze in Excel
6. Subscriptions
7. Embedding in Teams and SharePoint
8. QR Code Generation

Module 16: Paginated Reports using Power BI Report Builder

1. Paginated Reports Overview
2. Creating Paginated Reports
3. Working with Parameters
4. Defining Data Sources and Datasets
5. Publishing Paginated Reports

Module 17: Capstone Project – End-to-End Power BI Analytics

1. Data Preparation
2. Data Modeling
3. DAX Calculations
4. Report and Dashboard Creation
5. Security and Performance Optimization
6. Distribution Strategy