Exploration, Insight generation and Visualization of Olist E-commerce sales data using Python and POWER BI

Data analysis about Brazilian e-commerce business Olist

A Power BI Exploratory Data Analysis (EDA) and Visualization Project carried out to hone my DAX and Data Modelling Skills

This GitHub repository contains a comprehensive data analysis project conducted on Olist using , a prominent e-commerce company based in Brazil. The project aims to uncover valuable insights and facilitate informed decision-making by leveraging data analysis techniques. This project was carried out using SQL SERVER.

This repository contains SQL code for Olist database analysis using PostgreSQL

In this analysis, our group looked at data from the years 2016-2018 of 100,000 orders placed on the Brazilian eCommerce platform, Olist. We used the Random Forest machine learning algorithm to create a web app that predicts customer review scores using the most highly correlated features from the data as user inputs.

This repository contains Power BI dashboards and MySQL stored procedures of Brazilian E-Commerce Public Dataset by Olist

In this project, I will analyze a brazilian e-commerece (Olist) sales data to answer 39 business questions utilizing SQL. After that, I will construct a dashboard in PowerBI to highlight the most important KPI'S and indicators about the business.

Data Analysis Report based on Brazilian E-Commerce Public Dataset by Olist

No description available

Data Analysis and RFM Segmentation with the Olist Dataset Using PostgreSQL

This project is made around the data of 100k orders of a Brazilian e-commerce store "Olist". It includes EDA, customer satisfaction prediction, NLP of reviews, clustering and RFM analysis along with the project deployment in Streamlit.

This project focuses on analyzing customer geolocation data from a Kaggle dataset provided by Olist. The mean goal of this Analysis is to gain insights into customer distribution and generate visualizations for better understanding of the information of this Brasilian E-commerce Company.

Apply data analysis (descriptive and predictive) on Ecommerce data

Análise exploratória dos dados da Olist utilizando Python e Pandas. O projeto faz parte de uma atividade acadêmica e tem como objetivo extrair insights a partir das informações de 2016 a 2018, aplicando técnicas de manipulação, visualização e interpretação de dados.

SQL Project 2: Olist public data exploratory analysis

Embarking on a Solo Journey: Exploratory Analysis of Brazilian E-commerce Using Tableau, Python, Jupyter Notebook, and VS Code

A complete end-to-end data analytics and machine learning project on the Brazilian Olist E-commerce dataset, built using Python, PostgreSQL, Power BI, and Excel. This project provides actionable business insights and predictive analytics for decision-making across revenue, returns, customer retention, and operations.

This project was an analysis of Customer Satisfaction from public data of the Brazilian e-commerce named Olist.

Abstract: For this project the dataset we’ve chosen is the dataset of a Brazilian Ecommerce website “OLIST”. The details which OLIST has provided us are 9 different datasets each detailing the customers, their geolocation, orders placed, orders sold, items available, payment methods used by customers, order reviews & order delivery information. The analysis on the dataset is done through various methods like recommendation systems based on carrying out predictive analytics on users’ preferences, predicting the future sales on the basis of purchase date & discovering unsatisfied customers prone to certain product categories, clustered the customers based on Recency, Frequency and Monetary value. The above analysis has been in carried out in Apache pyspark 2.4.1 on both Cloudera platform and on Data bricks cloud environment.

ETL em python e KPI's de vendas em SQL: Brazilian E-commerce Public Dataset by Olist do Kaggle

This is a project of EDA and RFM segmentation using Kmeans

My very basic data analysis when working with tasks from Turing College

End-to-end data analysis of the Olist e-commerce dataset using Python, covering data cleaning, merging, EDA, and business insights on revenue, customers, payments, and delivery performance.

No description available

A beginner-friendly data analysis project exploring an e-commerce sales dataset using Python.

Sales data analysis project using SQL, Python and PowerBi

I'm working on this project as part of the Triggo.ai technical case for the Data Engineering Trainee Program

This is the April edition of the monthly data analysis challenge

No description available