customeranalysis

Data visualisations in Power BI

Projects

Customer Analysis is a critical business function that helps companies understand their customers better, identify areas of improvement, and build stronger relationships. Tableau is a powerful data visualization tool that can be used to analyze customer data and gain insights into customer behavior, preferences, and needs.

Tableau project with Sales and Customer dashboards providing actionable business insights, KPI tracking, and trend analysis using sample data.

SQL-based analysis of customer purchase data to uncover key insights on revenue, behavior, and customer segmentation.

All Main Projects

Customer segmentation is a pivotal task for business analytics. Customer segmentation is the process of splitting customers into different groups with similar characteristics for potential business value proposition. Many companies find that segmenting their customers enable them to communicate, engage with their customers more effectively. Futu…

Built a complete data science project on 119,000+ real e-commerce orders — covering data cleaning, exploratory analysis, machine learning models for price prediction and review classification, customer segmentation, and an interactive Streamlit dashboard. Found that delivery delays are the single biggest driver of negative customer reviews

This is a Descriptive Customer Analysis Dashboard. Created a Dashboard using different types of charts including a butterfly chart, a donut chart, a scatter plot and more.

End-to-End Product Intelligence Platform with ETL Pipeline, SQL Data Warehouse, Customer Analytics, Churn Analysis, CLV Modeling, Streamlit Dashboard, and Business Intelligence Reporting.

This project demonstrates an end-to-end data analytics workflow, including data cleaning, exploratory analysis, SQL querying, and dashboard creation. It highlights the ability to transform raw data into meaningful insights using Python, PostgreSQL, and Power BI, along with presenting results through reports and presentations.

Business analysis of 100K+ e-commerce orders uncovering revenue, customer experience & delivery performance insights.

Delves into customer and transaction data for a retail supermarket to inform the supermarket’s strategic plan for the chips category

AI-powered Business Analytics System using OpenAI Whisper, spaCy NLP, TF-IDF Logistic Regression, DistilBERT, Streamlit, and MySQL for customer call sentiment analysis, business intelligence dashboards, and automated recommendations.

End-to-end SQL analysis of sales performance, customer behavior, and product trends using the Chinook dataset.

This project analyzes data from a sales records database for scale model cars and extracts KPIs and other information for decision-making

End-to-end credit card analytics project using PostgreSQL, SQL, Power BI and DAX to analyze customer behavior, revenue, transactions and portfolio performance.

PostgreSQL-based e-commerce sales analytics project analyzing revenue, customer behavior, product performance, geographic trends, and cancellations. Includes data cleaning, KPI analysis, time-series analysis, advanced SQL, customer and product insights, and business recommendations.

Analyzing an E-commerce Customer Behavior and Purchase Dataset with SQL and performing Exploratory Data Analysis (EDA) to derive valuable insights to inform strategic decision-making in e-commerce.

This repository containe a customer analytics powerbi dashboard project