| | Title | Description |
| | Basics 101 - What is Business Intelligence? | This introductory video discusses what is meant by Business Intelligence (BI) and why businesses pursue BI projects. (12 minutes) |
| | Basics 102 - Delivering Business Intelligence | With a properly designed data warehouse, a BI solution can deliver value to almost any user in an organization. This video explores the different users and various tools in a BI solution. (34 minutes) |
| | Basics 103 - The Data Warehousing Process | Business Intelligence is a process, and the main component is building a data warehouse. This video discusses the process of building a data warehouse from problem definition through the delivery of the data. (19.5 minutes) |
| | Basics 104 - Why BI Projects Fail (and what you can do about it) | Learn about the primary reasons BI projects fail and what you can do to address these problems. This session is based on Craig Utley's experiences with BI projects at approximately forty companies worldwide. (32.5 minutes) |
| | Basics 105 - Introduction to Business Intelligence Development Studio | See the primary tool used during the development of a data warehousing solution, Business Intelligence Development Studio (BIDS). BIDS is used to create SSIS packages, SSAS cubes, and SSRS reports. (15.5 minutes) |
| | SSAS 101 - Introduction to Analysis Services | This short video introduces Analysis Services to those who aren't familiar with it. It discusses the two primary areas of Analysis Services: building multidimensional cubes and building data mining models. (6.5 minutes) |
| | SSAS 102 - Creating Projects and Data Sources | This video covers the creation of both projects and data sources. A discussion of the options and decision points is included. (17 minutes) |
| | SSAS 103 - Data Source Views | Data Source Views are an incredibly powerful concept in SSAS projects that represent logical views of one or more data sources and allow developers to manipulate the schema. (21 minutes) |
| | SSAS 104 - The Cube Wizard - SSAS 2005 | This video discusses the Cube Wizard in Analysis Services 2005 The Cube Wizard creates cubes but can also create dimensions, and populate those dimensions with attributes and hierarchies. (16.5 minutes) |
| | SSAS 105 - The Cube Wizard - SSAS 2008 | This video shows the significantly enhanced Cube Wizard in SSAS 2008. The wizard has been streamlined and creates much simpler dimensions. (12.5 minutes) |
| | SSAS 106 - Basic Deploying, Processing, and Browsing | Following up on the Cube Wizard videos, this shows how to deploy and process the simple cubes just created, and then browse the data to verify the cube structure. (23 minutes) |
| | SSAS 107 - Creating Dimensions | This video covers dimension creation using the Dimension Wizard in both SSAS 2005 and 2008. A discussion of database dimensions and cube dimensions follows, as well as an examination of some of the properties of dimensions and attributes. (42.5 minutes) |
| | SSAS 108 - Creating Hierarchies | This video follows up the previous video by showing how to create hierarchies in the new dimensions. Hierarchies are created and the All member is changed and removed, among other topics. (25 minutes) |
| | SSAS 109 - Attribute Relationships | This video covers attribute relationships: what they are, how they work, and why they are so important. You'll see how to create them and some of the problems you might have. (57.5 minutes) |
| | SSAS 110 - Dimension Usage | Learn how a cube supports multiple fact tables through the use of dimensions and measure groups. You'll discover how to tie dimensions to measure groups and how to handle unrelated dimensions. (19 minutes) |
| | SSAS 111 - Aggregation Basics in SSAS 2005 | This video shows how to create aggregations in SSAS 2005. It covers the aggregation wizard, the "one-third" rule, and aggregation counts. (24 minutes) |
| | SSAS 112 - Aggregation Basics in SSAS 2008 | This covers why you want to create aggregations and how to use the aggregation wizard. A discussion of the "one-third rule" is included. (25 minutes) |
| | PPS 101 - Introduction to PerformancePoint Server | This video discusses PerformancePoint Server and its three modules: Monitoring, Analytics, and Planning. You'll learn what the three modules do and how they fit together to form a comprehensive solution. (21 minutes) |
| | MDX 101 - MDX: Basics and Structure | This video is the first in an introductory series about MDX. This video discusses the basics of MDX including usage, tuples, sets, and the basic structure of an MDX query. (27.5 minutes) |
| | QuickHit #1 - Ignore Unrelated Dims and Calculated Measures | This video discusses how IgnoreUnrelatedDimensions works with calculated measures. (5 minutes) |
| | MDX 102 - Hierarchy Navigation | This video describes how to navigate attribute and user hierarchies. Set and Member Functions are discussed, and all code is shown running in SSMS. (19.5 minutes) |
| | QuickHit #2 - Attributes, Keys, and Hierarchies | Adding an attribute to a natural hierarchy sometimes involves setting up a compound key in the KeyColumns property. What if you also want that attribute available without the effects of the compound key? (6.5 minutes) |
| | QuickHit #3 - Incremental Fact Processing | How do you perform incremental measure group/partition processing without duplicating data? See how to use the ProcessAdd XMLA command and modify the query to accurately load facts incrementally. (11 minutes) |
| | SSAS 113 - Working with Slowly Changing Dimensions | This video describes slowly changing dimensions, both Type I and Type II, and how to work with them in SSAS. (26.5 minutes) |
| | SSAS 114 - Calculations | This video covers calculations in an SSAS database including calculated members, named sets, and the SCOPE statement. (35.5 minutes) |
| | SSAS 115 - KPIs | This video covers Key Performance Indicators (KPIs). Learn how to create KPIs, including the value, goal, status, and trend. (27 minutes) |
| | PC 101 - ProClarity Overview | This video is an overview of the ProClarity products. See what products exist, their uses, and their likely futures. (11 minutes) |
| | PC 102 - ProClarity Basics | Learn the basics of analysis with ProClarity Desktop Professional, including drilling down/up, expanding/collapsing, and the four basic views. (20.5 minutes) |
| | PC 103 - The Setup Panel | This video dives into the Setup Panel in ProClarity Desktop Professional. You'll see how to manipulate the rows, columns, and background, as well as create slicers, sets, and members. (32 minutes) |
| | PC 104 - Decomposition Tree | Discover the ProClarity Decomposition Tree. See how to launch it and use it to analyze data. (13.5 minutes) |
| | SSAS 116 - Introduction to Actions | This video introduces actions in Analysis Services. It discusses the types of actions and shows examples of a couple of actions in use. (10 minutes) |
| | SSAS 117 - Drillthrough Actions | This video covers drillthrough actions in Analysis Services. It shows how to set them up and describes fact dimensions and their use in drillthrough. (19 minutes) |
| | SSAS 118 - Standard Actions | This video is about standard actions in Analysis Services. It shows the creation and use of a URL action. (12.5 minutes) |
| | SSAS 119 - Reporting Actions | This video covers reporting actions in Analysis Services. It shows how to call a report in SSRS and pass parameters. (16.5 minutes) |
| | SSAS 120 - Storage Modes | This video covers storage modes in Analysis Services. You'll learn about MOLAP, ROLAP, and HOLAP and see how to change the settings for dimensions and cube partitions. (16.5 minutes) |
| | SSAS 121 - Partitions | Learn what partitions are, how to create partitions using table or query binding, and how to merge partitions. (22 minutes) |
| | SSAS 122 - Translations | This video covers translations in Analysis Services. After a quick overview of translations, you will learn how to create them for both the cube and dimensions. You'll see how to change captions as well as dimension data. (14.5 minutes) |
| | SSAS 123 - Perspectives | This video covers perspectives in Analysis Services. You'll learn what perspectives are, see how to create them, and then use them in a client tool. The video also compares perspectives to views in a relational database. (10.5 minutes) |
| | QuickHit #4 - Cube Sparsity and Query Performance | This video is a QuickHit covering the concept of cube sparsity and how it can affect calculations in a query. You'll see examples of a simple query change and the dramatic impact it can have on performance, and how to monitor the cells being calculated. ( |