<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Pragmatic Works Blog

Your source for SQL Server and Business Intelligence expert insight and the latest Pragmatic Works' news.

Power BI Focus for April's Training on the T's

Posted Mar 30, 2015 by Devon Stiles

Power BI is always a popular training topic at Pragmatic Works. The versatile platform brings together data so it can be analyzed in seconds across a multitude of devices. With the numerous recent updates and introduction of Power BI Designer, we’re focusing our free Training on the T’s webinars for April on Power BI.

This month’s free training will include sessions on leveraging Power Query, Power Map, Power Pivot and Excel Power Tools with leaders in the BI community including members of the Pragmatic Works team. We’re even featuring a bonus Power BI Panel to answer your top questions.

SSAS Multidimensional vs Tabular - Part 1

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

Fast Track to a Closed Support Case

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

Creating SSRS Reports Efficiently Through Best Practices

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

Math and Azure Machine Learning

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

Replicating Excel Percentile in DAX

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

How to Set SSIS Encryption Level Protection within Visual Studios 2012

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

March Employee Spotlight on Shawn Harrison

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

Subscribe to Blog Updates