Pragmatic Works offers a wide variety of training webinars, boot camps, workshops and on-demand training to fit into your busy schedule.
Whether you’re just starting out on your BI journey or looking to master your skills, we have the training and resources to meet all your needs.
Learn some fun and effective ways to turn your Power BI report into a more compelling digital narrative by leveraging Power BI’s storytelling cap...
Join Mitchell in this demo filled session and explore the new preview features now available in ADF v2.
This in-depth course takes a deep dive into building end-to-end Power BI Solutions including one day reserved for building dashboard on your own da...
This half-day workshop dives deep into advanced design patterns required for telling stories in Power BI.
The Data Science course goes in-depth within the data science and machine learning process.
At the end of this course you will be proficient in designing, publishing, and applying security to KPIs, dashboards and mobile reports in SSRS 201...
SharePoint training provides an in-depth introduction to topics like creating and deploying Reporting Services in SharePoint, creating dashboards i...
This course designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server develo...
Big Data is a new and complex ecosystem of technologies that can revolutionize the way your business acquires, processes and manages data.
Become a power user by learning Excel, Power Pivot, Power Query, Power View and Power Map.
Get our 7 Power BI courses plus a bonus course in an easy-to-use pack format!
Become a Power User by learning Excel, Power Pivot, Power Query, Power View and Power Map.
Get our 3 Excel courses guaranteed to help you master the world's most popular software!
Setup, configure and learn about High Availability techniques for your environment. This class will provide guidance on the different HA technologi...
The Introduction to DAX course is designed to teach the fundamentals of DAX while emphasizing the basic building blocks required to author more com...
In this class you will learn why testing is important and how LegiTest can be used to automate the testing process for your solutions.
This course teaches you the fundamental skills you need to develop and deploy SSAS solutions and present this new data to your end users.
Learn how hardware and software operate together so you can better understand what your systems can actually achieve and how to configure them prop...
Get in-depth instruction on Power BI Custom Visuals. Available with Elite Package purchase only.
The SQL Server Performance Tuning course is designed to provide SQL DBA’s with the tools and knowledge that is required to keep their SQL Servers r...
This course covers two separate modeling techniques, transactional systems and dimensional modeling.
The Art & Science of Excel Modeling course is an in-depth exploration of how to plan, design, and maintain robust, efficient business-operational m...
Power BI Administration provides the framework necessary to successfully integrate Power BI into your corporate environment.
This pack includes 6 courses dedicated towards DBAs.
The Power BI for Consumers course is designed to get you up to speed on consuming data and interacting with reports in Power BI.
Introduction to Tabular is an intensive course that is designed to get you up to speed using Analysis Services Tabular quickly and efficiently.
Leverage and understand how to build Tier 1 Analysis Services solutions while utilizing them in your platform for daily use.
Pragmatic Workbench Training gives users an extensive look at every feature our software suite has to offer.
Building Business Intelligence with Pivot Tables is an online video course that is perfect for anyone looking to build reports and quickly summariz...
Advanced Querying with T-SQL is an intensive course designed specifically for SQL developers.
This course gives a step-by-step overview of SQL Server and will review installing SQL Server.
This course is designed to help you understand all aspects of SQL Server Integration Services (SSIS), the ETL tool of choice for SQL Server users. ...
This course is designed to take you to the next level in your understanding of SQL Server Reporting Services (SSRS).
The Advanced DAX course is designed to build on the fundamentals taught in the Introduction to DAX course.
This course is for data analysts, data wranglers, spreadsheet developers and managers looking to design work for decision makers.
Learn how to use MDX for use with SSAS in your enterprise.
The Introduction to T-SQL course is designed to get you developing with T-SQL very quickly. You will first learn about the structure of a SQL Serve...
This course teaches you the fundamentals of Tableau and is helpful for anyone who works with data no matter their technical background.
For the SSIS user looking to become a more effective and advanced ETL developer, this course will teach you how to use SSIS in your enterprise to s...
Understand how Power Query can be used for self-service data extraction and manipulation.
This pack includes 16 courses designed to jump-start your BI journey.
In this session we will explore creating streaming datasets in Power BI using Microsoft Flow and ways to enhance the capabilities of Power BI whil...
In this Ask Me Anything style session get all of your questions answered on how to maintain your Power BI ecosystem.
Join Daniel as he guides you on how to optimize productivity and connectivity across the multitude of business services through Microsoft Flow.
Join Devin as he guides you on how to create a New App in PowerApps and automate additional workflow functionality through Microsoft Flow.
Devin Knight and Brian Knight will share their advice and top tips to setting an achievable learning path in 2019. They will also answer your ques...
This webinar will discuss R and Python integration with SQL Server. We also be discussing how to build and execute a predictive model with R in SQ...
This webinar will help guide you on how to create a re-usable data source with a new feature of Power BI called Dataflows.
This webinar will cover how having a Data Governance framework in place will support and fortify your efforts to becoming a Data Driven organizatio...
This webinar will cover using Logic Apps to add notification capability to a data integration solution using Azure Data Factory pipelines to send e...
This session will help you connect your clients to their data whether on premise or in the cloud, giving them access to real-time information all ...
Join Steve Hughes as he takes a look at our organization's move from primarily an on-premises solution company to a cloud solution company.
In this session, you will get an in-depth tour of Devin's top 5 favorite custom visuals and when to use these visual. You will also learn how to b...
In this session you will learn some of the basics on DAX in Power BI. What is the calculate function and how do you use it? When should you write M...
In this session, you will learn how to promote self-service by leveraging data assets you already have to increase your business’ consumable data b...
In this session, we will show you how to get started using Azure Machine Learning by guiding you through the steps to prepare data for use by an Az...
In this webinar, Brian Knight will guide you on how to consume data from a variety of sources and integrate the data with machine learning to predi...
In this webinar, Brian Knight will guide on how to create your first application using PowerApp.
In this webinar, we will be looking at Azure Machine Learning Studio and how it is used to create a predictive model.
In this release announcement, the authors will answer questions about the book and key highlights you’ll want to know.
In this webinar, you’ll learn how to create your first application using PowerApps. PowerApps is part of the Power Platform from Microsoft and prov...
In this webinar, you will learn more about Microsoft’s differentiated approach to shaping the Data Estate conversation with customers
In this webinar we are going to cover how to use the various activities available in Azure Data Factory and as a bonus we are going to discuss how ...
In this webinar we will explore utilizing maps to their full potential in Power BI. We will be going over many different mapping tools we have at o...
In this webinar, Brian Knight, Mitchell Pearson and Devin Knight will discuss common Power BI questions using real-time demos. There will also be ...
In this webinar, learn how to discuss leveraging Azure for disaster recovery and business continuity is the most effective way to ensure you're pr...
In this webinar you are going to learn how you can use SSIS, a tool you’re already familiar with, to interact with common resources in Azure like ...
In this webinar, learn how to fully demonstrate your skills in the Power BI Desktop’s Query Editor, as well as learning how to utilize M.
In this webinar, we will help navigate you through the latest updates from Power BI and share which features you should be using in your environme...
In this webinar, we will go beyond the basics and show how R can enable you to perform tasks that are not available in native Power BI.
In this webinar you will learn why DAX can sometimes produce unexpected results. You will have a better understanding of why the total row may not...
Join us in this extraordinary session, you will learn the how to spice up your Power BI. Some topics will be discussing are: Templates, Themes, In...
Join us for this demo-heavy session to learn the required steps for creating a Power BI Custom Visual using R.
Come to this free session to discover about true hybrid cloud deployment, based on the four key pillars: Identity, security, data platform and dev...
This 3-part session will eliminate confusion around GDPR, discuss the steps you need to take to be in compliance and guide you on how to make your...
This session will walk through the major features of Azure Data Factory V2 including creating the environment, authoring your first pipeline, sche...
In this introductory to DAX session, you will learn the basics using the DAX language to create calculated columns and calculated measures.
This introductory-level demonstration will show you the basics of SSIS, including control and data flows, sources and destinations.
In this session, we'll compare and contrast common functionality and options (including demos) for different Azure SQL services.
In this session, you will learn time-saving techniques within the Pragmatic Workbench that can protect your servers, databases, and tables.
In this session, we will guide you through what you might have missed over the last few Power BI Desktop updates.
In this 30-minute session, you’ll learn how to make SSIS run up to 3000% faster and discover ways to simplify and accelerate your SSIS development ...
In this session, we will address common questions and concerns about rolling out the Power BI Service to your organization.
In this session, you will learn how to use the power of windowing functions, how they work, pitfalls and some examples of where they come in handy....
In this session, learn from SQL Server Chef John Welch as he demonstrates how some simple data testing recipes can improve the quality of your prod...
In this session, we will start from the beginning and answer the big questions around what Azure SQL DB is, how you use it, how to monitor cost, an...
In this session, you’ll learn how to reduce testing time with this month’s new LegiTest recipes feature.
In this session, you'll learn how to use data lakes to support your data science and data warehouses.
In this session, we will walk through the architecture and components of creating an Azure facing video processing application that can scan videos...
In this session, you will learn how to migrate to the cloud through a 3-step process that embeds security, compliance and cost control in every st...
In this session, you will learn how to standardize your customer list of addresses, saving you money on postage and undeliverable items.
Join this session to learn how to set up SSIS in Azure, move your existing SSIS packages, and execute packages from the cloud.
The purpose of this presentation is to outline a solution using SSIS, T-SQL, and PowerBI to locate and analyze the PII information stored in a SQL ...
In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easie...
In this session, you'll find out how to build your own framework or use a professional 3rd party framework like BI xPress to debug a package in a f...
In this session, we are going to take a deep dive behind the GUI and learn how to do even more data cleansing and transformation in Power BI using ...
In this session, we will discuss some of the lessons learned by our team as we work through data platform migrations.
In this session, we will be investigating the ways to create Azure Storage, quick ways to manage our Azure Storage, and how to move on premises dat...
In this session, you’ll learn how you can performance tune packages that take hours in seconds with components like the Dimension Merge and Upsert ...
In this session, you will learn how to leverage Power BI features like Drillthrough, Bookmarks, Spotlight and the Selection Pane, to tell a story...
Learn the major ways that working with Tableau is the same as (and different from) how you've used Excel and/or SQL.
In this session, we will discuss what Data Warehouse/BI data testing is and examine three different approaches to automate data testing in SQL Serv...
In this session, we will review Pragmatic Works' updates, features and road maps. We will also discuss how Pragmatic Works tools help not only cust...
Learn what companies around the globe are doing to redesign the way they think about data.
In this session, we will discuss Microsoft Azure Analysis Services, including service availability, requirements for deployment, migration from exi...
In this session, you will learn how Pragmatic Works successfully migrated to the cloud and learn several key points to make your migration a breeze...
In this session, you will learn about the similarities and differences between Azure SQL DB and Azure SQL DW.
In this session, you’ll learn how Task Factory can help you produce the perfect customer list with clean CAAS-certified addresses.
This session will provide an overview of Power BI Administration as it relates to security and governance.
During this session, we will discuss what we can and can’t control during a backup or recovery of our SQL Data Warehouse.
In this session, you will learn how to use the Azure Machine Learning Studio to build a predictive model.
This introductory-level demonstration will show you the basics of SSIS, including control and data flows, sources and destinations as you embark on...
In this session, we’ll show a variety of ways to use your metadata with DOC xPress to stabilize change and bring insights to your users.
In this session, you will learn how to design Power BI reports optimized for mobile devices and learn the ins and outs of the Power BI mobile app.<...
In this webinar, Per Solli – founder of Power ON, will share some usage scenarios on how both small and enterprise clients take advantage of Power ...
In this session, we will walk through the creation, querying and management of temporal tables.
In this webinar, you'll learn: the components of best-practice identity management, tips for implementing an identity management system, how a regi...
In this 30-minute session, you’ll learn how to gain back tons of productivity with the Power BI service.
In this webinar, we will discuss how to identify reporting requirements and how to select a tool appropriate for each type of reporting your compan...
In this session, each of our Women in Consulting team members will address the following topics: data modeling, data integration, the semantic la...
In this demo-heavy webinar, we will walk through the process of solving some specific business problems using the DAX language.
In this session, we will discuss data security updates due to Microsoft's recent announcement of Power BI Premium.
In this session, we’ll discuss T-SQL & SSIS while asking questions around what is actually happening, in an effort to simplify the process.
In this demo-heavy webinar, we'll review the top 5 recently released features and updates from Pragmatic Works Software.
In this session, we will review the latest updates to Power BI that you may have missed over the past few months.
While previous versions of SQL Server have been very secure, SQL Server 2016 has added some major security features. In this session, you will lear...
During this session, we will discuss tips for effectively working with Salesforce data for business intelligence.
In this demo-heavy webinar, we will focus on the building blocks necessary for building more complex calculations in DAX.
Due to the frequent changes to Power BI, improvements to data security are common within the platform as it matures. In this session, we'll discuss...
In this 3-hour session you will learn techniques for solving complex yet common problems using Power BI.
This session will explain why the absence of SQL Server Agent may not be the end of the world when working with Azure SQL DB.
During this session, you will learn some of the minor deployment issues you may run into when working with Azure.
By the end of this session, you will have a clearer understanding of the strengths and weakness of both the SSAS multidimensional and SSAS tabular ...
In this webinar you’ll learn how to diagnose problems with your BI environment faster and test data with ease.
This session demonstrates how to use SQL 2016 Extended Events to monitor and evaluate query performance of SSAS multidimensional cubes and tabular ...
In this webinar, we are going to walk through an overview of dimension table architecture and dimension modeling techniques.
In this session, you will learn techniques to migrate your on-premises SQL Server databases to Azure SQL DBs, and why backup and restore is not one...
In this three-hour session, learn how to design styles around creating and loading your first data warehouse.
Learn the 4 steps to a data-driven digital transformation and how to change your company with the right approach and tools.
In this demo-heavy presentation, we’ll be discussing “gotcha” moments when working with table fast loads, sorted dataflows, unique identifiers and ...
In this webinar, we'll walk through Microsoft's mobile reporting and analytics solutions in Power BI and SSRS.
In this session, we’ll discuss the technologies Microsoft provides us within SQL Server to keep our databases up, our users happy, and our DBAs wel...
Learn what Temporal Tables are and how they track data change history for auditing and forensics.
Join Pragmatic Works for an hour of integration fun as we achieve communication and sharing between Power BI.com, SSRS 2016 and Excel.
This 3-hour session will go in-depth into hardware and virtualization, protecting your data, performance and the tools available for managing your ...
In this webinar, we will demonstrate how easy it is to use Power BI to build interactive reports and dashboards on your own time.
This session provides design techniques and tips that will have you building your own models to deliver solutions without those nasty performance s...
In this session, you will learn about many of the new features that have been added to Power BI over the last year like Row Level Security, Paramet...
Join Pragmatic Works and ScaleArc for this webinar to get valuable lessons learned and best practices for enabling continuous availability for your...
Learn some of the Power BI gotchas that can slow down report development and get solutions to overcome them.
Join us for this 3-hour session on advanced Excel for decision makers.
During this webinar, we will discuss one of the most commonly asked questions regarding visualizations and analytics.
This webinar will walk through building a predictive model in SQL Server 2016 and R Server.
Interested in doing some Machine Learning Analysis ? Consider performing data analytics in R with SQL Server 2016.
This session will review some cloud analytics use cases and how the tools from Microsoft combine to create business insight and value.
In this session, Jonathan will share his story on “Getting Started with Tableau” and help you know what to do next to help you and your team improv...
In this session, you’ll learn how to give your users what they’ve been craving for decades: real-time analytics.
In this session, we will review key concepts associated with Azure Data Factory to understand how key entities work together to define input and ou...
In this session, we will be taking a look at Microsoft’s new scalable data warehouse in Azure.
Attendees of this session will learn the techniques to create a successful environment for implementing Power BI within their organization.
Learn how to rethink your own development and get the right capabilities for an amazing future in data!
In this session, we will provide an introduction to Azure SQL Database, including how to get started in the Azure portal, provide some comparisons ...
In this webinar, we will leverage the patterns found in demographics, admissions, treatment and discharge data to build predictive models.
With Power BI parameters and templates, you can make individual datasets dynamic and also make your entire solution dynamic.
In this session, we'll be highlighting some of the new features and enhancements in the latest Task Factory, BI xPress and LegiTest release.
Using Azure’s HDInsight and Spark we’re going to look at the architecture and go step by step through examples with R and Python against public dat...
Join Mitch in this 3-hour session where you will learn advanced T-SQL techniques and design patterns to solve problems and then understand why one...
In this session, we will clearly define differences in performance tuning techniques, review concepts and draw comparisons to the regular SQL world...
Join us for this webcast and get a look at some of the new features coming for LegiTest in our summer release.
In this session, we'll look at how you can take advantage of an on-premises gateway to make use of local data when creating reports and dashboards ...
In this session, we'll take an introductory look at Power BI Desktop, the main authoring and design tool for Power BI.
Come see how you can leverage the new SQL Server 2016 security features independently for specific use cases or all working together for solid end-...
Join us as we talk through how the best organizations in the world are up-leveling their data culture by using SQL 2016, Azure and all the capabili...
This session will cover improvements in AlwaysOn for SQL Server 2016 that range from Standard Edition support for AGs to load balanced replicas to ...
In this session, we’ll talk about some of the performance and performance tuning tools improvements coming to SQL Server 2016.
In this session, we'll cover the new Stretch database functionality that allows for data to stretch between on-premises and Microsoft Azure.
Join us as we look at some hidden gems within the SQL 2016 release that have not been provided page 1 notoriety.
In this session, we'll take a look at what has changed in SSRS 2016 and how to get up and running using the new Dashboard/Mobile reports.
Watch as we use the power of the R programming language in conjunction with Microsoft SQL Server 2016 to transform and prepare large amounts of dat...
Learn all about the exciting new SQL Server 2016 feature, Polybase.
This session is designed to introduce SQL Server DBA’s and architects to some of the exciting features available in SQL Server 2016.
In this session, you will see what happens when you go beyond the basics of Power BI and try to solve difficult problems that you inevitably will r...
Get started with a Tabular Model, including explaining some of the differences between Tabular Models in Excel, Power BI and SSAS Tabular.
In this session, we will actually take an arbitrary application and its affiliated databases and go through the tasks/resources needed to accompli...
In this session, we will discuss how to solve T-SQL problems using more complex T-SQL concepts.
Join Devin Knight in this 3-hour session where you'll get a clear end-to-end journey through creating a Power BI solution.
In this session, we will review a real-world challenge migrating an old commission application to a new commission application.
In this session, we'll look into backup and recovery techniques for Full, Differential and log backups.
Watch as we use the power of Azure SQL Data Warehouse to transform and prepare large amounts of data into a format that ideal for building a predic...
This session will cover the benefits of migrating from Oracle to SQL Server 2016.
This session will discuss the fantastic new capabilities of Query Store with SQL Server 2016.
Learn all about what new in Reporting Services for SQL Server 2016.
In this session, you’ll see how to build a better SSIS process to load a data warehouse with native SSIS components and enhanced Task Factory compo...
This session will cover the origins of Polybase, how to set up SQL Server 2016 to use it, and what users can expect to see within SQL Server when q...
The topic for this hour will be creating a data flow blueprint on which to build a BI project with a focus on some common areas of struggle.
In this demo-heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why to...
This session will show you techniques for building efficient Power BI data models.
In this session, we'll discuss concepts around backup and recovery procedures for you databases.
LegiTest Server enables you to schedule, execute and view the results of tests created with the LegiTest client.
In this session, we'll go over use cases for Analysis Services and highlight the differences and strengths of each flavor of SSAS.
Superdome X is HP’s the top of the line server running Windows OS and SQL Server. Join us as we discuss the key areas where you can leverage Superd...
In this session, you’ll start from the ground-up learning how to create a basic MDX statement.
By the end of this session, you’ll be able to easily understand the impact of a column name change to your business.
In this presentation, we'll take a look at some of the latest features and updates for Power BI.
By the end of this session, you’ll have a clear understanding of the strengths and weakness of each model and how your organization can optimally l...
Investigate how to add flexibility to the For Loop Container in SSIS to consume the contents of any folder, regardless of file formatting or type.<...
In this webinar, you’ll learn how to make sure your business is making decisions with the correct data by building a testing framework into your da...
Join us as we review best practices and strategies for migrating from your current solution to modern versions of SQL Server and Azure.
This session discusses several strategies for security and shows you how to implement security in your enterprise BI solutions.
In this webinar, you’ll go beyond the basics of Analysis Services Multidimensional security.
In this session, you will learn about some less than obvious tips to keep users happy and the DBA’s phone quiet.
In this session, you learn not only how to create your own virtual environment in Azure, but also how to migrate your existing servers to the cloud...
This session will share best practices for developing SSIS packages that perform well and scale as data demands grow.
Building predictive models may seem intimidating at first, but the truth is it's fairly simple when you break it down into its core components.
Pragmatic Tools
The Microsoft SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to help assess t...
Many organizations start out by deploying SharePoint using a “Shared Services” model but realise that various divisions, companies and or business...