This course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform.COURSE OBJECTIVES:
After completing this course, students will be able to:Describe key features and benefits of self-service BI.Use SQL Server Reporting Services to implement a self-service reporting solution.Use PowerPivot in Microsoft Excel to create analytical data models.Use Power Query in Microsoft Excel to import data into a data model.Use Power View in Microsoft Excel to create interactive data visualizations.Use Power Map in Microsoft Excel to create geographic data visualizations.Use Microsoft SharePoint Server to implement collaborative self-service BI solutions.Provision and use a Windows Azure HDInsight cluster for Big Data analysis.Use Pig and Hive to analyze big data in Windows Azure HDInsight.Design and implement Big Data processes to support self-service BI.
|Lesson 1: Introduction to Self-Service Business Intelligence|
|Extending Enterprise BI |
Microsoft Self-Service BI and Big Data Technologies
Lab : Exploring an Enterprise BI Solution
|Lesson 2: Self-Service Reporting|
|Introduction to Self-Service Reporting |
Shared Data Sources and Datasets
Lab : Implementing Self-Service Reporting
|Lesson 3: Self-Service Data Modeling with PowerPivot|
|Creating Data Models in Excel with PowerPivot |
Using DAX in a PowerPivot Data Model
Lab : Self-Service Data Modeling with PowerPivot
|Lesson 4: Importing Data with Power Query|
|Introduction to Power Query |
Using Power Query to Import Data
Lab : Using Power Query
|Lesson 5: Visualizing Data with Power View in Microsoft Excel|
|Introduction to Power View |
Creating Dynamic Data Visualizations
Lab : Visualizing Data with Power View
|Lesson 6: Visualizing Geographic Data with Power Map|
|Introduction to Power Map |
Using Power Map
Lab : Visualizing Geographic Data with Power Map
|Lesson 7: Collaborative BI with Microsoft SharePoint Server|
|Sharing PowerPivot Workbooks |
Managing PowerPivot Services in SharePoint Server
Using Power View in SharePoint Server
Lab : Using SharePoint Server for BI Collaboration
|Lesson 8: The Windows Azure Marketplace Data Market|
|Introduction to the Windows Azure Marketplace |
Using Windows Azure Marketplace Data in Microsoft Excel
Lab : Using the Windows Azure Marketplace
|Lesson 9: Cloud Collaboration with Power BI for Microsoft Office 365|
|Introduction to Power BI |
Natural Language Queries with Q&A
The Data Management Gateway
Lab : Using Power BI
|Lesson 10: Introduction to Big Data and Windows Azure HDInsight|
|Introduction to Big Data |
Windows Azure HDInsight
Lab : Using Windows Azure HDInsight
|Lesson 11: Processing Big Data with Pig and Hive|
|Processing Big Data with Pig |
Processing Big Data with Hive
Lab : Processing Big Data with Pig and Hive
|Lesson 12: Implementing Big Data Processing Solutions with Windows Azure HDInsight|
|Automating Big Data Processing Tasks |
Integrating Windows Azure HDInsight with Enterprise Data
Lab : Creating a Big Data Solution
The primary audience for this course is database and business intelligence (BI) professionals who are familiar with data warehouses and enterprise BI solutions built with SQL Server technologies. Experienced data analysts who want to learn how to use Microsoft technologies for self-service analysis and reporting will also benefit from attending this course.
Virtual 20467 Designing Business Intelligence Solutions with Microsoft® SQL Server® 2012 Online Live training option
Imagine an industry-leading classroom training experience from wherever you have access to the Internet.
The Virtual Online Live events listed here gives you an effective and proven online virtual learning experience with the freedom to attend virtually from anywhere.
There is also an option of experiencing Online Live from one of the many national partner centers where a computer and headset will be provided for you.
This rich and engaging virtual classroom environment lets you conveniently interact with instructors and other students.
You will hear and see your instructor as they teach the course and answer your questions via voice or text.
Choose the online live virtual training option and you can access the recorded version even after the class has finished.
The onDemand labs give you access to the same client and server technologies covered in class so you can test, apply and hone your skills by accessing the labs before and even after the class.
Technical Requirements: a computer or laptop with a modern browser and high speed internet access along with one or two monitors.