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

Validate Your Data Before Your End Users Invalidate You

Posted Oct 30, 2017 by Pragmatic Works

Database testing is a critical aspect of development. BI and Data Warehouse testing is another level of testing that is key to ensuring the quality of your data throughout your BI system. Data quality, or lack of it, is a focus of many these days. Bad data is an epidemic, and data testing is the key to solving the epidemic while allowing you to have confidence in your data.

Power BI Custom Visuals - Cylindrical Gauge

Posted Oct 26, 2017 by Devin Knight

In this module, you will learn how to use the Cylindrical Gauge Custom Visual by MAQ Software.  The Cylindrical Gauge can be helpful for visualizing a single metric on your report.

Join Us at PASS Summit 2017 and SQL Karaoke!

Posted Oct 24, 2017 by Pragmatic Works

Pragmatic Works is excited to once again participate in the 18th annual Professional Association of SQL Server Summit (PASS) in Seattle, Washington. PASS Summit is the world's largest technical training conference for Microsoft data professionals to come together and gain access to the latest training and educational opportunities. 

Easily Handle Transform and Load of SCD2 (Type 2 Slowly Changing Dimensions)

Posted Oct 20, 2017 by Delora Bradish

This blog post is about type two slowly changing dimensions (SCD2). This is when an attribute change in row 1 results in SSIS expiring the current row and inserting a new dimension table row like this --> 

Power BI Custom Visuals - Heat Streams

Posted Oct 19, 2017 by Devin Knight

In this module, you will learn how to use the Heat Streams Custom Visual.  The Heat Streams visual allows you to visualize and compare a categorical value over time.

Easily Mark Deleted Source System Rows in a Data Warehouse Table

Posted Oct 17, 2017 by Delora Bradish

Even though many people think data warehouses ETLs (extract, transform and load) should contain insert data flows only, the vast majority of people I work with also have to deal with updates. Many also have to handle marking data warehouse rows as IsDeleted = "Y" in their ODS and EDW data repositories.

If you are working with a dimension table with less than 500K rows (an estimate), a traditional lookup task might work just fine. The data flow would look like this:

Read and Write to Constant Contact with SSIS Using Task Factory

Posted Oct 16, 2017 by Pragmatic Works

Manually importing and exporting data from web services can be a time-consuming task. A popular web service used today is Constant Contact for sending emails to your customers. Wouldn’t it be great to get data into or out of Constant Contact in a more automated way using SSIS?

Inspect Your Environment for Best Practices Adherence with BI xPress

Posted Oct 12, 2017 by Pragmatic Works

We get it, you’ve got all kinds of data packages and projects running across your environment; how can you ensure these are tested for adherence to best practices? How can you be sure you and your team are establishing a high level of excellence across your entire environment?

Power BI Custom Visuals - HTML Viewer

Posted Oct 12, 2017 by Devin Knight

In this module, you will learn how to use the HTML Viewer.  The HTML Viewer allows you to display the results of HTML code within your Power BI reports.

Quickly and Easily Generate Test Data with BI xPress

Posted Oct 11, 2017 by Pragmatic Works

Searching, managing, maintaining, and generating test data takes time. Data preparation is a time-consuming phase of the software testing; and who really has all this time? Most of us don’t.

Increase Developer Productivity with BI xPress

Posted Oct 05, 2017 by Pragmatic Works

Developers are always looking for ways to save time and increase productivity. Wouldn’t it be great to have tools that would help you maximize efficiency and create more reliable packages?

Power BI Custom Visuals - Timeline Storyteller

Posted Oct 05, 2017 by Devin Knight

In this module, you will learn how to use the Timeline Storyteller.  The Timeline Storyteller is a great way to tell a story about your data. It gives you the ability to create multiple representations of your data and then pull them together by creating multiple scenes.

Announcing Our New Course - Introduction to Tableau!

Posted Oct 02, 2017 by Pragmatic Works

Do you work with data and want to learn more about developing using Tableau? If you’re looking to break into using Tableau, our new in-depth course, Introduction to Tableau, is the course for you! This course will teach you all the basics and fundamentals you’ll need to become a thorough Tableau developer.

What's Going On in October?

Posted Oct 01, 2017 by Pragmatic Works

Fall is finally here! For most, that means football season is back in full swing, the air is starting to feel crisp and cool, and you can find pumpkin-flavored treats everywhere. Here at Pragmatic Works, we are ramping up for a busy month. With multiple bootcamps and PASS Summit 2017, you'll find us traveling all around the country educating tech professionals about our software suite, training offerings and consulting services.

Check out what we have coming up this month!


Blog Comments

Need help with this topic? Ask the author below.

 

Subscribe to Blog Updates

Categories

show all categories