Friday, August 17, 2018
 
BI Developer Training Schedule (SQL 2014, SSAS, SSIS, SSRS)
 

 Batch

 Start Date

 End Date

 Class Days

 Class Time

 Class Type

 Price

 Register

 1

 04/07/2015

 06/02/2015

 Tue, Wed, Thurs.

 8 – 9:30 pm EST

 Live Instructor-Led

 $499 (USD)

 ENROLL

 2

 04/11/2015

 06/07/2015

 Sat & Sun

 11 - 1 pm CST

 Live Instructor-Led

 $499 (USD)

 ENROLL

 

Course Details

Introduction to Business Intelligence and Data Modeling Using SQL Server 2014

As a SQL Server database professional, you may be required to participate in, or perhaps even lead, a project with the aim of implementing an effective enterprise BI solution. Therefore, it is important that you have a good understanding of the various elements that comprise a BI solution, the business and IT personnel typically involved in a BI project, and the Microsoft products that you can use to implement the solution. This class covers the elements of an enterprise BI solution, the Microsoft enterprise BI platform and planning an enterprise BI project.
 
Creating Multidimensional Databases Using SSAS 2014
This class provides an introduction to multidimensional databases and introduces the core components of an Online Analytical Processing (OLAP) cube, data sources, data source views and cube security.
 
Working with Cubes and Dimensions
This class covers how to create and configure dimensions and dimension hierarchies, sorting and grouping hierarchies in an Analysis Services multidimensional data model.
 
Working with Measures and Measure Groups
This class describes measures and measure groups. It also explains how you can use them to define fact tables and associate dimensions with measures.
 
Introduction to MDX
This class introduces you to the fundamentals of MDX and explains how to build calculations, such as calculated members and named sets, Use MDX to query a cube, etc.
 
Enhancing a Cube
This class covers how to enhance a cube with Key Performance Indicators (KPIs), actions, perspectives, and translations.
 
Implementing an Analysis Services Tabular Data Model
This class covers Analysis Services tabular data models and explains how to develop a tabular data model using the SQL Server Data Tools for Business Intelligence (BI) add-in for Visual Studio.
 
Introduction to DAX
This class introduces you to the fundamentals of the DAX language. It also explains how you can use DAX to create calculated columns and measures, and how you can use them in your tabular data models.
 
Implementing Reports with SQL Server Reporting Services
This class introduces Microsoft SQL Server Reporting Services and discusses the tools and techniques that a professional BI developer can use to create and publish reports by using Report Designer, grouping and aggregating data in a report and publishing and viewing a report.
 
Enhancing Reports with SQL Server Reporting Services
This class covers how to enhance a SQL Server reporting Services report with charts and other visualizations, and how to use parameters to filter data in a report.
 
Managing Report Execution and Delivery
This class covers how to apply security and report execution settings, and how to create subscriptions to deliver reports and how to troubleshoot Reporting Services.
 
Delivering BI with SharePoint PerformancePoint Services
This class introduces you to Microsoft SharePoint Server as a platform for BI, and then focuses on building BI dashboards and scorecards with PerformancePoint Services.
 
Performing Predictive Analysis with Data Mining
This class introduces data mining, describes how to create a data mining solution, how to validate data mining models, how to use the Data Mining Add-ins for Microsoft Excel, and how to incorporate data mining results into Reporting Services reports.
 
Download Course Syllabus for SQL Server 2014 Developer Course
SQL Developer Training Value
Corporate and Onsite Training by SQL Operations
Contact SQL Operations
SQL Operations Services
 

 

Home   |   Training   |   Services   |   Risk & Health Audit   |   Career   |   About Us   |   Contact Us
Copyright 2018 by SQLOPERATIONS