Analyzing Data with Power BI and Power Pivot for Excel (Business Skills) (Paperback)

To get the right insights from your data, you need to model it right. From Power BI to Power Pivot for Excel, Microsoft offers extremely powerful and accessible tools for modeling data. Now, for the first time, there's a complete guide to building exceptionally effective models using Microsoft's tools. World-renowned Microsoft data analytics experts Marco Russo and Alberto Ferrari introduce all the data modeling theory you'll need, and show how to apply it in the context of Microsoft's current and evolving products.

Step by step, you'll learn how to transform simple tables into full analytical models of immense power. You'll master data modeling through a collection of realistic scenarios of increasing sophistication. For each, the authors start with a simple "naïve" model that can't provide robust solutions. Next, they guide you to update and improve the model, so it can deliver the knowledge and insights you really need.

為了從您的數據中獲得正確的洞察力，您需要正確地對其進行建模。從 Power BI 到 Power Pivot for Excel，微軟提供了非常強大且易於使用的數據建模工具。現在，首次出現了一本完整的指南，教您如何使用微軟的工具建立極其有效的模型。世界知名的微軟數據分析專家 Marco Russo 和 Alberto Ferrari 介紹了您所需的所有數據建模理論，並展示了如何在微軟當前和不斷發展的產品環境中應用它。

逐步進行，您將學習如何將簡單的表格轉化為功能強大的分析模型。通過一系列逐漸複雜的實際情境，您將掌握數據建模的技巧。對於每個情境，作者們從一個簡單的“天真”模型開始，該模型無法提供強大的解決方案。接下來，他們將引導您更新和改進模型，以便它能夠提供您真正需要的知識和洞察力。