Visão Geral

Este Curso Designing Data Models in Excel for Power BI Reports, para exibição em um relatório interativo do Power BI ou em um painel interativo do Excel. Este é um curso fundamental de Power BI e um curso avançado de Excel que o levará por uma jornada de dados, desde a importação, limpeza e mesclagem de grandes quantidades de dados até a análise dos dados e a apresentação de dados estratégicos em uma tabela dinâmica e um painel do Power BI. Este curso prático oferece flexibilidade e permite que você escolha como deseja apresentar suas percepções de negócios para ajudar a administração a tomar decisões informadas.

Objetivo

Modelos de dados no Excel para benefícios do curso Power BI

• Transforme e apresente dados sofisticados para fornecer Business Intelligence (BI)
• Atualize um modelo de dados de várias fontes com o Power Pivot
• Molde e prepare seus dados com o Power Query
• Extraia e exponha informações ocultas com expressões de análise de dados
• Comunique insights de negócios e dados com relatórios e painéis do Power BI
• Aproveite o suporte contínuo com treinamento individual de instrutor após o curso e sandbox de computação

Materiais

Conteúdo Programatico

Identifying the Role of Power Pivot in Business Intelligence (BI)

Introducing the Business Intelligence Tools

1. Exploring the Microsoft Business Intelligence tools
2. Defining the requirements for a collaborative solution
3. Identifying the steps to create a Power BI dashboard

Familiarisation with Power Pivot

1. Navigating the Power Pivot interface
2. Extracting information from data with Power Pivot
3. Uncovering data interpretation issues
4. Creating a simple dashboard

Building the Data Model with Power Pivot

Defining a consolidated view of data

1. Generating a data mashup from structured and unstructured data sources into a data model
2. Deriving relationships from data sources with the Relationships tool and the Diagram View

Denormalizing data to simplify usage within other BI reporting tools

1. Simplifying the data model
2. Acquiring data from related tables
3. Consolidating information with calculated columns

Querying SQL Server data

1. Designing queries to import data from SQL Server
2. Relating tables with outer joins

Fixing common data issues with Power Query

1. Extracting, Transforming, and Loading (ETL) data
2. Converting data formats with Power Query steps
3. Parsing columns to aid analysis
4. Removing duplicates from a data set
5. Constructing a single data set from multiple sources with the same field headings

Shaping Data with Power Query

Familiarisation with Power Query

1. Navigating the Power Query interface
2. Extracting, Transforming, and Loading (ETL) data
3. Converting data formats with Power Query steps
4. Parsing columns to aid analysis

Combining Data

1. Merging tables of data
2. Constructing a single data set from multiple sources with the same field headings
3. Develop an automated solution to combining data

Filtering Data with Parameters

1. Developing queries
2. Removing duplicates from a data set
3. Defining Excel tables as parameters for a Power Query

Manipulating and Analyzing Data with the Data Analysis eXpressions (DAX) Language

Defining measures for business performance

1. Distinguishing the role of measures
2. Translating key business concepts into measures
3. Providing context for measures within a PivotTable
4. Determining between implicit and explicit measures

Implementing DAX functions in Power Pivot

1. Expressing information with measures
2. Exposing hidden information from data
3. Troubleshooting and debugging DAX calculations

Exploiting data analytics with aggregation

1. Quantifying and mining information with DAX functions
2. Summarising and aggregating data from other tables with the X functions
3. Evaluating expressions with the CALCULATE() function and filter functions
4. Substituting values with the SWITCH() function

Mining for information with date and time analysis

1. Grouping dates for time analysis
2. Comparing and categorising time periods with Time Intelligence functions

Setting key business targets with KPIs

1. Analysing performance with measures
2. Gauging performance against goals

Designing Interactive Power BI dashboards

Familiarisation with Power BI

1. Deciding on where to develop a dashboard
2. Importing an Excel data model into Power BI Desktop
3. Developing a data model in the Power BI Desktop
4. Crafting visualisations from the analytics

Building a Power BI dashboard

1. Constructing Power BI visualisations
2. Designing visual-level, page-level, and report-level filter
3. Assembling a Power BI Dashboard