RSS

Tag Archives: MSBI

Data Explorer – Introduction to Data Explorer for Excel

Microsoft Recently announced a new add-in for Excel called “Data Explorer”. Data Explorer is a data access and data discovery/exploration tool used by Business Intelligence Professionals and Information Workers.

Data Explorer can be used to do a variety of different data access and data discovery/exploration activities, some of them are:

  • Extract data from various different sources including Relational Databases, Feeds, Web, Files, Azure, Hadoop Distributed File System (HDFS), and many others.
  • Cleansing, Transformation, and Consolidation of data for further analysis and reporting.
  • Import the data into Excel and use it for further analysis and reporting in tools like Excel Reports, PowerPivot, and Power View etc.

In this post, we will take a look at the following topics:

  • Installing Data Explorer Add-in
  • Different Sources supported by Data Explorer
  • Importing data from Facebook
  • Perform some basic transformations
  • Creating a Simple Report in Excel

To read the full article, follow the link: Introduction to Data Explorer for Excel.

 

Tags: , , , , , , , , ,

BI Basics – Who Needs Business Intelligence

In the previous articles, we saw What is BI and Why do we need BI. In this article, we will see who needs Business Intelligence.

Now, we know what is BI and the necessity of BI, but next question we need to ask before building a BI application is Who Needs Business Intelligence?. In other words, we need to know who are the target audience of the BI application.

Who needs BI?

Getting an answer to this question is very important before designing a BI solution. In fact one of the basic questions which we need to ask before designing any solution is “Who are the end users/consumers of this application?”, as this will help to understand various requirements/needs that the solution should meet.

Simple answer to this question is “Every Decision Maker in an Organization needs BI”. Now the question is, who are the decision makers in an organization? Well, pretty much everyone in an organization is a decision maker and people at different levels make decisions of different level/scale/magnitude.

Let’s consider a simple scenario of a multi-national BPO with call centers across the globe. In this organization, there are people at different levels – CEO at the top, Upper Management, Middle Management, Leads & Managers, and Call Centre Executive as depicted below.

Who Needs BI

In this organization, everybody makes decisions but at different levels. A call center executive makes decisions related to the day-to-day calls being attended by him/her. Leads & Managers track the calls and make decisions about the calls successfully closed, re-opened calls, issues, escalations etc. Middle Management makes decisions about things like utilization of resources at a larger scale, response times etc. Upper Management and CEO make decisions of a very large-scale may be at the level of a territory or country and across the globe respectively.

As part of their decision-making, individuals at all the levels depicted above require different levels of information for making effective decisions and their informational needs vary in terms of different parameters like level of details, scale of goals (long-term or short-term), and acceptable data latency etc. Hence a BI application built for this kind of organization should be able to cater to the needs of people at all these different levels and should help them make informed decisions.

Hope that helps in understanding the type of users who require a BI solution.

Until next time, happy learning!

 

Tags: , , , , ,

BI Basics – Why do we need Business Intelligence

In the previous post, we learnt What is Business Intelligence (BI). In this post, I will explain the need for a BI system.

Why do we need BI?

This is a very important question that needs to be addressed before one can work towards building a BI Solution. In fact, this is the first question that any management guy would ask the Engineering Team before funding any new project. Let’s try to address this question in simple terms.

A BI system helps businesses analyze the past, understand the present, and predict the future. It helps answer few important questions about Past, Present, and Future of Business. Below is a quick snapshot of some of the important questions that a BI System can answer about Past, Present, and Future.

Why BI - Past-Present-Future

A BI System helps businesses at every stage of a Business Process. A typical business process involves few common phases – Planning, Execution, Measurement, Evaluation, and Improvement as shown below.

BI Basics - Backbone of BI

This cycle of Planning, Execution, Measurement, Evaluation, and Improvement repeats and with every cycle, businesses Improve, Grow, and Mature. A BI system helps businesses during each of these phases and acts as a Backbone of a Typical Business Process.

Hope this post helps in understanding the need for a BI System. Until next time, happy learning!

 
2 Comments

Posted by on April 15, 2013 in Basic Concepts

 

Tags: , , , , , , ,

 
Follow

Get every new post delivered to your Inbox.

Join 177 other followers