Friday, April 3, 2015

SDLC and BILC (Business Intelligence Life Cycle)

Most of the IT people understand about the system development life cycle or SDLC. It is common and basic when we talk about system. So for you who not understand about it, I write down here the definition from wikipedia

The systems development life cycle (SDLC), also referred to as the application development life-cycle, is a term used in systems engineering, information systems and software engineering to describe a process for planning, creating, testing, and deploying an information system. The systems development life-cycle concept applies to a range of hardware and software configurations, as a system can be composed of hardware only, software only, or a combination of both.

A number of SDLC models or methodologies have been created. Some of them are :
Okay, next lets talk about something more advance. It is about BILC or business intelligence life cycle. Not all company has the BI application in Indonesia. It is quite expensive for them who still struggle to develop or optimize the ERP or core system. If your company planning to start the project, you can see my post here about starting the analytics project and realize the value. One more post is about the BI consultation. Okay, back to the main topic of this post. When we talk about BILC we talk not only about BI, but also about data warehouse (DW) or data mart (DM). It is not necessary but most of the time it will come in pairs as the best practices.


  1. Analyze Business Requirements - You review business requirements to determine the types of analysis user need to perform.
  2. Design Data Model - Based on the business requirements, design the logical data model, which shows the information that users want to analyze and the relationships that exists within the data.
  3. Design the Physical Schema - Using the data model, design the physical schema, which defines the content and structure of the data warehouse.
  4. Build the Data Warehouse - Build the data warehouse according to the schema design and load data into the warehouse from source systems.
  5. Create the Project Structure (Metadata) - Create the metadata and begin to connect and map the metadata to table in the data warehouse.
  6. Develop The BI Objects - Develop object, like attribute, fact, metric, reports and dashboard.
  7. Administer and Maintain the Project - Administer and maintain the project as it undergoes continued development and changes, monitor performance and make adjustments to improve it, manage security, and perform other ongoing administrative tasks.
The source is from MicroStrategy PDF - Implementing MicroStrategy PDF Version 9.4.1.
I think this concept common and can be applied for another BI.  I have try this by using another product and it works. There is another common component that is hidden above. It is ETL. Don't forget we have to fill the DW with data from another source system. The DW needed to ensure the data is clean and ready to use by the BI application. So when some customer ask me to directly connect to their OLTP / database it is possible but not the best practices. It depends how you try to use the BI application and what you expect. Thank you for reading.

39 comments:

  1. Nice post.Thanks for sharing this post. Pridesys Business Intelligence (BI) is offering you easy-to-use analytics and business intelligence tools. With these tools you can explore your data. Create new patterns, rich visual and insights. to know more information visit: Pridesys IT Ltd

    ReplyDelete
  2. The compelling shaking plans impart and in the long run, decipher the exact information investigation into profit for money (ROI). data science course in pune

    ReplyDelete
  3. I was blown out after viewing the article which you have shared over here. So I just wanted to express my opinion on Data Science, as this is best trending medium to promote or to circulate the updates, happenings, knowledge sharing.. Aspirants & professionals are keeping a close eye on Data science course in Mumbai to equip it as their primary skill.

    Data science course in Mumbai

    ReplyDelete
  4. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. I would like to state about something which creates curiosity in knowing more about it. It is a part of our daily routine life which we usually don`t notice in all the things which turns the dreams in to real experiences. Back from the ages, we have been growing and world is evolving at a pace lying on the shoulder of technology. data science certification will be a great piece added to the term technology. Cheer for more ideas & innovation which are part of evolution.

    ReplyDelete
  5. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
    pmp certification cost india

    ReplyDelete
  6. Such a very useful article. I have learn some new information.thanks for sharing.
    data scientist course in mumbai

    ReplyDelete
  7. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
    Data science course in mumbai

    ReplyDelete
  8. Cool stuff you have and you keep overhaul every one of us
    Data science course in mumbai

    ReplyDelete
  9. Such a very useful Blog. Very interesting to read this article. I have learn some new information.thanks for sharing. know more about

    ReplyDelete
  10. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
    ExcelR Business Analytics Course

    ReplyDelete
  11. Very nice blog here and thanks for post it.. Keep blogging...
    ExcelR data science training

    ReplyDelete
  12. Yes i am totally agreed with this article and i just want say that this article is very nice and very informative article.I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!Thanks bitcoin profit app

    ReplyDelete
  13. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. Bitcoin Trader App

    ReplyDelete
  14. I am impressed by the information that you have on this blog. It shows how well you understand this subject.
    ExcelR data analytics courses

    ReplyDelete
  15. cool stuff you have and you keep overhaul every one of us
    data analytics courses

    ReplyDelete
  16. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it. excelr data science

    ReplyDelete
  17. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
    data analytics courses

    ReplyDelete
  18. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
    data analytics course mumbai

    ReplyDelete
  19. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! Paulus Heule

    ReplyDelete
  20. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work... Florida payday loans online

    ReplyDelete
  21. BI or Business Intelligence is defined as the process of gathering, cleansing, analyzing, integration and sharing data to accelerate business growth - which tell everything! Thanks for sharing this useful post, thanks a lot! :) There are lots of training institute provides the authentic BI consulting to make it more easy to understand.

    ReplyDelete
  22. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.

    business analytics course

    data analytics courses

    data science interview questions

    data science course in mumbai

    ReplyDelete
  23. One stop solution for getting dedicated and transparent Digital Marketing services and
    We take care of your brands entire digital presence.
    The digital marketing services we provide includes SEO, SEM, SMM, online reputation
    management, local SEO, content marketing, e-mail marketing, conversion rate
    optimization, website development, pay per click etc. We will definitely promote your
    brand, product and services at highest position with consistency in order to generate
    more revenue for your business.Digital Marketing
    Services

    ReplyDelete
  24. I would like to say that this blog really convinced me to do it! Thanks, very good post.
    ExcelR Data Analytics Course in Pune

    ReplyDelete
  25. No plano empresarial a sua associação profissional ou sindicato contrata o plano de saúde para você. O Plano de Saúde para Empresas é disponibilizado para empresas de todos os portes, tamanhos e segmentos (inclusive MEI). plano de saude empresarial

    ReplyDelete
  26. I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful.

    machine learning course

    artificial intelligence course in mumbai

    ReplyDelete
  27. This article discusses some of the roles of the modern business analyst. If you are looking into or are a business analyst this article will help you along the way. Business Analyst Training

    ReplyDelete
  28. Awesome Post!!! Attend The Data Science Courses From ExcelR. ExcelR experts have successfully trained over 140,000 students and professionals in multifarious domains which include Data Science.
    Data Science Course in Marathahalli
    Data Science Course Training in Bangalore

    ReplyDelete
  29. This is my first visit to your web journal! We are a group of volunteers and new activities in the same specialty. Website gave us helpful data to work. Online Business Opportunities

    ReplyDelete
  30. I have read a few of the articles on your website now, and I really like your style of blogging. I added it to my favorites blog site list and will be checking back soon. Please check out my site as well and let me know what you think. Write for us business

    ReplyDelete
  31. I have read your blog. It's very attractive and impressive. Very systematic indeed! Excellent work!
    Data Science Course in Marathahalli
    Data Science Course Training in Bangalore

    ReplyDelete
  32. Thanks for a very interesting blog. What else may I get that kind of info written in such a perfect approach? I’ve a undertaking that I am simply now operating on, and I have been at the look out for such info. Blogging the boys

    ReplyDelete
  33. The information provided on the site is informative. Looking forward more such blogs. Thanks for sharing .
    Artificial Inteligence course in Nashik
    AI Course in Nashik

    ReplyDelete
  34. Is business name avaiable Howdy, i value your work and devotion.  I was in fact just chatting with a business owner the other day, and discussed with him how to carry out what you are explaining in a comparable way for business naming. In your question, is business name available in US? Well, that question can be easily answered with the application i linked.

    ReplyDelete
  35. Anyone who offers you hosting for less than that should trigger a red flag. Choose and pay for at least a year, just as you have registered your domain name. here

    ReplyDelete
  36. Today, secure, remote usage of this computers stop being an extra -- it's evolved into a necessity. Having the capability to access your working environment or house computer from hotels, task list templates

    ReplyDelete

Share Your Inspiration...