Designing Business Intelligence Solutions with Microsoft SQL Server 2014

Course Details
Code M20467
Tuition (USD): $3,095.00 $2,785.50 • Virtual (5 days)
$3,095.00 $2,785.50 • Classroom (5 days)

In this course, you will learn how to design, implement, and maintain a Business Intelligence (BI) platform with Microsoft SQL Server 2014. Youll learn to design a data warehouse and Business Intelligence solutions including: ETL, BI Delivery, Reporting Services, Excel Reporting, SharePoint Server BI along with how to monitor and optimize a BI solution.

You will learn big data concepts and analysis using Microsoft Azure HDInsight plus how to design, implement, and process big data solutions.

This course uses Microsoft SQL Server 2014.

This course incorporates material from the Official Microsoft Learning Product 20467: Designing Business IntelligenceSolutions with Microsoft SQL Server 2014. This course maps to skills and knowledge measured by Microsoft exam 70-467, and in conjunction with on-the-job experience, can help prepare you for the exam.

Skills Gained

  • Plan the components of a BI solution
  • Plan a BI infrastructure
  • Design a data warehouse
  • Design an ETL solution
  • Plan analytical data models
  • Plan a BI delivery solution
  • Design a Reporting Services solution
  • Design an Excel reporting solution
  • Plan a SharePoint Server BI solution
  • Monitor and optimize a BI solution
  • Plan for BI operations

Who Can Benefit

  • BI professionals such as BI architects or database professionals who need to design BI solutions

Prerequisites

  • A basic understanding of dimensional modeling (star schema) for data warehouses
  • The ability to create Integration Services packages that include control flows and data flows
  • The ability to create a basic multidimensional cube with Analysis Services
  • The ability to create a basic tabular model with PowerPivot and Analysis Services
  • The ability to create Reporting Services reports with Report Designer
  • The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services
  • Familiarity with SharePoint Server and Microsoft Office applications, particularly Excel

Course Details

Lab 1: Explore an Enterprise BI Solution

  • View Reports
  • Analyze Data in a Data Model and from Multiple Sources

Lab 2: Implement Self-Service Reporting

  • Report Builder
  • Simplify Data Access for Business Users
  • Report Parts

Lab 3: Self-Service Data Modeling with PowerPivot

  • Create Data Model with PowerPivot
  • Enhance and Extend a Data Model

Lab 4: Import Data with Power Query

  • Merge Queries and Add a Query to a Data Model

Lab 5: Data Visualization with Power View


Lab 6: Geographic Data Visualization with Power Map

  • Create a Power Map Tour
  • Visualize Data Over Time

Lab 7: BI Collaboration using SharePoint Server

  • Share a PowerPivot Workbook
  • Manage PowerPivot Data Refresh
  • Power View in SharePoint Server

Lab 8: Microsoft Azure HDInsight

  • Provision a Microsoft Azure HDInsight Cluster
  • Process Data with HDInsight
  • Analyze Big Data in Microsoft Excel

Lab 9: Process Big Data with Pig and Hive


Lab 10: Implement Big Data Processing Solutions with Microsoft Azure HDInsight

  • Use HCatalog to Abstract Storage Locations
  • Coordinate Workflows with Oozie
  • Export Data with Sqoop
2015-06-23 13:39:09.587000000

6. Geographic Data Visualizations with Power Map in Microsoft Excel


7. Collaborative BI with Microsoft SharePoint Server

  • Share PowerPivot Workbooks in SharePoint Server
  • Manage PowerPivot Services in SharePoint Server
  • Power View in SharePoint Server

8. Introduction to Big Data and Microsoft Azure HDInsight

  • Big Data Key Features
  • Microsoft Azure HDInsight
  • Manage HDInsight using Microsoft Azure PowerShell

9. Process Big Data with Pig and Hive


10. Implement Big Data Processing Solutions with Microsoft Azure HDInsight

  • Automate Big Data Processing Tasks
  • Integrate Microsoft Azure HDInsight with Enterprise Data

Lab 1: Explore an Enterprise BI Solution

  • View Reports
  • Analyze Data in a Data Model and from Multiple Sources

Lab 2: Implement Self-Service Reporting

  • Report Builder
  • Simplify Data Access for Business Users
  • Report Parts

Lab 3: Self-Service Data Modeling with PowerPivot

  • Create Data Model with PowerPivot
  • Enhance and Extend a Data Model

Lab 4: Import Data with Power Query

  • Merge Queries and Add a Query to a Data Model

Lab 5: Data Visualization with Power View


Lab 6: Geographic Data Visualization with Power Map

  • Create a Power Map Tour
  • Visualize Data Over Time

Lab 7: BI Collaboration using SharePoint Server

  • Share a PowerPivot Workbook
  • Manage PowerPivot Data Refresh
  • Power View in SharePoint Server

Lab 8: Microsoft Azure HDInsight

  • Provision a Microsoft Azure HDInsight Cluster
  • Process Data with HDInsight
  • Analyze Big Data in Microsoft Excel

Lab 9: Process Big Data with Pig and Hive


Lab 10: Implement Big Data Processing Solutions with Microsoft Azure HDInsight

  • Use HCatalog to Abstract Storage Locations
  • Coordinate Workflows with Oozie
  • Export Data with Sqoop

7. Collaborative BI with Microsoft SharePoint Server

  • Share PowerPivot Workbooks
  • Manage PowerPivot Scenarios in SharePoint Server
  • Power View in SharePoint Server

8. Windows Azure Marketplace Data Market

  • Find and Use Datasets in Windows Azure Marketplace

9. Cloud Collaboration with Power BI for Microsoft Office 365

  • Natural Language Queries with Q&A
  • Share Queries
  • Data Management Gateway

10. Introduction to Big Data and Windows Azure HDInsight

  • Big Data Key Features
  • Process Map/Reduce Jobs with Windows Azure HDInsight

11. Process Big Data with Pig and Hive

12. Implementing Big Data Processing Solutions with Windows Azure HDInsight

  • Automate Big Data Processing Tasks
  • Integrate Windows Azure HDInsight with Enterprise Data

Lab 1: Explore an Enterprise BI Solution

  • View Reports
  • Analyze Data in a Data Model and from Multiple Sources

Lab 2: Implement Self-Service Reporting

  • Report Builder
  • Simplify Data Access for Business Users
  • Report Parts

Lab 3: Self-Service Data Modeling with PowerPivot

  • Create Data Model with PowerPivot
  • Enhance and Extend a Data Model

Lab 4: Import Data with Power Query

  • Merge Queries and Add a Query to a Data Model

Lab 5: Data Visualization with Power View

Lab 6: Geographic Data Visualization with Power Map

  • Create a Power Map Tour
  • Visualize Data Over Time

Lab 7: BI Collaboration using SharePoint Server

  • Share a PowerPivot Workbook
  • Manage PowerPivot Data Refresh
  • Power View in SharePoint Server

Lab 8: Windows Azure Marketplace

  • Find Data in the Windows Azure Marketplace
  • Windows Azure Marketplace Data in Excel

Lab 9: Power BI

  • Provision Power BI
  • View Reports and Query Data in Power BI
  • Share Queries
  • Cloud-Enabling a Data Source

Lab 10: Windows Azure HDInsight

  • Provision a Windows Azure HDInsight Cluster
  • Process Data with HDInsight
  • Analyze Big Data in Microsoft Excel

Lab 11: Process Big Data with Pig and Hive

Lab 12: Create a Big Data Solution

  • Use HCatalog to Abstract Storage Locations
  • Coordinate Workflows with Oozie
  • Export Data with Sqoop

Lab 14: Monitor and Optimize a BI Solution

  • Monitor and Optimize a Data Warehouse, Analysis Services, and Reporting Services

Lab 15: Operate a BI Solution

  • Configure SSIS
  • Automate Data Warehouse Load Tasks
  • Test Automated Operations
Course Details
Code M20467
Tuition (USD): $3,095.00 $2,785.50 • Virtual (5 days)
$3,095.00 $2,785.50 • Classroom (5 days)