Project Botticelli

Most Popular

Multidimensional Analysis with Microsoft Excel and SQL Server

Multidimensional Analysis with Microsoft Excel and SQL Server

For most people, the easiest tool for opening and navigating a multidimensional (OLAP) cube is Microsoft Excel. In this short demo you can also see how to perform basic slice-and-dice analysis, drill into and filter using dimensions, and summarise trends with a sparkline.

Aggregations & Cube Performance

Chris Webb shows aggregation designer and its impact on cube performance

In this final, 1-hour video of our SSAS cube design course, Chris Webb tackles the goal we all aspire to: performance, which is directly under your control when you build aggregations. You will learn about different ways to build and tune them, and how to validate if they are actually providing any benefits to your queries. You will also find out how to balance performance goals achieved while querying with any degradation of cube processing time. As usual, you will see plenty of detailed demos, even focusing on the minutiae of such aggregation design concerns as many-to-many relationships, semi-additive measures, partitioning strategies, parent-child hierarchies and MDX calculations.

Irish Economic Crisis Visualised in Power BI

Where Did Ireland Get The Money From?

Carmel Gunn and Bob Duffy explore the Irish Economic Crisis using Power Query, Power Map, Power View and Q&A in this 40-min video. Could Power BI prevent a small country run a shocking €200bn debt?

Using the Deployment Wizard

Chris Webb Shows How to Deploy a Cube Using the Wizard

Let Chris Webb, book author and a world-renowned expert on SQL Server Analysis Services (SSAS) introduce you to the world of practical cube design with this short, 5-minute video, which demonstrates how to use the SSAS Deployment Wizard. This tutorial is part of our cube design course.

Designing Dimensions

Chris shows an attribute hierarchy of a time dimension

Let Chris Webb explain to you how to build dimensions: one of the foundations of multidimensional cube design, in this 1-hour video. You will also learn the concept of attributes, and their relationships, parent/child and ragged hierarchies, data aggregation, and Date dimensions.

Using SQL Server Data Tools-BI

Chris Webb Explains the Data Source Wizard in SSDT-BI

SQL Server Data Tools-BI (SSDT-BI, previously called BI Development Studio or BIDS) is the name for the Visual Studio templates used for building SQL Server Analysis Services projects, which are fully introduced in this 40-minute video by Chris Webb, expert on all things SSAS. You will learn how to create an SSDT-BI project, set its properties, connect to relational data such as a data warehouse, and how to create Data Source Views (DSVs).

Cubes, Measures and Measure Groups

Chris Webb shows Dimension-Measure Relationships and Measure Groups

Following on from the module on designing dimensions, Chris Webb teaches how to build cubes, measures, and measure groups, in this 1-hour 10-minute, in-depth, hands-on tutorial. You will also learn about various dimension-measure relationships, measure expressions, Distinct Counts, semi-additive aggregations, important properties such as FormatString, actions, like a drill down, perspectives and translations.

Cube Deployment, Processing and Admin

Chris introduces cube processing strategies

This 30-minute video by Chris Webb discusses the operational side of cubes: deployment, processing, backup and restore, synchronization, and scripting.

Cube Security

Chris explains how to create dynamic cube security

In this 30-minute video, part of our Cube Design series, Chris Webb explains SQL Server Analysis Services security. You will learn about administrative and data security, the latter on three levels: at cube, dimension hierarchy, and at cell levels.

Online Courses