Pragmatic Works Blog

Company blog for some of our Pragmatic Works employee to write about company happenings and about the software business.

Exploring Excel 2013 for BI: Quick Explore

On Jul 02, 2015 by Steve Hughes

Excel is a powerful tool that is used by almost everyone is the business world. Because of its numerous capabilities, Excel has many functions that can often be confusing to users. In this new blog series Our resident expert, Steve Hughes, will cover a wide variety of Excel topics ranging from easy to complex. Steve will provide you tips and tricks he has discovered in his journey through Excel.

Quick Explore

So, you have connected Excel to your SSAS cube. You really wish you could cross drill easily in the product. If you have used PerformancePoint Services you know the process. Right click on the bar or cell and then choose the dimension to drill to using the information you clicked on as a starting point. You can now do this in Excel 2013 using Quick Explore. Here’s how to do it:

Read More »

Tagged With: SSAS, Excel, Excel at Excel

Preparing a Technical Session Part 1: Picking a Topic

On Jun 30, 2015 by Devin Knight

So you’ve decided or perhaps were told to do a technical presentation. If this is something that’s new for you, then you may be going through a variety of emotions. You may start feeling excited in anticipation of the event, but often that quickly that changes to anxiety as you realize the amount ofwork ahead of you. As an experienced technical presenter, I understand what you're going through and the challenges you'll face throughout the process. 

Read More »

Tagged With: Professional Development

Looping Through a Result Set with the ForEach Loop

On Jun 24, 2015 by Shawn Harrison

In today's blog post, I am going to show you another use for the ForEach Loop container in SSIS. Most of the time, this container is used for looping through a group of files, however, there are many different uses for it.

Read More »

Tagged With: ssis

Why You Should Care About Data Testing

On Jun 22, 2015 by Robert Cain


It has long been a staple of the application world, but far less so in the world of data-centric development. Testing should be critical at every stage of development, especially at the data level.

Read More »

Tagged With: Products, Data Testing

Creating a SQL 2016 CTP2 Virtual Machine in Azure

On Jun 17, 2015 by Devin Knight

With the CTP2 of SQL Server 2016 now released, you may be eager to try it out. One of the best ways to do this in my opinion is to set it up on a virtual machine. You could certainly do this with VMWare or Hyper-V but my new preference for creating VMs is Azure.

Read More »

Tagged With: Azure

What is a Data Lifecycle Assessment?

On Jun 11, 2015 by Devon Stiles

Understanding the importance and value of data is crucial for success in today's data-driven world. Organizations who haven’t prioritized data maturity often struggle with confidence in decision making and miss out on opportunities that leave them falling behind the competition. Over the years, we've helped more than 7500 customers globally across industries such as banking, insurance, financial services, automotive and education to implement and execute strategies that leverage and manage their data as an asset while creating a vision for the future. 

Read More »

Tagged With: DLO

We're Headed to Sunny South Florida for SQLSaturday!

On Jun 08, 2015 by Liz Hamilton

So many SQLSaturdays, so little time! This weekend, we'll be at SQLSaturday South Florida in Davie. Several of our consultants will be speaking on various topics related to SQL Server and Power BI. Keep reading for more information on all the sessions from our industry experts:

SQLSaturday South Florida Details

When: Saturday, June 13, 2015

Where: Nova Southeastern University, Carl DeSantis Building, 3301 College Ave, Davie, FL 33314

Read More »

Tagged With: Company Info, SQLSaturday

What is LegiTest?

On Jun 03, 2015 by Robert Cain

Testing has long been a core component of traditional software development. Over the years many tools and testing frameworks have emerged to assist developers in testing their applications to ensure a higher quality product.

Sadly, those tools have been lacking in the world of data centric development. There are some tools to assist with testing some aspects of data centric development, but a huge need has gone unfilled for a single tool to perform comprehensive testing across all areas of data centric development.

Until now.

Pragmatic Works has answered the call for a comprehensive testing tool with its newest product: LegiTest.

Read More »

Tagged With: Company Info, Products

SSAS Tabular vs. SSAS Multidimensional - Business Logic

On May 29, 2015 by Alan Faulkner


In Part I of the SSAS Tabular vs. SSAS Multidimensional – Which One Do I Choose? series, we began to set the stage for looking at 5 high level considerations to answer this question. In Part II, we explored the Scalability and Performance considerations between the two technologies. In  Part III, we explored the characteristics of the data and the model required to deliver the analytics and reporting required. In this installment, we will cover how to extend the capabilities and characteristics of your data model through the use of business logic.

Read More »

Tagged With: SSAS

Power BI with Azure SQL Database

On May 28, 2015 by Devin Knight

**Information is current as of 5/21/2015**

Recently Azure SQL Database was added as a new connection to the Power BI Preview. Read the notes about how it can be used here. The things I found especially worth noting were:

Read More »

Tagged With: Azure, Power BI

Some of our clients