Does Data Science Replace BI?

When a new technology comes around, there’s a temptation to think that it replaces a previous one. But most of the time, that’s not really true. I started working with computers in the Mainframe days. We still had them when I worked for NASA. Minicomputers came out, then Personal Computers – and in large part,…

0

What is the main difference between Business Intelligence and Data Science?

I’ve explained in other articles that Data Science is not a replacement for other data technologies, it’s a continuation of the data analytics process. So if Data Science is used in analytics of large sets of data, how does it differ from Business Intelligence (BI), which is also used to analyze large sets of data? Business…

0

Data Wrangling – ELT not ETL

In Data Science, we most often use Extract, Load and Transform (ELT) as opposed to Extract, Transform and Load (ETL) that you see most often in Business Intelligence (BI). There are a couple of reasons for this. First, in many BI solutions you have a few data sources that you are integrating into a historical…

0

Big Data – A Microsoft Tools Approach

(As with all of these types of posts, check the date of the latest update I’ve made here. Anything older than 6 months is probably out of date, given the speed with which we release new features into Windows and SQL Azure) I don’t normally like to discuss things in terms of tools. I find…

2

The Data Scientist

A new term – well, perhaps not that new – has come up and I’m actually very excited about it. The term is Data Scientist, and since it’s new, it’s fairly undefined. I’ll explain what I think it means, and why I’m excited about it. In general, I’ve found the term deals at its most…

2

What’s a Microsoft "Fast Track" for Data Warehousing?

Microsoft is a platform company, meaning that we don’t often sell pre-packaged solutions, but rather tools for you to make them. In other words, we sell Microsoft Word, we don’t type the letters for you. But in some cases you might like to have a little more guidance than just "Here’s a database product. Go…

1

The "Clicks" Paradigm

I’ve been doing a couple of BI discussions lately, and I used a term that I thought was more widely spread – the "clicks" paradigm. It has to do with the way data is pushed out to users – whether that is based on OLAP or OLTP data. A "three click" setup is a tool…

7

BI – Where is the most time spent?

I was speaking with my class last evening about Business Intelligence projects. I divide BI projects into a few broad steps, regardless of the vendor for the solution at the end:   1.     Understanding the business and its data 2.     Designing the “Star” or other BI schema 3.     Extract, Transform and Load processes to move…

1