O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012

Video Description

This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012. This course is designed for BI Developers who most-likely focus on hands-on work creating the BI solution including implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.

Table of Contents

  1. Implementing Data Models and Reports with Microsoft SQL Server 2012
    1. Course Introduction 00:00:37
    2. Course Modules 00:01:11
  2. Module 1
    1. SQL Server 2012 Business Intelligence 00:00:09
    2. Introduction to Business Intelligence Part1 00:00:11
    3. Introduction to Business Intelligence Part2 00:01:13
    4. Data Warehouse 00:05:52
    5. Extract, Transform and Load (ETL) 00:00:44
    6. SQL Server Integration Services 00:00:55
    7. SQL Server 2012 BI Tools 00:05:23
    8. Developer Tools 00:02:00
    9. Exam Scenarios 1 00:00:55
  3. Module 2
    1. SQL Server Reporting Services 00:00:12
    2. Introduction to SSRS Part1 00:00:14
    3. Introduction to SSRS Part2 00:01:22
    4. Creation and Delivery 00:01:21
    5. SSRS Reports 00:02:35
    6. Report Grouping 00:01:06
    7. Expressions 00:00:48
    8. Drilldown Report Part1 00:01:59
    9. Drilldown Report Part2 00:01:07
    10. Parameters 00:03:41
    11. Visual Components 00:00:49
    12. Creating SQL Server Part1 00:05:43
    13. Creating SQL Server Part2 00:06:03
    14. Creating SQL Server Part3 00:05:32
    15. Creating SQL Server Part4 00:05:27
    16. Creating SQL Server Part5 00:05:25
    17. Creating SQL Server Part6 00:01:56
    18. Exam Scenarios 2 00:02:15
    19. Module 2 Review 00:01:16
  4. Module 3
    1. SSRS Management 00:00:09
    2. Deploying Reports Part1 00:00:07
    3. Deploying Reports Part2 00:00:40
    4. Report Security Part1 00:00:50
    5. Report Security Part2 00:03:20
    6. Executing Reports 00:01:23
    7. Report Caching 00:02:48
    8. Report Snapshot 00:02:53
    9. Subscriptions 00:01:44
    10. Data Alerts 00:02:03
    11. Managing Reporting Services Part1 00:04:39
    12. Managing Reporting Services Part2 00:05:19
    13. Managing Reporting Services Part3 00:05:27
    14. Managing Reporting Services Part4 00:05:09
    15. Exam Scenarios 3 00:01:31
    16. Module 3 Review 00:00:53
  5. Module 4
    1. Multidimensional Cubes 00:00:06
    2. Introduction to Cubes 00:02:25
    3. Cube Components 00:01:21
    4. Creating and Configuring Analysis Services Cube Part1 00:05:26
    5. Creating and Configuring Analysis Services Cube Part2 00:06:56
    6. Creating and Configuring Analysis Services Cube Part3 00:04:08
    7. Creating and Configuring Analysis Services Cube Part4 00:02:48
    8. Creating and Configuring Analysis Services Cube Part5 00:04:12
    9. Creating and Configuring Analysis Services Cube Part6 00:01:56
    10. Exam Scenarios 4 00:02:10
    11. Module 4 Review 00:00:40
  6. Module 5
    1. Advanced Cube Concepts 00:00:08
    2. Measures 00:01:03
    3. Formatting Measures 00:02:26
    4. Measure Groups 00:01:58
    5. Measure Group Storage 00:03:29
    6. Aggregations 00:01:02
    7. Dimensions Part1 00:00:08
    8. Dimensions Part2 00:00:51
    9. Dimension Storage 00:00:50
    10. Grouping and Sorting 00:02:27
    11. Working with Measures Part1 00:03:57
    12. Working with Measures Part2 00:04:40
    13. Working with Measures Part3 00:05:51
    14. Working with Measures Part4 00:04:41
    15. Working with Measures Part5 00:04:16
    16. Working with Measures Part6 00:04:45
    17. Exam Scenarios 5 00:02:15
    18. Module 5 Review 00:01:04
  7. Module 6
    1. Customizing Cubes and Security 00:00:10
    2. Actions 00:01:26
    3. Perspectives 00:01:34
    4. Key Performance Indicators 00:02:32
    5. Translations 00:00:47
    6. SSAS Security 00:01:04
    7. Cell Permissions 00:01:04
    8. Dimension Permissions 00:00:51
    9. Customizing Cubes and Cube Security Part1 00:06:33
    10. Customizing Cubes and Cube Security Part2 00:04:44
    11. Customizing Cubes and Cube Security Part3 00:05:36
    12. Customizing Cubes and Cube Security Part4 00:01:40
    13. Exam Scenarios 6 00:02:40
    14. Module 6 Review 00:01:21
  8. Module 7
    1. MultiDimensional eXpressions (MDX) 00:00:10
    2. Introduction to MDX 00:01:09
    3. Why Use MDX? 00:01:13
    4. MDX Syntax 00:00:52
    5. MDX Queries and Filters Part1 00:00:30
    6. MDX Queries and Filters Part2 00:01:33
    7. Sets 00:00:41
    8. Applying MDX 00:00:27
    9. Working with MDX Part1 00:05:35
    10. Working with MDX Part2 00:05:44
    11. Working with MDX Part3 00:03:27
    12. Exam Scenarios 7 00:01:54
    13. Module 7 Review 00:00:40
  9. Module 8
    1. Tabular Data Models 00:00:12
    2. Introduction to TDM Part1 00:00:14
    3. Introduction to TDM Part2 00:01:05
    4. PowerPivot 00:03:43
    5. Linked and Non-Linked Tables 00:00:56
    6. PowerPivot 00:01:00
    7. Server Based Tabular Data Models 00:01:12
    8. Creating a Tabular Data Model 00:01:48
    9. Workspace Database 00:01:16
    10. Tabular Data Model Part1 00:02:32
    11. Tabular Data Model Part2 00:00:49
    12. Working with Tabular Data Modeling Part1 00:04:27
    13. Working with Tabular Data Modeling Part2 00:05:34
    14. Working with Tabular Data Modeling Part3 00:03:53
    15. Working with Tabular Data Modeling Part4 00:03:51
    16. Working with Tabular Data Modeling Part5 00:04:44
    17. Working with Tabular Data Modeling Part6 00:01:49
    18. Exam Scenarios 8 00:02:02
    19. Module 8 Review 00:01:37
  10. Module 9
    1. Data Analysis eXpressions (DAX) 00:00:06
    2. Introduction to DAX Part1 00:00:11
    3. Introduction to DAX Part2 00:00:53
    4. Working with DAX 00:01:23
    5. DAX Functions 00:00:35
    6. DAX Queries 00:00:54
    7. Calculated Columns 00:00:25
    8. Measures 00:00:28
    9. Multiple Relationships 00:00:50
    10. Working with DAX within PowerPivot 00:04:39
    11. Exam Scenarios 9 00:01:40
    12. Module 9 Review 00:00:49
  11. Module 10
    1. Data Mining 00:00:14
    2. Introduction to Data Mining 00:01:40
    3. Data Mining Algorithms 00:01:50
    4. Data Mining Components 00:01:23
    5. Validating Mining Models 00:01:53
    6. Presenting Mining Data 00:01:29
    7. Creating a Mining Structure Part1 00:05:54
    8. Creating a Mining Structure Part2 00:02:35
    9. Exam Scenarios 10 00:02:47
    10. Module 10 Review 00:01:11
    11. Course Review 00:01:30