Facebook Twitter Blogger You Tube

877.484.1182

 Implementing Data Models and Reports with Microsoft SQL Server 2012 (MS 10778)

Facebook Share on Facebook
5 Days
Implementing Data Models and Reports with Microsoft SQL Server 2012 (MS 10778)

 
Join our Mailing list

Certifications:

Course At A Glance

This course is one of five courses required to pass the MCSE: Business Intelligence exam.... READ MORE

Request a Quote

 

There are currently no scheduled classes.

Try searching for another option from our course list.

Course Locator

Or call us at (623) 570-4309 to request a class near you!

Implementing Data Models and Reports with Microsoft SQL Server 2012 (MS 10778)

Course Length: 5 Days

This course is one of five courses required to pass the MCSE: Business Intelligence exam.

This 5-day instructor-led course describes how to empower information workers through self-service analytics and reporting. Students will learn how to implement PowerPivot and tabular data models, create and deliver rich data visualizations with Power View and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466.


Course Objectives

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 a reporting infrastructure
  • 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 Power View to create interactive data visualizations
  • Use Data Mining for predictive analysis

Pre-requisites

In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:

  • 10774: Writing Queries with Microsoft SQL Server Transact-SQL

Implementing Data Models and Reports with Microsoft SQL Server 2012 (MS 10778)

Module 1: Introduction to Business Intelligence and Data Modeling

    Lessons
  • Introduction to Business Intelligence
  • The Microsoft Business Intelligence Platform
    Lab: Reporting and Analyzing Data
  • Exploring a Reporting Services report
  • Exploring a PowerPivot workbook

Module 2: Implementing Reports with Reporting Services

    Lessons
  • Introduction to Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Showing Data Graphically
  • Filtering Reports Using Parameters
    Lab: Implementing Reports with Reporting Services
  • Creating a Report
  • Grouping and Aggregating Data in a Report
  • Adding a Chart to a Report
  • Implementing Parameters in a Report
  • Publishing and Viewing a Report
  • Optional Exercise: Creating Visual Comparisons in a Report
  • Optional Exercise: Creating a Map Report

Module 3: Supporting Self-Service Reporting

    Lessons
  • Introduction to Report Builder
  • Creating Reusable Report Items
    Lab: Supporting Self-Service Reporting
  • Using Report Builder
  • Creating a shared data source
  • Creating shared data sets
  • Creating a Report Part

Module 4: Managing a Reporting Infrastructure

    Lessons
  • Managing Security
  • Managing Report Execution
  • Delivering Reports with Subscriptions
  • Troubleshooting Reporting Services
    Lab: Implementing Report Subscriptions
  • Configuring Report Execution
  • Implementing a Standard Subscription
  • Implementing a Data-Driven Subscription

Module 5: Creating Multidimensional Databases

    Lessons
  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security
    Lab: Creating a Multidimensional Database
  • Creating a Data Source
  • Creating and Modifying a Data Source View
  • Creating and Modifying a Cube

Module 6: Working with Cubes and Dimensions

    Lessons
  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes
    Lab: Working with Cubes and Dimensions
  • Configuring Dimensions
  • Defining Relationships and Hierarchies
  • Sorting and Grouping Dimension Attributes

Module 7: Working with Measures and Measure Groups

    Lessons
  • Working With Measures
  • Working with Measure Groups
    Lab: Configuring Measures and Measure Groups
  • Configuring Measures
  • Defining Dimension Usage and Relationships
  • Configuring Measure Group Storage

Module 8: Introduction to MDX

    Lessons
  • MDX Fundamentals
  • Adding Calculations to a Cube
  • Using MDX To Query a Cube
    Lab: Using MDX
  • Querying a Cube by Using MDX
  • Creating a Calculated Member

Module 9: Customizing Cube Functionality

    Lessons
  • Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations
    Lab: Customizing a Cube
  • Implementing a KPI
  • Implementing an Action
  • Implementing a Perspective
  • Implementing a Translation

Module 10: Implementing a Tabular Data Model by Using Microsoft PowerPivot

    Lessons
  • 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
  • Creating a Tabular Data Model by Using PowerPivot for Excel
  • Using a Tabular Data Model in Excel
  • Sharing a PowerPivot Workbook to PowerPivot Gallery
  • Using a PowerPivot Workbook as a Data Source

Module 11: Introduction to Data Analysis Expression (DAX)

    Lessons
  • DAX Fundamentals
  • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
    Lab: Creating Calculated Columns and Measures by Using DAX
  • Creating Calculated Columns
  • Creating Measures
  • Using Time Intelligence
  • Creating a Dynamic Measure

Module 12: Implementing an Analysis Services Tabular Data Model

    Lessons
  • Introduction to Analysis Services Tabular Data Model Projects
  • Implementing an Analysis Services Tabular Data Model in Business Intelligence Development Studio
    Lab: Working with an Analysis Services Tabular Data Model
  • Creating an Analysis Services Tabular Data Model Project from a PowerPivot Workbook
  • Implementing a Perspective
  • Implementing Partitions
  • Deploying an Analysis Services Tabular Data Model
  • Enabling Access to a Tabular Data Model
  • Configuring DirectQuery Storage Mode
  • Implementing Security in a Tabular Data Model

Module 13: Creating Data Visualizations with Power View

    Lessons
  • Introduction to Power View
  • Visualizing Data with Power View
    Lab: Creating Interactive Reports with Power View
  • Modify the Tabular Data Model
  • Create a Simple Power View Report
  • Interactive Visualizations
  • Create a Scatter Chart and a Play Axis

Module 14: Performing Predictive Analysis with Data Mining

    Lessons
  • Overview of Data Mining
  • Using the Data Mining Add-In for Excel
  • Creating a Custom Data Mining Solution
  • Validating a Data Mining Model
  • Connecting to a and Consuming a Data-Mining Model
    Lab: Performing Predictive Analysis with Data Mining
  • Using the Excel Data Mining Add-In
  • Creating a Data Mining Structure and Model
  • Exploring Data Mining Models
  • Validating Data Mining Models
  • Consuming a Data Mining Model

MCSE: Business Intelligence 2012

MCSE: Business Intelligence 2012

The globally recognized standard for IT professionals

Prove that you have the skills and techniques needed to design, build, and deploy solutions that deliver more data to more people across the organization.

Earning an MCSE: Business Intelligence certification will qualify for a position as a BI and reporting engineer.

Step

Exam title

Optional training

Required exam

1

Querying Microsoft SQL Server 2012

10774461

2

Administering Microsoft SQL Server 2012 Databases

10775462

3

Implementing a Data Warehouse with Microsoft SQL Server 2012
After successfully completing steps 1-3, you'll earn a Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification.

10777463

4

Implementing Data Models and Reports with Microsoft SQL Server 2012

10778466

5

Designing Self-Service Business Intelligence and Big Data Solutions

20467467

 

Training and Certification Courses and Bootcamps in VMware | Microsoft Technical | Microsoft Developer | Microsoft Sharepoint | Security | Cisco | Citrix