How nithinchillara/brazilian-e-commerce-analytics works
This repository is a notebook-based analysis of the Olist Brazilian e-commerce dataset. An analyst loads the nine CSV files, prepares order-level data, then explores business questions through descriptive, sales, customer, geographic, review, payment, seller, and retention analyses. A separate SQLite section loads data into an in-memory database and runs 15 SQL queries. The README documents these capabilities and the notebook’s section structure; notebook source was not provided, so the links below reflect documented relationships rather than inspected implementation details.
Main entry points: Nithin Chillara_BrazilianECommerceAnalytics.ipynb Cleaning and preprocessing
Components 17
Data preparation
- Data loading
Nithin Chillara_BrazilianECommerceAnalytics.ipynb - Cleaning and preprocessing
Nithin Chillara_BrazilianECommerceAnalytics.ipynb
Business analytics
- EDA and statistics
Nithin Chillara_BrazilianECommerceAnalytics.ipynb - KPI analysis
Nithin Chillara_BrazilianECommerceAnalytics.ipynb - Sales and time series
Nithin Chillara_BrazilianECommerceAnalytics.ipynb - Customer and RFM
Nithin Chillara_BrazilianECommerceAnalytics.ipynb - Geographic analysis
Nithin Chillara_BrazilianECommerceAnalytics.ipynb - Review analysis
Nithin Chillara_BrazilianECommerceAnalytics.ipynb - Payment analysis
Nithin Chillara_BrazilianECommerceAnalytics.ipynb - Retention cohorts
Nithin Chillara_BrazilianECommerceAnalytics.ipynb - Seller analysis
Nithin Chillara_BrazilianECommerceAnalytics.ipynb - Advanced analysis
Nithin Chillara_BrazilianECommerceAnalytics.ipynb
SQL analysis
- SQLite database
Nithin Chillara_BrazilianECommerceAnalytics.ipynb - SQL queries
Nithin Chillara_BrazilianECommerceAnalytics.ipynb
Analysis outputs
- Charts and findings
Nithin Chillara_BrazilianECommerceAnalytics.ipynb
Other components
- Analyst
- Olist CSV data
Connections 26
- Analyst → Data loading: runs notebook
README.md - Olist CSV data → Data loading: loads files
README.md - Data loading → Cleaning and preprocessing: prepares data
README.md - Cleaning and preprocessing → EDA and statistics: analyzes data
README.md - Cleaning and preprocessing → KPI analysis: computes KPIs
README.md - Cleaning and preprocessing → Sales and time series: analyzes sales
README.md - Cleaning and preprocessing → Customer and RFM: segments customers
README.md - Cleaning and preprocessing → Geographic analysis: analyzes geography
README.md - Cleaning and preprocessing → Review analysis: analyzes reviews
README.md - Cleaning and preprocessing → Payment analysis: analyzes payments
README.md - Cleaning and preprocessing → Retention cohorts: builds cohorts
README.md - Cleaning and preprocessing → Seller analysis: analyzes sellers
README.md - Cleaning and preprocessing → Advanced analysis: answers questions
README.md - Data loading → SQLite database: loads data
README.md - SQLite database → SQL queries: runs queries
README.md - EDA and statistics → Charts and findings: produces analysis
README.md - KPI analysis → Charts and findings: reports metrics
README.md - Sales and time series → Charts and findings: reports trends
README.md - Customer and RFM → Charts and findings: reports segments
README.md - Geographic analysis → Charts and findings: reports geography
README.md - Review analysis → Charts and findings: reports results
README.md - Payment analysis → Charts and findings: reports results
README.md - Retention cohorts → Charts and findings: reports retention
README.md - Seller analysis → Charts and findings: reports results
README.md - Advanced analysis → Charts and findings: answers questions
README.md - SQL queries → Charts and findings: returns results
README.md