I’ve been toying around with the possibly getting more into BI and Cube design, aka Business Intelligence. From Wiki..
|
Business Intelligence (BI) refers to computer-based techniques used in spotting, digging-out, and analyzing business data, such as sales revenue by products or departments or associated costs and incomes. [1] BI technologies provide historical, current, and predictive views of business operations. Common functions of Business Intelligence technologies are reporting, online analytical processing, analytics, data mining, business performance management, benchmarking, text mining, and predictive analytics. Business Intelligence often aims to support better business decision-making.[2] Thus a BI system can be called a decision support system (DSS).[3] Though the term business intelligence is often used as a synonym for competitive intelligence, because they both support decision making, BI uses technologies, processes, and applications to analyze mostly internal, structured data and business processes while competitive intelligence, is done by gathering, analyzing and disseminating information with or without support from technology and applications, and focuses on all-source information and data (unstructured or structured), mostly external to, but also internal to a company, to support decision making. |
I’ve looked into a few books but find I am already swamped with reading up on Team Foundation Server, Silverlight, WCFRIA, Windows Workflow, Azure Cloud Services and a few other technologies.
With that, I find it sometimes easier to listen or watch a video while I work on something else. I came across an interesting site from CIOBriefings. LearnMicrosoftBI.Com.
They have an excellent list of BI videos and searching the “cube”, and they are free if you register.
Note: You MUST Register Free on Site Before you can access these videos.
|
|
Title |
Description |
|
This introductory video discusses what is meant by Business Intelligence (BI) and why businesses pursue BI projects. (12 minutes) |
||
|
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) |
||
|
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) |
|
|
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) |
||
|
This video covers the creation of both projects and data sources. A discussion of the options and decision points is included. (17 minutes) |
||
|
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) |
||
|
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) |
||
|
This video shows the significantly enhanced Cube Wizard in SSAS 2008. The wizard has been streamlined and creates much simpler dimensions. (12.5 minutes) |
||
|
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) |
||
|
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) |
||
|
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) |
||
|
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) |
||
|
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) |
||
|
This video shows how to create aggregations in SSAS 2005. It covers the aggregation wizard, the "one-third" rule, and aggregation counts. (24 minutes) |
||
|
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) |
||
|
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) |
||
|
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) |
||
|
This video discusses how IgnoreUnrelatedDimensions works with calculated measures. (5 minutes) |
||
|
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) |
||
|
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) |
||
|
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) |
||
|
This video describes slowly changing dimensions, both Type I and Type II, and how to work with them in SSAS. (26.5 minutes) |
||
|
This video covers calculations in an SSAS database including calculated members, named sets, and the SCOPE statement. (35.5 minutes) |
||
|
This video covers Key Performance Indicators (KPIs). Learn how to create KPIs, including the value, goal, status, and trend. (27 minutes) |
||
|
This video is an overview of the ProClarity products. See what products exist, their uses, and their likely futures. (11 minutes) |
||
|
Learn the basics of analysis with ProClarity Desktop Professional, including drilling down/up, expanding/collapsing, and the four basic views. (20.5 minutes) |
||
|
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) |
||
|
Discover the ProClarity Decomposition Tree. See how to launch it and use it to analyze data. (13.5 minutes) |
||
|
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) |
||
|
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) |
||
|
This video is about standard actions in Analysis Services. It shows the creation and use of a URL action. (12.5 minutes) |
||
|
This video covers reporting actions in Analysis Services. It shows how to call a report in SSRS and pass parameters. (16.5 minutes) |
||
|
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) |
||
|
Learn what partitions are, how to create partitions using table or query binding, and how to merge partitions. (22 minutes) |
||
|
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) |
||
|
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) |
||
|
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. ( |