Designing Self-Service BI and Big Data Solutions [Class in Los Angeles] @ ONLC Training Centers

Start Dates (0)

$2,795
over 5 sessions
All classes are live, hands-on training via remote instructor.

Showing 1 – 0 of 0

Description

What you'll learn in this business intelligence training:

This five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.

Note
This course is designed for customers using SQL Server 2012 or SQL Server 2014 in conjunction with Microsoft Office.

Audience Profile
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.

Prerequisites
This course requires that you meet the following prerequisites:

Knowledge of data warehousing and data modeling principles.
Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.

At Course Completion
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.
Find and use public data in the Windows Azure Marketplace.
Use Microsoft Office 365 Power BI to implement cloud-based 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.

Course Outline

Module 1: Introduction to Self-Service Business Intelligence
This module introduces self-service BI.

Lessons

Extending Enterprise BI
Microsoft Self-Service BI and Big Data Technologies

Lab : Exploring an Enterprise BI Solution
Viewing Reports
Analyzing Data in a Data Model
Analyzing Data from Multiple Sources

Module 2: Self-Service Reporting
This module describes how to use Report Builder as a tool for self-service Microsoft SQL Server Reporting Services report authoring.

Lessons

Introduction to Self-Service Reporting
Shared Data Sources and Datasets
Report Parts

Lab : Implementing Self-Service Reporting
Using Report Builder
Simplifying Data Access for Business Users
Using Report Parts

Module 3: Self-Service Data Modeling with PowerPivot
This module describes how to use PowerPivot in Microsoft Excel to create self-service data models for analysis.

Lessons

Creating Data Models in Excel with PowerPivot
Using DAX in a PowerPivot Data Model

Lab : Self-Service Data Modeling with PowerPivot
Creating a Data Model with PowerPivot
Enhancing a Data Model
Extending a Data Model

Module 4: Importing Data with Power Query
This lesson describes how to use Power Query in Microsoft Excel to find and import data.

Lessons

Introduction to Power Query
Using Power Query to Import Data

Lab : Using Power Query
Importing data with Power Query
Merging Queries
Adding a Query to a Data Model

Module 5: Visualizing Data with Power View in Microsoft Excel
This module describes how to use Power View in Microsoft Excel to create interactive data visualizations.

Lessons

Introduction to Power View
Creating Dynamic Data Visualizations

Lab : Visualizing Data with Power View
Using Power View

Module 6: Visualizing Geographic Data with Power Map
This module describes how to use Power Map in Microsoft Excel to create geographic data visualizations.

Lessons

Introduction to Power Map
Using Power Map

Lab : Visualizing Geographic Data with Power Map
Creating a Power Map Tour
Visualizing Data Over Time

Module 7: Collaborative BI with Microsoft SharePoint Server
This module describes how to use Microsoft SharePoint Server in an enterprise environment to enable users to share PowerPivot workbooks and Power View reports.

Lessons

Sharing PowerPivot Workbooks
Managing PowerPivot Services in SharePoint Server
Using Power View in SharePoint Server

Lab : Using SharePoint Server for BI Collaboration
Sharing a PowerPivot Workbook
Managing PowerPivot Data Refresh
Using Power View in SharePoint Server

Module 8: The Windows Azure Marketplace Data Market
This module describes how to find and use datasets in the Windows Azure Marketplace.
Lessons

Introduction to the Windows Azure Marketplace
Using Windows Azure Marketplace Data in Microsoft Excel

Lab : Using the Windows Azure Marketplace
Finding Data in the Windows Azure Marketplace
Using Windows Azure Marketplace Data in Excel

Module 9: Cloud Collaboration with Power BI for Microsoft Office 365
This module introduces Power BI for Microsoft Office 365, and describes how to use it for cloud-based, collaborative self-service BI.

Lessons

Introduction to Power BI
Natural Language Queries with Q&A
Sharing Queries
The Data Management Gateway

Lab : Using Power BI
Provisioning Power BI
Viewing Reports and Querying Data in Power BI
Sharing Queries
Cloud-Enabling a Data Source

Module 10: Introduction to Big Data and Windows Azure HDInsight
This module introduces Big Data concepts and describes the key features of Windows Azure HDInsight.

Lessons

Introduction to Big Data
Windows Azure HDInsight

Lab : Using Windows Azure HDInsight
Provisioning a Windows Azure HDInsight Cluster
Processing Data with HDInsight
Analyzing Big Data in Microsoft Excel

Module 11: Processing Big Data with Pig and Hive
This module introduces Pig and Hive, and describes how you can use them to process Big Data in Windows Azure HDInsight.

Lessons

Processing Big Data with Pig
Processing Big Data with Hive

Lab : Processing Big Data with Pig and Hive
Processing Big Data with Pig
Processing Big Data with Hive

Module 12: Implementing Big Data Processing Solutions with Windows Azure HDInsight
This module introduces key Windows Azure HDInsight technologies that enable you to design and implement automated, repeatable Big Data processing solutions that support self-service BI.

Lessons

Automating Big Data Processing Tasks
Integrating Windows Azure HDInsight with Enterprise Data

Lab : Creating a Big Data Solution
Using HCatalog to Abstract Storage Locations
Using Oozie to Coordinate a Workflow
Using Sqoop to Export Data

Refund Policy

Cancellation / Reschedule by Student

Because we must schedule rooms, ship course materials, assign instructors and provision computer resources well in advance, it is important students alert us ASAP with any cancel/reschedule requests.

Please note the following policies:

If requested 16 or more calendar days before the class

Cancellation requests made in this timeframe are eligible for refund less 5% cancellation fee.
Reschedule requests made in this timeframe will be accommodated if availability exists and will be processed at no additional charge.

If requested 15 calendar days or less before the class

Cancellation or Reschedule requests made by the student 15 calendar days or less before the class starts will be charged 100% the course fee and are not entitled to a refund.

Substitutions

If you are unable to attend your class, a substitute who meets the course prerequisites may attend in your place at no additional charge for the original class title, date and location. If you cannot find a substitute, you will be subject to the class cancellation policy.

Make-up Policy

Students are permitted one (1) Make-Up opportunity to attend an instructor-led class that was paid for but not previously attended for no additional charge.

Make-Up class registrations are subject to availability and are not entitled to refund.
Students may not reschedule a Make-up class registration.
Any no shows or cancellations forfeit their one Make-up opportunity.

Additionally, ONLC reserves the right to retire courses due to lack of demand. Retired classes are not available for Make-Up.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at ONLC Training Centers (7)

(4.3-star rating across 7 reviews)

See reviews for other classes at ONLC Training Centers

Hide Reviews

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 27950 points. Earn 10% back in reward points!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Give This Course as a Gift Card

Thousands of classes
No expiration
Unique and memorable gifts for any occasion
Personalized
Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
Instant delivery
Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card