Cube Design training course

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

JBI training course London UK

"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

Public Courses

03/08/26 - 2 days
£1295 +VAT
Enrol 
14/09/26 - 2 days
£1295 +VAT
Enrol 
26/10/26 - 2 days
£1295 +VAT
Enrol 

Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day
EDF logo Capita logo Sky logo NHS logo RBS logo BBC logo CISCO logo
JBI training course London UK
  • 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

JBI training course London UK

Developers or Analysts creating Data Cubes

 

5 star

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

 

 

JBI training course London UK

Certification


Every delegate will be entitled to a certificate of achievement on completion of the course.

If you are missing your certificate - please use the link below to apply - you can also use this link to sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.
 



More about this course

This training course is led by industry experts who will show you how to build robust, industry-strength data cubes to efficiently access your corporate data.

An SSAS cube is a type of multidimensional matrix that lets users explore and analyse a collection of data from many different perspectives. 

The main constituents of a cube are dimensions and measures. Dimensions define the structure of the cube that you use to slice and dice over, and measures provide aggregated numerical values of interest to the end-user.

As a logical structure, a cube allows you to retrieve values (or measures) as if they were contained in cells in the cube, where the cells are defined for every possible summarised value. A cell in the cube is defined by the intersection of dimension members and contains the aggregated values of the measures at that specific intersection.

FAQs

JBI Training offers five courses in this group covering the Microsoft SQL Server BI stack and Oracle Business Intelligence. Available courses are Microsoft Business Intelligence 2016 (five days), SQL Server Analysis and Integration Services — SSAS and SSIS (three days), SQL Server Reporting Services — SSRS (two days), Oracle OBIEE (four days), and Cube Design (two days). All courses are available as scheduled classroom sessions in London, as live online instructor-led training, or as customised onsite programmes for BI and data teams.
The Microsoft Business Intelligence 2016 course is a comprehensive five-day programme covering the full Microsoft SQL Server BI stack. It covers SQL Server Integration Services (SSIS) for data extraction, transformation, and loading; SQL Server Analysis Services (SSAS) for building multidimensional and tabular data models; SQL Server Reporting Services (SSRS) for creating and distributing reports; and DAX and MDX for analytical querying. It is suited to BI developers, data warehouse developers, and reporting professionals who need a thorough end-to-end understanding of the Microsoft BI platform for building enterprise reporting and analytics solutions on SQL Server.
SQL Server Analysis Services (SSAS) is Microsoft's online analytical processing (OLAP) and data mining engine, used to build multidimensional cubes and tabular data models that serve as the analytical layer for business intelligence solutions. SQL Server Integration Services (SSIS) is Microsoft's ETL tool for extracting, transforming, and loading data from source systems into data warehouses and analytical models. JBI's three-day SQL Server Analysis and Integration Services course covers both components — SSIS pipeline design, transformations, and deployment, alongside SSAS multidimensional and tabular model design, MDX querying, and KPI and calculation development. It is suited to BI developers and data warehouse engineers working within the Microsoft SQL Server ecosystem.
The two-day SQL Server Reporting Services course covers Microsoft's enterprise reporting platform for creating, managing, and distributing structured reports from SQL Server and other data sources. Topics include the Report Designer and Report Builder environments, creating tabular and matrix reports, working with parameters and filters, using expressions for dynamic report content, embedding charts and data visualisations within reports, creating drillthrough and linked reports, scheduling and subscription-based report delivery, and deploying and managing reports on the SSRS Report Server. It is suited to report developers, BI developers, and business analysts who need to build and manage enterprise reports within a Microsoft SQL Server environment.
Oracle Business Intelligence Enterprise Edition (OBIEE) is Oracle's enterprise business intelligence platform for building interactive dashboards, ad hoc queries, and analytical reports from Oracle and other data sources. It uses a three-tier architecture consisting of the Oracle BI Repository (which defines the business model and data mappings), the Oracle BI Server (which handles query processing and caching), and the Oracle BI Presentation Services (which delivers interactive reports and dashboards to users). JBI's four-day Oracle OBIEE course covers the full OBIEE development workflow — including building the physical, business model, and presentation layers of the repository, creating answers and dashboards, working with prompts and filters, and building KPIs and scorecards. It is suited to BI developers and report authors working in Oracle-based environments.
A data cube (also known as an OLAP cube) is a multidimensional data structure that organises data along multiple dimensions — such as time, geography, product, and department — enabling fast, flexible analytical queries and aggregations across large datasets. It is a foundational concept in business intelligence and data warehousing. JBI's two-day Cube Design course covers the principles of multidimensional modelling, dimension and measure design, hierarchy design, the role of cubes in a BI architecture, and practical cube design considerations for performance and usability. It is suited to BI architects, data warehouse developers, and senior analysts who design or work with multidimensional analytical models.
The traditional Microsoft BI stack — consisting of SSIS, SSAS, and SSRS running on SQL Server — has been the backbone of enterprise Microsoft reporting and analytics for many organisations for over two decades. Power BI, which was introduced later, uses many of the same underlying technologies — particularly the SSAS Tabular engine for its data model and DAX for calculations — but delivers them through a modern, cloud-friendly, self-service interface. Microsoft Fabric represents the next evolution of the Microsoft data platform, bringing together data engineering, warehousing, and analytics in a unified SaaS environment. Organisations with existing SQL Server BI investments are not required to migrate immediately, but understanding both the traditional stack and the modern Microsoft data platform helps teams make informed architectural decisions about where to invest and how to evolve their reporting infrastructure over time.

CONTACT
+44 (0)20 8446 7555

[email protected]

 

Copyright © 2026 JBI Training. All Rights Reserved.
JB International Training Ltd  -  Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us

POPULAR

AI training courses                                                                        CoPilot training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Data Storytelling training course                                               C++ training course

Power Automate training course                               Clean Code training course