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

The Road to Insight Part Two

This is part two (to get to part one, simply click “The Road to Insight” tag at the bottom of this post) in my series of developing a small business intelligence solution based on the AdventureWorks demo database.  In this post we will install and setup our test SQL Server 2016 instance.  This instance will be housed in a VM running on my laptop as we won’t be doing anything resource intensive.  Also, if people want to me to put one together, I can do a video on YouTube on installing SQL Server 2016 – just comment below and ask for it!

Continue reading The Road to Insight Part Two

T-SQL 101 – The SELECT Command

This post is going to be part of my T-SQL 101 series in which I cover some of the basics of T-SQL aimed at the data analyst type of person.  By that I mean the type of person who would have to write queries to pull data into Excel or SQL Report Builder and might have been used to graphical query designers to get the data they need.  My hope is that by reading through this series data analysts will have a better idea of how to write their own queries from scratch which may allow them to use SQL Server to do more of the heavy lifting as opposed to the front end application doing it.  At the very least, understanding how queries work will allow the data analyst to have a better idea of what the graphical query designer.

Continue reading T-SQL 101 – The SELECT Command

The Road to Insight Part One

Hello everyone!  This is the first post of  series that will be walking through building a complete BI solution from start to finish using the AdventureWorks database.  I chose to use this database because everyone has access to it so you can follow along at home if you want to learn business intelligence.  Specifically, I am writing this series to show how I handle a certain type of end user:  the one that wants to see what we can get from a particular data source.

Continue reading The Road to Insight Part One

Free eBooks! Yes, This is Legit…

I was checking my Twitter and came across this Tweet:

So I figured I would mosey over and check it out.  I fully expected it to be a sales hook and that I would have to buy something to get the free ebooks because there is no such thing as a free lunch, right?

Wrong.  I downloaded two PDF format ebooks to stash in my OneDrive for reading later on my tablet.  I was never asked for credit card information or to sign up for any trials or accept any offers.  I bookmarked the page linked in the tweet above because the author will be adding free ebooks as he finds them, which is a great deal.

http://www.wzchen.com/data-science-books is the direct link to get to the list of the books.

Published my First Magazine Article

Today is a personal milestone for me as I strive to build my personal brand in the Microsoft BI space.  TribalNet, which is a community of IT leaders in Native American tribes, selected my article as a featured column in their upcoming spring issue.  It’s a small circulation, but is the first step towards establishing my credibility in the BI space.

Continue reading Published my First Magazine Article

The Value of the Do-Over

How many of you have, back when you were a kid, screwed up and yelled “Do over!”?  I know I did my fair share of times.  As I grew up, I started to look at the do over as something that just wasn’t allowed.  You made your  mistakes and you moved on.  However, as I started in business intelligence, I found the do over to be immensely helpful.  Join me after the jump to see what I mean.

Continue reading The Value of the Do-Over