Tecflix

Browse our courses

    Mastering DAX Workshop (2nd Ed)

    Loading the video player...

    If this message stays on please ensure you are using a supported browser with JavaScript enabled.

    See our device support page.

    Watch 1-min Overview

    32 Modules

    26-hour 7-min

    This 2nd edition of the DAX language workshop will teach you how to master data analytics formulas used in Power BI and Analysis Services.

    Learn more

    • Introduction to Mastering DAX 2nd Edition 5-min Free—Watch Now

    • Introduction to DAX 1-hour 46-min Watch with Free Subscription

    • Exercises, Labs, Demos, and Presentation Slides 52-min

    • Exercises for: Introduction to DAX 52-min Watch with Free Subscription

    • Table Functions 1-hour 9-min

    • Exercises for: Table Functions 44-min

    • Evaluation Contexts 57-min

    • Exercises for: Evaluation Contexts 29-min

    • The CALCULATE Function 1-hour 4-min

    • Exercises for: The CALCULATE Function 49-min

    • Advanced Evaluation Contexts 56-min

    • Exercises for: Advanced Evaluation Contexts 1-hour 5-min

    • Iterators 41-min

    • Exercises for: Iterators 39-min

    • Building a Date Table 37-min

    • Time Intelligence in DAX 1-hour 20-min

    • Exercises for: Time Intelligence in DAX 46-min

    • Hierarchies in DAX 37-min

    • Querying with DAX 1-hour 58-min

    • Exercises for: Querying with DAX 47-min

    • Data Lineage and TREATAS 13-min

    • Expanded Tables 34-min

    • Exercises for: Expanded Tables 15-min

    • Segmentation 36-min

    • Exercises for: Segmentation 14-min

    • Many-to-many Relationships 35-min

    • Exercises for: Many-to-Many Relationships 13-min

    • Advanced Filtering 49-min

    • Relationships at Different Granularities 1-hour 20-min

    • Additional Exercises 27-min

    • Calculation Groups 1-hour 27-min

    • Exercises for: Calculation Groups 57-min

    Power BI

    Loading the video player...

    If this message stays on please ensure you are using a supported browser with JavaScript enabled.

    See our device support page.

    Watch 1-min Overview

    22 Modules

    13-hour 1-min

    Learn Power BI with Chris Webb, world analytics expert and author of many books on the subject, who will teach you everything you need to know about it.

    Learn more

    • Power BI New Features and Course Updates 1-min Free—Watch Now

    • What is Power BI? 59-min Watch with Free Subscription

    • Licensing 8-min

    • Connecting to Data Sources 42-min

    • Connecting to Data Sources (2018 Updates) 23-min

    • Data Import Concepts 55-min

    • Transforming Data with the Query Editor 1-hour 20-min

    • Transforming Data with the Query Editor (2018 Updates) 13-min

    • Advanced Data Loading 49-min

    • Modelling Data 1-hour 10-min

    • Modelling Data (2018 Updates) 14-min

    • DAX and the Data Model 31-min

    • DAX and the Data Model (2018 Updates) 10-min

    • Power BI Desktop vs Excel 37-min

    • Cloud and Desktop Power BI Dashboards and Reports 45-min

    • Power BI Reports (2018 Updates) 40-min

    • Building Reports in Excel 32-min

    • Sharing, Distribution, and Security 42-min

    • Data Refresh 8-min Free—Watch Now

    • Administration and Auditing 11-min Watch with Free Subscription

    • Azure Analysis Services 1-hour 3-min

    • Power BI Premium and Power BI Embedded 36-min Watch with Free Subscription

    The Future Series (2019)

    Loading the video player...

    If this message stays on please ensure you are using a supported browser with JavaScript enabled.

    See our device support page.

    Watch 1-min Overview

    8 Modules

    5-hour 36-min

    Is AI, advanced analytics, BI, data and knowledge mining, data science, security, or machine learning relevant to your work? This series discusses the key industry trends that affect all decision makers.

    Learn more

    MDX: Multidimensional Expressions

    Loading the video player...

    If this message stays on please ensure you are using a supported browser with JavaScript enabled.

    See our device support page.

    Watch 1-min Overview

    11 Modules

    6-hour 42-min

    Multidimensional Expressions (MDX), the original language of cubes, is still the industry standard for OLAP (Online Analytical Processing) calculations, cube querying, and reporting, especially in finance and retail.

    Learn more

    • MDX Basic Concepts 29-min Watch with Free Subscription

    • MDX Queries 24-min Watch with Free Subscription

    • MDX Calculated Members 52-min

    • MDX: Member and Set Functions 38-min

    • What is the MDX Current Member Function? 5-min Free—Watch Now

    • MDX Numeric Functions and CURRENTMEMBER 33-min

    • MDX: Previous Period Growths, Shares & Moving Averages 38-min

    • More MDX Member & Set Functions 1-hour 37-min

    • What is a Subselect in MDX? 3-min Watch with Free Subscription

    • Exists, MDX Solve Order, and Subselects 49-min

    • MDX Performance Diagnosis with Profiler 29-min

    SSAS Cubes

    Loading the video player...

    If this message stays on please ensure you are using a supported browser with JavaScript enabled.

    See our device support page.

    Watch 1-min Overview

    7 Modules

    5-hour 6-min

    Learning multidimensional cubes, also known as OLAP (Online Analytical Processing) will give you a powerful method for analysing complex, hierarchical, time-based enterprise data.

    Learn more

    • Using the Deployment Wizard 5-min Watch with Free Subscription

    • Using SQL Server Data Tools-BI 40-min

    • Designing Dimensions 1-hour 4-min

    • Cubes, Measures and Measure Groups 1-hour 10-min

    • Cube Security 30-min

    • Cube Deployment, Processing and Admin 36-min

    • Aggregations & Cube Performance 57-min

    Data Mining with SQL Server SSAS

    Loading the video player...

    If this message stays on please ensure you are using a supported browser with JavaScript enabled.

    See our device support page.

    Watch 1-min Overview

    11 Modules

    8-hour 25-min

    Study the fundamentals of Data Mining with SQL Server Analysis Services, an older, highly visual technology, well suited to learning.

    Learn more

    • Introduction to Data Mining with Microsoft SQL Server 24-min Watch with Free Subscription

    • Data Mining Concepts and Tools 50-min

    • Data Mining Model Building, Testing and Predicting with Microsoft SQL Server and Excel 1-hour 20-min

    • What Are Decision Trees? 10-min Free—Watch Now

    • Decision Trees in Depth 1-hour 54-min

    • Why Cluster and Segment Data? 9-min Watch with Free Subscription

    • Clustering in Depth 1-hour 50-min

    • What is Market Basket Analysis? 10-min Watch with Free Subscription

    • Association Rules in Depth 1-hour 35-min

    • HappyCars Sample Data Set for Learning Data Mining

    • Additional Code and Data Samples (R, ML Services, SSAS) Get with Free Subscription

    Excel BI for Enterprises

    Loading the video player...

    If this message stays on please ensure you are using a supported browser with JavaScript enabled.

    See our device support page.

    Watch 1-min Overview

    3 Modules

    1-hour 52-min

    Excel is more than a spreadsheet—it is a great tool for exploring, preparing, dashboarding and analysing corporate data, especially if you work with analytical cubes.

    Learn more

    • How to Make Enterprise Dashboards in Excel 29-min Watch with Free Subscription

    • Excel BI: Basic Concepts 34-min

    • Selecting, Filtering, and Sorting Data in Excel 47-min

    In collaboration with
    Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo