Business Intelligence and Data Warehousing.


Business Intelligence and Data Warehousing :

Business Intelligence is a process and methodology to convert raw data in to meaningful information for business use.

     Business Intelligence Tools can be Categorized Into :
  • ETL Tools :
For Extracting Transforming and Loading the data to Data warehouse.
  • Reporting Tools :
Read data, process the data and format the data in to structured reports
and dashboards those are delivered to business users.
  • Data Mining Tools :
Data mining is commonly used for marketing, surveillance, and fraud detection.
  • Knowledge Management Tools :
          Knowledge management tools are used capture, develop, share, and effectively                                          using organizational knowledge


              

What is Data Warehousing ?

A data warehouse is a collection of corporate information, derived directly from operational systems and some external data sources. Its specific purpose is to support business decisions, not business operations.


Characteristics of a Data Warehouse:
  • Subject-oriented Data
 •        Collects all data  for a subject,  from different sources
       Read-only Requests
        Loaded during off-hours, read-only during day hours
  • Interactive Features, Ad-hoc query.
       Flexible design to handle spontaneous user queries.
       Pre-aggregated data
       To improve runtime performance
  •  Highly demoralized data structures
Data Mart :

         It’s a smallest level or Subset of the data warehouse and is specific to a business.
          Example : Sales Data Mart, Orders Data Mart, Finance Data Mart.

Staging Area  :
  •  Is an Intermediate storage area between the source and data warehouse.
  • It’s an area where the cleansing of  raw data takes place
  • It might be UNIX storage mount or relation staging table based on the requirement.
Sources :

It might any OLTP relational or file sources:
   Example : ERP, Mainframe, Oracle, Teradata , DB2.

Available BI Tools In market ?

ETL Tools 
  • Informatica
  • Abintio
  • Data Stage
  • Talend 
Reporting Tools.
  • Cognos
  • Business Objects (BOXI)
  • OBIEE
  • MicroStrategy
Data Bases and Operating Systems used for DW Design

Popular Relational Databases.

• Oracle
• IBM DB2
• Teradata
• Sybase
• MySQL
• Greenplum
• VectorWise

Popular OS Platforms.

• Red Hat Linux
• Solaris Unix
• Window 

Difference Between OLTP and OLAP

OLTP
OLAP
1
OLTP is for Business process or Business Operations.
OLAP is for Business Decisions and Analytics
2
OLTP involves short and fast inserts and updates initiated by end users.
Periodic long-running batch jobs refresh the data
3
Highly normalized with many tables
De-normalized with fewer tables
4
Clerical Users
Managerial/Business Users
5
Detailed Oriented Data
Subject Oriented Data
6
Entity Attribute Relationship Model
Dimensional Modeling
7
Contains Instant Data
Contains Historical Data

 Types of OLAP

ROLAP :

·         Relational Online Analytical Processing.
·         ROLAP data will be stored in Standard Relational Database as a result it doesn’t need any pre computation.
·         ROLAP is scalable to handle large volumes of data.
                Ex : Business Object       
               
MOLAP :

·         Multi Dimensional Online Analytical Processing.         
·         MOLAP is alternative to ROLAP
·         Store pre-computed data in an optimized multidimensional array storage we call it as  cube
·         Query performance will be very high due to the optimized storage.
                 Ex : Cognos.

HOLAP :

·         Hybrid Online Analytical Processing.
·         It’s a combination of ROLAP and MOLAP.
·         Increased Aggregation and Query performance.
                Ex : Micro strategy.



99 comments:

  1. Thanks shivakumar, nice blog to sharing valuable information Java Training Chennai

    ReplyDelete
  2. Hi am, interested learning datawarhousing tool. but i don't selected which tool best in the this tool? please discuss to me shiva Java Training in Chennai

    ReplyDelete
  3. Great post, and great website. Thanks for the information! Odzyskiwanie danych Łódź

    ReplyDelete
  4. Might you be able to envision what the thing that matters is between the over a significant time span showcasing systems?data science course in pune

    ReplyDelete
  5. I was blown out after viewing the article which you have shared over here. So I just wanted to express my opinion on Data Analytics, 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 analytics course in Mumbai to equip it as their primary skill.

    ReplyDelete
  6. Great post!
    Thanks for sharing this list!
    It helps me a lot finding a relevant blog in my niche!
    Java Training in Chennai
    Java Training in Coimbatore
    Java Training in Bangalore

    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. 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 course will be a great piece added to the term technology. Cheer for more ideas & innovation which are part of evolution.

    ReplyDelete
  8. 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 in bangalore

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

    ReplyDelete
  10. I curious more interest in some of them hope you will give more information on this topics in your next articles.

    Data science course in mumbai

    ReplyDelete
  11. Excelr is providing emerging & trending technology training, such as for data science, Machine learning, Artificial Intelligence, AWS, Tableau, Digital Marketing. Excelr is standing as a leader in providing quality training on top demanding technologies in 2019. Excelr`s versatile training is making a huge difference all across the globe. Enable ?business analytics? skills in you, and the trainers who were delivering training on these are industry stalwarts. Get certification on "
    best data science course in hyderabad"
    and get trained with Excelr.

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

    ReplyDelete
  13. Nice explanations of Tech Cloud ERP’s Business Intelligence Tool, it's good to know that! A friend of mine has implemented a company which is the best ERP software in Hyderabad right now, she provides cloud based ERP software in Hyderabad, so I hope it goes well for her.
    Best Regards

    ReplyDelete
  14. Are you a businessman? Are you facing any kind of crisis in your business? If your answer is yes, then you should meet Antose Antony Bangalore Karnataka to get some good advice on how to overcome such kinds of problems in no time. He is a great person with several years of experience and his proficiency helps him to guide others. can help you in the time of such kinds of problems. You may consult him for better business-related advice.

    ReplyDelete
  15. I’m excited to uncover this page. I need to to thank you for ones time for this particularly fantastic read!! I definitely really liked every part of it and i also have you saved to fav to look at new information in your site.
    ExcelR Data Analytics courses

    ReplyDelete
  16. Great blog thanks for sharing Instagram and Facebook have provided an amazing place for new brands to grow and flourish. We can find the perfect niche for your brand on the best social media platforms. Marketing through social media brings forth global audience without all these physical boundaries. Analyze and take over the competition with ease with Adhuntt Media’s digital marketing tools and strategies.
    digital marketing company in chennai

    ReplyDelete
  17. Nice blog thanks for sharing Karuna Nursery Gardens provides you with the best nursery solutions for setting you up with a glamorous landscape. That’s right, you have finally found the perfect nursery to set you up with the best house garden in Chennai.
    plant nursery in chennai

    ReplyDelete
  18. Excellent blog thanks for sharing Shopping for international cosmetics in Chennai? Look no further, the Pixies Beauty Shop has got your back with hundreds of international brands to choose from, that too with the best value.
    beauty Shop in Chennai

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

    ReplyDelete
  20. Attend The PMP Certification in Abu Dhabi From ExcelR. Practical PMP Certification in Abu Dhabi Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The PMP Certification in Abu Dhabi.
    ExcelR PMP Certification in Abu Dhabi

    ReplyDelete
  21. After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.
    ExcelR data analytics courses

    ReplyDelete
  22. Its very informative blog and useful article thank you for sharing with us , keep posting learn Informatica Certification

    ReplyDelete
  23. Great blog thanks for sharing Online marketing has changed how businesses run and succeed in today’s highly competitive world. With Adhuntt Media, your E-commerce store can reach for the stars and find the right customers. Our team of marketing analysts can analyze, strategize and implement the perfect path for you to take to beat your competition and come out as #1.
    social media marketing company in chennai

    ReplyDelete
  24. Nice blog thanks for sharing Say no to unethical ways for growing plants fast. We at Karuna Nursery Gardens stick to traditional and environment friendly methods of caring and growing therefore enabling us to showcase the largest collection on organic plants in Chennai.
    plant nursery in chennai

    ReplyDelete
  25. Excellent blog thanks for sharing Pixies beauty Shop is the best place to buy cosmetics in Chennai. With thousands of premium imported brands to choose from, you’ll never run out of lipstick again. And don’t forget about the best offers and value they provide.
    beauty Shop in Chennai

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

    ReplyDelete
  27. 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
  28. Its very informative blog and useful article thank you for sharing with us , keep posting learn
    more about Microstrategy Online Training
    Power BI Online Training

    ReplyDelete
  29. I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article.
    data science course in mumbai

    ReplyDelete
  30. Thank you so much for this nice information. Hope so many people will get aware of this and useful as well. And please keep update like this.

    Big Data Services

    Data Lake Services

    Advanced Analytics Solutions

    Full Stack Development Services

    ReplyDelete
  31. I finally found great post here.I will get back here. I just added your blog to my bookmark sites. thanks.Quality posts is the crucial to invite the visitors to visit the web page, that's what this web page is providing.
    ExcelR Data Analytics Course

    ReplyDelete
  32. 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... data science course

    ReplyDelete
  33. This is a splendid website! I"m extremely content with the remarks!ExcelR Courses In Business Analytics

    ReplyDelete
  34. Prolog is one of the most powerful languages of Machine learning. It is also very easy to learn and practice. To know more about machine learning provider and machine learning technologies, click here, and you will get all your answers.

    ReplyDelete
  35. You have provided a nice article, Thank you very much for this one. And I hope this will be useful for many people. And I am waiting for your next post keep on updating these kinds of knowledgeable things
    Android Training in Chennai
    Android Course in Chennai
    Android Training in Bangalore
    Android Course in Bangalore
    Android Training in Coimbatore
    Android Course in Coimbatore
    Android Training in Madurai

    ReplyDelete
  36. Good to become visiting your weblog again, it has been months for me. Nicely this article that i've been waited for so long. I will need this post to total my assignment in the college, and it has exact same topic together with your write-up. Thanks, good share.
    ExcelR Data Analytics Course
    Data Science Interview Questions

    ReplyDelete
  37. This post is very simple to read and appreciate without leaving any details out. Great work! data science course

    ReplyDelete
  38. Very useful for and effective blog for us..I always read your all blogs..
    For any Testing and Measuring Instruments in India
    Hipot Tester Distributor in India
    Check here.

    ReplyDelete
  39. I would like to read more of your posts. Very nice post thank you for sharing.
    Velachery Serviced apartments

    ReplyDelete
  40. I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
    Home Decor Services in Delhi NCR

    ReplyDelete
  41. Google brain is working in the Big data consulting services to make it a huge success for the world. We hope that society will soon use AI devices at a reasonable cost.

    ReplyDelete
  42. "Thank you for taking the time to publish this information very useful! I've been looking for books of this nature for a way too long. I'm just glad that I found yours. Looking forward for your next post. Thanks :). We are top business consultancy services uk providing high quality academic sample papers, organizational research and expert business reports. Join us as a freelance researcher
    We are providing best business consultancy services uk
    "

    ReplyDelete
  43. I feel happy about and learning more about this topic. keep sharing your information regularly for my future reference. This content creates new hope and inspiration within me. Thanks for sharing an article like this. the information which you have provided is better than another blog.
    Proprietorship Firm Registration in India
    online company registration in india

    ReplyDelete
  44. This is really useful and informative blog Best IELTS Online Training it is worthy to go through this blog ,thank you

    ReplyDelete
  45. Very useful blog thanks for sharing IndPac India the German technology Packaging and sealing machines in India is the leading manufacturer and exporter of Packing Machines in India.

    ReplyDelete
  46. 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.

    business analytics course

    data analytics courses

    data science interview questions

    data science course in mumbai

    ReplyDelete
  47. Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work.
    Digital Marketing Course In Kolkata

    ReplyDelete
  48. Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!

    data analytics courses

    data science interview questions

    business analytics courses

    data science course in mumbai

    ReplyDelete
  49. keep up the good work. this is an Ossam post. This is to helpful, i have read here all post. i am impressed. thank you. this is our data analytics course mumbai
    data analytics course mumbai | https://www.excelr.com/data-analytics-certification-training-course-in-mumbai

    ReplyDelete
  50. keep up the good work. this is an Ossam post. This is to helpful, i have read here all post. i am impressed. thank you. this is our courses of pmp certifications
    pmp certifications | https://www.excelr.com/pmp-training-in-mumbai

    ReplyDelete
  51. Awesome blog. I enjoyed reading your articles.

    tableau certification

    ReplyDelete
  52. Nice blog, it’s so knowledgeable, informative, and good looking site. I appreciate your hard work. Good job. Thank you for this wonderful sharing with us. Keep Sharing.
    Digital Marketing Course In Kolkata
    Web Design Course In Kolkata

    ReplyDelete
  53. This is a wonderful article, Given so much info in it, Thanks for sharing. CodeGnan offers courses in new technologies and makes sure students understand the flow of work from each and every perspective in a Real-Time environmen python training in vijayawada. , data scince training in vijayawada . , java training in vijayawada. ,

    ReplyDelete
  54. keep up the good work. this is an Ossam post. This is to helpful, i have read here all post. i am impressed. thank you. this is our Data Science course Mumbai
    data science course mumbai | https://www.excelr.com/data-science-course-training-in-mumbai

    ReplyDelete
  55. This is a wonderful article, Given so much info in it, Thanks for sharing. CodeGnan offers courses in new technologies and makes sure students understand the flow of work from each and every perspective in a Real-Time environmen python training in vijayawada. , data scince training in vijayawada . , java training in vijayawada. ,

    ReplyDelete
  56. Such a wonderful article and I feel that it is best to write more on this topic. Thank you so much because i learn a lot of ideas about it. Keep posting...
    Digital Marketing Course In Kolkata
    Web Design Course In Kolkata
    SEO Course In Kolkata

    ReplyDelete
  57. Very useful blog thanks for sharing IndPac India the German technology Packaging and sealing machines in India is the leading manufacturer and exporter of Packing Machines in India.

    ReplyDelete
  58. This is a wonderful article, Given so much info in it, Thanks for sharing. CodeGnan offers courses in new technologies and makes sure students understand the flow of work from each and every perspective in a Real-Time environmen python training in vijayawada. , data scince training in vijayawada . , java training in vijayawada. ,

    ReplyDelete
  59. You are providing a post is very useful for develop my knowledge and I learn more info from your blog.
    Digital Marketing Training In Kolkata
    Web Design Training In Kolkata
    SEO Training In Kolkata

    ReplyDelete
  60. Really awesome blog!!! I finally found a great post here.I really enjoyed reading this article. It's really a nice experience to read your post. Thanks for sharing your innovative ideas. Excellent work! I will get back here.
    Data Science Course Training in Bangalore
    Data Science Course in Marathahalli

    ReplyDelete
  61. After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.

    Digital marketing course

    ReplyDelete
  62. Thanks for giving me the time to share such nice information. Thanks for sharing.
    Data Science Course

    ReplyDelete
  63. Hi! This is my first visit to your blog! We are a team of volunteers and new initiatives in the same niche. Blog gave us useful information to work. You have done an amazing job!
    data science course
    360DigiTMG

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

    ReplyDelete
  65. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one.
    data science course
    360DigiTMG

    ReplyDelete

Featured Post

Cloud : A Trendsetter Technology