…brew your own Business Intelligence

Posts Tagged ‘SSIS’

PSA: Stop Putting Sorts in SSIS Data Flows…

…or any fully-blocking transforms for that matter.   SSIS 101 The primary function of SSIS is to move data from location A to location B with the option of performing transformations to the data along the way. That’s certainly an over simplification but it gives you the general framework from […]

Read more

SSIS Data Viewer Objects are Static

Recently, while debugging the logic involving a derived column component in an SSIS data flow, I learned something new and thought I’d share 🙂 Before we dive into the details, let’s quickly review a few of the common methods for troubleshooting issues in an SSIS data flow: using error output […]

Read more

Reporting Against the SSIS 2012 Catalog

This weekend, on the way home from a nice few days at the beach with family, I was listening to a SQLBitsX session (A Lap Around the SSIS Catalog) by Jamie Thomson (b | t) and it got me thinking about some work I did at my last client and how […]

Read more

Passed 70-466 and 70-467 Exams + Study Guides

Earlier this month, I passed the following two exams putting me 1 away (70-462) from the MCSE Business Intelligence certification. 70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2012 70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Below is an outline of the material I worked […]

Read more

Extracting Facebook Data With SSIS

This is the 3rd post in this quasi-series on Facebook data from a business intelligence perspective.  First, we discussed the value of customer analysis and how integrating Facebook data can enrich such analysis.  Next we established a basic understanding of the Facebook social graph from which we wish to extract […]

Read more

SQL Server 2012 Certification Path Update

Yesterday morning, I passed the 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012! This completes the second step on my SQL Server 2012 certification path. What follows is a quick outline of the materials I used while preparing for this exam along with some comments and afterthoughts. Data Warehouse […]

Read more

Value of Integrating Facebook Data For Customer Analysis

Unless you recently awoke from a coma, you probably noticed that Facebook filed for IPO earlier this year.  The stock opened at $38/share valuing the company at ~$104 billion.  Since then, the stock has gotten absolutely crushed as critics everywhere have come crawling out of the wood work with claims […]

Read more