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.
Pragmatic Works Blog
Company blog for some of our Pragmatic Works employee to write about company happenings and about the software business.
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.
Tagged With: Company Info
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.
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.
Tagged With: Azure
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.
Tagged With: Excel
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.
Tagged With: ssis
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.
Tagged With: Company Info
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.
Tagged With: Webinar
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.
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.
Tagged With: SQLSaturday