Categories
Uncategorized

Facebook as a Data Source

Earlier this month year, I discussed the value of integrating Facebook data for customer analysis.  Originally, I planned to follow up with a post covering the process of extracting data from Facebook using SSIS… but as I started working through the material, I quickly realized the background information on ‘Facebook as a data source’ was worthy of its […]

Categories
Uncategorized

Defensive Database Programming with SQL Server

A couple of weeks ago, I spent some time reviewing a few trigger-based constraints recently put in place to enforce business-rules in a database I’m working on for a client.  Specifically, I was looking for any potential side-effects that could arise with a database that is configured for READ-COMMITTED SNAPSHOT ISOLATION. During my online research, I […]

Categories
Uncategorized

MDS Update Required After SQL 2012 SP1 Installation

Earlier this month I installed SQL Server 2012 SP1 in my development environment.  But, unfortunately, I had to split before spending any time checking out the changes. Fast forward to this morning.  As I was firing up the MDS gui to try and reproduce an issue on the MSDN forum, I was greeted with the […]

Categories
Uncategorized

AdventureWorks, User Adoption, and Self-Service BI Projects

User adoption is critical to the overall success of any IT project…but that goes double for self-service BI projects because at the end of the project the users will be expected to actually use the tools to generate their own BI (reports, dashboards, scorecards, analysis) and facilitate fact-based decision making in a rapidly evolving business […]

Categories
Uncategorized

TSQL Script: Check for Missing DEFAULT Constraints

Here’s a quick script I put together recently while polishing up a data model I’ve been working on.  This script will list every table containing a column named EffectiveDate that is missing a default constraint. The scenario that prompted its creation was for an EffectiveDate column that exists in a lot of the tables in […]

Categories
Uncategorized

System Upgrade: SSD + Windows 8 Pro

Warning: this post is mainly just fluff to let all five of my readers know that I haven’t forgotten about them. There are a lot of unfinished posts in the drafts folder that I plan on churning out over the coming weeks as we head into the end of the year…so stay tuned! A few […]

Categories
Uncategorized

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 Design Read The Data Warehouse […]

Categories
Uncategorized

Kaggle: Making Data Science a Sport

A few months ago, I stumbled upon an article that mentioned a cool site called Kaggle which hosts data-related “competitions”. Through this site, data problems collide with solutions as data-experts compete against each other for prizes (cash and/or bragging rights) to see who can come up with the most effective, elegant, efficient solution to each […]

Categories
Uncategorized

Interacting With Live Data via Power View During a Presentation: Worth the Risk?

Over the past few months I’ve delivered a few presentations for current clients (and potential leads) covering the “Sharepoint BI Portal”. The presentation is very demo-heavy and focuses on the self-service capabilities of the Micrsoft 2012 BI stack when integrated with Sharepoint 2010 and built upon a well constructed BI Semantic Model (BISM). This morning […]

Categories
Uncategorized

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 about Facebook’s mobile strategy (or […]