Cognitive Information

Archive for BI/DW Projects

Return on Data – InnoTech Download

Thank you to all who attended today’s ‘Return on Data’ session at the 10th Annual InnoTech in Oklahoma City. This session helps chart the waters through the sea of options when working with data. IT departments need tools to turn data into useful information for users. Instead of ROI, this session talks about ‘Return on […]

SpotFire for Analytics

This is just a quick review of initial impressions of working with SpotFire for business analytics from multiple data sources.

Downloads for SQL Saturday #396 – Dallas BI Edition

Here are the downloads for today’s sessions at SQL Saturday #396, Dallas BI Editoni. BI Basics: Finding Return on Data   Kimball’s not Dead:  Dimensional Modeling Basics   Thank you to all the sponsors.  Thank you for inviting me.  

Data Problems? Get Help

After a short hiatus from consulting, I am once again available for short or long term consulting projects. We also offer onsite training and desk-side mentoring for database issues.

Favorite SSIS Audit Framework

Just a quick video of the Pragmatic Works audit framework on a set of SSIS packages.

Time Value of Data

Data has a value and a cost to the business, based on the latency of the data and the needs of the business.

SQL Saturday 309 Downloads

Downloads for SQL Saturday #309 in Oklahoma City are below. Thank you to all who attended. Thanks also to all the sponsors who help make these great events possible for the tech community.     Business Intelligence Basics: Finding Return on Data This session will you chart the waters through the sea of Business Intelligence […]

Getting SQL data into SharePoint

Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session we will start with the basics of sharing a SQL data in Sharepoint.

Measuring BI ROI begins with Business Analysts

Calculating ‘Payback Period’ or ‘Return on Investment’ (ROI) on business intelligence projects requires information at every project stage. On a recent project expansion required my team to provide information about cost savings for the project. This process was important not just for project approval, but also for validation after the project was built. If business […]

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: