So today I don’t have any posts for Road to Insight series. I’ve been busy at work and with bowling season wrapping up I’ve been getting my tournament appearances in. However, today, I do have a story to tell. Catch me after the jump to hear it.
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.
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.
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!
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!
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.
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.
I was checking my Twitter and came across this Tweet:
— Evan Sinar (@EvanSinar) March 13, 2016
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.
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.
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.