Tecflix

Most Popular

    How to Make Enterprise Dashboards in Excel

    Carmel Gunn is a Data Management Specialist from Prodata. Let her show you Excel as an enterprise-grade BI client in this short video, in which she builds a fully fledged enterprise dashboard—in under 30 minutes!—and then shares it with others, even on mobile devices, such as an iPad, iPhone, Android, or a Surface.

    • 4 September 2013
    • 54241 views

    MDX Basic Concepts

    MDX, or Multidimensional Expressions, has the reputation of being a difficult language, but this reputation is undeserved, even if the concepts it uses are different from those of relational databases. In this free, 29-minute video, part of our series on MDX, world-renowned SQL Server Analysis Services expert Chris Webb introduces three basic concepts: the use of unique names to refer to objects, tuples and how they are used to return values from a cube, and sets, which are ordered lists. Understanding these ideas will give you the theoretical foundation you need to write your own MDX calculations, and queries, for SSAS and PowerPivot.

    • 26 October 2012
    • 41261 views

    What is the MDX Current Member Function?

    The CurrentMember function is, probably, the most important function in MDX: understanding how it works is the key to being able to write all kinds of really useful calculations in MDX, such as time intelligence calculations. Let Chris Webb, noted authority on MDX, explain this function to you in this short, free video.

    • 31 January 2014
    • 19705 views

    MDX Queries

    /knowledge/mdx-calculated-members-video-tutorial-multidimensional-expressionsIn most cases an MDX SELECT statement is used to retrieve data from a SQL Server Analysis Services cube. Let Chris Webb introduce this important statement to you in this 20-minute video.

    • 4 December 2013
    • 11419 views

    MDX Calculated Members

    Calculated members are the most commonly used way of performing calculations in MDX. Let Chris Webb explain the different ways in which they can be created in this 45-minute video, part of our online MDX course.

    • 4 December 2013
    • 9738 views

    MDX Numeric Functions and CURRENTMEMBER

    There are a number of important functions in MDX that return numeric values. Chris Webb explains these in this 30-minute, demo-driven tutorial, focusing on Sum(), Count(), Aggregate(), and other numeric functions like Min(), Max(), and Avg(). Importantly, however, half of this video is dedicated to the most important MDX function, CurrentMember, which is essential to writing real-world calculations, such as time intelligence.

    • 31 January 2014
    • 7019 views

    What is a Subselect in MDX?

    Chris Webb introduces the subselect in this short 3-min video. It uses an MDX SELECT statement instead of a cube’s name, and it allows you to pre-filter the members on a hierarchy before you run a query.

    • 2 April 2014
    • 6596 views

    MDX: Member and Set Functions

    Being able to think in sets is the key to being able to write more advanced queries and calculations in MDX. Chris Webb introduces the commonest MDX functions that return sets in this 40-minute, demo-driven video, including: .MEMBERS, CROSSJOIN(), .PARENT, DESCENDANTS( ), ANCESTOR(), .NEXTMEMBER, .PREVMEMBER, .LEAD() and .LAG(). You will need these functions for rudimentary navigation using MDX.

    • 18 December 2013
    • 5141 views

    Excel BI: Basic Concepts

    Carmel Gunn, a Data Management Specialist from Prodata introduces fundamental concepts of Excel BI: measures, dimensions, attributes, and hierarchies, while explaining how to use them in your pivot tables. In the extensive, 30-min demo, you will also learn about the layout of the Excel BI tools, including the Pivot Table Fields List and its Fields Section, the Design ribbon, and even how to add a new calculated measure.

    • 4 September 2013
    • 4578 views

    Exists, MDX Solve Order, and Subselects

    This 50-min video, part of our MDX course, by Chris Webb, covers three separate, advanced MDX topics: autoexists and the Exists() function and the Existing operator, solve order, and subselects. Not only does Chris carefully explain these important topics, but he also takes time to show everything in his detailed, live demos, discussing the code, and the results.

    • 2 April 2014
    • 4016 views

    More MDX Member & Set Functions

    MDX has a lot of set and member functions that make it easy to create all kinds of advanced common business calculations. Watch this full-length, 1-hour 40-minute, demo-rich video by Chris Webb to learn how to compute important business reporting metrics using MDX. You will learn about: ParallelPeriod(), PeriodsToDate(), YTD(), QTD(), MTD(), Filter(), NonEmpty(), TopCount(), BottomCount(), TopPercent(), BottomPercent(), Head(), Tail(), Generate(), StrToX/XToStr function family.

    • 25 February 2014
    • 3643 views

    MDX: Previous Period Growths, Shares & Moving Averages

    In this 40-minute video by Chris Webb you will see common business calculations implemented in MDX: the relative tuple pattern, used for previous period growth calculations, percentage share calculations, and the relative set pattern, used for obtaining three-period moving averages.

    • 24 February 2014
    • 3107 views

    MDX Performance Diagnosis with Profiler

    Watch this 30-minute video by Chris Webb to learn the steps necessary to use the SQL Server Profiler to identify performance problems in your MDX queries, and to learn about the interaction between the SSAS Formula Engine and its Storage Engine, focusing on the useful Profiler events, including Query Subcube Verbose.

    • 19 May 2014
    • 2055 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
    • 1393 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
    • 1237 views
    In collaboration with
    Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo