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

Easily Manage Your Data From Constant Contact 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