Information is good. Insight is even better. RBA helps extract critical business intelligence to give your organization a competitive advantage and your teams the knowledge to move your business forward.



October 27, 2014

[Tutorial] Automating Data Cleaning and Validation with DQS and SSIS, Part 2

[Tutorial] Automating Data Cleaning and Validation with DQS and SSIS, Part 2-01

  In part 1 of this article, I outlined how a data steward – a person who is responsible for data quality and typically not on the IT staff – would create a collection of rules that can be used to automate data cleansing and address verification http://blog.rbaconsulting.com/automating-data-cleaning-and-validation-with-dqs-and-ssis-part-1/ .  In… Read More


October 21, 2014

[Tutorial] Automating Data Cleaning and Validation with DQS and SSIS, Part 1

[Tutorial] Automating Data Cleaning and Validation with DQS and SSIS, Part 1-01

Automating Data Cleaning and Validation with DQS and SSIS, Part 1   I have been doing some work with SQL Server Data Quality Services (DQS) in preparation for SQL Saturday in Salt Lake City (https://www.sqlsaturday.com/349/eventhome.aspx ).  Part of my code demo involves validating addresses using MelissaData Address Check.  Address data… Read More


June 2, 2014

[Tutorial] A Few Thoughts on PowerBI

I recently had an opportunity to present at a Microsoft technology roadmap event here in the Denver area on PowerBI.  In preparing for this presentation I had to take a stroll down memory lane… well more like a memory dark alley where monsters I’d rather forget are still lurking. Back… Read More