Implementing Data Models and Reports with Microsoft® SQL Server® 2012 Training Course


Microsoft Official Curriculum Course Number: 10778
Printer Friendly Printer Friendly

Overview:
Students will learn how to implement self-service analytics and reporting, to implement multidimensional analysis solutions, create PowerPivot and tabular data models, and deliver rich data visualizations with PowerView and SQL Server Reporting Services,

Who Should Attend:
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: - Implementing reporting solutions by using SQL Server Reporting Services. - Implementing multidimensional databases by using SQL Server Analysis Services. - Creating tabular semantic data models for analysis by using SQL Server Analysis Services. - Create visualizations of data by using PowerView. - Create data mining solutions by using SQL Server Analysis Services.

At Course Completion:
After completing this course, students will be able to: 
- Describe the components, architecture, and nature of a BI solution. 
- Create reports with Reporting Services. 
- Create reusable report items that simplify self-service reporting. 
- Manage report execution and delivery. 
- Create a multidimensional database with Analysis Services. 
- Implement dimensions in a cube. 
- Implement measures and measure groups in a cube. 
- Use MDX Syntax. 
- Customize a cube. 
- Implement a Tabular Data Model in PowerPivot. 
-Use DAX to query a tabular model. 
- Implement a Tabular Database. 
- Use PowerView to create interactive data visualizations. 
- Use Data Mining for Predictive Analysis. 

Prerequisite Comments:
Before attending this course, the student should have: - At least 2 years’ experience of working with relational databases, including: - Designing a normalized database. - Creating tables and relationships. - Querying with Transact-SQL. - Some basic knowledge of data warehouse schema topology (including star and snowflake schemas). - Some exposure to basic programming constructs (such as looping and branching). - An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
 
Outline:
Lesson 1: Introduction to Business Intelligence and Data Modeling
Introduction to Business Intelligence 
The Microsoft Business Intelligence Platform 
Lab : Reporting and Analyzing Data

Lesson 2: Implementing Reports with SQL Server Reporting Services
Introduction to Reporting Services 
Creating a Report with Report Designer 
Grouping and Aggregating Data in a Report 
Showing Data Graphically 
Filtering Reports by Using Parameters 
Publishing and Viewing a Report 
Lab : Creating a Report with Report Designer 
Lab : Enhancing and Publishing a Report
Lesson 3: Supporting Self Service Reporting
Introduction to Self Service Reporting 
Shared Data Sources and Datasets 
Report Parts 
Lab : Implementing Self Service Reporting
Lesson 4: Managing Report Execution and Delivery
Managing Report Security 
Managing Report Execution 
Subscriptions and Data Alert 
Troubleshooting Reporting Services 
Lab : Configuring Report Execution and Delivery
Lesson 5: Creating Multidimensional Databases
Introduction to Multidimensional Analysis 
Creating Data Sources and Data Source Views 
Creating a Cube 
Overview of Cube Security 
Lab : Creating a Multidimensional Database

Lesson 6: Working with Dimensions
Configuring Dimensions 
Defining Attribute Hierarchies 
Sorting and Grouping Attributes 
Lab : Defining Dimensions
Lesson 7: Working with Measures and Measure Groups
Working with Measures 
Working with Measure Groups 
Lab : Configuring Measures and Measure Groups
Lesson 8: Introduction to MDX
MDX Fundamentals 
Adding Calculations to a Cube 
Using MDX to Query a Cube 
Lab : Using MDX
Lesson 9: Customizing Cube Functionality
Working with Key Performance Indicators 
Working with Actions 
Working with Perspectives 
Working with Translations 
Lab : Customizing a Cube

Lesson 10: Implementing a Tabular Data Model with Microsoft PowerPivot
Introduction to Tabular Data Models and PowerPivot Technologies 
Creating a Tabular Data Model by Using PowerPivot for Excel 
Sharing a PowerPivot Workbook and Using PowerPivot Gallery 
Lab : Using PowerPivot for Excel
Lesson 11: Introduction to DAX
DAX Fundamentals 
Using DAX to Create Calculated Column and Measures in a Tabular Data Model 
Lab : Creating Calculated Columns and Measures by Using DAX
Lesson 12: Implementing an Analysis Services Tabular Data Model
Introduction to Analysis Services Tabular Data Model Projects 
Developing an Analysis Services Tabular Data Model in SQL Server Data Tools 
Lab : Working with an Analysis Services Tabular Data Model
Lesson 13: Creating Data Visualizations with Power View
Introduction to Power View 
Visualizing Data with Power View 
Lab : Creating Data Visualizations with Power View

Lesson 14: Performing Predictive Analysis with Data Mining
Overview of Data Mining 
Creating a Data Mining Solution 
Validating a Data Mining Solution 
Consuming a Data Mining Solution 
Lab : Using Data Mining to Support a Marketing Campaign

 

*Content, days, and times vary depending on your location. Please view the outline on the checkout page prior to purchase or
contact the local center for more information.

Current User's Login:


Fill out the information as a first time user:
Name:
(First/Last)
 
Email:
(UserName)
Confirm Email:
Company:
(if applicable)
Title:
Address 1:
Address 2:
City:
State/Province:
Postal Code:
Country:
Phone:
Discount Code:
Comments:
To Redeem SATV vouchers please have your voucher redemption number ready


Live Instructor-led Implementing Data Models and Reports with Microsoft® SQL Server® 2012 Training Dates

SATV Eligible
Filter By...
Providers:       Location:      
Date Range:  
 to 
Provider Location Date Type Duration Price 0 course(s)
  << Prev  Next >> 

Online Self-Paced Implementing Data Models and Reports with Microsoft® SQL Server® 2012 Training Options

SATV Eligible
No online results

Request Training Assistance

Please complete the form below and a TrainUp.com support specialist will send you information on the course you've selected. Our staff typically responds to your requests within 30 minutes or less. You can also reach us toll-free at 1-866-540-9677

Request Training Assistance

Please complete the form below and a TrainUp.com support specialist will send you information on the course you've selected. Our staff typically responds to your requests within 30 minutes or less. You can also reach us toll-free at 1-866-540-9677

//