X

Purchase On-Demand Training

ODT

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.

 

Our Excel Pack includes 3 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.


ODT-Excel-Dashboards Interactive Dashboards with Excel

Interactive 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.

  • Learn how to develop smarter and save time in Excel
  • Understand design patterns and strategies for building dashboards in Excel
  • Understand how to use the Formulas and Functions for the purpose of designing dashboards
ODT-Excel-Pivot-Table Building BI with Pivot Tables

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.

  • Develop Excel PivotTables reports and modify their aesthetics
  • Learn how to leverage tools like Power Query and Power Pivot to enhance what’s possible with PivotTables.
  • Understand how to refresh PivotTable local and external data.
Art and Science of Excel Modeling.png Art & Science of Excel Modeling New!

The Art & Science of Excel Modeling course is an in-depth exploration of how to plan, design, and maintain robust, efficient business-operational models with Excel. This class is ideal for consultants, financial analysts, auditors, accountants, managers, and technical professionals seeking to elevate their Excel modeling acumen, tap into greater design creativity, and reap the benefits of great Excel models that can drive cost savings, process efficiencies and improve business decision making.
Kicking off with a bigger-picture, philosophical view of spreadsheet design principles, we aim to stimulate critical thinking skills and inspire confidence as you navigate an increasingly competitive job market. In our “real world based” demonstrations, we will explore creative solutions to routine business problems in the business, finance, and accounting world. We will also offer practical guidance for newer challenges arising from the ever-increasing volumes of “big” data that seem to be “pushing the boundaries” that Excel is naturally equipped to handle.

  • Basic spreadsheet design principles
  • How to demonstrate "real-world" creative solutions to routine business problems
  • How to plan, design and maintain business operational models with Excel

Our Power BI Pack includes our 9 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 Introduction to Power BI

This 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.

  • Learn to build your own dashboards
  • Understand the Power BI Ecosystem
  • Extract and model data
Power-BI.png Power BI for Consumers

This course is designed to get you up to speed on consuming data and interacting with reports in Power BI. This is key to help you understand where your business has been and where it’s going in the future. First, you will learn how to get connected to the Power BI Service. Once connected, you will see how easy it is to interact with reports and even change their appearance to better suit your needs. Lastly, you will learn how to build your own dashboards from these reports and see how they can be immediately viewed from your mobile devices.

Power-BI.png Power BI Report Server Administration

Planning a non-cloud Power BI architecture can be done with a feature called the Power BI Report Server. While this features gives you added flexibility you also must now manage and administer a new service. This short class helps bridge the gap of understanding required for organizations that are not using the cloud for Power BI.

Power-BI.png Power BI Service Administration

Proper Power BI Administration and Governance is a critical aspect of having a successful Power BI deployment across your organization. This course provides the framework necessary to successfully integrate Power BI into your corporate environment. In this course we cover various topics such as deployment, data refresh, security, collaboration, data governance, auditing and more.

Power-BI Power BI with Excel

The 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.

  • Learning the best ways to present your data by building reports using Excel, Power View and Power Map
  • By learning how to make the self-service BI solutions, you create scalable across your entire enterprise environment
Power-Query Power Query for Business

The 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.

  • How Power Query can be used to solve seemingly complicated data problems in the easiest possible way
  • How queries you design can be shared with others in your organization
Advanced Dax Introduction to DAX

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.

  • Have the ability to add analytical value to data models by creating calculated columns and measures.
  • Develop a strong understanding of how to work with time intelligence functions in DAX.
  • Build the foundations necessary for authoring more complex DAX calculations.
Advanced Dax Advanced DAX

The Advanced DAX course is designed to build on the fundamentals taught in the Introduction to DAX course. This course focuses on the advanced and difficult to comprehend DAX concepts like evaluation context, security, iterator functions and advanced DAX functions. The goal of this course is to give the student the tools necessary to think like DAX and understand the 'why' behind how calculations work.

  • Have the ability to significantly enhance the analytical value of data models with DAX calculations
  • Develop a strong understanding of advanced DAX concepts and learn to think like DAX
  • Understand when and how to use the more advanced DAX functions
Power-BI Power BI Custom Visuals

This 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/

Power-BI Advanced Power BI

Understanding the basics of Power BI can only get you so far. There are many lesser known advanced features within the tool that can take your Power BI knowledge to the next level. This course explores those features. Starting with how the languages of R and M can be used to extend that standard data extraction and transformation capabilities of Power BI. You will then understand complex data modeling scenarios and how Power BI can overcome them. Lastly, you will learn about several advanced data visualization techniques that can take your reports and dashboards beyond the basics.

Our SQL Server Administration Pack includes 7 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.



HighAvailability SQL Server High Availability

High 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.

  • Understand the basic High Availability terminology
  • Learn how to set up and configure a High Availability solution
  • Understand how to monitor your High Availability solution
SQL-Server-Performance-Tuning SQL Server Performance Tuning

SQL 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.

  • Learn SQL Server Index Tuning and Query Tuning best practices
  • Learn to use tools such as Profiler, Extended Events and SQLIO
  • Create a plan that will assist the DBA to monitor servers, alert on issues and resolve slowdowns
T-SQL Introduction to T-SQL

This 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.

  • Write queries that involve multiple tables and summary queries
  • Modify data and understand the logical programming aspects of T-SQL
T-SQL Advanced T-SQL

Advanced 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 Fundamentals.png DBA Fundamentals

Starting 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 SQL Server Hardware and Configuration

SQL 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 and SQL Server Administration Package purchase only.

PowerShell Introduction to PowerShell

This class is designed to overview and equip you with the basics of Windows PowerShell, Microsoft’s designated tool for automation within the Windows Environment. This course will introduce you to the tools necessary for using PowerShell, the foundations of Commands (called cmdlets), the PSProvider, and the Pipeline. After this we will cover more domain specific topics for Data Professionals Including cmdlets for traditional DBA workloads (DML, DDL, DCL), cmdlets for Reporting Services, community-built cmdlets, and the SMO provider. Finally, we will introduce PowerShell DSC, a Declarative framework for configuring systems, which may be used for Installing and Configuring SQL Server. By the end of this course you should feel comfortable with the command line in Windows and will be able to write your own scripts for managing SQL Server.

Our Business Intelligence Pack includes 17 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.



SSAS Introduction to SSAS

In 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 needed to develop and deploy SSAS solutions and present this new data to your end users.

  • Learn to develop a data warehouse for your company
  • Learn to develop a repeatable methodology for a successful SSAS project
  • Learn to create and configure a cube and dimensions
  • Learn to write MDX (the querying language for cubes)
  • Learn to define calculations, Key Performance Indicators (KPIs) and perspectives, and implementing dynamic security
  • Learn to administer and deploy SSAS, defining actions, implementing data mining
  • Learn to build office-based BI applications and dashboards, and administering SSAS
SSAS Advanced SSAS

This 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.

  • Learn how to build tier 1 Analysis Services solutions that will scale, while understanding all the internals to help you back up these best practices you will be implementing
  • This class will have a focus on architecture, design, scaling and internals that make Analysis Services the powerful analytics platform of choice
SSIS Introduction to SSIS

This 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.

  • Create an SSIS package to load to a database
  • Make dynamic packages that work and self-heal in the event of a failure
  • Use SSIS in your environment
SSIS Advanced SSIS

For 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.

  • Performance Tuning for SSIS
  • How to extend SSIS using script tasks and components
  • SSIS integration with SSAS and DQS
  • Data warehouse loading patterns
SSRS Introduction to SSRS

Introduction 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.

  • Learn how to create complex reports
  • Key concepts of Reporting Services from basic reporting, parameters, deploying and scheduling
SSRS Advanced SSRS

Advanced 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.

  • How to create complex reports that use Analysis Services as a data source and custom code assemblies
  • Master advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage
ODT-Tableau.png Introduction to Tableau

The Introduction to Tableau course teaches you the fundamentals of Tableau and is helpful for anyone who works with data no matter their technical background. You’ll come out of the course with an understanding of Tableau terminology, be able to create visualizations, and build dashboards.

MobileReports Mobile Reports and Dashboards with SSRS 2016

The 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.

  • Understand how to use the Mobile Report Publisher for designing Dashboards viewable on your desktop, tablet and phone
  • Learn how to design KPIs in the Web Portal
  • Understand how to administer and manager security on you Mobile Reports
SSAS Introduction to SSAS Tabular

Introduction 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.

MDX Introduction to MDX

After 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.

  • How to write MDX queries to retrieve data from an Analysis Services cube
  • Common functions for creating sets and performing set-based operations
  • MDX and Cube security
  • Optimization techniques for queries
Big-Data Big Data for Beginners

The 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.

  • How to deploy Big Data in your environment
  • What technologies make-up Big Data
  • Which common business problems Big Data can and cannot solve
Data-Science-with-Azure-ML Data Science with Azure ML

Cash 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 SharePoint BI

This 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 Modeling Data Modeling

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.

Advanced DAX Introduction to DAX

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.

  • Have the ability to add analytical value to data models by creating calculated columns and measures.
  • Develop a strong understanding of how to work with time intelligence functions in DAX.
  • Build the foundations necessary for authoring more complex DAX calculations.
Advanced DAX Advanced DAX

The Advanced DAX course is designed to build on the fundamentals taught in the Introduction to DAX course. This course focuses on the advanced and difficult to comprehend DAX concepts like evaluation context, security, iterator functions and advanced DAX functions. The goal of this course is to give the student the tools necessary to think like DAX and understand the 'why' behind how calculations work.

  • Have the ability to significantly enhance the analytical value of data models with DAX calculations
  • Develop a strong understanding of advanced DAX concepts and learn to think like DAX
  • Understand when and how to use the more advanced DAX functions
Administering-Business-Intelligence Administering Business Intelligence New!

Administration of SQL Server can often be as simple as query tuning a T-SQL statement or configuring a server properly. When a Business Intelligence developer gets a hold of other ‘cool’ features provided in Standard or Enterprise Edition of SQL Server, then the range of knowledge a DBA has needs to keep up with developers. The administrator does not need to know how to develop an integration service (SSIS) package or create a calculated measure in analysis services (SSAS), but it is good to understand what is needed to help debug and maintain the features used in their enterprise IT systems. Most shops do not use all these components, but most do use more than one.

ODT-Excel-Pivot-Table Building BI with Pivot Tables

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.

  • Develop Excel PivotTables reports and modify their aesthetics
  • Learn how to leverage tools like Power Query and Power Pivot to enhance what’s possible with PivotTables.
  • Understand how to refresh PivotTable local and external data.
Advanced DAX Introduction to DAX

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.

  • Have the ability to add analytical value to data models by creating calculated columns and measures.
  • Develop a strong understanding of how to work with time intelligence functions in DAX.
  • Build the foundations necessary for authoring more complex DAX calculations.
Advanced-DAX Advanced DAX

The Advanced DAX course is designed to build on the fundamentals taught in the Introduction to DAX course. This course focuses on the advanced and difficult to comprehend DAX concepts like evaluation context, security, iterator functions and advanced DAX functions. The goal of this course is to give the student the tools necessary to think like DAX and understand the 'why' behind how calculations work.

  • To have the ability to significantly enhance the analytical value of data models with DAX calculations
  • To develop a strong understanding of advanced DAX concepts and learn to think like DAX
  • To understand when and how to use the more advanced DAX functions
Art and Science of Excel Modeling.png Art & Science of Excel Modeling

The Art & Science of Excel Modeling course is an in-depth exploration of how to plan, design, and maintain robust, efficient business-operational models with Excel. This class is ideal for consultants, financial analysts, auditors, accountants, managers, and technical professionals seeking to elevate their Excel modeling acumen, tap into greater design creativity, and reap the benefits of great Excel models that can drive cost savings, process efficiencies and improve business decision making.
Kicking off with a bigger-picture, philosophical view of spreadsheet design principles, we aim to stimulate critical thinking skills and inspire confidence as you navigate an increasingly competitive job market. In our “real world based” demonstrations, we will explore creative solutions to routine business problems in the business, finance, and accounting world. We will also offer practical guidance for newer challenges arising from the ever-increasing volumes of “big” data that seem to be “pushing the boundaries” that Excel is naturally equipped to handle.

  • Basic spreadsheet design principles
  • How to demonstrate "real-world" creative solutions to routine business problems
  • How to plan, design and maintain business operational models with Excel
Big-Data Big Data for Beginners

The 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.

  • How to deploy Big Data in your environment
  • What technologies make-up Big Data
  • Which common business problems Big Data can and cannot solve
Data-Science-with-Azure-ML Data Science with Azure ML

Cash 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 Introduction to Power BI

This 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.

  • Learn to build your own dashboards
  • Understand the Power BI Ecosystem
  • Extract and model data
Power-BI Power BI with Excel

The 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.

  • Learning the best ways to present your data by building reports using Excel, Power View and Power Map
  • By learning how to make the self-service BI solutions, you create scalable across your entire enterprise environment
Power-Query Power Query for Business

The 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.

  • How Power Query can be used to solve seemingly complicated data problems in the easiest possible way
  • How queries you design can be shared with others in your organization
Power-BI Power BI Custom Visuals

This 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/

ODT-Excel-Dashboards Interactive Dashboards with Excel

Interactive 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.

  • Learn how to develop smarter and save time in Excel
  • Understand design patterns and strategies for building dashboards in Excel
  • Understand how to use the Formulas and Functions for the purpose of designing dashboards
SSAS Introduction to SSAS Tabular

Introduction 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.

MDX Introduction to MDX

After 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.

  • How to write MDX queries to retrieve data from an Analysis Services cube
  • Common functions for creating sets and performing set-based operations
  • MDX and Cube security
  • Optimization techniques for queries
SSAS Introduction to SSAS

In 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.

  • Develop a data warehouse for your company
  • Develop a repeatable methodology for a successful SSAS project
  • Create and configure a cube and dimensions
  • Write MDX (the querying language for cubes)
  • Define calculations, Key Performance Indicators (KPIs) and perspectives, and implementing dynamic security
  • Administer and deploy SSAS, defining actions, implementing data mining
  • Build office-based BI applications and dashboards, and administering SSAS
SSAS Advanced SSAS

This 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.

  • Learn how to build tier 1 Analysis Services solutions that will scale, while understanding all the internals to help you back up these best practices you will be implementing
  • This class will have a focus on architecture, design, scaling and internals that make Analysis Services the powerful analytics platform of choice
HighAvailability SQL Server High Availability

High 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.

  • Understand the basic High Availability terminology
  • Learn how to set up and configure a High Availability solution
  • Understand how to monitor your High Availability solution
Power-BI.png Power BI for Consumers

This course is designed to get you up to speed on consuming data and interacting with reports in Power BI. This is key to help you understand where your business has been and where it’s going in the future. First, you will learn how to get connected to the Power BI Service. Once connected, you will see how easy it is to interact with reports and even change their appearance to better suit your needs. Lastly, you will learn how to build your own dashboards from these reports and see how they can be immediately viewed from your mobile devices.

Power-BI.png Advanced Power BI New!

Understanding the basics of Power BI can only get you so far. There are many lesser known advanced features within the tool that can take your Power BI knowledge to the next level. This course explores those features. Starting with how the languages of R and M can be used to extend that standard data extraction and transformation capabilities of Power BI. You will then understand complex data modeling scenarios and how Power BI can overcome them. Lastly, you will learn about several advanced data visualization techniques that can take your reports and dashboards beyond the basics.

SSIS Introduction to SSIS

This 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.

  • Create an SSIS package to load to a database
  • Make dynamic packages that work and self-heal in the event of a failure
  • Use SSIS in your environment
SSIS Advanced SSIS

For 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.

  • Performance Tuning for SSIS
  • How to extend SSIS using script tasks and components
  • SSIS integration with SSAS and DQS
  • Data warehouse loading patterns
SSRS Introduction to SSRS

Introduction 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.

  • Learn how to create complex reports
  • Key concepts of Reporting Services from basic reporting, parameters, deploying and scheduling
SSRS Advanced SSRS

Advanced 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.

  • How to create complex reports that use Analysis Services as a data source and custom code assemblies
  • Master advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage
MobileReports Mobile Reports and Dashboards with SSRS 2016

The 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.

  • Understand how to use the Mobile Report Publisher for designing Dashboards viewable on your desktop, tablet and phone
  • Learn how to design KPIs in the Web Portal
  • Understand how to administer and manager security on you Mobile Reports
SharePoint SharePoint BI

This 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-Tuning SQL Server Performance Tuning

SQL 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.

  • Learn SQL Server Index Tuning and Query Tuning best practices
  • Learn to use tools such as Profiler, Extended Events and SQLIO
  • Create a plan that will assist the DBA to monitor servers, alert on issues and resolve slowdowns
T-SQL Introduction to T-SQL

This 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.

  • Write queries that involve multiple tables and summary queries
  • Modify data and understand the logical programming aspects of T-SQL
T-SQL Advanced T-SQL

Advanced 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 Fundamentals.png DBA Fundamentals

Starting 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 Data Modeling

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-Software-Configuration SQL Server Hardware and Configuration

SQL 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 and SQL Server Administration Package purchase only.

ODT-Tableau.png Introduction to Tableau

The Introduction to Tableau course teaches you the fundamentals of Tableau and is helpful for anyone who works with data no matter their technical background. You’ll come out of the course with an understanding of Tableau terminology, be able to create visualizations, and build dashboards.

Power-BI.png Power BI Report Server Administration

Planning a non-cloud Power BI architecture can be done with a feature called the Power BI Report Server. While this features gives you added flexibility you also must now manage and administer a new service. This short class helps bridge the gap of understanding required for organizations that are not using the cloud for Power BI.

Power-BI.png Power BI Service Administration

Proper Power BI Administration and Governance is a critical aspect of having a successful Power BI deployment across your organization. This course provides the framework necessary to successfully integrate Power BI into your corporate environment. In this course we cover various topics such as deployment, data refresh, security, collaboration, data governance, auditing and more.

Pragmatic-Workbench2.png Pragmatic Works Workbench

Pragmatic 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.

  • Proper usage for the entire Pragmatic Works’ product suite.
  • How the Pragmatic Works’ product suite will increase your job efficiency and productivity.
LegiTest.png Pragmatic Works LegiTest

Pragmatic 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.

  • Proper usage of LegiTest
  • How to easily test your production and end data with LegiTest
Introduction to R.png Introduction to R New!

During this R programming virtual training course, you will learn how to use R for data analysis. We’ll start with a discussion of the R language and how to install the R language interpreter and RStudio, the popular R integrated development environment. We’ll learn how R can be extended with modules called packages and discuss some of the popular packages in use. We’ll delve into the unique features of R that make it so suitable for data science. The core R data structures; vectors, matrices, arrays, and data frames, will be discussed with examples. Before moving into predictive modeling, we’ll do a quick overview of key concepts in statistics. From there, we will walk through the training, testing and evaluation of a predictive model. Since many people will be using data from relational databases, we will explain how to use the RODBC package to read in data using a SQL Server table as an example. The course wraps up by discussing related topics such as scaling R programs, creating R based web applications, and creating dynamic presentations with R Markdown.

Administering-Business-Intelligence Administering Business Intelligence New!

Administration of SQL Server can often be as simple as query tuning a T-SQL statement or configuring a server properly. When a Business Intelligence developer gets a hold of other ‘cool’ features provided in Standard or Enterprise Edition of SQL Server, then the range of knowledge a DBA has needs to keep up with developers. The administrator does not need to know how to develop an integration service (SSIS) package or create a calculated measure in analysis services (SSAS), but it is good to understand what is needed to help debug and maintain the features used in their enterprise IT systems. Most shops do not use all these components, but most do use more than one.

PowerShell Introduction to PowerShell New!

This class is designed to overview and equip you with the basics of Windows PowerShell, Microsoft’s designated tool for automation within the Windows Environment. This course will introduce you to the tools necessary for using PowerShell, the foundations of Commands (called cmdlets), the PSProvider, and the Pipeline. After this we will cover more domain specific topics for Data Professionals Including cmdlets for traditional DBA workloads (DML, DDL, DCL), cmdlets for Reporting Services, community-built cmdlets, and the SMO provider. Finally, we will introduce PowerShell DSC, a Declarative framework for configuring systems, which may be used for Installing and Configuring SQL Server. By the end of this course you should feel comfortable with the command line in Windows and will be able to write your own scripts for managing SQL Server.


Excel Pack
$295
Per user per year
  • 3 Excel Courses
  • Class Samples and Labs
  • Data Sheet
Enroll
Power BI Pack
$595
Per user per year
  • 10 Power BI Courses
  • Class Samples and Labs
  • Data Sheet
Enroll
SQL Server Admin Pack
$795
Per user per year
Enroll
Business Intelligence Pack
$995
Per user per year
Enroll
  • In-Depth Course Content

    Each On-Demand Training purchase comes with class labs, assessments, certifications and deep-course content. Our content is updated constantly as the different platforms update.

  • Reporting

    Monitor the progress of your students or employees. Track their progress, assessments scores and completed courses to measure retention. All courses have certificates of completion that can be printed after passing the course.

Testimonial What People Say About Us

This company is a great resource for learning new techniques. Highly recommended!

Cindy Hernandez
Cindy Hernandez
Flint Hills Technical College

Quality, easy to understand classes - anytime and anywhere.

Rebecca Byrd
Rebecca Byrd
Republic Bank

We have loved this training for our employees. It has helped us in our on boarding.

Nathan Allphin
Nathan Allphin
Xerva

I am really impressed with the course content. The instructors know what they are talking about.

Shashwat Chavan
Shashwat Chavan
Fuzion

The industry experience that goes into these courses is invaluable.

Catherine Ingalls
Catherine Ingalls
Astoria Bank

Pragmatic Works definitely has the best training material for SQL and MS BI related topics.

Chris Anthony
Chris Anthony
IUSM

As a user with zero experience, the Power BI Pack On-Demand Training has been a great introduction!

Allie Bleier
Allie Bleier
Staples

Great way to be updated on Microsoft offerings in a very efficient way in time and money.

Eduardo Carlo
Eduardo Carlo
Plains Capital

The Pragmatic Works courses I took allowed for me to immediately make an impact at my organization.

Troy Hill
Troy Hill
White Lodging Services Corp
On-Demand Training
Call Us At: (904) 413-1911

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.

Excel Pack
$295
Per user per year
  • 2 Excel Courses
  • Class Samples and Labs
Enroll
Power BI Pack
$595
Per user per year
  • 8 Power BI Courses
  • Class Samples and Labs
Enroll
SQL Server Admin Pack
$795
Per user per year
  • 6 DBA Courses
  • Class Samples and Labs
Enroll
Business Intelligence Pack
$995
Per user per year
  • 16 BI Courses
  • Class Samples and Labs
Enroll