Spreadsheets and Business
Analyzed real business datasets to uncover customer retention patterns, segment buyer behavior and calculate lifetime value using cohort analysis, RFM and LTV modeling.
PLAN. ANALYZE. GROW.
End-to-end digital growth - strategy,analytics,and website design .
Hey, I’m Abhijeet Anand , from IIM Bangalore. I’m currently pursuing a BBA in Digital Business & Entrepreneurship and have previously interned at the Ministry of Information Technology. I provide an end-to-end growth service for brands and businesses: I design their website front-end, build business-ready spreadsheets to analyze performance and support decisions, and create complete social media strategies based on data-driven insights. In simple words — I read the data, decide what matters, design a social media plan around it, and create a website that communicates the brand clearly. Everything in one place.
Social Media Strategy
Data & Business Analytics
Frontend Website Developer ( HTML. CSS. JavaScript. Responsive UI)
From data and spreadsheets to social media and websites — I help your business make smarter decisions and build a strong brand.
Design a complete social media strategy for your brand — starting from buyer persona and competitive listening to goal setting and executive summary aligned with overall business objectives.
Create customer-funnel-based content strategy with platform-specific plans, weekly content calendars and content formats that match how your audience discovers, engages and converts.
Build weekly and monthly optimization dashboards aligned with marketing goals — track KPIs, understand what’s working, and improve content performance using real numbers and insights.
Build dashboards and business reports for better decisions — including cohort analysis, clustering, LTV, RFM segmentation, P&L insights and clear action recommendations.
Design and build responsive, modern websites using HTML, CSS and JavaScript — clean UI, smooth experience and a strong brand identity across all pages.
From data analysis → to business insights → to social media marketing → to website design — a complete end-to-end service that connects strategy, execution and brand experience.
Showcasing some of my best work
A fully interactive travel discovery website that enables users to explore destinations, plan trips and get inspired using AI-style itinerary logic and real-time data. The platform combines modern frontend development with multiple APIs to display live weather, city information, travel photography, maps and nearby landmarks for any searched location. Its standout feature is the AI-powered trip planner, which generates customised day-by-day itineraries based on the user’s destination, duration, budget and interests — turning simple search into an end-to-end travel plan. Built with HTML, CSS and JavaScript, the website integrates Unsplash, Wikipedia and OpenWeather APIs, and includes responsive design, dynamic image grids and an interactive world map powered by Leaflet and OpenStreetMap.
A complete social media marketing plan built for an imaginary men’s grooming studio targeting Gen-Z and young professionals. The project includes buyer persona research, competitive & listening analysis, SMART marketing objectives, content pillars, and platform-specific posting strategy. The entire plan is structured around the customer funnel — awareness, engagement, conversion, and loyalty — ensuring that every post has a clear purpose. A weekly and monthly content calendar is included, along with measurable goals and KPIs to track performance and optimize over time. All insights and recommendations are backed by data to maintain consistent brand identity and support long-term business growth.
A fully coded personal resume and portfolio website built using HTML, CSS and JavaScript. The site showcases my skills, experience, services and projects in a clean and responsive single-page layout. I designed and developed the full frontend structure myself, including animations, smooth navigation, section transitions and mobile responsiveness. This website acts as my professional digital identity and demonstrates my ability to convert user requirements into a functional and well-designed web experience.
A complete business analytics project focused on customer retention and Customer Lifetime Value (CLTV) using an online retail dataset. Through spreadsheet analytics, I segmented customers into monthly cohorts, calculated CLTV for every cohort, and built a retention matrix showing how customer repeat-purchase behaviour evolves over time. Customer retention was visualised through percentage tables and graphs to reveal how cohorts expand, contract and stabilise, enabling clear interpretation of customer behaviour patterns. The final dashboard, powered by pivot tables and step-by-step transformations, offers leaders insight into customer value, retention performance and revenue growth opportunities.
A financial analytics project where I converted raw ledger transactions into a structured Profit & Loss statement to support better business decision-making. The project includes automated aggregation of revenue and expense categories, percentage contribution analysis, and dynamic comparisons to reveal cost drivers and profitability insights. Using spreadsheets, I transformed unorganized accounting records into a clean dashboard that highlights margins, operational efficiency and overall financial health—allowing business leaders to identify areas that require attention at a glance.
A detailed presentation on Intellectual Property rights and patent systems prepared during my internship at the Ministry of Electronics and Information Technology (MeitY). The presentation covers copyright vs trademark vs patent, types of patents, patent filing workflow, PCT applications, patentability criteria, global patent trends and crime related to patents. This document demonstrates my ability to research complex topics, synthesize information from credible sources, and communicate insights in a structured and professional format.
A journey through my professional experiences and achievements
Analyzed real business datasets to uncover customer retention patterns, segment buyer behavior and calculate lifetime value using cohort analysis, RFM and LTV modeling.
Built an end-to-end social media strategy including buyer persona research, competitive listening, content pillars, SMART goals, customer-funnel planning and weekly/monthly content calendars.
Created multiple frontend web projects during academic and self-learning work, applying real-world development practices and responsive design principles.
Conducted research on global patent systems and developed a complete Intellectual Property presentation during internship at MeitY.