Abu Aasif Ansari
I build AI-powered data apps and dashboards
Ready for work
Abu Aasif is ready for their next project!
The Forecast is a 40-second psychological thriller short film built entirely on Renoise. The story follows a South Asian data analyst working late in a dark room, intensely focused on completing a critical forecast. Shot by shot, we see him type, analyze, and finally lean back with a satisfied smile as the screen flashes "FORECAST COMPLETE" — he believes he's done something meaningful. Then comes the twist: the camera pulls back to reveal he was never in an office. He's been sitting inside a glowing glass simulation pod the entire time, surrounded by scientists in white lab coats quietly taking notes on tablets — observing him like a lab subject. The final black screen delivers the gut punch: "Every forecast you trust... was made by someone who never knew they were being watched." Built using Renoise Canvas with Seedance 2.0 and FacePass for consistent character identity across all scenes.
Tool used: Renoise AI — renoise.ai
(http://renoise.ai)#RenoiseChallenge
2
1
158
SOOT — Mascot of LAST DRAFT
Every creative person has a SOOT inside them.
SOOT is the official mascot of LAST DRAFT — a fictional stationery brand built for people who start things beautifully and abandon them gloriously. SOOT is a small, round creature made entirely of graphite smudge and dust. He has no legs — he just floats, unbothered. He has oversized expressive eyes that carry the weight of seventeen unfinished projects. And he always, always carries one unfinished thing. It's never the same thing twice.
He's not sad about it. He's weirdly proud.
THE BRAND IDEA
LAST DRAFT exists for the beautifully unfinished. Not for people who quit — for people who start with full intention, get distracted by a better idea, and begin again. The brand lives on stationery, notebooks, and merch — products for people who buy notebooks but never finish them. Sound familiar?
Tagline: "For everything you'll finish someday."
CHARACTER BRIEF
Name: SOOT
Role: Brand mascot of LAST DRAFT
Form: Small round graphite smudge creature — no legs, tiny stubby arms, oversized expressive eyes
Personality: Unbothered, chaotic, soft, perpetually mid-thought, oddly proud of unfinished work
SOOT is the patron saint of good intentions and better beginnings. Warm and chaotic, he shows up on every LAST DRAFT product as a reminder that starting is the whole point. He has been working on something for three years. He doesn't mind. Neither should you.
THE SYSTEM
Every element of LAST DRAFT was designed to feel like it belongs together — and like nothing else out there.
Color palette: Three colors only. Deep charcoal #1C1C1E, warm paper off-white #F5F0E8, and a single burnt amber accent #D4622A — used sparingly, like a pencil tip.
Typography: Bold serif for LAST, italic serif for DRAFT — because one thing is certain, and the other is still being figured out.
SOOT across five applications:
Sticker Pack — Six emotional states: happy, tired, shrugging, focused, done, pretending to work. Because SOOT contains multitudes.
Dark Poster — Pure charcoal background, SOOT centered with breathing room, one orange pencil. Tagline at the bottom in the smallest possible font. Less is the whole point.
Notebook Cover — SOOT peeking from the bottom edge of a kraft paper cover, just his eyes and the top of his head visible. Because the best notebooks are the ones you almost finish.
Social Post Template — "another unfinished thought." SOOT holding a crumpled paper, looking directly at you. @lastdraft. This is the post format that would make anyone who has ever abandoned a project stop scrolling.
T-Shirt Merch — SOOT on a clean white tee, small and centered. "still working on it." in tiny lowercase. The most relatable shirt ever made.
WHY SOOT WORKS
Most mascots are aspirational. SOOT is the opposite — he's deeply, specifically relatable. Every creative person, every student, every person who has ever bought a notebook and not finished it will see SOOT and think: that's me.
That's the point. A mascot people laugh at themselves through is a mascot they remember.
SOOT is distinctive enough to own a silhouette. Simple enough to stay consistent. And human enough to make you feel seen.
He's been working on something for three years.
You already know what it feels like.
That's LAST DRAFT.
🔗 Full Recraft Project:
https://www.recraft.ai/project/adad844a-479d-4b83-86ff-665bf04fca89
1
4
326
MOODBOARD — A Mood-Reactive Creative Companion
What if your dashboard could feel what you feel?
Meet BLOO — a creative character who lives inside your workspace and reacts to your mood in real time. Not a mascot. Not a sticker. A companion who's actually plugged into what you're doing.
The idea:
Every creative person cycles through the same emotional states every single day. The electric rush when ideas flow. The heavy fog of creative block. The jittery overdrive of too much caffeine. The quiet depth of deep thinking. And that pure, unfiltered joy when you finally ship something.
BLOO lives all of these — and shows it.
How it works:
BLOO is driven by a Rive State Machine with 5 custom triggers. Each mood state triggers a unique full-body animation — arms, eyebrows, mouth, eyes, and body all move independently. Complete a task on the dashboard? BLOO jumps and celebrates. Switch your mood? His entire expression changes in real time.
What's under the hood:
— Rive State Machine with 5 triggers (Inspired, Blocked, Caffeinated, Thinking, Celebrating)
— 6 timeline animations with anticipation frames and squash & stretch
— Eye blink loop on Idle state
— Workspace scene — desk, coffee cup, sticky notes, pencil — all animated
— Interactive Creative Dashboard — tasks, progress bars, energy tracker
— Sound effects via Web Audio API — unique sound per mood
— Keyboard shortcuts (1–5) for instant mood switching
— Live deployed on GitHub Pages
The result:
BLOO is not decorative. He's functional. He responds to user input, reflects the emotional state of the work session, and makes the dashboard feel alive.
This is what it means to build a character that lives inside a product.
Try it live: https://abuasifansari.github.io/moodboard/
(https://abuasifansari.github.io/moodboard/)Rive file: https://editor.rive.app/file/moodboard/2391491
2
445
Superstore Sales Dashboard — 3-Page Power BI Report
Built an interactive 3-page Power BI dashboard using
the Superstore Sales dataset (9,994 orders across USA).
Page 1 — Sales Overview: KPI cards, monthly trend,
regional breakdown, category performance.
Page 2 — Product Performance: Top products, category
donut, profit analysis, sales vs profit scatter.
Page 3 — Customer & Shipping: Segment breakdown,
top 10 customers, monthly growth, ship mode distribution.
Tools: Power BI, DAX, Superstore Dataset
Theme: Dark professional with interactive year filter.
0
67
🚀 SkillSwap — Trade what you know for what you want to learn.
SkillSwap is a peer-to-peer skill exchange platform where professionals trade expertise without money. You teach me Python, I teach you photography. No payments. Just skills.
Core features:
Skill onboarding — list what you teach & want to learn
Discover partners by skill category
Send & manage swap requests
Personal dashboard — reputation score, upcoming & completed swaps
In-app messaging with matched partners
Reviews & ratings system
Built on Bubble AI — started with one prompt that generated the full foundation: 8 pages, complete database (User, Skill, SwapRequest, Message, Review), and UI. Then manually refined workflows, data sources, navigation, and UX.
Category: Social & Community + Dashboard
🔗 Live app: abuasifansari.bubbleapps.io/version-test
🔗 LinkedIn :
https://www.linkedin.com/posts/abuaasif_promptandcircumstance-promptandcircumstance-ugcPost-7474244917997957120-JOmo/?utm_source=share&utm_medium=member_desktop&rcm=ACoAACRm5rcB0nVG0_HUX6-IXfuWqNGquZ-jMQU
#promptandcircumstance #bubble #skillswap #nocode
3
3
919
AI-Powered Data Cleaning Tool Development
1
1
AI-Powered Data Cleaning Tool
1
2
Smart Data Analyst — AI-Powered Data Analysis App
1
2
PersonaSkill AI — Career Assessment Tool
1
4
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
968
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.9K
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
525
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
640
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
358
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
422
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
472
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
406
🚀 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
343
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
297