Blog Carnival: How I Got Here

Hello everyone!  I’d like to start hosting regular blog carnivals on a monthly interval and this post will start off the first one.  For those that don’t know, a blog carnival is where one blogger posts a topic, and other bloggers respond and link back to the original blogger to create a pingback.  Some bloggers then collect the responses and post a list of links to each blogger that responded to the carnival.  Join me after the break to see this month’s topic.

Continue reading Blog Carnival: How I Got Here

My Thoughts on Communities and Rules

So the downside of being active with the SQL Server community on Twitter is that occasionally you stumble into drama best left for community members with more time in the community and more smarts than I have.  However, opinionated me just doesn’t listen to good advice like that.    Jump below the break to see what’s going on and exactly what I think of it.

Continue reading My Thoughts on Communities and Rules

Dimensional Modeling vs In-Memory Analysis

SQL Server 2016 is just around the corner.  One of the big features is in memory analysis of OLTP databases.  At first glance, it seems that traditional data warehousing and dimensional modeling of data would be severely threatened, especially with tools like PowerBI and SQL Server Analysis Services making it so easy for analysts to work with data.

Continue reading Dimensional Modeling vs In-Memory Analysis

My World Just Got Scarier…

Oh boy… I just noticed that FOXPass just posted their June meeting announcement the other day at http://fox.sqlpass.org/Home.aspx.  You’ll notice that I am presenting at this user group meeting.  Me.  A wide-eyed newbie is going to talk to these pros about dimensional modeling and why they need to know about it.

Never mind that dimensional modeling was introduced a long time ago by Ralph Kimball.  Never mind that this audience might have known about dimensional modeling for a lot longer that I have.  No.  Despite these things, I still had the audacity to say, sure, I’ll give a talk.  What’s the worse that can happen?

Continue reading My World Just Got Scarier…

Source Control Woes

With the pending release of SQL Server 2016, it’s time for me to refresh and update my environment.  One of the biggest issues I have with my current environment and workflow is that I am not well positioned for an eventual expansion of my team.  Right now,  I am the sole BI developer so I can leave all my development code on my laptop (unless something happens to it).

With the new environment I want to utilize Team Foundation Server for version control.  The primary reason for TFS is that it’s a Microsoft product, it’s easier to maintain (at least in my mind it is), and I can use the community edition and not have to license it. Continue reading Source Control Woes

Why #PowerBI Won’t Replace Data Warehouses

Good morning everyone!

I hope you all have had a good week so far, and if you are reading this on a Monday, I’m sorry.  I am going to take a break on the Road to Insight series and talk about why data warehouses won’t be replaced by cloud-based BI solutions like PowerBI.  Now, I know that PowerBI isn’t positioning itself to replace traditional data warehouses but if I had the thought that it might, I am sure others have so I want to present my reasons why I don’t believe that cloud BI will replace a traditional warehouse.

Continue reading Why #PowerBI Won’t Replace Data Warehouses

The Road to Insight pt 4 – Building the Data Warehouse

Good morning everyone (while it’s morning as I right this, so pretend its morning when you read this)!  I hope everyone had an excellent Easter.  Even if you are not religious or your faith doesn’t celebrate Easter, it’s still a great time for personal renewal and reflection, as well as spending time with friends and family.  In this post in the on-going series of The Road to Insight, we tackle building the data warehouse itself.  Join me after the jump to figuratively see this build in action.

Continue reading The Road to Insight pt 4 – Building the Data Warehouse

The Road to Insight pt 3 – Dimensional Modeling

Welcome to part 3 of my road to insight series in which I build an entire BI solution from start to finish.  In parts 1 and 2 we setup a test server and brought the AdventureWorks database online.  In this post, we discuss the project requirements and data model for the data warehouse.  Let’s hop to it!

Continue reading The Road to Insight pt 3 – Dimensional Modeling

Bending data to my will one post at a time