SQL Project — UK Online Retail Store

(Photo credit: https://unsplash.com/photos/dQyS2pMYtok?utm_source=unsplash&utm_medium=referral&utm_content=creditShareLink)


Hello and welcome, this is my first post about SQL portfolio. Here I will describe the data analysis of Ecommerce Retail Stores in the UK.

I got the data from Kaggle, here’s the link if you want to check it out : 
https://www.kaggle.com/datasets/carrie1/ecommerce-data

Throughout the project, I used tools such as MySQL Workbench and Tableau (data visualization). I also upload the SQL code on GitHub:
https://github.com/ratnaprasada/UKEcommerce

Here’s the analysis of the data. Feel free to contact me if there are any suggestions or questions about it. Thank you.


(Photo credit: https://unsplash.com/photos/dQyS2pMYtok?utm_source=unsplash&utm_medium=referral&utm_content=creditShareLink)







https://www.linkedin.com/in/luh-gede-ratna-prasada-27b4871ba



Comments

Post a Comment

Popular posts from this blog

Microsoft Excel Project - Vlookup and Hlookup

Image
  Hey, how are you? Welcome again!! So now we are moving to some complex functions and formulas, which are Vlookup and Hlookup. VLOOKUP & HLOOKUP VLOOKUP is a function to read or find data vertically. The function form is :     =Vlookup(lookup_value;  table_array; column_index_num; range_lookup)     "lookup_value": the value as the basic table reading     "table_array": the range of the reference table     "column_index_num": the number of the column position on the reference table     "range_lookup": TRUE for approximate results, or FALSE for accurate results. HLOOKUP is a function to read or find data horizontally. The function form is :     =Hlookup(lookup_value;  table_array; row_index_num; range_lookup)     "lookup_value": the value as the basic table reading     "table_array": the range of the reference table     "row_index_num": the number of the row position on the refe...
Read more

Microsoft Excel Project - Simple Tabel

Image
 Hello, welcome back!! Last week, I finished Microsoft Office Basic Training organized by BLKIP Bali. I learned a lot about  Word, Excel, PowerPoint, and any other soft skills needed in the workplace. Starting now, I will upload some of my portfolios to show off my skills in Microsoft Office. In this post, I will show you some simple Excel projects, regarding bills and invoices. This project does not include any formulas, just some simple Excel templates. Because the training was in Indonesian, some of the words and sentences in the portfolios might not be in English. Feel free to contact me if you have any suggestions or questions about it. Thankyou 😁 Bills ( Fraktur Tagihan ) Bills Here are the conditions and functions that I use in this project :  Paper size A4 Landscape orientation Margin 2222 Custom Border and Shading Merge and Center for some merge cells Cells alignment Accounting format number Custom Header Footer Invoices Invoice Here are the conditions...
Read more

SQL Project #2 - Myanmar 3 Superstore

Image
  (photo credit:  https://unsplash.com/photos/kLwgUwv_m_g?utm_source=unsplash&utm_medium=referral&utm_content=creditShareLink ) In this post, I will show you my second SQL Project about data analysis of Superstores. These superstores are located in Myanmar and have 3 branches. Branch A located in Yangon City, Branch B is located in Mandalay City, and Branch C is located in Naypyitaw City. I got the data from AUNG PYAE on Kaggle : https://www.kaggle.com/datasets/aungpyaeap/supermarket-sales I used the same tools as the previous project, MySQL Workbench and Tableau. You can see the SQL code on my GitHub account:  https://github.com/ratnaprasada/3Superstore So here's the analysis, feel free to contact me if you have  any suggestions or questions about it. Thankyou 😁
Read more