Beginning Power BI with Excel 2013: Self-Service Business Intelligence Using Power Pivot, Power View, Power Query, and Power Map (Paperback)

Dan Clark

買這商品的人也買了...

商品描述

Understanding your company’s data has never been easier than with Microsoft’s new Power BI package for Excel 2013. Consisting of four powerful tools—Power Pivot, Power View, Power Query and Power Maps—Power BI makes self-service business intelligence a reality for a wide range of users, bridging the traditional gap between Excel users, business analysts and IT experts and making it easier for everyone to work together to build the data models that can give you game-changing insights into your business.

Beginning Power BI with Excel 2013 guides you step by step through the process of analyzing and visualizing your data. Daniel R. Clark, an expert in BI training and a regular speaker on these topics, takes you through each tool in turn, using hands-on activities to consolidate what you’ve learned in each chapter.

Starting with Power Pivot, you will create robust scalable data models which will serve as the foundation of your data analysis. Once you have mastered creating suitable data models, you will use them to build compelling interactive visualizations in Power View. It’s often necessary to combine data from disparate sources into a data model. Power Query allows you to easily discover, combine, and refine data from a variety of sources, so you can make accurate judgments with all the available information. Geographical awareness is another common requirement of data analysis. Using Power Maps you will create captivating visualizations that map your data in space and time.

Beginning Power BI with Excel 2013 is your practical guide to getting maximum insight from your data, and presenting it with impact.

What you’ll learn

  • Import data from a range of sources into the Power Pivot Model
  • Create solid data models to support data analysis
  • Create compelling dashboards in Excel
  • Use Power View to create robust Interactive Data Presentations
  • Simplify data discovery, association and cleansing with Power Query
  • Combine analytical and geographic data in powerful 3D visualizations using Power Maps

Who this book is for

Beginning Power BI with Excel 2013 is for business analysts, database administrators and developers who need to work together to analyze and interpret their company’s data. Good modeling design and the necessary coding will be covered in an accessible way for those without a specialist background in these areas.

Table of Contents

Part I - Building Models in Power Pivot

Chapter 1: Introducing Power Pivot

Chapter 2: Importing Data into Power Pivot

Chapter 3: Creating the Data Model

Chapter 4: Creating Calculations with DAX

Chapter 5: Creating Measures with DAX

Chapter 6: Incorporating Time Intelligence

Chapter 7: Data Analysis with Pivot Tables and Charts

Part II – Building Interactive Reports and Dashboards with Power View

Chapter 8: Optimizing Power Pivot Models for Power View

Chapter 9: Creating Standard Visualizations with Power View

Chapter 10: Creating Interactive Dashboards with Power View

Part III – Exploring and presenting Data with Power Query and Power Map

Chapter 11: Data Discovery with Power Query

Chapter 12: Geospatial Analysis with Power Map

Chapter 13: Mining Your Data with Excel

 

Chapter 14: Creating a Complete Solution

 

 

 

商品描述(中文翻譯)

使用 Microsoft 的新 Power BI 套件,結合 Excel 2013,讓您更容易了解公司的數據。Power BI 包含四個強大的工具:Power Pivot、Power View、Power Query 和 Power Maps,將自助式商業智能帶給廣大用戶,彌合了 Excel 用戶、業務分析師和 IT 專家之間的傳統差距,讓每個人更容易合作,建立能為您的業務帶來重大洞察的數據模型。

《Beginning Power BI with Excel 2013》逐步引導您分析和視覺化數據的過程。BI 培訓專家丹尼爾·R·克拉克(Daniel R. Clark)將逐個介紹每個工具,並使用實際操作來鞏固每章所學的知識。

從 Power Pivot 開始,您將建立堅固可擴展的數據模型,作為數據分析的基礎。一旦掌握了建立適合的數據模型的技巧,您將使用它們來建立引人入勝的互動式視覺化效果。通常需要將來自不同來源的數據合併到數據模型中。Power Query 可讓您輕鬆發現、合併和精煉來自各種來源的數據,以便您能夠根據所有可用信息做出準確的判斷。地理意識是數據分析的另一個常見需求。使用 Power Maps,您將創建引人入勝的視覺化效果,將數據在空間和時間上進行地圖化。

《Beginning Power BI with Excel 2013》是您從數據中獲得最大洞察力並以有影響力的方式呈現數據的實用指南。

您將學到什麼:

- 將數據從各種來源導入 Power Pivot 模型
- 建立堅固的數據模型以支持數據分析
- 在 Excel 中創建引人入勝的儀表板
- 使用 Power View 創建強大的互動式數據演示
- 使用 Power Query 簡化數據發現、關聯和清理
- 使用 Power Maps 將分析和地理數據結合在強大的 3D 可視化效果中

本書適合對象:

《Beginning Power BI with Excel 2013》適合業務分析師、數據庫管理員和開發人員,他們需要共同分析和解釋公司的數據。本書以易於理解的方式介紹了良好的建模設計和必要的編碼技巧,適合沒有專業背景的讀者。

目錄:

第一部分 - 在 Power Pivot 中建立模型

第 1 章:介紹 Power Pivot

第 2 章:將數據導入 Power Pivot

第 3 章:創建數據模型

第 4 章:使用 DAX 創建計算

第 5 章:使用 DAX 創建度量

第 6 章:加入時間智能

第 7 章:使用樞紐表和圖表進行數據分析

第二部分 - 使用 Power View 建立互動式報告和儀表板

第 8 章:優化 Power Pivot 模型以供 Power View 使用

第 9 章:使用 Power View 創建標準視覺化效果

第 10 章:使用 Power View 創建互動式儀表板

第三部分 - 使用 Power Query 和 Power Map 探索和呈現數據

第 11 章:使用 Power Query 進行數據發現

第 12 章:使用 Power Map 進行地理空間分析

第 13 章:使用 Excel 挖掘數據