Data Analysis vs Data Mining vs Data Warehouse

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
Sorry if that is off topic. I want to know the difference between these 3. I google it but no one seems can explain it in easy and understanding way.

Thank you.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Data warehouse is different to the other 2. It is a place to store your data, typically extracted from your main transactional systems to provide fast and consistent delivery of Data for reporting.

The other 2 can probably mean different things to different people. My view is Data mining is more about digging into the data looking for stuff that you maybe don’t even know exists. Eg patterns of buyer behaviour. Data Analysis is a broader term meaning to look at and analyse data generally to show trends, changes, exceptions etc.

Its a fine line, but I think Analysis is “I know we performed better or worse than last year - which is it. Data mining is more like “customers that buy X.... I wonder what else they buy.
 
Upvote 0

Forum statistics

Threads
1,214,920
Messages
6,122,264
Members
449,075
Latest member
staticfluids

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top