 |
|
 |
 |
 |
|
 |
 |
 |
|
 |
|
 |
 |
This sample video is available to all users.
| |
|
| SSAS 103 - Data Source Views | 7/20/2008 | 31.05 MB | 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) |
|
|
 |
 |
 |
 |
 |
 |
|
 |
 |
If you're seeing this message, you've come looking for free videos on the Microsoft BI tools. The videos are here but only available to registered users. Registration is free; simply click on Sign-up in the upper-right-hand corner of the page and register with the site. Once you verify your account and sign in, you'll be able to see the videos.
Thirty nine videos are currently available:
- The first video is a twelve minute introduction entitled "What is Business Intelligence?" This video covers what is meant by terms such as data warehousing and business intelligence and why companies undertake such projects.
- The second video is a 34 minute overview of how a single data warehouse can be used to deliver business value to a wide variety of users through scorecards, dashboards, reports, analytic applications, and custom applications.
- The third video discusses the process of data warehousing, from the initial problem definition through the creation of the cubes and delivery of the data. This video runs 19.5 minutes.
- The fourth video is "Why Business Intelligence Projects Fail (and what you can do about it)." This covers some of the primary reasons that BI projects fail along with tips for addressing the problems. This video is 32.5 minutes in length.
- The fifth video is "Introduction to Business Intelligence Development Studio" and covers the primary tool used to create data warehouses. This is the environment for creating SSIS packages, SSAS cubes, and SSRS reports. This video runs 15.5 minutes.
- The sixth video is an introduction to Analysis Services. It briefly discusses the two primary purposes of Analysis Services: building cubes and building mining models. The video runs 6.5 minutes.
- The seventh video is a SQL Server Analysis Services video called "Creating Projects and Data Sources." The video discusses the different types of Analysis Services projects and the options for creating them. It then discusses the creation of data sources and the various settings and considerations for handling authentication and impersonation. This video runs 17 minutes.
- The eighth video covers the topic of Data Source Views (DSVs) in Analysis Services projects. DSVs are powerful, logical views of the schema on which the cube will be built. This video covers the creation of the DSV as well as manipulating the schema. This video runs 21 minutes.
- The ninth video discusses the Cube Wizard for Analysis Services 2005. The Cube Wizard creates cubes but can also create dimensions, and populate those dimensions with attributes and hierarchies. This video will be followed by one specific to Analysis Services 2008 because of the significant differences in the Cube Wizard between versions. This video runs 16.5 minutes.
- The tenth video shows the Cube Wizard for Analysis Services 2008. The Cube Wizard for 2008 is greatly simplified from the one in 2005 and takes a minimalist approach to creating dimensions. This video runs 12.5 minutes.
- The eleventh video follows up on the Cube Wizard videos. The video explains the build, deployment, and processing pieces by deploying and processing the simple cube created in the previous videos. The video then covers browsing the data to verify the cube structure. This video runs 23 minutes.
- The twelfth video shows the creation of dimensions using the Dimension Wizards in both SSAS 2005 and SSAS 2008. After creating a dimension, the difference between a database dimension and cube dimension is explored, along with several of the attributes of a dimension. Finally, properties of the attributes are examined along with a discussion of what will follow in future videos. This video runs 42.5 minutes.
- The thirteenth video follows up on the twelfth by adding hierarchies to the dimensions created in the previous video. There is a discussion of why hierarchies should be created, then a demonstration of how to do it. Some properties are examined to change the name of the All level of the hierarchy, as well as to hide the All level. This video runs 25 minutes.
- The fourteenth video is "Attribute Relationships" and covers an extremely important topic in dimension design. You'll learn why attribute relationships are so important, how to create them, and some of the challenges you might have in working with them. Demonstrations in both SSAS 2005 and SSAS 2008 are provided. This video runs 57.5 minutes.
- The fifteenth video is "Dimension Usage" and discusses how cubes handle multiple fact tables when the facts have different dimensionality. You'll discover why you need multiple fact tables, how dimensions can be related to measure groups, and how to handle unrelated dimensions when viewing facts. This video runs 19 minutes.
- The sixteenth video is "Aggregation Basics in SSAS 2005" and covers why you want to create aggregations and how to use the aggregation wizard. A discussion of the "one-third rule" is included. This video runs 24 minutes.
- The seventeenth video is "Aggregation Basics in SSAS 2008" and covers why you want to create aggregations and how to use the new aggregation wizard, including the Aggregation Usage page. A discussion of the "one-third rule" is included. This video runs 25 minutes.
- The eighteenth video is "Introduction to PerformancePoint Server." and discusses the three modules of PerformancePoint Server: Monitoring, Analytics, and Planning. It describes how the three modules fit together to form a complete solution for keeping tabs on business performance. This video runs 21 minutes.
- The nineteenth video is the first in an introductory series about MDX. This video, entitled "MDX: Basics and Structure," discusses the basics of MDX including usage, tuples, sets, and the basic structure of an MDX query. This video runs 27.5 minutes.
- The twentieth video is the first "QuickHit" video, which are short videos that address a solution to a specific problem or question. The video discusses how IgnoreUnrelatedDimensions works with calculated measures. This video runs 5 minutes.
- The twenty first video is the second MDX video and covers hierarchy navigation for both attribute hierarchies and user hierarchies. Member and Set Functions are covered including Members, Parent, Children, and Descendants. This video runs 19.5 minutes.
- The twenty second video is a QuickHit that covers attributes that are added to a natural hierarchy and are given a compound key, but the attribute hierarchy should remain available without the compound key. This video runs 6.5 minutes.
- The twenty third video is a QuickHit that covers incremental fact processing. See how to load new records into a measure group/partition without duplicating records. This video runs 11 minutes.
- The twenty fourth video describes slowly changing dimensions, both Type I and Type II, and how to work with them in SSAS. This video runs 26.5 minutes.
- The twenty fifth video covers calculations in an SSAS database. These calculations include calculated members, named sets, and scripts (the SCOPE statement.) This video runs 35.5 minutes.
- The twenty sixth video covers Key Performance Indicators (KPIs). There is a discussion of what KPIs are and then discusses the elements of a KPI (value, goal, status, trend.) This video runs 27 minutes.
- The twenty seventh video is an overview of the ProClarity products. You'll learn what products exist, their uses, and their likely futures. This video runs 11 minutes.
- The twenty eighth video covers the basics of analysis with ProClarity Desktop Professional. See how to drill down and drill up, expand and collapse data, and cycle through the four basic views. This video runs 20.5 minutes.
- The twenty ninth 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. This video runs 32 minutes.
- The thirtieth video shows the ProClarity Decomposition tree. This very popular tool allows unique view of the data and the video shows how to launch the decomposition tree and how to use it to analyze data by drilling down and cross-drilling. This video runs 13.5 minutes.
- The thirty first video introduces actions in Analysis Services. It discusses the types of actions and shows examples of a couple of actions in use. This video runs 10 minutes.
- The thirty second video covers drillthrough actions in Analysis Services. It shows how to set them up and describes fact dimensions and their use in drillthrough. This video runs 19 minutes.
- The thirty third video is about standard actions in Analysis Services. It shows the creation and use of a URL action. This video runs 12.5 minutes.
- The thirty fourth video covers reporting actions in Analysis Services. It shows how to call a report and pass parameters. This video runs 16.5 minutes.
- The thirty fifth 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. This video runs 16.5 minutes.
- The thirty sixth video covers partitions in Analysis Services. You'll learn what partitions are, how to create them, what table binding and query binding mean, and how to merge partitions. This video runs 22 minutes.
- The thirty seventh 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. This video runs 14.5 minutes.
- The thirty eighth 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. This video runs 10.5 minutes.
- The thirty ninth video is a QuickHit video 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. This video runs 12 minutes.
|
|
 |
 |
 |
 |
|
|
|
 |
| Copyright 2011 by CIOBriefings LLC
|
|
|
 |
|
 |
|