Dismiss

Cube Design training course

Design SSAS Multi Dimensional Cubes - Ensure Meaningful, Efficient Access To Your Corporate Data

"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

Highlights Details Audience Feedback Prices/Dates

TAILOR-MADE
Enquire & get a quote

PUBLIC COURSES
Next on 4 Jul - see prices

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

Brian Leek, Data Analyst, May 2022

Enquiries & Bookings

Live courses - face-to-face or remote

PUBLIC COURSES

4 Jul 2022 - 2 days

£1295 +VAT

ENROL

ENQUIRE

15 Aug 2022 - 2 days

SEE PRICES £1295 +VAT

ENROL

ENQUIRE

26 Sep 2022 - 2 days

£1295 +VAT

ENROL

ENQUIRE

TAILOR-MADE COURSES

* Train your entire team
* Tailored course content & duration
* Free taster sessions

GET A QUOTE

Microsoft Business Intelligence 2016

SQL Server Analysis & Int Services

SQL Server Reporting Services

Top 20 "Pain Points" for Data Analysts

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

All 20 points are in our latest Newsletter - Delivered directly to your inbox