Courses

  • SSIS: The Data Flows Part 2

    by Andy Leonard
    5 Lessons
    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
      per member
    • SSIS: The Data Flows Part 2 - $99.00
      • EUR: €91.14
      • GBP: £77.56
      • NZD: $161.17
      • CAD: $135.07
      • AUD: $148.79

    SSIS Data Flows Part 2 builds on SSIS Data Flows Part 1 by adding a correlating Lookup and subsequent Conditional Split transformations to prevent data re-loading, or loading duplicates. This addition introduces the first order of an Incremental Load SSIS design pattern that Andy calls “Forward-Only Incremental Load.”

  • Scripting in SSIS

    by Andy Leonard
    2 Lessons
    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
      per member
    • Scripting in SSIS - $99.00
      • EUR: €91.14
      • GBP: £77.56
      • NZD: $161.17
      • CAD: $135.07
      • AUD: $148.79

    SSIS Scripting demonstrates the SSIS Script Task and the SSIS Data Flow Task’s Script Component, and includes .Net scripting basics in C# and Visual Basic. Andy shares templates for raising Information and Error events.

  • Data Science with SQL Server (and Azure SQL Database)

    by Dejan Sarka
    48 Lessons
    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
      per member
    • Data Science with SQL Server (and Azure SQL Database) - $259.00
      • EUR: €238.44
      • GBP: £202.92
      • NZD: $421.65
      • CAD: $353.37
      • AUD: $389.27

    This course teaches you how to start doing data science with Microsoft SQL Server (and Azure SQL Database) using the in-database Machine Learning Services (ML Services). During the course, you will learn about all stages of a real-life data science project, starting with business and data understanding, continuing with data overview and data preparation, and […]

    Preview this course - (1 preview lessons)

  • SSIS: The Data Flows Part 1

    by Andy Leonard
    5 Lessons
    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
      per member
    • SSIS: The Data Flows Part 1 - $99.00
      • EUR: €91.14
      • GBP: £77.56
      • NZD: $161.17
      • CAD: $135.07
      • AUD: $148.79

    Because Andy Leonard believes you learn best by doing, the first SSIS Data Flows course lecture demonstrates how to create an SSIS project and build your very first data flow task that includes a Flat File Source Adapter and Flat File Connection Manager to read data from a real-world source file (for http://andyweather.com) and write.

  • Power Apps 101 Getting started with building Apps

    by Reza Dorrani
    26 Lessons
    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
      per member
    • Power Apps 101 – Let’s get started with building Apps - $259.95
      • EUR: €239.31
      • GBP: £203.67
      • NZD: $423.20
      • CAD: $354.67
      • AUD: $390.70

    This course delivers an instructor-led training experience for Microsoft Power Apps. This course will provide students the fundamentals required to get started with Power Apps. Students will learn how to design, build and publish Apps integrated with multiple data sources. 

    Preview this course - (1 preview lessons)

  • AI Visuals in Power BI

    by Leila Etaati
    11 Lessons
    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
      per member
    • Video Training: AI Visuals in Power BI - $199.95
      • EUR: €184.07
      • GBP: £156.66
      • NZD: $325.52
      • CAD: $272.80
      • AUD: $300.52

    Using AI is a norm these days. There is a possibility in most of Microsoft products to use AI or ML in their tools. Microsoft Power BI is one of the hottest self-service BI products. In this course, you will learn how to use some of the Power BI visuals for the aim of advanced […]

    Preview this course - (1 preview lessons)

  • DIFINITY 2020 Conference Sessions Recording

    by Reza Rad
    65 Lessons
    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
      per member
    • Difinity Conference 2020 Sessions Recordings - $79.00
      • EUR: €72.73
      • GBP: £61.89
      • NZD: $128.61
      • CAD: $107.78
      • AUD: $118.73

    Difinity 2020 Conference happened in New Zealand with over 50 speakers and 65 sessions. Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand focusing on Data Platform, AI, Business Intelligence, Business Applications, Power Platform, and Analytics. IT Decision Makers, Developers, Business Analysts, IT Professionals, BI Managers, […]

  • Building Smart Applications Using AI Builder

    by Leila Etaati
    16 Lessons
    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
      per member
    • Video Training: Building Smart Applications Using AI Builder - $259.95
      • EUR: €239.31
      • GBP: £203.67
      • NZD: $423.20
      • CAD: $354.67
      • AUD: $390.70

    Preview this course - (1 preview lessons)

  • DAX and Calculations in Power BI

    by Reza Rad
    40 Lessons
    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
      per member
    • Video Training: DAX and Calculations in Power BI - $259.95
      • EUR: €239.31
      • GBP: £203.67
      • NZD: $423.20
      • CAD: $354.67
      • AUD: $390.70

    This course is part of the Power BI from Rookie to Rock Star Training. This training is designed for data modelers, who have the data prepared to be modeled for analysis. Usually, people who take this course need to also take the Power Query video course to learn about the step before the modeling. In […]

    Preview this course - (1 preview lessons)

  • AI Applications with Power Platform

    by Leila Etaati
    20 Lessons
    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.11
      • GBP: £38.39
      • NZD: $79.77
      • CAD: $66.85
      • AUD: $73.65
      per member
    • Video Training: AI Applications with Power Platform - $259.95
      • EUR: €239.31
      • GBP: £203.67
      • NZD: $423.20
      • CAD: $354.67
      • AUD: $390.70

    Description of the course Using AI is a norm these days. There is a possibility in most of Microsoft product t use AI or ML in their tools. Power platform (Microsoft Power BI, Power Apps, and Microsoft Flow) is one of the hottest topics. In this course, you will learn how to create a smart […]

    Preview this course - (1 preview lessons)