Aneesh Mohanan, MBA

• View Project in Github
• View Project

Finance and VAT Analysis with Power BI and DAX

Project Overview: Conducted comprehensive financial and VAT analysis using Power BI, DAX, Python, Excel to provide actionable insights and enhance decision-making processes.

• View Project in Github
• View Project

Financial Data Analysis in Property Management

Project Overview: Experienced Financial Data Analysis in the property management sector. I possess expertise in financial reporting, budgeting, forecasting, and advanced data analysis to ensure the financial health and regulatory compliance of real estate assets.

• View Project in Github
• View Project
• View Project
• View Project

Income Statement Analysis

Project Overview: This Power BI dashboard provides an interactive monthly analysis of a company's **Income Statement** for the year 2025. It visualizes **Revenue**, **Direct Expenses**, **Indirect Expenses**, and calculates key performance metrics such as **Gross Profit**, **Net Profit**, and **Profit Margins**.

• View Project in Github
• View Project

Dental Clinic Operations Dashboard

Project Overview: This Power BI dashboard presents a comprehensive analysis of a dental clinic’s operations for the year 2024. It enables monitoring of key metrics such as **revenue**, **cost**, **profit**, **patient count**, **treatment distribution**, **dentist performance**, **payment types**, and **demographics**. Designed for clinic managers and analysts to make data-driven decisions and optimize service delivery.

• View Project in Github
• View Project

Coffee Shop Sales Dashbaord

Project Overview: Project Overview An interactive dashboard designed to analyze key sales and operational metrics of a coffeeshop chain across three locations.

• View Project in Github

MySQL Project – Restaurant Menu Analysis

Project Overview: This project showcases my **MySQL data analysis skills** using a simulated restaurant database. The goal was to analyze the **newly launched menu**, understand **customer ordering behavior**, and provide **actionable insights** to optimize operations and offerings.

• View Project in Github

Interactive Document Processing AI Application (LLM)

Project Overview: Developed a user-friendly AI application utilizing Large Language Models (LLM) and Python libraries to revolutionize document analysis and content retrieval.

• View Project in Github

Patient Record Data Analysis

Project Overview: This project involved developing an interactive dashboard to analyze patient data from a healthcare facility. The dashboard was designed using Python, Power BI, DAX, and Excel, providing both desktop and mobile views for ease of access and navigation.

• View Project in Github
• View Project

Sales, Purchase and VAT Analysis

Project Overview: In this project, I developed an interactive Sales-Purchase and VAT Analysis report using Google Data Studio to provide valuable insights into sales, purchase, and VAT trends for businesses. The report visualizes key financial metrics and presents actionable insights to drive better business decisions..

• View Project in Github
• View Project

Extracting, Analyzing, and Visualizing Data from .eml Files Using Python

Project Overview: This project involved automating the extraction of data from .eml (email) files, conducting data analysis, and creating visualizations using Python. The extracted data was analyzed to uncover trends in email activity over time, identify key senders and recipients, and visualize common email subjects. I used libraries such as Pandas, Matplotlib, and Seaborn to process and visualize the data, providing valuable insights into the email data set. The final report and visuals were exported to Excel for easy sharing and further analysis.

• View Project in Github

Coffee Shop Sales Analysis with Python

Project Overview: This project is focused on analyzing the sales data of a coffee shop using Python's Pandas, NumPy, Matplotlib, and Seaborn libraries. The dataset contains various details of transactions, including the transaction date, time, store location, product details, and sales amounts. The aim is to perform an exploratory data analysis (EDA), handle missing data, perform data cleaning, and generate visualizations to uncover key insights about sales trends across different store locations and time periods.

• View Project in Github
• View Project in Streamlit APP

Experience vs Salary Machine Learning Simple Linear Regression

Project Overview: This project demonstrates a simple linear regression model using Streamlit to predict salaries based on years of experience. The model is trained on a dataset and provides real-time predictions and visualizations through a web application.

• View Project in Github
• View Project in Streamlit APP

Tata Data Visualisation

Tata Data Visualisation: Empowering Business with Effective Insights Job Simulation on Forage - December 2023
- Completed a simulation involving creating data visualizations for Tata Consultancy Services
- Prepared questions for a meeting with client senior leadership
- Created visuals for data analysis to help executives with effective decision making
 

• View Project

Accenture North America Data Analytics and Visualization

Accenture North America Data Analytics and Visualization Job Simulation on Forage - February 2024
- Completed a simulation focused on advising a hypothetical social media client as a Data Analyst at Accenture
- Cleaned, modelled and analyzed 7 datasets to uncover insights into content trends to inform strategic decisions
- Prepared a PowerPoint deck and video presentation to communicate key insights for the client and internal stakeholders