For those of you, like myself, who are interested in learning more about building data warehouses for the use of building Business Intelligence Applications and Key Performance Indicator Dashboards, you might want to check out this free online training from Microsoft.
Here’s the details:
What you’ll learn
How to define data sources, data source views, dimensions, attributes, attribute relationships, hierarchies, and cubes in an Analysis Services project within BI Development Studio. How to view cube and dimension data by deploying the Analysis Services project to an instance of Analysis Services, and how to then process the deployed objects to populate them with data from the underlying data source. How to modify the measures, dimensions, hierarchies, attributes, and measure groups in the Analysis Services project, and how to then deploy the incremental changes to the deployed cube on the development server. How to define calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.
This tutorial is divided into ten lessons.
- Lesson 1: Defining a Data Source View within an Analysis Services Project
-
In this lesson, you define a data source view within an Analysis Services project by using BI Development Studio.
- Lesson 2: Defining and Deploying a Cube
-
In this lesson, you define a cube and its dimensions by using the Cube Wizard, and then deploy the cube to the local instance of Analysis Services.
- Lesson 3: Modifying Measures, Attributes and Hierarchies
-
In this lesson, you improve the user-friendliness of the cube and incrementally deploy the related changes, processing the cube and its dimensions as needed.
- Lesson 4: Defining Advanced Attribute and Dimension Properties
-
In this lesson, you define a referenced dimension relationship, order attribute members by using composite keys, and define custom error handling.
- Lesson 5: Defining Relationships Between Dimensions and Measure Groups
-
In this lesson, you define a fact relationship for a degenerate dimension and define a many-to-many relationship.
- Lesson 6: Defining Calculations
-
In this lesson, you define calculated members, named sets, and scripts.
- Lesson 7: Defining Key Performance Indicators (KPIs)
-
In this lesson, you define Key Performance Indicators (KPIs).
- Lesson 8: Defining Actions
-
In this lesson, you define actions.
- Lesson 9: Defining Perspectives and Translations
-
In this lesson, you define views of a cube and translations of metadata.
- Lesson 10: Defining Administrative Roles
-
In this lesson, you define administrative and user roles
↑ Grab this Headline Animator
Enjoy,
~Robert Shelton