Training Class Recordings Are Available (12 Classes. Pre-Cons)
Subscribe NowAt DPS 2022, Pre-Cons were delivered (collectively called Training Classes). These were 8 hours, focused, deep-dive, demo-based virtual classroom training. Each Training Class was designed to offer intermediate & advanced-level training on a specific topic/subject. These classes offered more knowledge, skills and expertise beyond the summit content.
Recordings are now available. If you missed registering for the LIVE class, no worries, Subscribe Now to the recordings & get 12 Months On-Demand access.
ETL/ELT In The Cloud Using Data Factory
ETL/ELT In The Cloud Using Data Factory
Pre-Con Title | ETL/ELT In The Cloud Using Data Factory |
Track(s) | Data Administration |
Tags | #DataFactory #Azure #Cloud #ETL #DataWarehouse |
Level | Intermediate |
Trainer/Speaker | |
Abstract | Data Factory is a powerful member of the Azure data platform. We can build powerful ETL solutions with no code and migrate existing on-premise SSIS solutions to the cloud. Come to this full-day session to discover how it works and what you can build. This demo-packed preconference will show many different examples and scenarios illustrating common ETL/ELT challenges in an enterprise data platform. |
Modules/Topics | 1. Data Factory - Basic Concepts
2.The Flexibility of the Copy Data Activity
4. Datasets
11. PowerQuery
12. Data Factory Examples
13. Incremental Loading Data
15. Managing the Development
16. Managing Execution
17. SSIS
|
Attendee Pre-requisite (if any) | NA |
Is this class being recorded? | Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
Additional Comments from Instructor/Speaker | No special instructions/comments from the Speaker |
Additional Comments from the Organizers | The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
BooK Now |
Analytics At Scale With Power BI And Azure Synapse Analytics
Analytics at scale with Power BI and Azure Synapse Analytics
Pre-Con Title | Analytics At Scale With Power BI And Azure Synapse Analytics |
Track(s) | Business Intelligence & Advanced Analytics |
Tags | #PowerBI #AzureSynapseAnalytics |
Level | Advanced |
Trainer/Speaker | |
Abstract | This training day we will learn how Power BI and Azure Synapse Analytics can form a solid marriage, and provide a truly scalable analytical platform. Together we will explore the tricky parts of an enterprise-grade Power BI solution, and how advanced modelling capabilities of Power BI with a solid data lakehouse / warehouse in Azure Synapse Analytics can save the day! For Power BI solutions, we see it can be challenging to load data from APIs, or to store historical snapshots. This is where you can really benefit from the capabilities of a data platform. Also, if you already have an amazing data platform, we see it can be challenging to load all of its data into a Power BI dataset and still have a performant solution, or to refresh data in near real-time. Finally, daisy-chaining all the steps in the data flow – from source to report/dashboard – can be tricky to design, especially if you don’t want to do a full refresh of the Power BI dataset for performance reasons. The advanced capabilities of both worlds can really complement each other. We will train you how to design and build a solution, share our learnings and best-practices along the way in a demo-rich day. After the training you will be able to:
You will be guided by Dave Ruijter, bringing a wealth of practical experience to the table across the entire stack of Power BI and Azure Synapse Analytics. |
Modules/Topics |
|
Attendee Pre-requisite (if any) | NA |
Is this class being recorded? | Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
Additional Comments from Instructor/Speaker | NA |
Additional Comments from the Organizers | The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
Book Now |
The Performance Tuning Magic Show
The Performance Tuning Magic Show
Pre-Con Title | The Performance Tuning Magic Show |
Track(s) | Development |
Tags | #SQLServer #AzureSQL #Performance #Tuning |
Level | Intermediate |
Trainer/Speaker | |
Abstract | Welcome to the great Performance Tuning Magic Show! Come to the show and watch real magic in action. We will analyze common use cases of poorly performing queries and apply magic tricks to make them run really fast. But unlike traditional magic shows, we will learn how these magic tricks actually work. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced and practical techniques. Some examples of magic tricks we will cover: proper handling of parameter sniffing, scalar UDF inlining and T-SQL tricks. By the end of the show, you will walk away with a list of actionable performance tuning techniques, including how to identify candidate queries for each magic trick. Enjoy an interactive and entertaining magic show (and yes, I will pull a rabbit out of my hat). |
Modules/Topics |
|
Attendee Pre-requisite (if any) | NA |
Is this class being recorded? | Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
Additional Comments from Instructor/Speaker | No special instructions/comments from the Speaker |
Additional Comments from the Organizers | The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
BooK Now |
Data Modelling In Power BI – From Zero To Hero
Data Modelling in Power BI – From Zero to Hero
Pre-Con Title | Data Modelling In Power BI – From Zero To Hero |
Track(s) | Business Intelligence & Advanced Analytics |
Tags | #DataModelling, #DimensionalModelling #DAX #PowerQuery #RealWorldExamples |
Level | Advanced |
Trainer/Speaker | |
Abstract | You have collected your first experiences with Power BI and wondering why the performance of your reports is slow (even when working with a relatively small amount of source rows)? Maybe you are suffering from complicated DAX formulas (which can have their cause in non-optimal modelling)? Or you are just curious about what’s the secret behind the model view? In any case, this full-day workshop got you covered! We will start with the very basic foundation and we will work step-by-step from concepts and practical examples to real world problems and how to solve them. |
Modules/Topics |
|
Attendee Pre-requisite (if any) | NA |
Is this class being recorded? | Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
Additional Comments from Instructor/Speaker | Keep up the good community work you are doing with your events! |
Additional Comments from the Organizers | The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
Book Now |
Advanced Analytics With Transact-SQL
Advanced Analytics with Transact-SQL
Pre-Con Title | Advanced Analytics With Transact-SQL |
Track(s) | Business Intelligence & Advanced Analytics |
Tags | #TSQL #datascience #advancedanalytics #dataoverview #datapreparation |
Level | Expert |
Trainer/Speaker | |
Abstract | If you want to learn how to get information from your data with Transact-SQL, or shortly T-SQL language, then this course is the course for you. It will teach you how to calculate statistical measures from descriptive statistics including centers, spreads, skewness and kurtosis of a distribution, find the associations between pairs of variables, including calculating the linear regression formula, calculate the confidence level with definite integration, find the amount of information in your variables, and do also some machine learning or data science analysis, including predictive modeling and text mining. T-SQL language in latest editions of SQL Server, Azure SQL Database, and Azure Synapse Analytics, has so many business intelligence (BI) improvements that it might become your primary analytic database system. Many database developers and administrators are already proficient with T-SQL. Occasionally they need to analyze the data with statistical or data science methods, but they do not want to or have time to learn a completely new language for these tasks. In addition, they need to analyze huge amounts of data, where specialized languages like R and Python might not be fast enough. SQL Server has been optimized for work with big datasets for decades. In order to get the maximum out of these language constructs, you need to learn how to properly use them. This in-depth course shows extremely efficient statistical queries that use the window functions and are optimized through algorithms that use mathematical knowledge and creativity. The formulas and usage of those statistical procedures are explained as well. No analysis is good without good data quality. The course introduces data quality issues, and shows how you can check for completeness and accuracy with T-SQL, and how to measure improvements of data quality over time. And since the talk is already about the time, the course shows how you can optimize queries with temporal data, for example when you search for overlapping intervals. More advanced time-oriented information includes hazard and survival analysis. Then the course switches to the currently most fashionable topic, the data science. Some of quite advanced algorithms can also be implemented in T-SQL. The reader learns about the market basket analysis with association rules using different measures like support and confidence, and even sequential market basket analysis, when there is a sequence in the basket. Then the course shows how to develop predictive models with a mixture of k-nearest neighbor and decision trees algorithms and with Bayesian inference analysis. Analyzing text, or text mining, is another modern topic. However, many people do not realize that you can do really a lot of text mining also in pure T-SQL. SQL Server can also become a text mining engine. The course shows how to analyze text in multiple natural languages with pure T-SQL, using also features from the full-text search (FTS). |
Modules/Topics |
|
Attendee Pre-requisite (if any) | NA |
Is this class being recorded? | Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
Additional Comments from Instructor/Speaker | NA |
Additional Comments from the Organizers | The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
Book Now |
Spark For Data Engineers
Spark for Data engineers
Pre-Con Title | Spark For Data Engineers |
Track(s) | Business Intelligence & Advanced Analytics |
Tags | #spark #data #engineering #azure |
Level | Intermediate |
Trainer/Speaker | |
Abstract | Data Analysts, data Scientist, Business Intelligence analysts and many other roles require data on demand. Fighting with data silos, many scatter databases, Excel files, CSV files, JSON files, APIs and potentially different flavours of cloud storage may be tedious, nerve-wracking and time-consuming. Automated process that would follow set of steps, procedures and processes take subsets of data, columns from database, binary files and merged them together to serve business needs and potentials is and still will be a favorite job for many organizations and teams. Apache Spark™ is designed to to build faster and more reliable data pipelines, cover low level and structured API and brings tools and packages for Streaming data, Machine Learning, data engineering and building pipelines and extending the Spark ecosystem. Spark is an absolute winner for this tasks and a great choice for adoption. Data Engineering should have the extent and capability to do: - System architecture And in addition to that, it is as important as familiarity with the technical tools is, the concepts of data architecture and pipeline design are even more important. The tools are worthless without a solid conceptual understanding of: - Data models Apache Spark have all the technology built-in to cover these topics and has the capacity for achieving a concrete goal for assembling together functional systems to do the goal. |
Modules/Topics |
|
Attendee Pre-requisite (if any) | Data engineering tasks:
Technical prerequisite:
|
Target Audience | Data engineer, BI Engineer, Cloud data engineer |
Is this class being recorded? | Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
Additional Comments from Instructor/Speaker | NA |
Additional Comments from the Organizers | The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
Book Now |
SQL Server Performance Tuning And Troubleshooting
SQL Server Performance Tuning and Troubleshooting
Pre-Con Title | SQL Server Performance Tuning And Troubleshooting |
Track(s) | Data Administration |
Tags | #SQLServer #PerformanceTuning #Internals #QueryProcessor #StorageEngine #SQLOS #PerfromanceCounters #ExtendedEvents #DMVs #QueryStore #QueryPlan #QueryTuning |
Level | Advanced |
Trainer/Speaker | |
Abstract | Nothing is perfect, which means that your database maybe not perfect as well. And one day you may decide that your database is slow and it’s time to optimize it. But.. Where to start? When to end? What to look at? Which queries are slow? How to identify the real bottleneck? And so on, and so on. There are a lot of questions that should be answered in a process of performance tuning. In this workshop, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. In this way, we will learn performance tuning practical techniques and solve a bunch of issues in real time. And despite I’m a big fan of Profiler and old-fashioned tools and technics, new, more interesting and useful instruments are available nowadays, so will use them to find the bottleneck and tune performance. Minimum of theory and a lot of practice. |
Modules/Topics | 1. SQL Server Internals
2. Searching for Performance Issue Root Cause
3. Optimizing Query
|
Attendee Pre-requisite (if any) | NA |
Is this class being recorded? | Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
Additional Comments from Instructor/Speaker | NA |
Additional Comments from the Organizers | The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
Book Now | Book Now |
Cracking Power BI Performance Tuning In A Day!
Cracking Power BI Performance Tuning in a day!
Pre-Con Title | Cracking Power BI Performance Tuning In A Day! |
Track(s) | Business Intelligence & Advanced Analytics |
Tags | #PowerBI #DAX #Performance #PowerQuery #Aggregations |
Level | Advanced |
Trainer/Speaker | |
Abstract | Congratulations! You've built your shiny fancy Power BI report and your charts look terrific. But, your data refresh takes forever...Or, your report is utterly slow when interacting with visuals...You switch to DirectQuery mode to make things better, just to discover that the report performance sucks even more... And, if you feel lost, I don't blame you - I've also been there! That's why this workshop is for you: we will examine potential bottlenecks in your Power BI report - starting with defining the best practices for data model size optimization, understanding the importance of query folding feature, all the way to identifying culprits for your slow report rendering. We will wrap it up with learning when and why (not) to use DirectQuery mode, and how to apply improvements on the data source side to make things faster in the Power BI. |
Modules/Topics |
|
Attendee Pre-requisite (if any) | NA |
Is this class being recorded? | Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
Additional Comments from Instructor/Speaker | NA |
Additional Comments from the Organizers | The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
Book Now |
PowerShell DBA Dream DBATools Workshop
PowerShell DBA Dream DBATools Workshop
Pre-Con Title | PowerShell DBA Dream DBATools Workshop |
Track(s) | Data Administration |
Tags | #PowerShell #DBA |
Level | Basic |
Trainer/Speaker | |
Abstract | This full day class will take you through the most essential DBATOOLS module commands and teach you all you need to know to hit the ground running. We will go over the dbatools ecosystem and the common concepts that will help you get the most out of this module. There are over 650 commands, so we won't be going over all of them, but I will take you through the mainstream, daily use commands in the Get, Set, Test, Backup, Restore and others in the verbs in this module. Not only that but we will cover how to prepare your profile and environment to have ready variables that will assist you in quick commandline operation as well as automated running of commands. Join me in the quest for becoming a PowerShell DBA. |
Modules/Topics | 1. DBATools Ecosystem 2. Anatomy of a command in DBATools 3. Seeing DBATools in Action |
Attendee Pre-requisite (if any) | NA |
Is this class being recorded? | Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
Additional Comments from Instructor/Speaker | No special instructions/comments from the Speaker |
Additional Comments from the Organizers | The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
BooK Now |
Data Integration Best Practices In Azure Synapse Analytics
Data Integration Best Practices In Azure Synapse Analytics
Pre-Con Title | Data Integration Best Practices In Azure Synapse Analytics |
Track(s) | NA |
Tags | #Synapse |
Level | Basic |
Trainer/Speaker | |
Abstract | Azure Synapse contains the same Data Integration engine and experiences as Azure Data Factory, allowing you to create rich at-scale ETL pipelines without leaving Azure Synapse Analytics.
This training will cover the best practices when using Synapse pipelines and is targeted at a data engineer who is new to Azure/ Azure Synapse Analytics. |
Modules/Topics |
|
Attendee Pre-requisite (if any) |
|
Is this class being recorded? | Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
Additional Comments from Instructor/Speaker | No special instructions/comments from the Speaker |
Additional Comments from the Organizers | The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
BooK Now |
Query Store Deep Dive
Query Store Deep Dive
Pre-Con Title | Query Store Deep Dive |
Track(s) | Data Administration |
Tags | #QueryStore |
Level | Intermediate |
Trainer/Speaker | Milos Radivojevic |
Abstract | In this full-day workshop, you will learn to leverage Query Store to quickly identify and solve query performance issues. You’ll see and learn from many real-world examples, the author experienced in the last three years in the complex SQL Server production environment with heavy workloads. You’ll get tips for proper Query Store configuration and recommendations to reduce its impact on the production system. Plan forcing is a very powerful feature, but a bit controversial. This workshop will demystify it; you’ll see what Query Store exactly does when an execution plan is forced when it is respected, when and why isn’t, and the most important – when you have to force a plan in the production system, and when force can bring additional troubles. The next topic that will be covered in detail is automatic tuning. You will understand the benefits and potential issues you can have with this feature and how to leverage it with no or minimal risk. Finally, you’ll learn how to mitigate Query Store limitations and common issues. This workshop is a great opportunity to learn about Query Store or expand your knowledge and implement it successfully in your production system. |
Modules/Topics |
|
Attendee Pre-requisite (if any) | NA |
Is this class being recorded? | Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
Additional Comments from Instructor/Speaker | No special instructions/comments from the Speaker |
Additional Comments from the Organizers | The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
Book Now |