BI 相關的參考資料整理（課程、認證、參考連結）

BI 相關的參考資料整理（課程、認證、參考連結）

  April 10, 2019    Blake W.

---

整理了一些 BI 相關的資訊，記錄下來隨時可以來查詢，也提供大家參考！

目前網路上就有很多可以參考的線上課程以及線上資訊，如果有興趣的人可以上網直接參考，這些資訊都還蠻多蠻足夠的，而且都是線上免費的課程和教材，我整理如下。

下列是我正在讀的資料、課程和教材，提供給各位參考，如果各位有興趣可以一起研讀，一起討論。

## BI 線上課程：

* Introduction to Data Modeling

https://www.edx.org/course/introduction-to-data-modeling

* Delivering a Relational Data Warehouse

https://www.edx.org/course/delivering-a-relational-data-warehouse

* Delivering a Data Warehouse in the Cloud

https://www.edx.org/course/delivering-a-data-warehouse-in-the-cloud-2

* Developing a Multidimensional Data Model

https://www.edx.org/course/developing-a-multidimensional-data-model

* Developing a Tabular Data Model

https://www.edx.org/course/developing-a-tabular-data-model

* Implementing ETL with SQL Server Integration Services

https://www.edx.org/course/implementing-etl-with-sql-server-integration-services

* Creating a Master Data Solution with SQL Server Master Data Services (MDS)

https://www.edx.org/course/creating-a-master-data-solution-with-sql-server-master-data-services-mds

* Data Cleansing with Data Quality Services (DQS)

https://www.edx.org/course/data-cleansing-with-data-quality-services-dqs-0

* Analyzing and Visualizing Data with Power BI

https://www.edx.org/course/analyzing-and-visualizing-data-with-power-bi-2

* Data Analysis: Take It to the MAX()

https://www.edx.org/course/data-analysis-take-it-to-the-max

* Analyzing and Visualizing Data with Excel

https://www.edx.org/course/analyzing-and-visualizing-data-with-excel-2

* Microsoft Excel for the Data Analyst

https://www.edx.org/xseries/microsoft-excel-data-analyst

## BI 相關認證：

----------

1. MCSA: BI Reporting

https://www.microsoft.com/zh-tw/learning/mcsa-bi-reporting.aspx

(1) Exam 70-778/使用 Power BI 來分析和可視化處理資料

(2) Exam 70-779/使用 Microsoft Excel 分析和將資料視覺化

----------

2. MCSA: SQL 2016 BI Development

https://www.microsoft.com/zh-tw/learning/mcsa-sql2016-business-intelligence-certification.aspx

(1) Exam 70-767/Implementing a SQL Data Warehouse

(2) Exam 70-768/Developing SQL Data Models

----------

3. MCSA: SQL 2016 Database Development

https://www.microsoft.com/zh-tw/learning/mcsa-sql2016-database-development-certification.aspx

(1) Exam 70-761/Querying Data with Transact-SQL

(2) Exam 70-762/Developing SQL Databases

## BI 認證相關參考資料：

1. Exam 70-767 / Implementing a SQL Data Warehouse

** 書籍：

(1) 測驗參考 70-767 Implementing a SQL Data Warehouse

出版時間：2017 年 11 月

(2) Exam material for Microsoft 70-768 Developing SQL Data Models

https://www.mssqltips.com/sqlservertip/4780/exam-material-for-microsoft-70768-developing-sql-data-models/

(3) Preparing for and Taking Microsoft Exam 70-768 (Developing SQL Data Models)

https://www.cathrinewilhelmsen.net/2018/08/07/preparing-taking-microsoft-exam-70-768-developing-sql-data-models/

(4) Developing SQL Data Models v7.0 (70-768)

https://www.itexams.com/exam/70-768

** 參考資料：

1.) SQL 資料倉儲文件

https://docs.microsoft.com/zh-tw/azure/sql-data-warehouse/

2.) SQL Server Integration Services

https://docs.microsoft.com/zh-tw/sql/integration-services/sql-server-integration-services?view=sql-server-2017

3.) SSIS 如何建立 ETL 封裝

https://docs.microsoft.com/zh-tw/sql/integration-services/ssis-how-to-create-an-etl-package?view=sql-server-2017

4.) Data Quality Services (DQS) 簡介

(中文) https://docs.microsoft.com/zh-tw/sql/data-quality-services/introduction-to-data-quality-services?view=sql-server-2017

(英文) https://docs.microsoft.com/en-us/sql/data-quality-services/data-quality-services?view=sql-server-2017

5.) Master Data Services

https://docs.microsoft.com/zh-tw/sql/master-data-services/master-data-services?view=sql-server-2014&viewFallbackFrom=sql-server-2016

6.) Master Data Services 概觀 (MDS)

https://docs.microsoft.com/zh-tw/sql/master-data-services/master-data-services-overview-mds?view=sql-server-2017

---------------

2. Exam 70-768 / Developing SQL Data Models

** 書籍：

(1) Exam Ref 70-768: Developing SQL Data Models

Published: May 2017

(2) Exam material for the Microsoft 70-767 - Implementing a SQL Data Warehouse

https://www.mssqltips.com/sqlservertip/4741/exam-material-for-the-microsoft-70767--implementing-a-sql-data-warehouse/

(3) Implementing a Data Warehouse using SQL v5.0 (70-767)

https://www.itexams.com/exam/70-767

** 參考資料：

1.) SQL Server Analysis Services

https://docs.microsoft.com/zh-tw/sql/analysis-services/analysis-services?view=sql-server-2017

2.) SQL Server Data Tools

https://docs.microsoft.com/zh-tw/sql/ssdt/sql-server-data-tools?view=sql-server-2017

3.) MDX 查詢基礎觀念 (Analysis Services)

https://docs.microsoft.com/zh-tw/sql/analysis-services/multidimensional-models/mdx/mdx-query-fundamentals-analysis-services?view=sql-server-2017

4.) Data Analysis Expressions (DAX) Reference

https://docs.microsoft.com/en-us/dax/data-analysis-expressions-dax-reference

5.) DAX 簡介

https://docs.microsoft.com/zh-tw/power-bi/guided-learning/introductiontodax