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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks