Thread: How to connect 3 spreadsheets for data analysis?

I'm a database noob and I wonder how I can connect three spreadsheets A, B, and C when A & B, B &C and C & A have corresponding columns for data analysis

I have three excel spreadsheets derived from raw database:

1) order_ord - has details of the order,
It includes columns such as:
id_ord userid_ord amount_ord taxes_ord shipping_ord currency_ord date_ord status_ord ordernumber_ord details_ord shipmethod_ord shipname_ord shipstreetaddress_ord shipcity_ord shipstate_ord shipcountry_ord shipzip_ord

2) orderdetail_ode - has some more details about the order
It includes columns like

id_ode idord_ode pid_ode pquantity_ode pname_ode pproperties_ode pprice_ode pterm_ode

3) users_usr - has all the details regarding the user
It includes columns like id_usr email_usr email2_usr phone_usr altPhone_usr fax_usr firstname_usr lastname_usr spouse_usr address_usr address2_usr city_usr state_usr county_usr zip_usr country_usr level_usr status_usr DateLastEntry dateNew referrer_usr source_usr discountCode_usr

My Question

How do I connect these three databases so I can analyze the data. I want to know answers to what products are people buying during different months, or what is the most common product bought by people of a certain state - for example.

I'm not even sure if I can do this with Excel or if I will need some other tools. Much appreciate any guidance.

Thank you very much for any answers

Sriram

Hi,

Can you please post an example of the workbook you have?

Thanks