![]() 20466: Implementing Data Models and Reports with Microsoft SQL ServerNetworking/Server/Operating Systems
Schedules
Delivery Type (Must Select One)
Instructor-Led
Online Live Instructor-Led
Optional
A+ Test Voucher ($390) - Set of 2 - $195 Each
A+ Practice Exam ($70.00)
IT Online Library (1 Year Subscription - $1595.00)
Quantity
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date.
Special Instructions
The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft� SQL Server� Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Module 1: Introduction to Business Intelligence and Data Modeling
Lab : Exploring a BI Solution After completing this module, you will be able to:
Lab : Creating a Multidimensional Database After completing this module, you will be able to:
Lab : Working with Cubes and Dimensions After completing this module, you will be able to:
Lab : Configuring Measures and Measure Groups After completing this module, you will be able to:
Lab : Using MDX After completing this module, you will be able to:
Lab : Customizing a Cube After completing this module, you will be able to:
Lab : Implementing an Analysis Services Tabular Data Model After completing this module, you will be able to:
Lab : Creating Calculated Columns and Measures by using DAX After completing this module, you will be able to:
Lab : Creating a Report with Report Designer After completing this module, you will be able to:
Lab : Implementing Report Subscriptions After completing this module, you will be able to:
Lab : Implementing PerformancePoint Services After completing this module, you will be able to:
Lab : Using Data Mining to Support a Marketing Campaign After completing this module, you will be able to:
After completing this course, students will be able to:
This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include:
This course requires that you meet the following prerequisites:
You may cancel this class 10 or more business days prior to the start date of the class for a full refund. No shows or cancellations made within
10 days will forfeit all fees paid.
|