> > > 10778 Detailed outline

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

Course Description Kurs tarihleri Course Outline

Detailed Course Outline

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 Mode
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!