<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 Custom Visuals - Custom Calendar by Akvelon

Posted Sep 28, 2017 by Devin Knight

In this module, you will learn how to use the Custom Calendar by Akvelon.  The Custom Calendar by Akvelon is a calendar that allows you to display multiple metrics on each individual day of a month view.

Stay on Top of Development Tests with LegiTest

Posted Sep 26, 2017 by Philip de la Cal

From calendar alerts to information about our day, notifications allow us to never miss a thing. But what about in our work environment? Imagine it's closing time on a Friday and you execute a package or test knowing it will take hours, and leave for the weekend. What happens when it's Monday morning, you walk in expecting your results and see an error occurred moments after you left for the weekend? This situation can happen to anyone. Not only is it a huge waste of time, but it can be avoided.

Free POC Offer for Task Factory's Address Verification Feature!

Posted Sep 22, 2017 by Jeremy Sirois

As a consumer or potential customer, I’m often required to fill in my address details when completing a web form on various sites. The idea is this, I go from a potential lead into your database, which can then be marketed to in the form of email outreaches or physical mail campaigns where brochures or coupons are sent to my physical address.

Power BI Custom Visuals - Heatmap

Posted Sep 21, 2017 by Devin Knight

In this module, you will learn how to use the Heatmap Custom Visual.  The Heatmap is useful for showing data density on a map. It does this well because it aggregates data points and plots them to colors on a map.

Keys to a Successful Data Platform Migration

Posted Sep 20, 2017 by Pragmatic Works

Have you started your data platform migration yet? If not, you can be certain that your competitors have either already migrated, or will be soon. What are you waiting for? A modern data platform opens a wealth of opportunities for your organization.

Finding Errors in Packages Easily with BI xPress

Posted Sep 19, 2017 by Philip de la Cal

'Are you sure it's not working? It was working just fine on my computer.' Sound familiar?

Errors are a part of production, but when going from development to production under a time crunch, you simply may not have the time or the workforce to go back and search through endless SQL statements and data flows. Maybe a SQL statement changed, or maybe your connection manager was altered, but what if it was something so small, it is almost impossible to find?

Confident Cloud Migrations

Posted Sep 18, 2017 by Pragmatic Works

Conversations about your cloud strategy are probably the focus of many business meetings today. And if they’re not, they should be. You may ask, ‘Is everyone moving to the cloud?’ The answer is Yes!

USPS Address Verification Using Task Factory

Posted Sep 14, 2017 by Brian Knight

You’ll probably agree that one of the most valuable assets to your company is your customer database. But do you know that bad data in your client addresses can cost you thousands of dollars each year? 4.7% of ecommerce address data is undeliverable as entered by customers and 35% is undeliverable is due to undeliverable addresses. The average company loses $254 per 1,000 pieces of mail returned.

Power BI Custom Visuals - Dynamic Tooltip by MAQ Software

Posted Sep 14, 2017 by Devin Knight

In this module, you will learn how to use the Dynamic Tooltip Custom Visual by MAQ Software.  The Dynamic Tooltip allows you to add extra insight to your report or visuals with a popup that provides additional information.

Use DOC xPress Snapshot Compare to Find Changes in Your Environment

Posted Sep 13, 2017 by Philip de la Cal

"What happened to my code? My expressions all worked last night!" Sound familiar?

For many developers and DBAs, this is all too common. Sometimes development can change overnight. A new team member implemented a change, a contractor came in while you were out of town; the possibilities for error are endless.

Power BI Custom Visuals - Impact Bubble Chart

Posted Sep 07, 2017 by Devin Knight

In this module, you will learn how to use the Impact Bubble Chart Custom Visual.  The Impact Bubble Chart is an animated bubble chart that allows you to compare two entities against each other.

Quickly and Accurately Write SQL Queries with LegiTest

Posted Sep 05, 2017 by Philip de la Cal

As someone in the tech/development scene, I realize that most of us type quickly, think quickly and our hands often have a hard time keeping up with us. A frustrating part of production is rewriting and typing similar queries repeatedly!

Blog Comments

Need help with this topic? Ask the author below.


Subscribe to Blog Updates