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 6. Primeiros passos no Power Pivot
Este trabalho foi traduzido com recurso a IA. Agradecemos o teu feedback e comentários: translation-feedback@oreilly.com
A Parte I de este livro concentrou-se na utilização do Power Query para extrair dados de diversas fontes e transformar os resultados em conjuntos de dados acionáveis. O Power Query não funciona como uma ferramenta de análise de dados autónoma; em vez disso, funciona como um intermediário para refinar os dados antes da análise.
Para continuar o percurso analítico, a Parte II centrar-se-á no Power Pivot, uma ferramenta concebida especificamente para a análise de dados. Com o Power Pivot, os utilizadores podem estabelecer relações entre fontes de dados e gerar medidas avançadas, permitindo uma análise de dados e relatórios simplificados.
O que é o Power Pivot?
O Power Pivot é uma ferramenta de modelação e análise de dados relacionais diretamente integrada no Excel. Permite-lhe estabelecer relações entre várias tabelas e construir dashboards e relatórios baseados em tabelas dinâmicas a partir deste modelo de dados. O Power Pivot oferece uma vasta gama de ferramentas para a criação de análises robustas, melhorando significativamente as capacidades do Excel para business intelligence e relatórios.
Porquê o Power Pivot?
Para compreender a importância do Power Pivot na análise de dados do Excel, abre ch_06.xlsx da pasta ch_06 no repositório complementar do livro. Tem em atenção que este capítulo não inclui um ficheiro de ...
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.