r/dataanalysis • u/Tasty_Principle_3640 • 9d ago

Built a Customer Shopping Behaviour Analysis Project Using Python, PostgreSQL & Power BI Au kichhi options: 1. Customer Shopping Behaviour Analysis Python + SQL + Power BI 2. My End-to-End Data Analytics Project: Customer Shopping Behaviour Analysis 3. I Analyzed Customer Shopping Behaviour Usi

Post image

Hi everyone!

I recently completed an end-to-end Data Analytics project on Customer Shopping Behaviour.

The goal of this project was to analyze customer purchasing patterns, identify important trends, and create meaningful business insights from the data.

šŸ”§ Tools & Technologies:

ā€¢ Python ā€“ Pandas, NumPy, Matplotlib

ā€¢ Jupyter Notebook ā€“ Data Cleaning & EDA

ā€¢ PostgreSQL ā€“ Data Storage & SQL Analysis

ā€¢ Power BI ā€“ Interactive Dashboard

ā€¢ GitHub ā€“ Project Documentation

šŸ“Š Project Workflow:

  1. Loaded and explored the dataset using Python

  2. Cleaned and prepared the data

  3. Performed Exploratory Data Analysis (EDA)

  4. Stored the cleaned data in PostgreSQL

  5. Wrote SQL queries to analyze customer behaviour

  6. Built an interactive Power BI dashboard

  7. Generated insights and prepared a project report

šŸ“ˆ Some areas analyzed:

ā€¢ Customer purchasing behaviour

ā€¢ Product/category performance

ā€¢ Customer demographics

ā€¢ Purchase patterns

ā€¢ Ratings and sales trends

Iā€™m sharing this project to get feedback and improve my data analytics skills.

GitHub: [https://github.com/nniteshbarik9-lab/customers_behavior_analysis-\]

I would really appreciate your feedback and suggestions. Thank you!

3 Upvotes

100% Upvoted

2 comments sorted by

1

u/AutoModerator 9d ago

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/NightRain3 9d ago

make sure to round displayed values appropiately