March 2025
Intermediate to advanced
244 pages
5h 42m
Portuguese (Portugal, Brazil)
Content preview from Análise de dados moderna no Excel
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Capítulo 8. Criando medidas e KPIs no Power Pivot
Este trabalho foi traduzido com recurso a IA. Agradecemos o teu feedback e comentários: translation-feedback@oreilly.com
No Capítulo 7, foram introduzidos os fundamentos do Power Pivot e do Modelo de dados, incluindo relações, hierarquias e colunas calculadas. Com o Modelo de Dados implementado, este capítulo aborda a criação de medidas DAX e KPIs para ajudar os utilizadores finais na interpretação dos dados.
Para demonstrações, consulta ch_08.xlsx na pasta ch_08 do repositório que acompanha o livro. Este capítulo utiliza o mesmo conjunto de dados de vendas a retalho do Capítulo 7, com o Modelo de Dados predefinido no ficheiro de exercício fornecido.
Criando medidas DAX
No Capítulo 7, a tentativa do de adicionar uma coluna profit margin à tabela orders levou a um resultado insatisfatório. Para agregar e recalcular resultados em diferentes categorias e períodos de tempo, são necessárias medidas DAX. No Power Pivot, as medidas podem ser criadas de duas formas: implícita e explicitamente. Para ganhar experiência prática com esses métodos, insere uma tabela dinâmica do modelo de dados.
Criação de medidas implícitas
Para dados agregados, como encontrar a quantidade total de encomendas por região, normalmente arrasta os campos diretamente para a Tabela Dinâmica, como mostrado na Figura 8-1.
Para ajustar a agregação para determinar o número médio de unidades vendidas por região, navega até o menu suspenso em "Soma da quantidade do pedido" ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.