Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.
Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.
What makes our On-Demand Training different? Other programs provide cursory looks at SQL Server and Business Intelligence, which Pragmatic Works offers to you at no cost in our free training sessions. Pragmatic Works On-Demand Training is designed to get you capable of working with the technology on your own in no time.
Pragmatic Works On-Demand Training is taught by industry experts and Microsoft MVPs with real world experience across all industries. The classes are designed to help you master the technology anywhere, anytime and on any device.
Our Excel Pack includes 2 Excel courses that were developed by Microsoft Excel MVPs. This group of courses takes you beyond the basics and helps you master the world's most popular software. With these courses, you will not only become an expert in Pivot Table design but will also be skilled in building Interactive Excel Dashboards.
Interactive Dashboards with ExcelInteractive Dashboards with Excel is an online video course for data analysts, data wranglers, spreadsheet developers and managers looking to design work for decision makers. This course will teach you how to present data to leadership so they can ask questions of the data and make decisions quickly. In addition, this course covers theoretical concepts like data visualization and how to build spreadsheets so they’re always fast, transparent, feature-rich, and extensible. By the end of this course, you will feel confident knowing the best chart to use to present based on the data you have, and you’ll be able to turn around dashboards and charts more quickly than before. While the topics in this course may seem advanced, they’ll be presented to you in a friendly manner—and lessons are designed such that you’ll be able to apply the material immediately to your own work before finishing the course.
Building BI with Pivot Tables New!Building Business Intelligence with Pivot Tables is an online video course that is perfect for anyone looking to build reports and quickly summarize 10s to 1,000s of rows of data. This course will provide the analyst with the best ways to source and clean up source data for reporting. As the data is cleansed, the course will show you how to present the data in a way that is easy to use for analysis by presenting data in both tabular and visually. The course will further explore the best ways to analyze the data and drill in and out of data. By the end of this course, you will feel confident sourcing, cleansing, and analyzing data through pivot tables and dashboards.
Our Power BI Pack includes our 4 Power BI courses plus a bonus free course that is exclusive to Elite and Power BI Pack holders. This group of courses will turn you into a Power BI expert by providing in-depth instruction on all of the capabilities that Power BI provides. Learn how to utilize Power BI to transform your data into easy-to-use visualized reports and dashboards that you can share and view from any device.
Power BI Desktop and DashboardsThis class is designed to get you up to speed on the latest with Power BI. First you will learn how to query and pull in data. Then organize the results into a data model with relationships and calculations. Finally, you will learn the best way to visualize your data through a variety of charts, graphs, maps and gauges that are provided. This class exclusively uses the Power BI Desktop application to create solutions that are deployed to the Power BI Service and are then visible from any devices.
Power BI with ExcelThe Power BI with Excel course is designed to get you up-to-speed using tools easily accessible to Power Users and all Microsoft Office users including Office 365 (Please note Office 365 is not mandatory for this class). First, you’ll learn the basics of creating models using Power Pivot. Then, using Power Query, you’ll shape additional data that can be found in external data sources.
Power Query for BusinessThe Power Query for Business course is designed to help you understand how Power Query can be used for self-service data extraction and manipulation. This hands-on session starts with the basics of Power Query and takes you all the way through the possibilities when you write M queries from scratch.
Introduction to DAX New!DAX is a both a programming and query language that gives you the ability to extend what is possible in either your Power BI or Tabular data models. The Introduction to DAX course is designed to teach the fundamentals of DAX while emphasizing the basic building blocks required to author more complex DAX calculations. This video based course quickly moves from basic DAX functions to more advanced functions like CALCULATE and iterator functions like SUMX.
Power BI Custom VisualsThis video series will teach you how to use each of the Power BI Custom Visuals that are available in the Power BI Custom Visual Gallery. This gallery includes visuals created by the Power BI community. https://app.powerbi.com/visuals/
Our SQL Server Administration Pack includes 6 courses specifically for DBAs or those looking to become a DBA. These classes will give you a jumpstart on your DBA journey or keep you up-to-date with your skills.
SQL Server High AvailabilityHigh availability is a broad term used and misused throughout on and offline discussions about uptime and application availability. For the DBA, it is critical to understand this topic and the technological underpinnings of the high availability options Microsoft provides within SQL Server. This course will begin by explaining key terms and concepts surrounding the idea of high availability. Following that, every SQL Server high availability option will be discussed and demoed. By the end of the course, students will have a firm idea of what high availability tools are presented within SQL Server as well as how to deploy those tools.
SQL Server Performance TuningSQL Server performance is as much an art form as it is a science. Many times a server will give conflicting information about the state that it is in. 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 running efficiently and reliably. Additionally, you will experience how to perform advanced performance tuning and optimization in your everyday DBA work.
Introduction to T-SQLThis course is designed to get you developing with T-SQL very quickly. First you will learn the structure of a SQL Server database, then you will dive into how to query the tables. Next, We will cover sorting and filtering the results.
Advanced T-SQLAdvanced Querying with T-SQL is an intensive course designed specifically for SQL developers. This course has been designed using examples from real-world scenarios. In many cases, the course will demonstrate the different methods to solve a particular scenario and then explain why one may be better than another due to performance reasons. The course has a heavy emphasis on writing optimal queries.
DBA FundamentalsStarting out as a DBA is rough. Nobody takes the time to show you the ropes, everybody wants ‘advanced’ this, ‘Internals’ that, or Deep Dive level 1000! All that advanced stuff is great, but you need to build a foundation. This course gives a step-by-step overview of SQL Server and will review installing SQL Server and it’s various services, post configuration, setting up maintenance plans, reviewing essential concepts surrounding what backups should be selected, and basic SQL Server and Active Directory Security.
SQL Server Hardware and ConfigurationSQL Server configuration is an often neglected part of setting up your organizations infrastructure for success. Accepting system defaults does not always provide the best results and in fact can often result in performance problems and later rework to correct the problems. In this class you will learn how hardware and software operate together so you can better understand what your systems can actually achieve and how to configure them properly for SQL Server. Available with Elite Package purchase only.
Our Business Intelligence Pack includes over 10 courses designed to guide you on your BI journey. This group of courses will turn you into a Business Intelligence expert by providing detailed instruction on all aspects of the BI stack. Begin your journey into BI with this impressive training suite.
Introduction to SSAS TabularIntroduction to Tabular is an intensive course that is designed to get you up to speed using Analysis Services Tabular quickly and efficiently. You will start from basic concepts and move to complex data models and DAX formulas. In addition, this course covers creating and deploying tabular data models using SQL Server Data Tools. Once deployed, Tabular data models can be used by data analysts, decision makers, and information workers for ad-hoc reporting and data exploration. By the end of this course, you will feel confident using this powerful toolset to analyze and gain insight from your business data.
Advanced SSASThis course is designed to take you to the next level in your understanding of SQL Server Analysis Services (SSAS). We use a variety of lab exercises and exclusive internals lectures to ensure lectures are backed up by hands-on experience and real world knowledge.
Introduction to SSISThis course designed to help you understand all aspects of SQL Server Integration Services (SSIS), the ETL tool of choice for SQL Server users. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and be prepared to build your own real world applications using this SQL Server application. Students will learn real world uses for SSIS.
Advanced SSISFor the SSIS user looking to become a more effective and advanced ETL developer, our Advanced SSIS course will teach you how to use SSIS in your enterprise to solve common extract, transform and load (ETL) challenges. Much of this course focuses on implementing common real-world SSIS patterns taught from the experts of SSIS. Be prepared for a very in-depth day of SSIS with advanced discussion in many areas.
Introduction to SSRSIntroduction to SSRS is designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server developers. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and to prepare you to build your own real-world applications using this SQL Server subsystem.
Advanced SSRSAdvanced Report Developers must hold unique traits to set themselves and their work apart from others. The course is designed to take you to the next level in your understanding of SQL Server Reporting Services (SSRS). We use a variety of lab exercises to ensure lecture sessions are backed up by hands-on experience.
Mobile Reports and Dashboards with SSRS 2016The release of SQL Server 2016 has now integrated the incredible dashboarding and mobile reporting capabilities from Microsoft’s acquisition of Datazen. These new capabilities are now available in SQL Server Reporting Services along with many other improvements some of which include a new Mobile Report Publisher and upgrades to the existing Report Builder and Web Portal. At the end of this course you will be proficient in designing, publishing, and applying security to KPIs, dashboards and mobile reports in SQL Server Reporting Services 2016.
Introduction to SSAS TabularIntroduction to Tabular is an intensive course that is designed to get you up to speed using Analysis Services Tabular quickly and efficiently. You will start from basic concepts and move to complex data models and DAX formulas. In addition, this course covers creating and deploying tabular data models using SQL Server Data Tools. Once deployed, Tabular data models can be used by data analysts, decision makers, and information workers for ad-hoc reporting and data exploration. By the end of this course, you will feel confident using this powerful toolset to analyze and gain insight from your business data.
Introduction to MDXAfter watching this course, you’ll learn how to use MDX for use with SSAS in your enterprise. This class begins with explaining the basic concepts related to multidimensional expressions and how they are used to enhance cubes with calculations as well as to query cubes to retrieve data for reports.
Big Data for BeginnersThe Big Data for Beginners course is designed to introduce the Big Data ecosystem. The course begins with basic concepts behind how Hadoop systems are laid out and how they function. On the second day, it covers the different types of work that you might consider Hadoop for, and whether or not it is the right tool.
Data Science with Azure MLCash registers, websites, patients, employees, customers, students, machines, warehouses and nearly every other aspect of the modern business world generate enormous amounts of data. Hiding within these ever-increasing mountains of data are patterns that can optimize nearly every business decision. Knowing how to find and leverage these patterns is a skill-set that is in high demand and will remain there indefinitely. Data science and machine learning are the core components used to understand, transform, model and execute on those data patterns.
SharePoint BIThis course will help you learn how to use SharePoint to bring business intelligence to the forefront for your users and customers. This class is built to take your SharePoint BI knowledge to the next level. Hands-on labs will reinforce the concepts learned and help familiarize you with the tools in an actual SharePoint environment. Topics covered include basic SharePoint server architecture, Excel, Power Pivot, Power View, PerformancePoint, SQL Server Reporting Services 2012 and site branding.
Data ModelingThe Pragmatic Works Data Modeling course is designed to teach the foundation of creating effective data models. This course covers two separate modeling techniques, transactional systems and dimensional modeling. A well designed data model is the foundation for supporting the day to day operational activities of an organization and providing analytical value through business intelligence.
Introduction to DAX New!DAX is a both a programming and query language that gives you the ability to extend what is possible in either your Power BI or Tabular data models. The Introduction to DAX course is designed to teach the fundamentals of DAX while emphasizing the basic building blocks required to author more complex DAX calculations. This video based course quickly moves from basic DAX functions to more advanced functions like CALCULATE and iterator functions like SUMX.
Building BI with Pivot Tables New!Building Business Intelligence with Pivot Tables is an online video course that is perfect for anyone looking to build reports and quickly summarize 10s to 1,000s of rows of data. This course will provide the analyst with the best ways to source and clean up source data for reporting. As the data is cleansed, the course will show you how to present the data in a way that is easy to use for analysis by presenting data in both tabular and visually. The course will further explore the best ways to analyze the data and drill in and out of data. By the end of this course, you will feel confident sourcing, cleansing, and analyzing data through pivot tables and dashboards.
Introduction to DAX New!DAX is a both a programming and query language that gives you the ability to extend what is possible in either your Power BI or Tabular data models. The Introduction to DAX course is designed to teach the fundamentals of DAX while emphasizing the basic building blocks required to author more complex DAX calculations. This video based course quickly moves from basic DAX functions to more advanced functions like CALCULATE and iterator functions like SUMX.
Big Data for BeginnersThe Big Data for Beginners course is designed to introduce the Big Data ecosystem. The course begins with basic concepts behind how Hadoop systems are laid out and how they function. On the second day, it covers the different types of work that you might consider Hadoop for, and whether or not it is the right tool.
Data Science with Azure MLCash registers, websites, patients, employees, customers, students, machines, warehouses and nearly every other aspect of the modern business world generate enormous amounts of data. Hiding within these ever-increasing mountains of data are patterns that can optimize nearly every business decision. Knowing how to find and leverage these patterns is a skill-set that is in high demand and will remain there indefinitely. Data science and machine learning are the core components used to understand, transform, model and execute on those data patterns.
Power BI Desktop and DashboardsThis class is designed to get you up to speed on the latest with Power BI. First you will learn how to query and pull in data. Then organize the results into a data model with relationships and calculations. Finally, you will learn the best way to visualize your data through a variety of charts, graphs, maps and gauges that are provided. This class exclusively uses the Power BI Desktop application to create solutions that are deployed to the Power BI Service and are then visible from any devices.
Power BI with ExcelThe Power BI with Excel course is designed to get you up-to-speed using tools easily accessible to Power Users and all Microsoft Office users including Office 365 (Please note Office 365 is not mandatory for this class). First, you’ll learn the basics of creating models using Power Pivot. Then, using Power Query, you’ll shape additional data that can be found in external data sources.
Power Query for BusinessThe Power Query for Business course is designed to help you understand how Power Query can be used for self-service data extraction and manipulation. This hands-on session starts with the basics of Power Query and takes you all the way through the possibilities when you write M queries from scratch.
Power BI Custom VisualsThis video series will teach you how to use each of the Power BI Custom Visuals that are available in the Power BI Custom Visual Gallery. This gallery includes visuals created by the Power BI community. https://app.powerbi.com/visuals/
Interactive Dashboards with ExcelInteractive Dashboards with Excel is an online video course for data analysts, data wranglers, spreadsheet developers and managers looking to design work for decision makers. This course will teach you how to present data to leadership so they can ask questions of the data and make decisions quickly. In addition, this course covers theoretical concepts like data visualization and how to build spreadsheets so they’re always fast, transparent, feature-rich, and extensible. By the end of this course, you will feel confident knowing the best chart to use to present based on the data you have, and you’ll be able to turn around dashboards and charts more quickly than before. While the topics in this course may seem advanced, they’ll be presented to you in a friendly manner—and lessons are designed such that you’ll be able to apply the material immediately to your own work before finishing the course.
Introduction to SSAS TabularIntroduction to Tabular is an intensive course that is designed to get you up to speed using Analysis Services Tabular quickly and efficiently. You will start from basic concepts and move to complex data models and DAX formulas. In addition, this course covers creating and deploying tabular data models using SQL Server Data Tools. Once deployed, Tabular data models can be used by data analysts, decision makers, and information workers for ad-hoc reporting and data exploration. By the end of this course, you will feel confident using this powerful toolset to analyze and gain insight from your business data.
Introduction to MDXAfter watching this course, you’ll learn how to use MDX for use with SSAS in your enterprise. This class begins with explaining the basic concepts related to multidimensional expressions and how they are used to enhance cubes with calculations as well as to query cubes to retrieve data for reports.
Introduction to SSASIn this course, you’ll learn how to use SSAS in your enterprise. This training takes you from the ground-up, teaching you the fundamental skills you need to develop and deploy SSAS solutions and present this new data to your end users.
Advanced SSASThis course is designed to take you to the next level in your understanding of SQL Server Analysis Services (SSAS). We use a variety of lab exercises and exclusive internals lectures to ensure lectures are backed up by hands-on experience and real world knowledge.
SQL Server High AvailabilityHigh availability is a broad term used and misused throughout on and offline discussions about uptime and application availability. For the DBA, it is critical to understand this topic and the technological underpinnings of the high availability options Microsoft provides within SQL Server. This course will begin by explaining key terms and concepts surrounding the idea of high availability. Following that, every SQL Server high availability option will be discussed and demoed. By the end of the course, students will have a firm idea of what high availability tools are presented within SQL Server as well as how to deploy those tools.
Introduction to SSISThis course designed to help you understand all aspects of SQL Server Integration Services (SSIS), the ETL tool of choice for SQL Server users. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and be prepared to build your own real world applications using this SQL Server application. Students will learn real world uses for SSIS.
Advanced SSISFor the SSIS user looking to become a more effective and advanced ETL developer, our Advanced SSIS course will teach you how to use SSIS in your enterprise to solve common extract, transform and load (ETL) challenges. Much of this course focuses on implementing common real-world SSIS patterns taught from the experts of SSIS. Be prepared for a very in-depth day of SSIS with advanced discussion in many areas.
Introduction to SSRSIntroduction to SSRS is designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server developers. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and to prepare you to build your own real-world applications using this SQL Server subsystem.
Advanced SSRSAdvanced Report Developers must hold unique traits to set themselves and their work apart from others. The course is designed to take you to the next level in your understanding of SQL Server Reporting Services (SSRS). We use a variety of lab exercises to ensure lecture sessions are backed up by hands-on experience.
Mobile Reports and Dashboards with SSRS 2016The release of SQL Server 2016 has now integrated the incredible dashboarding and mobile reporting capabilities from Microsoft’s acquisition of Datazen. These new capabilities are now available in SQL Server Reporting Services along with many other improvements some of which include a new Mobile Report Publisher and upgrades to the existing Report Builder and Web Portal. At the end of this course you will be proficient in designing, publishing, and applying security to KPIs, dashboards and mobile reports in SQL Server Reporting Services 2016.
SharePoint BIThis course will help you learn how to use SharePoint to bring business intelligence to the forefront for your users and customers. This class is built to take your SharePoint BI knowledge to the next level. Hands-on labs will reinforce the concepts learned and help familiarize you with the tools in an actual SharePoint environment. Topics covered include basic SharePoint server architecture, Excel, Power Pivot, Power View, PerformancePoint, SQL Server Reporting Services 2012 and site branding.
SQL Server Performance TuningSQL Server performance is as much an art form as it is a science. Many times a server will give conflicting information about the state that it is in. 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 running efficiently and reliably. Additionally, you will experience how to perform advanced performance tuning and optimization in your everyday DBA work.
Introduction to T-SQLThis course is designed to get you developing with T-SQL very quickly. First you will learn the structure of a SQL Server database, then you will dive into how to query the tables. Next, We will cover sorting and filtering the results.
Advanced T-SQLAdvanced Querying with T-SQL is an intensive course designed specifically for SQL developers. This course has been designed using examples from real-world scenarios. In many cases, the course will demonstrate the different methods to solve a particular scenario and then explain why one may be better than another due to performance reasons. The course has a heavy emphasis on writing optimal queries.
DBA FundamentalsStarting out as a DBA is rough. Nobody takes the time to show you the ropes, everybody wants ‘advanced’ this, ‘Internals’ that, or Deep Dive level 1000! All that advanced stuff is great, but you need to build a foundation. This course gives a step-by-step overview of SQL Server and will review installing SQL Server and it’s various services, post configuration, setting up maintenance plans, reviewing essential concepts surrounding what backups should be selected, and basic SQL Server and Active Directory Security.
Data Modeling New!The Pragmatic Works Data Modeling course is designed to teach the foundation of creating effective data models. This course covers two separate modeling techniques, transactional systems and dimensional modeling. A well designed data model is the foundation for supporting the day to day operational activities of an organization and providing analytical value through business intelligence.
SQL Server Hardware and ConfigurationSQL Server configuration is an often neglected part of setting up your organizations infrastructure for success. Accepting system defaults does not always provide the best results and in fact can often result in performance problems and later rework to correct the problems. In this class you will learn how hardware and software operate together so you can better understand what your systems can actually achieve and how to configure them properly for SQL Server. Available with Elite Package purchase only.
Pragmatic Works WorkbenchPragmatic Workbench On-Demand Training gives users an extensive look at every feature our tools have to offer. Attendees will learn how to use the Pragmatic Works’ product suite to its fullest potential in their unique environment and how the tools will help with overcoming common challenges and create an overall more efficient BI experience.
Pragmatic Works LegiTestPragmatic Works LegiTest On-Demand Training gives users an extensive look at every feature it has to offer. LegiTest is a comprehensive tool for testing all data-centric applications, in an easy-to-use, automated platform. In this class, you will learn why testing is important and how LegiTest can be used to automate the testing process for your solutions.
We got Task Factory mostly because of PragmaticWorks reputation for the service they provide and the specific need of a secure SFTP task.
The University of Calgary Data Warehouse consists of over two dozen data marts, built upon a decade's worth of ETL programming in IBM Cognos Data Manager. When support for that product ended and we investigated converting all ETL to SSIS, concerns were raised about performance and maintainability in the new toolset. Thus the decision was made to purchase Pragmatic Works Task Factory; I can say with confidence that halfway into the conversion effort, it has been one of our smartest and most cost-effective software acquisitions in recent memory.
Contains 65+ tasks, connection managers, sources and Destinations for SSIS. You can compare editions here. Task Factory does not require a license while you're running packages in Visual Studio.