Tecflix

Latest Content

    Aggregations & 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.

    • 31 October 2015
    • 5518 views

    Cube Deployment, Processing and Admin

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

    • 10 September 2015
    • 1380 views

    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.

    • 17 July 2015
    • 1233 views

    Cubes, Measures 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.

    • 30 April 2015
    • 1774 views

    Designing Dimensions

    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.

    • 30 March 2015
    • 2179 views

    Irish Economic Crisis Visualised in Power BI

    Irish Economic Post-2008 Crisis

    Carmel Gunn and Bob Duffy explored the past Irish Economic Crisis using Power Query, Power Map, Power View and Q&A in this 40-min video which won a number of accolades at the time. Could Power BI have prevented a small country run a shocking €200bn debt?

    Using the Deployment 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.

    • 26 February 2015
    • 2568 views

    Using SQL Server Data Tools-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).

    • 26 February 2015
    • 2033 views
    In collaboration with
    Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo