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-467: Designing Business Intelligence Solutions 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 designing business intelligence solutions with Microsoft SQL Server 2012. This course is designed for BI Architects, who focus on the overall design of the BI infrastructure, including how it relates to other data systems in use.

Table of Contents

  1. Designing Business Intelligence Solutions with Microsoft SQL Server 2012
    1. Course Introduction 00:00:30
    2. Course Modules 00:01:22
  2. Module 1
    1. Introduction to Data Warehousing 00:00:13
    2. On-Line Transaction Processing (OLTP) vs. OLAP 00:03:02
    3. Data Warehousing 00:01:51
    4. Data Warehouse Architecture 00:01:54
    5. Creating a Data Warehouse Part1 00:02:52
    6. Creating a Data Warehouse Part2 00:01:15
    7. Presenting On-Line Analytical Processing (OLAP) Data 00:04:27
    8. OLTP vs. OLAP Demonstration 00:04:11
    9. Exam Scenarios 1 00:02:43
    10. Module 1 Review 00:00:46
  3. Module 2
    1. Designing a Data Warehouse 00:00:05
    2. Data Modeling 00:01:05
    3. Data Warehouse Schemas 00:01:38
    4. Time Dimensions 00:02:05
    5. Data Modeling Considerations 00:05:14
    6. Implementing a Data Model 00:01:24
    7. Logical Model 00:00:38
    8. Physical Model 00:03:52
    9. Working with Dimensions and Fact Tables 00:05:18
    10. Exam Scenarios 2 00:02:06
    11. Module 2 Review 00:01:08
  4. Module 3
    1. Extraction, Transformation, and Load (ETL) with SSIS 00:00:09
    2. Introduction to SQL Server Integration Services (SSIS) 00:00:54
    3. Upgrading SSIS Packages 00:01:00
    4. SSIS Tools 00:00:42
    5. Introduction to Data Flow Tasks 00:02:06
    6. Data Sources 00:00:35
    7. Transformations 00:02:38
    8. Destinations 00:02:59
    9. Control Flow 00:01:24
    10. Variables 00:02:38
    11. Expressions 00:00:38
    12. Precedence 00:00:56
    13. Containers 00:00:22
    14. Control Flow Containers Part1 00:01:56
    15. Control Flow Containers Part2 00:02:19
    16. Transactions 00:01:06
    17. Package Execution with Checkpoints 00:02:59
    18. Working with SSIS Packages Part1 00:05:22
    19. Working with SSIS Packages Part2 00:04:47
    20. Working with SSIS Packages Part3 00:04:07
    21. Exam Scenarios 3 00:02:56
    22. Module 3 Review 00:01:29
  5. Module 4
    1. Deploying and Securing Packages 00:00:08
    2. Deploying Options 00:01:42
    3. Deploying Packages 00:00:26
    4. Deploying Projects 00:00:48
    5. Securing Packages 00:00:59
    6. Deploying and Securing Packages 00:03:40
    7. Exam Scenarios 4 00:02:19
    8. Module 4 Review 00:01:00
  6. Module 5
    1. SQL Server Reporting Services (SSRS) 00:00:10
    2. Introduction to Reporting Services Part1 00:00:10
    3. Introduction to Reporting Services Part2 00:01:17
    4. SSRS Reports Creation and Delivery 00:00:33
    5. SSRS Reports 00:01:24
    6. Grouping 00:00:51
    7. Expressions 00:00:32
    8. Drilldown 00:01:55
    9. Parameters 00:02:10
    10. Drillthrough 00:00:58
    11. Visual Components 00:01:03
    12. Creating Reports Within Reporting Services Part1 00:04:21
    13. Creating Reports Within Reporting Services Part2 00:04:34
    14. Creating Reports Within Reporting Services Part3 00:04:18
    15. Creating Reports Within Reporting Services Part4 00:03:42
    16. Exam Scenarios 5 00:02:48
    17. Module 5 Review 00:01:11
  7. Module 6
    1. SSRS Reports 00:00:10
    2. Deploying Reports 00:00:55
    3. Report Security 00:04:05
    4. Report Execution 00:00:53
    5. Report Caching 00:03:03
    6. Report Snapshot 00:02:22
    7. Subscriptions 00:02:12
    8. Data Alerts 00:01:50
    9. Deploying Reports and Report Security Part1 00:04:50
    10. Deploying Reports and Report Security Part2 00:02:49
    11. Exam Scenarios 6 00:02:05
    12. Module 6 Review 00:01:01
  8. Module 7
    1. Multidimensional Cubes 00:00:08
    2. Introduction to Cubes Part1 00:00:12
    3. Introduction to Cubes Part2 00:00:47
    4. Components of a Multidimensional Cubes 00:01:18
    5. Measures 00:01:06
    6. Measure Format and Aggregation Functions 00:01:46
    7. Measure Groups Part1 00:01:37
    8. Measure Groups Part2 00:02:04
    9. Aggregations 00:00:56
    10. Dimensions 00:00:53
    11. Dimension Storage 00:00:49
    12. Dimensions Hierarchies 00:01:47
    13. Grouping and Sorting 00:01:37
    14. Actions 00:00:54
    15. Perspectives 00:01:20
    16. Key Performance Indicators 00:01:19
    17. Translations 00:00:58
    18. SSAS Security 00:01:32
    19. Cell Permissions 00:01:09
    20. Dimension Permissions 00:00:42
    21. Creating and Configuring a Cube Part1 00:04:39
    22. Creating and Configuring a Cube Part2 00:05:23
    23. Creating and Configuring a Cube Part3 00:03:01
    24. Creating and Configuring a Cube Part4 00:05:40
    25. Exam Scenarios 7 00:02:44
    26. Module 7 Review 00:01:14
  9. Module 8
    1. Tabular Data Models 00:00:10
    2. Introduction to Tabular Data Models 00:01:24
    3. PowerPivot 00:00:48
    4. Working with PowerPivot 00:01:28
    5. Linked and Non-Linked Tables 00:00:41
    6. PowerPivot Features 00:00:42
    7. Server Based Tabular Data Models Part1 00:00:17
    8. Server Based Tabular Data Models Part2 00:00:37
    9. Creating a Tabular Data Model 00:00:37
    10. Tabular Models with SSDT 00:00:42
    11. Workspace Database 00:01:06
    12. Tabular Data Model 00:01:51
    13. Tabular Data Model Security 00:00:35
    14. Creating a Tabular Data Model Using PowerPivot Part1 00:03:35
    15. Creating a Tabular Data Model Using PowerPivot Part2 00:05:18
    16. Creating a Tabular Data Model Using PowerPivot Part3 00:04:58
    17. Creating a Tabular Data Model Using PowerPivot Part4 00:02:42
    18. Exam Scenarios 8 00:01:46
    19. Module 8 Review 00:00:55
  10. Module 9
    1. MDX/DAX 00:00:19
    2. Introduction to Multidimensional Expressions (MDX) 00:00:56
    3. Why Use MDX? 00:01:07
    4. MDX Syntax 00:02:36
    5. Sets 00:01:21
    6. Where is MDX Used? 00:01:14
    7. Introduction to Data Analysis eXpressions (DAX) Part1 00:00:13
    8. Introduction to Data Analysis eXpressions (DAX) Part2 00:00:38
    9. Working with DAX 00:02:11
    10. DAX Functions 00:01:30
    11. DAX Queries 00:00:42
    12. Calculated Columns 00:00:44
    13. DAX Measures 00:00:30
    14. Multiple Relationships 00:00:30
    15. Exam Scenarios 9 00:02:22
    16. Module 9 Review 00:01:03
  11. Module 10
    1. Data Mining 00:00:15
    2. Introduction to Data Mining 00:01:04
    3. Data Mining Algorithms 00:01:48
    4. Data Mining Components 00:01:43
    5. Validating and Presenting Data Mining Models 00:02:46
    6. Creating a Data Mining Model Part1 00:04:32
    7. Creating a Data Mining Model Part2 00:02:54
    8. Exam Scenarios 10 00:01:26
    9. Module Review 10 00:00:45
    10. Course Review 00:01:39