Highlights
- Explore data warehouse and star schema design for use with Analysis Services (SSAS)
- Learn about multidimensional cubes
- Design SSAS multidimensional cubes to ensure meaningful and efficient access to your corporate data
- Explore hierarchies and attribute relationships
- Understand how to create cubes and learn cube security
- Put a cube into production
- Learn how to use MDX
Course Details
- Data warehouse/Star Schema design for use with Analysis Services
- Multi dimensional Cubes
- Hierarchies and attribute relationships
- Cube Security
- Putting a Cube into production
- MDX
- Create a Cube Using the Cube Wizard
- Create a Cube from a template without using a Data Source View
- Create a Cube using a Data Source View
- Browse data and metadata in Cube
- View the Cube Schema
- Define Cube Dimension Properties
- Define Cube Hierarchy Properties
- Define Cube Attribute Properties
- Define a Regular Relationship and Regular Relationship Properties
- Define a Referenced Relationship and Referenced Relationship Properties
- Define a Fact Relationship and Fact Relationship Properties
- Define a Many-to-Many Relationship and Many-to-Many Relationship Properties
Who should attend
Developers or Analysts creating Data Cubes
Feedback
4.8 out of 5 average
"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"
Brian Leek, Data Analyst, May 2022
“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”
Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022
