What’s the difference between data mining and data warehousing?


Data mining is the process of finding patterns in a given data set. These patterns can often provide meaningful and insightful data to whoever is interested in that data. Data mining is used today in a wide variety of contexts – in fraud detection, as an aid in marketing campaigns, and even supermarkets use it to study their consumers.

Data warehousing can be said to be the process of centralizing or aggregating data from multiple sources into one common repository.

Example of data mining

If you’ve ever used a credit card, then you may know that credit card companies will alert you when they think that your credit card is being fraudulently used by someone other than you. This is a perfect example of data mining – credit card companies have a history of your purchases from the past and know geographically where those purchases have been made. If all of a sudden some purchases are made in a city far from where you live, the credit card companies are put on alert to a possible fraud since their data mining shows that you don’t normally make purchases in that city. Then, the credit card company can disable your card for that transaction or just put a flag on your card for suspicious activity.

Another interesting example of data mining is how one grocery store in the USA used the data it collected on it’s shoppers to find patterns in their shopping habits.
They found that when men bought diapers on Thursdays and Saturdays, they also had a strong tendency to buy beer.

The grocery store could have used this valuable information to increase their profits. One thing they could have done – odd as it sounds – is move the beer display closer to the diapers. Or, they could have simply made sure not to give any discounts on beer on Thursdays and Saturdays. This is data mining in action – extracting meaningful data from a huge data set.

Example of data warehousing – Facebook

A great example of data warehousing that everyone can relate to is what Facebook does. Facebook basically gathers all of your data – your friends, your likes, who you stalk, etc – and then stores that data into one central repository. Even though Facebook most likely stores your friends, your likes, etc, in separate databases, they do want to take the most relevant and important information and put it into one central aggregated database. Why would they want to do this? For many reasons – they want to make sure that you see the most relevant ads that you’re most likely to click on, they want to make sure that the friends that they suggest are the most relevant to you, etc – keep in mind that this is the data mining phase, in which meaningful data and patterns are extracted from the aggregated data. But, underlying all these motives is the main motive: to make more money – after all, Facebook is a business.

We can say that data warehousing is basically a process in which data from multiple sources/databases is combined into one comprehensive and easily accessible database. Then this data is readily available to any business professionals, managers, etc. who need to use the data to create forecasts – and who basically use the data for data mining.

Datawarehousing vs Datamining

Remember that data warehousing is a process that must occur before any data mining can take place. In other words, data warehousing is the process of compiling and organizing data into one common database, and data mining is the process of extracting meaningful data from that database. The data mining process relies on the data compiled in the datawarehousing phase in order to detect meaningful patterns.

In the Facebook example that we gave, the data mining will typically be done by business users who are not engineers, but who will most likely receive assistance from engineers when they are trying to manipulate their data. The data warehousing phase is a strictly engineering phase, where no business users are involved. And this gives us another way of defining the 2 terms: data mining is typically done by business users with the assistance of engineers, and data warehousing is typically a process done exclusively by engineers.

Hiring? Job Hunting? Post a JOB or your RESUME on our JOB BOARD >>

Subscribe to our newsletter for more free interview questions.

  • Manjari Chaturvedi

    Going through the same situation right now…. -_-
    And this is EXCELLENT. it made this topic very clear 🙂

  • sanjay singh yadav

    nice explanation

  • murugesan

    Good Explanation …..!

  • awesome and easy explanation good…

  • krishna p madhwani

    u win my heart :*

  • Abhinav

    hi Manikandan,

    do you have any useful study material for business Analyst. currently i am working as Engg. in IT firm and want to become a BA. it would be great if you can share some useful stuff on my email id (25abhinavrana@gmail.com)

    Abhinav rana

  • rahul

    That’s brilliant dude. now only i understood the different definitions with proper real life examples. That is how one should explain concepts.
    Thank you Editors.

  • Vipin

    what an explanation….polichu

  • Putty

    Thank u so much,

  • Manisha

    Simply awesome..

  • Akhilesh M V

    “Data warehousing is the process of compiling and organizing data into one common database, and data mining is the process of extracting meaningful data from that database”

    This sentence explained it all……thanq!!!

  • Anonymous

    thanks fr …. amazing way to explain both topics.

  • Charan

    That was a nice explanation, now I got soo much clarity on this topics. Thanks 🙂

  • beautiful explanation liked it

  • ruben

    it is too easy to understand…thxx

  • Anonymous

    this was really help full example

  • Ajay Garg

    sir salute..superb outstanding …never seen such great examples about data warehousing and data mining

  • Informative. nice work

  • Sheldon Cooper

    I have exam in one our at the time when I posted this comment and saw the article!!

  • Tushar

    great explanation.. its very use full data by real time scenarios.
    greate work

  • barbie

    This is nice. Thank you !!!!

  • Vivek

    brilliant, concept got cleared… thanks

  • joselie castañeda

    a big thank you to you dude!

  • Thank you, amazing way to explain both topics.

  • Dhivya sampath

    it is very useful definition for me

  • Prince

    Tt has worth for thanking.awesome.

  • Uday Pratap Maurya


  • Daniel

    great explanation! Congrats! 🙂

  • Ash123

    Too good !

  • Guest

    fantastic examples
    thank you

  • VendeTTa

    love you man… what a lucid and simple definition with some exquisite examples.

  • shelke

    great explanation

  • rishi vaishnav

    nice ….useful

  • sandeep das

    superb explanation with a practical example…thank you

  • Siva

    Who is the author of all these sessions. U r doing a great work. Very simple & detailed explanations for a layman..

  • Milind Kamble


  • Ravi

    Good explanation! This what I looking for about data warehouse and data mining.

  • Dinesh

    really it is the best explanation it can be understood with in few minutes.

    by any one . its awesome!

  • athithiyien vb

    really awesome

  • A.S

    thats really awesome… a good explanation for basic concept of data mining and ware housing

  • Godson

    Great work 🙂

  • Kalpit

    Good1 🙂

  • Manikandan K

    Great information with Simple and neat explanations ! Am almost 2yrs of experience as a engineer and decide to see my career in Business analyst, for the first time searched the meaning for data mining & warehousing, really exited to learn more and to see myself as a Business Analyst in upcoming years ! Great Thanks !

  • Swapna

    Thankyyy 🙂

  • anoop pandey

    very good knowledge
    thanks for you

  • kibrom weldehaweria

    thanks alot

  • Khalid

    This is awesome explanation. Thank you.

  • Nambi

    Really simple and lot means

  • Kulal

    Good .Thank u.

  • Danilo Lion

    Never saw such a clear explanation as this one! Thanks a lot…. I going to use this examples here (i'm in Brazil) to explain for my students.


  • KapitanP

    ohhmyy goddness thnk u 🙂

  • Firoz

    Very well explained! Thanks

  • manu jain

    these two concepts never going to forget…

  • Ajinkya


  • Dave

    Was shite

  • Dave


  • Dave

    You're welcome

  • Dave

    spark her up Raj

  • Dave

    1 luv

  • Dave


  • Ramsha

    such a clear and easy to understand explanation. thank you 🙂

  • ctmanohar

    very useful and easily
    understanding explanation

  • Archana

    Superb explanation.. very easy to understand.. thank yo:):)

  • bhanu


  • anbu

    it's very easy to understanding thank u soooooooooo much

  • phurba

    good one

  • reka

    thanks a lot…

  • Selvam

    Great , Excellent

  • Excellent explanation,Thank you.

  • Monu

    it is really very helpful…Thanks

  • Fola

    My god!!! I have an exam in 1 hour, just wanted a practical explanation to these concepts and this is superb. Thank you!!!

  • sakshi


  • chaitu

    most useful explained in d most effective way

  • Scouser

    Indeed a good explaination

  • Raj


  • kisor

    thanks alot

  • Manoj

    Nice one

  • shek

    Thanks a lot…… Very clear description.. Thumbs up Dude !! 🙂

  • ashu taps

    Very well explained..!!

  • Amir

    good explaination…

  • Ankur

    helpful description…thank you.

  • Ruwan

    Great explanations….thank u very much……

  • Thgopiinadh


  • Priya

    excellent example …..

  • Neeteshpal

    thnx a lot…ur info help me a lot

  • Tao

    Very useful for me

  • Meetraghuram92

    tahnks for you,:)

  • Vishal

    HEY VARUN nice insight case clear could you also guide
    best institutes to train in mining , business intelligence, predictive anaylsis ,& warehousing

  • Prageeth

    this was really helpful…thanx

  • Anjali Dhanawat