Aurora Chatbot - Customer Analytics Dashboard
Power BI · DAX · Data Visualization · Dashboard Design · UI/UX
Designed a modern Power BI customer analytics dashboard for an AI chatbot, focused on making complex conversational data easy to understand at a glance.
Developed an interactive Power BI dashboard to analyze sales performance, customer behavior, and business KPIs. The solution transforms raw data into actionable insights through dynamic visualizations and automated reporting.
Key Features:
Interactive KPI cards for Revenue, Inforce Policy Orders, and Growth
Sales analysis by State, Product Category, and Policy Segment
Dynamic slicers and drill-through functionality
Year-over-Year (YoY) performance tracking
Profitability and trend analysis using DAX measures
Data modeling with relationships and star schema design
Automated data refresh and optimized report performance
Tools & Technologies:
Power BI Desktop
Power Query
DAX
SQL / Excel Data Sources
Data Modeling & Visualization
Skills Tags🔥
Power BI • DAX • Power Query • Data Visualization • Business Intelligence • Dashboard Design • SQL • Data Analytics
I built an AI-powered Facebook Messenger Follow-up Automation workflow using n8n to help businesses reconnect with potential customers and reduce missed sales opportunities.
When a customer asks about a product but stops replying, businesses often lose track of the conversation. This workflow helps automate timely, personalized follow-ups while keeping customer experience in mind.
What the Workflow Does
Automated Follow-ups: Sends follow-up messages at the right time.
AI-Powered Personalization: Uses AI to generate personalized messages based on customer conversations.
Order Verification: Checks order status before sending reminders.
Communication Scheduling: Avoids sending messages during late-night hours.
Sales Support: Helps businesses reconnect with interested buyers and reduce manual follow-up tasks.
Tools & Technologies
n8n | AI | Facebook Messenger | Workflow Automation | Order Verification
Project Goal
Demonstrate how AI-powered automation can improve customer communication, streamline sales follow-ups, and create more opportunities for businesses to convert interested buyers.
This is a demo workflow showcasing the potential of AI automation for eCommerce businesses.
Services
I help businesses build AI-powered workflows, sales automation systems, customer support automations, and custom n8n integrations.
The late-night quiet hours are a nice touch. When a follow-up gets held for the morning, does the workflow re-check the order status at send time, or only when the reminder is first queued?