Abu Aasif Ansari
I build AI-powered data apps and dashboards
Ready for work
Abu Aasif is ready for their next project!
DataStory turns any CSV into a visual story your audience can actually understand. Upload data, pick your audience — Business, NGO, Student, or Social Media — and instantly get charts, AI insights, and a narrative in the right tone.
🔗 Live App: gloss-pink-92515363.figma.site (http://gloss-pink-92515363.figma.site)
🎨 Figma File: https://www.figma.com/make/3fXa18CiqXMh5DGpDEJB2b/DataStory-web-app?t=x2aGr4k1EKKAyKHl-1
📱 LinkedIn Post: https://www.linkedin.com/posts/abuaasif_configmakeathon-figmamake-datavisualization-ugcPost-7468777281721638912-euQR/?utm_source=share&utm_medium=member_desktop&rcm=ACoAACRm5rcB0nVG0_HUX6-IXfuWqNGquZ-jMQU
Built with Figma Make + Supabase.
2
5
765
DataStory turns any CSV into a visual story your audience can actually understand. Upload data, pick your audience — Business, NGO, Student, or Social Media — and instantly get charts, AI insights, and a narrative in the right tone.
🔗 Live App: gloss-pink-92515363.figma.site (http://gloss-pink-92515363.figma.site)
🎨 Figma File: https://www.figma.com/make/3fXa18CiqXMh5DGpDEJB2b/DataStory-web-app?t=8gpa5UvsYyDBd1RP-1
📱 LinkedIn Post: https://www.linkedin.com/posts/abuaasif_configmakeathon-figmamake-datavisualization-activity-7468491109715935232-htUB?utm_source=share&utm_medium=member_desktop&rcm=ACoAACRm5rcB0nVG0_HUX6-IXfuWqNGquZ-jMQU
Built with Figma Make + Supabase.
8
13
2.7K
CUT Coffee — Brew Your Story I reimagined CapCut as a premium coffee brand for creators. The scissors become a cup mark. The timeline becomes a film-strip sleeve. Every great story begins with a cut. Direction A — CapCut as a Different Industry
https://www.linkedin.com/posts/abuaasif_capcutdesignstudio-branddesign-capcut-activity-7467333219772952576-53vt?utm_source=share&utm_medium=member_desktop&rcm=ACoAACRm5rcB0nVG0_HUX6-IXfuWqNGquZ-jMQU
0
375
Freelance IQ — AI-powered analytics dashboard for freelancers,
built entirely with Google Stitch.
5 screens: Income tracking, Client insights, Project pipeline,
AI earnings forecast, and Goal tracker — all in a premium dark UI.
Used Stitch's Gemini 3.1 Pro mode with streaming generations
and in-place AI edits to go from idea to interactive prototype
in one session.
https://stitch.withgoogle.com/preview/9455851854863077407?node-id=494f0bc78d54431bbb199e7793602920
2
2
501
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
213
Sales, Customer & Marketing Analytics Dashboard Project
1
3
I’m a Data Analyst specializing in cleaning, structuring, and analyzing marketing and sales data using Python, Excel, SQL, and Power BI.
I help businesses fix broken data pipelines, resolve formatting issues, and turn raw data into accurate dashboards that support decision-making.
My work focuses on clarity, reliability, and scalability—ensuring reports remain consistent as data grows.
If you’re struggling with inconsistent data or dashboards that don’t reflect reality, I can help streamline the process end-to-end.
0
311
I specialize in data cleaning and preprocessing, ensuring your spreadsheets or databases are accurate, well-formatted, and ready for analysis or reporting.
What Ill do for you:
Remove duplicates, nulls, and inconsistencies
Standardize date, text, and numeric formats
Fix spelling/case issues
Split/merge columns (e.g., names, addresses)
Convert file formats (CSV Excel SQL)
Python or SQL-based advanced cleaning (if required)
Supported formats: Excel, CSV, Google Sheets, SQL dumps
Clean, fast & confidential service
100% satisfaction guaranteed
Message me before ordering so I can understand your dataset and goals!
0
360
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
328
🚀 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
267
Sales, Customer & Marketing Analytics in Power BI
I built a complete 3-page Power BI dashboard to analyze Sales performance, Customer behavior, and Marketing ROI—all in one place.
🔍 Sales Overview
Revenue trends & top product categories
Total Sales, Orders & Average Order Value
Region-wise and payment method analysis
👥 Customer Insights
New vs Returning customers
Customer Lifetime Value (LTV) by region
Purchase frequency & repeat behavior using DAX
📈 Marketing Performance
Spend vs Revenue across Paid Ads, Social, Referral, Influencer/UGC, Email & Offline
Clear ROI comparison to identify winning and underperforming channels
🛠 Tools Used: Power BI, SQL, DAX, CSV
💡 Outcome:
This project shows how combining Sales, Customer, and Marketing data helps businesses make faster, smarter decisions.
0
228