Pragmatic Works Blog

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

SSAS Multidimensional vs Tabular - Part 1

On Mar 27, 2015 by Alan Faulkner

Have you been or are you currently working on a project where you are trying to determine which flavor of Analysis Services (Tabular or Multidimensional) you should have used or should use? Recently, I was doing a presentation on SSAS Multidimensional best practices and following the presentation one of the attendees asked a very good question, “When it comes to SSAS Tabular versus SSAS Multidimensional how do I know which one to choose?” We discussed some of the various aspects of each one, but during the conversation I realized I needed to put a presentation and ultimately a blog post together on this topic.

Read More »

Tagged With: SSAS

Fast Track to a Closed Support Case

On Mar 24, 2015 by Haley McKinney

The Pragmatic Works' Support Team is always prepared to assist with any issues you may encounter when using our software. Our team of support technicians are experienced with our products and SQL Server. As programs and platforms grow and evolve, we are constantly training to keep up with any product changes and new features. Whether you have a simple activation request or a more complicated problem, we are ready to spring into action and assist you in any way. 

Read More »

Tagged With: Company Info

Creating SSRS Reports Efficiently Through Best Practices

On Mar 20, 2015 by Mickey Stuewe

On Tuesday, March 3, 2015, I had the privilege of speaking for Pragmatic Works. For the month of March, they are highlighting Women in Tech and have the whole month lined up with female speakers for every Tuesday and Thursday at 11am ET. 

Read More »

Tagged With: Webinar, SSRS

Math and Azure Machine Learning

On Mar 12, 2015 by Ginger Grant

Business and predictive analytics are the pinnacle of a mature data lifecycle, and Machine Learning is an exceptional tool providing in-depth statistical analysis of data. One of the common misconceptions about Machine Learning is the level of mathematical experience required, and Pragmatic Works' Business Intelligence Consultant and Data Aficionado Ginger Grant is on a mission to set the record straight. In her upcoming webinar, Complex Data Analysis and Azure Machine Learning, she'll be explaining how to leverage Azure ML to analyze cloud data without having to know a lot of complex formulas. 

Read More »

Tagged With: Azure

Replicating Excel Percentile in DAX

On Mar 10, 2015 by Josh Owen

The lack of a percentile function in DAX is a commonly brought up challenge. In order to replicate a version that matches what the Excel Percentile.INC (inclusive) function does, you have to jump through a few hoops. This process involves having to create several measures to hold some intermediate values to apply a final formula. In theory, you could do it all in one DAX expression, but it would very difficult to read and test. Here's a step-by-step guide for replicating Excel percentile in DAX. 

Read More »

Tagged With: Excel

How to Set SSIS Encryption Level Protection within Visual Studios 2012

On Mar 05, 2015 by Ken Wood

You’ve just completed building your SSIS package; your hopes are set high on your newly created project becoming the company's number one tool for data building, organization and formatting. Surely that unreachable career tier level will finally be reached with the successful execution of just this one package within SSIS. You save your work and immediately execute the newly created package just to be greeted by a series of ugly error messages.

Read More »

Tagged With: ssis

March Employee Spotlight on Shawn Harrison

On Mar 03, 2015 by Liz Hamilton

At Pragmatic Works, we believe that our employees are the cornerstone of our success. Our staff is made up of many extremely talented professionals, and we believe in recognizing their achievements and hard work. Each month, we feature one of our stellar employees that often goes above and beyond the call of duty as a small way of saying thank you. This month we're highlighting Shawn Harrison, one of our talented Product Specialists. 

Read More »

Tagged With: Company Info

Highlighting Women in Tech: March Free Training on the T's Webinars

On Feb 27, 2015 by Liz Hamilton

Every year in March, the National Women's History Project celebrates Women in History Month. This year's theme is focusing on weaving the stories of women's lives and the impact they've had individually and as a whole on our nation's history. For centuries, women have been contributors in technology, and they've made a significant impression on the field.

Ada Lovelace is attributed with creating what many consider to be the first computer program in 1840.  In 1946, Dr. Grace Hopper helped develop the Eniac, one of the first electronic digital computers. By the 1960s, women held 30 to 50% of programming jobs; however, that percentage has since decreased.

Today, women make up only 25% of the data technology field in totality. At Pragmatic Works, our staff consists of approximately 20% women  not unusual according to the book Women in Data.

Read More »

Tagged With: Webinar

Object Variable: How to Make Your Packages Dynamic in SSIS

On Feb 23, 2015 by Manuel Quintana

Greetings everyone, and thank you for taking the time to look at this blog. This is my first post and I hope I’m able to answer some of your questions about building packages in SSIS. In this post I will be showing you how to use the object variable to make packages dynamic while using Task Factory, a SSIS product by Pragmatic Works.

Read More »

Tagged With: ssis, Products

Learn About Data Factory at SQLSaturday Phoenix

On Feb 19, 2015 by Josh Luedeman

I have been speaking a lot over the past year. Much more than I have spoken in years past. I’ve moving from town to town like a ninja, speaking at SQLSaturdays. SQLSaturdays are free training events that are held internationally, where speakers like myself and others, come to town and speak on a multitude of subjects relating to SQL Server. On February 28th, 2015, I will be speaking at SQLSaturday #370 in Phoenix, AZ.

Read More »

Tagged With: SQLSaturday

Some of our clients