Posts

Showing posts from September, 2022

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 😁

SQL Project — UK Online Retail Store

Image
(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.