Designing Self Service Business Intelligence and Big Data Solutions (20467)

Quantity

$2,895.00

Add to Cart

New Age Technologies has been delivering Authorized Training since 1996. We offer Microsoft’s full suite of authorized courses including courses pertaining to Designing Self Service Business Intelligence and Big Data Solutions, SharePoint 2013 Business Intelligence, Microsoft Office, Microsoft Exchange Server, Microsoft SQL and more. If you have any questions or can’t seem to find the Microsoft class that you are interested in, contact one of our Microsoft Training Specialists. Invest in your future today with Microsoft training from New Age Technologies.

✉ Microsoft Training Specialist | ☏ 502.909.0819

---

EXCLUSIVE BENEFIT:

This course includes a twelve-month subscription to these exclusive benefits:

• 12 months of anytime access to your course labs and lab environment
• 12 months of 24/7 access to mentoring via chat, email, and phone
• 12 months of on-demand access to indexed, searchable recordings of your Online Live class
• 12 months of unlimited retakes of your class

---

COURSE INFORMATION

Designing Self-Service Business Intelligence and Big Data Solutions (20467) Overview:

Designing Self-Service Business Intelligence and Big Data Solutions (20467) course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform.

The course discusses how to create self-service data models and reports by using:

• Microsoft SQL Server Reporting Services
• Microsoft Excel
• Microsoft SharePoint Server
• Microsoft Office 365 Power BI

The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.

Who Should Attend:

• 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

Designing Self-Service Business Intelligence and Big Data Solutions (20467) Prerequisites:

Before attending this course, you must have:

• 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.

You can also meet the prerequisites by attending the following courses:

• M10777: Implementing a Data Warehouse with Microsoft SQL Server 2012
• M10778: Implementing Data Models and Reports with Microsoft SQL Server 2012

Designing Self-Service Business Intelligence and Big Data Solutions (20467) Objectives:

After successfully 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.

Designing Self-Service Business Intelligence and Big Data Solutions (20467) Outline:

Module 1: Introduction to Self-Service Business Intelligence (BI)

• Extend Enterprise BI
• Microsoft Self-Service BI and Big Data Technologies
• Module 1 Labs: Explore an Enterprise BI Solution
• View Reports
• Analyze Data in a Data Model and from Multiple Sources

Module 2: Self-Service Reporting

• Introduction to Self-Service Reporting using Report Builder
• Shared Data Sources and Datasets
• Report Parts
• Module 2 Labs: Implement Self-Service Reporting
• Report Builder
• Simplify Data Access for Business Users
• Report Parts

Module 3: Self-Service Data Modeling with PowerPivot

• Create Data Models in Excel with PowerPivot
• PowerPivot Data Model using DAX
• Module 3 Labs: Self-Service Data Modeling with PowerPivot
• Create Data Model with PowerPivot
• Enhance and Extend a Data Model

Module 4: Import Data with Power Query

• Find and Import Data using Power Query in Microsoft Excel
• Module 4 Labs: Import Data with Power Query
• Merge Queries and Add a Query to a Data Model

Module 5: Data Visualizations with Power View in Microsoft Excel

• Create Interactive and Dynamic Data Visualizations using Power View in Microsoft Excel
• Module 5 Labs: Data Visualization with Power View

Module 6: Geographic Data Visualizations with Power Map in Microsoft Excel

• Module 6 Labs: Geographic Data Visualization with Power Map
• Create a Power Map Tour
• Visualize Data Over Time

Module 7: Collaborative BI with Microsoft SharePoint Server

• Share PowerPivot Workbooks in SharePoint Server
• Manage PowerPivot Services in SharePoint Server
• Power View in SharePoint Server
• Module 7 Labs: BI Collaboration using SharePoint Server
• Share a PowerPivot Workbook
• Manage PowerPivot Data Refresh
• Power View in SharePoint Server

Module 8: Introduction to Big Data and Microsoft Azure HDInsight

• Big Data Key Features
• Microsoft Azure HDInsight
• Manage HDInsight using Microsoft Azure PowerShell
• Module 8 Labs: Microsoft Azure HDInsight
• Provision a Microsoft Azure HDInsight Cluster
• Process Data with HDInsight
• Analyze Big Data in Microsoft Excel

Module 9: Process Big Data with Pig and Hive

• Module 9 Labs: Process Big Data with Pig and Hive

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

• Automate Big Data Processing Tasks
• Integrate Microsoft Azure HDInsight with Enterprise Data
• Module 10 Labs: Implement Big Data Processing Solutions with Microsoft Azure HDInsight
• Use HCatalog to Abstract Storage Locations
• Coordinate Workflows with Oozie
• Export Data with Sqoop

---

Boost your salary by obtaining your Microsoft Certification: Microsoft Certified Systems Engineer (MCSE): Business Intelligence