Innovative Strategies for Your Data Needs

With the right team, the right knowledge and the right solutions, your business can operate optimally and leverage data as an asset. Our team of consultants are Microsoft MVPs with real-world experience and in-depth insight to deliver successful data platform solutions at all levels. The strong relationship we’ve built over the years with Microsoft positions us as the best partner to advise you on your data journey.

Architecture and Configuration
Build a resolute architecture for your data platform that takes into consideration new technologies such as cloud and nontraditional data.
Learn More
Availability and Continuity
Leverage both on premise and cloud solutions and test your processes for validity to ensure optimal performance in any situation.
Learn More
Performance and Optimization
Identify performance goals, assess current enterprises and implement an optimization plans to make your data lifecycle best in business.
Learn More
Business Intelligence
Valuable enterprise BI solutions are tightly integrated with transactional or business systems, pacing their changes and release schedules while opening its data to more advanced specialized analysis tasks.
Learn More
Big Data Architecture and Deployment
Add value to your data platform with an integrated solutions providing unparalleled access to Big Data tools and infrastructures.
Learn More
Business and Predictive Analytics
The pinnacle of a mature data lifecycle is when all the other lifecycle stages align in supporting the right data availability, at the right speed and with the right integration to other sources of information.
Learn More
Pragmatic Works Staffing
Pragmatic Works takes a modern approach to staffing by ensuring you have the right resources with the technical skills to match your company’s needs and that those resources are backed by our consulting team experts.
Learn More

Learning Paths

Introduction to T-SQL

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

Learn More

Data Modeling

This course covers two separate modeling techniques, transactional systems and dimensional modeling.

Learn More

Data Science with Azure ML

The Data Science course goes in-depth within the data science and machine learning process.

Learn More

Big Data for Beginners

Big Data is a new and complex ecosystem of technologies that can revolutionize the way your business acquires, processes and manages data.

Learn More

Advanced T-SQL

Advanced Querying with T-SQL is an intensive course designed specifically for SQL developers.

Learn More

Introduction to SSIS

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.

Learn More

Introduction to SSAS

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 More

Introduction to SSRS

This course designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server develo...

Learn More

Interactive Dashboards with Excel

This course is for data analysts, data wranglers, spreadsheet developers and managers looking to design work for decision makers.

Learn More

DBA Fundamentals

This course gives a step-by-step overview of SQL Server and will review installing SQL Server.

Learn More

Introduction to T-SQL

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

Learn More

Data Modeling

This course covers two separate modeling techniques, transactional systems and dimensional modeling.

Learn More

Data Science with Azure ML

The Data Science course goes in-depth within the data science and machine learning process.

Learn More

Big Data for Beginners

Big Data is a new and complex ecosystem of technologies that can revolutionize the way your business acquires, processes and manages data.

Learn More

Advanced T-SQL

Advanced Querying with T-SQL is an intensive course designed specifically for SQL developers.

Learn More

Introduction to SSIS

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.

Learn More

Introduction to SSAS

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 More

Introduction to SSRS

This course designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server develo...

Learn More

Interactive Dashboards with Excel

This course is for data analysts, data wranglers, spreadsheet developers and managers looking to design work for decision makers.

Learn More

DBA Fundamentals

This course gives a step-by-step overview of SQL Server and will review installing SQL Server.

Learn More

Introduction to T-SQL

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

Learn More

Data Modeling

This course covers two separate modeling techniques, transactional systems and dimensional modeling.

Learn More

Data Science with Azure ML

The Data Science course goes in-depth within the data science and machine learning process.

Learn More

Big Data for Beginners

Big Data is a new and complex ecosystem of technologies that can revolutionize the way your business acquires, processes and manages data.

Learn More

Advanced T-SQL

Advanced Querying with T-SQL is an intensive course designed specifically for SQL developers.

Learn More

Introduction to SSIS

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.

Learn More

Introduction to SSAS

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 More

Introduction to SSRS

This course designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server develo...

Learn More

Interactive Dashboards with Excel

This course is for data analysts, data wranglers, spreadsheet developers and managers looking to design work for decision makers.

Learn More

DBA Fundamentals

This course gives a step-by-step overview of SQL Server and will review installing SQL Server.

Learn More

Introduction to T-SQL

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

Learn More

Data Modeling

This course covers two separate modeling techniques, transactional systems and dimensional modeling.

Learn More

Data Science with Azure ML

The Data Science course goes in-depth within the data science and machine learning process.

Learn More

Big Data for Beginners

Big Data is a new and complex ecosystem of technologies that can revolutionize the way your business acquires, processes and manages data.

Learn More

Advanced T-SQL

Advanced Querying with T-SQL is an intensive course designed specifically for SQL developers.

Learn More

Introduction to SSIS

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.

Learn More

Introduction to SSAS

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 More

Introduction to SSRS

This course designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server develo...

Learn More

Interactive Dashboards with Excel

This course is for data analysts, data wranglers, spreadsheet developers and managers looking to design work for decision makers.

Learn More

DBA Fundamentals

This course gives a step-by-step overview of SQL Server and will review installing SQL Server.

Learn More

Learning Paths

All BI Architect BI Developer ETL Developer Cube Developer Report Developer Business Analyst DBA Data Scientist

Our Experts

All Leadership Marketing Support

Brian Knight

Brian Knight is the owner and founder of Pragmatic Works and is a serial entrepreneur, starting up other companies throughout his prolific career. Brian is a contributing columnist at several technical magazines and does regular webcasts. He is the author of more than fifteen technical books. Brian has spoken at dozens of conferences like PASS, SQL Connections and TechEd and many Code Camps. He has received a number of awards from the state, governor and press including the Business Ambassador Award (Governor) and Top CEO (Jacksonville Magazine). He is on the board of the region’s Chamber of Commerce and Economic Development Corporation.

See Bio

Tim Moolic

Tim Moolic has more than 20 years of experience executing sales, marketing and alliance strategies for software and consulting companies. Tim founded his first software and consulting business in 1996 and has worked with a wide range of enterprise software solutions including systems management, automated testing, database and online collaboration tools. As a Principal Partner with Pragmatic Works, he has helped the company grow from its first sale to more than 7,500 customers worldwide with a focus on the SQL Server DBA, Developer and the Power BI Data Consumer.

See Bio

Adam Jorgensen

Adam Jorgensen has over 15 years of experience leading organizations to exponential growth through transformational change. His focus is on creating organizational systems that equip high potential teams, empower them through insights and engage them to drive their growth. He also serves on multiple boards including as Executive Vice President of PASS, the nonprofit global community of data professionals with over 200,000 members. He has been speaking and writing on these topics for over a decade. Adam is often a featured expert in media coverage, trade publications and industry events as an expert in data culture, insights and strategy. He has authored more than a dozen books on similar topics.

See Bio

Robert Beatty

Robert Beatty has proven experience in leading strategic partnerships, marketing, solution sales, professional services, software sales and channel business development teams and initiatives. With more than 20 years of experience building and leading sales, Robert has founded/co-founded 3 companies all focused on the Microsoft data platform. Robert now leads the Alliance line of business for Pragmatic Works, which has over 6,000 customers worldwide and is aligned with some of the largest Fortune 500 companies. Robert continues to add bottom line revenue to the company by creating more alliance partners that support the Microsoft Data and Cloud Platform.

See Bio

John Welch

John Welch leads the development of a suite of products that make developing, managing and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.

See Bio

Ryan Dowd

As Vice President of Sales, Ryan is responsible for the strategic growth of our enterprise business units across the world. Having risen through the ranks from Director of Regional Sales, Ryan works closely with our Microsoft partners and our Alliance team to grow and expand upon existing partnerships and create new opportunities for joint initiatives. Ryan leads our high-performing sales team and is pivotal in crafting our go-to-market messaging.

See Bio

Data Lifecycle Optimization

Treating your data lifecycles like the circulatory system of your company allows you to approach it’s design, implementation and optimization with the right perspective and avoid potential imbalance resulting in performance degradation and missed opportunities. Our Data Lifecycle Optimization strategy is the leading framework for assessing, planning, optimizing and maturing your data lifecycle. This framework was born out of the collective expertise of Pragmatic Works and cultivated into a model that:

Creates remarkable value in measurable and repeatable ways
Increases the maturity of the strategies, systems, tools and teams involved
Leverages the best methods and techniques to achieve the most mature and impactful data experience for your organization

Data Lifecycle Optimization (DLO) is centered on the 6 stages of a successful data lifecycle which address strategy, tactics, readiness and tooling. Embracing a strategy that focuses on business readiness and data integrity will not only empower your business decisions, it will position your organization for growth and innovation.

Learn more

Testimonial What people say about us

We got Task Factory mostly because of PragmaticWorks reputation for the service they provide and the specific need of a secure SFTP task.

Matt Cushing

Loews Corporation

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.

Gabriel Gray

University of Calgary

Innovative Strategies for Your Data Needs

Speak With a Strategist

Architecture and Configuration

Availability and Continuity

Performance and Optimization

Business Intelligence

Big Data Architecture and Deployment

Business and Predictive Analytics

Pragmatic Works Staffing

Learning Paths

Learning Paths

Introduction to T-SQL

Data Modeling

Data Science with Azure ML

Big Data for Beginners

Advanced T-SQL

Introduction to SSIS

Introduction to SSAS

Introduction to SSRS

Interactive Dashboards with Excel

DBA Fundamentals

Advanced SSIS

Introduction to MDX

Mobile Reports and Dashboards with SSRS 2016

Power BI Desktop and Dashboards

SQL Server Hardware and Configuration

Introduction to SSAS Tabular

Advanced SSRS

Introduction to DAX

SQL Server High Availability

Introduction to DAX

Sharepoint BI

Advanced DAX

SQL Server Performance Tuning

Advanced DAX

Power BI Custom Visuals

Advanced SSAS

Power BI with Excel

Power Query for Business

Our Experts

Brian Knight

Tim Moolic

Adam Jorgensen

Robert Beatty

John Welch

Ryan Dowd

Data Lifecycle Optimization

Testimonial What people say about us

Resources

Blog

Cheatsheets

Webinars

Case Studies

Our Clients 96% of fortune 100 companies trust pragmatic works:

Get product and training updates