Joins in the exercise
Before doing the exercise I thought that going sales and reviews sheets in excel would be more appropriate, as excel is better than tableu for data processing. However, I had certain difficulties while doing it. Could you give quick tip on how to combine those two spreadsheets into one?
1 answers ( 0 marked as helpful)
Hi Emin,
thanks for reaching out! To combine the two tables you need to join the two tables together. You could do that with the help of Tableau, Power Bi, or with SQL, for example. If you'd like to use Excel, you could try the merge option it provides.
You can check out more on the topic from the following link:
https://www.ablebits.com/office-addins-blog/2018/10/31/excel-merge-tables-matching-columns/
Hope this helps!
Best,
365 Eli