By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data Analytics instagram stories
    Data Analytics Helps Marketers Make the Most of Instagram Stories
    15 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    What to Know Before Recruiting an Analyst to Handle Company Data
    6 Min Read
    AI analytics
    AI-Based Analytics Are Changing the Future of Credit Cards
    6 Min Read
    data overload showing data analytics
    How Does Next-Gen SIEM Prevent Data Overload For Security Analysts?
    8 Min Read
    hire a marketing agency with a background in data analytics
    5 Reasons to Hire a Marketing Agency that Knows Data Analytics
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: The Biggest BI Blunder
Share
Notification Show More
Aa
SmartData CollectiveSmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Data Management > Best Practices > The Biggest BI Blunder
Best PracticesBusiness Intelligence

The Biggest BI Blunder

DougLautzenheiser
Last updated: 2011/11/21 at 5:49 PM
DougLautzenheiser
9 Min Read
SHARE
Many Business Intelligence projects struggle and fail. But there may be just one general reason why they go south: the individuals in charge did not treat the initiatives as software application development projects.

Many Business Intelligence projects struggle and fail. But there may be just one general reason why they go south: the individuals in charge did not treat the initiatives as software application development projects.

Instead, many people with failed projects saw BI as a business initiative or as a financial exercise and ignored decades of best practices of software development life cycle.
 
Jim Collins talked about how great companies put the right people on the right bus going in the right direction.
If you try to run a BI project as something other than a software application development effort, then you are immediately starting off on a bad trip with the wrong people on the wrong vehicle.
 
Wrong Approach
If you do not understand that your BI initiative is an SDLC project, then you will not follow well-established practices that would improve your chance of success.
You might not even follow basic project management concepts such as the “Magic Triangle” to define the “scope” of what you promise to deliver by what time and at what cost. Experienced SDLC developers understand that in a project you are stuck with three variables that are all interrelated. Changing one impacts the others. 
 
These are: 
  • Deadline (the length of time to complete the project)
  • Functionality (the scope of the project, the features your provide)
  • Cost (the resources on the project)

For a project, you are stuck within an elastic constraint of these three limits. Individuals who do not understand or ignore these variables will have a failed project.
 
If you need your BI project to be done quickly, then you must add resources (increase cost) and/or reduce what will be delivered (reduce functionality).
 
If you want lots of functionality, then you must push back the deadline and/or add resources (increase your costs).
 
If you need to lower costs, then you have to be willing to eliminate functionality and/or push back the deadline and work with fewer resources. 
 
Ka-Boom!
Experienced SDLC developers also know the difference between the “Big Bang” approach and a phased, iterative roll-out. Failed BI initiatives are those where an influential person gives vague marching orders such as, “I want an enterprise dashboard where everybody in the company can access all data in any way they need to see it and I need to demo it at the annual conference in three months. Oh, and make sure it works on my iPad, Bob’s Android phone, and Sally’s iPhone, and Greg’s BlackBerry.”
Burning Your Dollars
Successful SDLC projects understand a phased staffing approach. Not everybody needed the project has to start on Day One. Yet that is a common mistake on failed BI projects.
 
Imagine building a house. On Day One, you have an empty lot and must first dig a hole and pour the foundation. If your custom home builder told the electricians, plumbers, dry-wallers, and painters to come on Day One and just have a seat in lawn chairs to watch and wait for their work to start, you would immediate recognize this was wasting time and money.
 
Yet bringing in GUI developers to sit and wait for the database developers to finish a repository is common on a failed BI project. It just is not as obvious since IT people look more productive sitting in a Herman Miller chair in a cubicle rather than out front on a lawn chair. 
 
Wrong Expectations
Experienced software developers know they will not be successful unless they first have a clear definition of the application they are to build. Successful individuals are able to take a fuzzy idea from the business and work jointly with others to properly define and formally document the specifics of what will be done.
 
The worst BI projects are those where the ideas for the dashboard are in one person’s head. This Person is always frustrated that nobody else on the project is smart enough to understand what she is thinking. Without formally dumping ideas from that person’s head into a well-articulated requirements document, the BI project is doomed. Yet it often happens.
 
Note: read the “Tappers and Listeners” section in the Heath Brothers’ book “Made to Stick” for more on this topic.
 
The first problem of not knowing what you are building is that you will create the wrong thing; your project will fail.
 
There is another problem of not clearly defining what you are building: you will never be done. At some point, the executive paying for the BI project will start to scream about the time and cost. “Why is this BI project taking so long?”

Well, it was never designed with an end goal in mind and as aresult the BI developers are continuously running a marathon on a circular track.

More Read

ai low code frameworks

AI Can Help Accelerate Development with Low-Code Frameworks

Tackling Bias in AI Translation: A Data Perspective
Data Ethics: Safeguarding Privacy and Ensuring Responsible Data Practices
How AI is Boosting the Customer Support Game
AI-Based Analytics Are Changing the Future of Credit Cards
 
Wrong People
If you do not understand that you are running a SDLC project, then you will not employ the right people.
 
If you view this as a business initiative, you will naturally pick people who understand your business. It just seems to make sense to have the guy in Finance who calculates your business metrics to run the BI project. But without a formal SDLC understanding, Bob in Finance is not going to be able to run a successful software project.  
 
Repeatedly, I have a certain type of organizations fail in their BI initiative. These have been those where their IT groups have traditionally done operational support; they do not do SDLC projects. They are great at running the networks and keeping e-mail and packaged applications running, but they are not software developers. 
 
This is not a fault; their IT organization is intentionally designed to provide operational support.
 
When these types of  IT groups get complex BI projects thrust upon them, they typically fail. This is not what they know how to do. They are inexperienced in software development. Yet it does not occur to the executive that he or she is asking for the impossible from these employees. Instead, the project fails and the executive asks, “Why can’t my IT development implement a dashboard?”
 
Plan for BI Success
Business Intelligence is a software application development endeavor;  without that basic worldview in place, your BI project will fail. Instead, you will jump into a BI project with the wrong approach, the wrong expectations, and the wrong people. 
 
A “Just Do It” command from an executive will not make an enterprise dashboard magically appear. To be successful, you will need experienced people following the right methodologies and best-practices to create your clearly-defined BI application. 

DougLautzenheiser November 21, 2011
Share This Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

smart home data
7 Mind-Blowing Ways Smart Homes Use Data to Save Your Money
Big Data
ai low code frameworks
AI Can Help Accelerate Development with Low-Code Frameworks
Artificial Intelligence
data Analytics instagram stories
Data Analytics Helps Marketers Make the Most of Instagram Stories
Analytics
data breaches
How Hospital Security Breaches Devastate Local Communities
Policy and Governance

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

ai low code frameworks
Artificial Intelligence

AI Can Help Accelerate Development with Low-Code Frameworks

12 Min Read
data perspective
Big Data

Tackling Bias in AI Translation: A Data Perspective

9 Min Read
Data Ethics: Safeguarding Privacy and Ensuring Responsible Data Practices
Best PracticesBig DataData CollectionData ManagementPrivacy

Data Ethics: Safeguarding Privacy and Ensuring Responsible Data Practices

7 Min Read
How AI is Boosting the Customer Support Game
Artificial Intelligence

How AI is Boosting the Customer Support Game

6 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive
ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?