Our whitepapers, case studies and cheat sheets are designed to assist you on your journey through SQL Server and Business Intelligence. Whether you're a beginner or expert, we have the material to guide you on your data journey.
Learn how the University of New Haven transformed their reporting environment with Power BI.
Learn first hand how MOTOR improved data quality and increased productivity with LegiTest.
We'll review the keys to a successful data platform migration and discuss the top reasons companies
This guide will help equip you to confidently discuss what’s happening in the cloud landscape.
This case study describes how Pragmatic Works implemented Task Factory components to help East Coast
This case study describes how Pragmatic Works implemented Microsoft Azure SQL Database (v12) to help
This case study describes how Pragmatic Works architected a scale-out solution that essentially doub
This case study describes how Pragmatic Works saved an oil and gas company in both man hours and res
This case study describes how Pragmatic Works used Microsoft "R" and the Azure Cloud to help the ana
This case study describes how Pragmatic Works used Predictive Analytics and Azure Machine Learning t
Use this cheat sheet for basic DAX calculations.
This case study describes how MetaBank's Meta Payment Systems (MPS) division leveraged Workbench to
This case study describes how The Energy Authority leveraged LegiTest's automated data testing to im
Get an overview of how you can use SSRS 2016 for on-premise reporting.
Learn how to get your organization's Predictive Analytics project off the ground in 30 days.
In this case study, you'll learn how Pragmatic Works' Task Factory helped The University of Calgary
In this whitepaper, you will learn what it means to be a world class data organization, the importan
Part 3 of this series covers verifying data in production.
In this case study, you'll learn how Pragmatic Works doubled a large human resources consulting firm
In this case study, you'll learn how we assisted a large, non-profit health agency in meeting their
In this case study, you'll learn how a large manufacturing company saw dramatic performance improvem
In this case study, you'll learn how Mobile Medsoft increased productivity and performance through a
In part 2 of this whitepaper series, we will cover some important concepts on what sort of things yo
For anyone new to Reporting Services this cheatsheet will get you the right start on making your rep
MDX is one of the most difficult database languages to learn. This cheatsheet will help you get started.
Find common SSIS expression that will help jumpstart your development.
The challenge with SSIS, though, is identifying a problem once you deploy your packages to productio
Prove your SSIS skills by besting the experts at Pragmatic Works! This Whitepaper is designed to hel
This whitepaper walks you through a crash course in the SSIS expression language across all componen
Learn about the benefits of migrating your SQL Server 2000 Data Transformation Services (DTS) packag
This whitepaper discusses how to configure packages so that you can have zero-touch deployments. We'
This whitepaper will focus on how to overcome the gaps that expressions leaves by using custom code.
As a SQL Server BI Pro developing SSIS packages, you often encounter situations and scenarios that h
The goal of this white paper is to expose you to the process needed to create a BISM Tabular Model i
Database administrators face the challenge of keeping costs low while providing the required feature
Proper maintenance and tuning of indexes is a critical part of a database administrator's job. This
SQL Server Performance issues can often be resolved without costly hardware upgrades. This white pap
In this experiment, several different statistical modeling methods/algorithms will be used in an att
Understanding the significance of your data lifecycle and treating it like the circulatory system of
In part one of this three-part series, John explains what data-centric testing is, and provides an