Validation always feels good! Last week, Microsoft and Adobe announced a strategic partnership “that will redefine how enterprises manage their marketing, sales and services to better engage with customers across all touch points” as stated in their April 29, 2015 press release. For marketers and business decision makers, this is… Read More
Data Management & BI
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.
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
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
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