RSS

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: , , , , , , ,

PowerPivot – Creating Hierarchies in PowerPivot for Excel 2010

In this post, we will see how to create Hierarchies in a Table in PowerPivot for Excel. We will look at the following two scenarios for building Hierarchies:

  • Creating Hierarchies using Columns from the Same Table
  • Creating Hierarchies using Columns from Different Tables

To start working with the steps in this post, setup your Excel/PowerPivot workbook and add the following items to your workbook:

To read the full article, go to this link: Creating Hierarchies in PowerPivot for Excel.

 

Tags: , , , , ,

PowerPivot – Working with Column Properties in PowerPivot for Excel 2010

In the previous post, we saw how to combine data from multiple relational sources into a single table in PowerPivot. In this post, let us see some of the common properties/features associated with columns in PowerPivot.

This tip will cover the following topics:

  • How to set Description for Columns in PowerPivot
  • How to set and modify Column Data Types in PowerPivot
  • How to apply formatting to Column Data in PowerPivot
  • How to Show or Hide the Columns in PowerPivot
  • How to Sort Data in one Column with Data in another Column in PowerPivot

To work through the steps outlined in this post, you need to set up your Excel/PowerPivot Workbook by following the steps outlined in the below listed posts in the same sequence specified.

To read the full article, go to this link: Working with Columns and Properties in PowerPivot for Excel.

 

Tags: , , , , , , , ,

PowerPivot – Combine Data from Multiple Relational Tables into One Table in PowerPivot for Excel

This is the next post in the PowerPivot for Excel Series. In the previous post we saw how to create Linked Tables in Excel, which helps us to maintain a live connection between a working excel and PowerPivot table. In this post, we will see how to combine data from two or more relational tables into a single table in PowerPivot.

Let’s consider this scenario. You have a sales database with a large Sales table in your organization and the data in the Sales Table grows at a rapid pace. To keep the performance in check (and/or for any other reasons), you decide to archive or move the data from the Sales table into a separate table in the same or different database, say annually (to keep things simple). Now, when users need to analyze the sales data for past few years then it requires them to pull the data from all these different tables and consolidate into one single table. In this post let’s see how this scenario can be address by combining the data from multiple sales tables into a single table in PowerPivot for Excel.

To read the full article, go to this link: Combining Data from Multiple Relational Data Sources into One Table in PowerPivot for Excel.

 

Tags: , , , , , , , ,

BI Basics – What is Business Intelligence

Off late I have been receiving few emails to write about stuffs which can help new comers into Data Warehousing and Business Intelligence space to ramp up and get up to speed. So I thought of writing few posts to explain few basic concepts of Data Warehousing and Business Intelligence to give my perspective of these concepts.

What is BI?

BI stands for Business Intelligence.

There are many definitions for BI given by different people. In short, “Business Intelligence is a Process of Transforming Data into Information”.

There is another very important concept associated with BI and is called as Data Warehousing (DW).

A Data Warehouse is a Centralized Data Repository and servers as the source of data for Analysis and Reporting. Data Warehouses are built by consolidating/integrating data from different data sources belong to different departments/business units and contain both Recent Data (Non Real-Time) as well as Historical Data required for Analysis and Reporting.

There is another smaller entity which is conceptually same as a Data Warehouse but is specific to Subject Areas and is called as a Data Mart. Data Marts are built using the same processes and principles as that of Data Warehouses and are more common when compared to Data Warehouses. Most of the times, the terms Data Warehouse and Data Mart are used interchangeably.

Without a proper data warehouse/data mart in place, BI is ineffective and incomplete in most of the scenarios. Hence a Data Warehouse/Data Mart is always associated with/part of any large-scale Business Intelligence systems.

Data Warehouse and Business Intelligence are collectively abbreviated as DWBI. Most of the times in the industry, DWBI is simple known as BI.

In short, DWBI is a “Process of Extracting Data from Source in Whichever Format it exists, Transforming it into a Consumable Format, Loading it into a Centralized Data Repository, and Delivering/Presenting it to the End Users (Decision Makers) in the Format that they need, to Enable them to make Effective Decisions”.

Notice in the above definitions that, I have referred to BI as a Process. Remember that Business Intelligence is a Process and not a tool. Irrespective of the tools/technologies that you use, the underlying concept/process remains the same. You might hear people saying BI Tools, which most often they are referring to the tools that help us build BI Systems.

[Updated | 2013-02-14]: As Data Warehouses and Data Marts are centralized data repositories and are used to deliver data for analysis and reporting to people at different levels in an organization, they ensure that the same version of the data is delivered to every individual in the organization and thus ensures that “Single Version of Truth” is available to each and every individual.

 

Tags: , , , ,

PowerPivot – Creating Linked Tables in PowerPivot for Excel

In the previous article, we saw how to import data from multiple data sources into PowerPivot for Excel. In this article, I will cover the following concepts:

  • Concept of Linked Tables in PowerPivot for Excel
  • Maintaining a live connection between a Working Excel file and PowerPivot using Linked Tables

Read the following articles before proceeding with this article:

To read the full article, go to this link: Creating Linked Tables in PowerPivot for Excel.

 

Tags: , , , , , ,

 
Follow

Get every new post delivered to your Inbox.

Join 176 other followers