NewEra Technology Facebook
10778 Implementing Data Models and Reports with Microsoft SQL Server 2012 - Virtual Led Training - Course Information
PRINT
SEND TO A FRIEND
Name: 10778 Implementing Data Models and Reports with Microsoft SQL Server 2012 - Virtual Led Training
Category: Microsoft Official Curriculum Courses
Length (Days): 5
Course Price (CAD): 2750
Description:
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,
Prerequisites:
10774 Querying Microsoft SQL Server 2012
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
Guaranteed to run courses