Data Visualization Projects in Kagal

Data Visualization Projects in KagalData Visualization Projects in Kagal

Cover image for Smart Data Analyst — AI-Powered

Smart Data Analyst — AI-Powered Data Analysis App Built a fully working AI-powered data analysis app from scratch using Streamlit and Gemini API. The problem: Most business owners have data in Excel or CSV files but no easy way to analyze it without hiring a full-time analyst or learning Python. So I built a tool where you just upload your file — and the app does the rest. → Auto-detects KPIs from any dataset → Generates charts automatically → Ask questions in plain English — get instant answers with tables and charts → Downloads full PDF report with KPIs and charts → RAG memory — remembers past questions Tech: Streamlit · Gemini API · Python · Pandas · Plotly 🔗 Live: https://smart-data-analyst-ahkz32vjd6dzvhmexkrhdm.streamlit.app/ (https://smart-data-analyst-ahkz32vjd6dzvhmexkrhdm.streamlit.app/)⭐ GitHub: https://github.com/AbuAsifAnsari/smart-data-analyst (https://github.com/AbuAsifAnsari/smart-data-analyst)

0

65

Cover image for Data Analytics Project – Subscription Model Analysis (SQL & ...

Data Analytics Project – Subscription Model Analysis (SQL & Power BI) Analyzed a subscription-based business model for Foodie-Fi (TastyStream), a digital platform offering on-demand global cuisine content. The objective was to understand customer journeys, subscription transitions, and revenue performance using SQL and Power BI. Key Contributions & Insights: Segmented customers based on trial-to-paid and plan transitions. Analyzed free trial behavior and conversion patterns. Evaluated revenue performance across subscription plans. Built interactive dashboards in Power BI for actionable insights. Tools Used: MYSQL, Power BI Outcome: Delivered a clear, insight-driven dashboard supporting data-driven decisions in a subscription-based business.

2

229

Cover image for 🚀 SQL & Tableau Project | Sales Analytics Dashboard To prac...

🚀 SQL & Tableau Project | Sales Analytics Dashboard To practice real-world analytics, I built an interactive Sales Analytics Dashboard using SQL & Tableau to analyze sales performance and customer behavior. 🔹 Dataset Highlights OrderID, CustomerID, Product, Category, Sales, Quantity, Discount, Profit, Region, OrderDate 🔹 Dashboard Coverage • Sales overview: Total Sales, Profit & Orders • Product performance: Top-selling products & category insights • Monthly sales trends 🔹 Tools Used • SQL • Tableau 🔹 Key Insights • A small customer segment drives most revenue • Certain product categories consistently outperform others • Clear seasonal sales patterns 🔹 What I Learned • Writing efficient SQL queries for analysis • Translating numbers into business-friendly visuals • Designing dashboards that support data-driven decisions

0

172