Portfolio - Sana Afreen

Excel Project

Customer Performance Report

Develop an analytics system to monitor sales performance, analyze data, and generate reports for effective customer discounts and business expansion opportunities

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

SQL

The Customer Net Sales Performance Report project creates a concise yet detailed report to analyze individual customer sales within a set period

This project compares market performance to benchmarks in Excel, creating an analysis tool to align actual sales with targets

Project Details

This project is a testament to the seamless fusion of meticulous analysis and technological finesse, aimed at empowering AtliQ Hardware with comprehensive insights into its sales trajectory and financial vitality. Through the adept utilization of Microsoft Excel, we have crafted a suite of dynamic reports tailored to the specific needs of AtliQ Hardware, providing a panoramic view of its operational performance and strategic opportunities

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardware is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exist in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights

View Project
Engagement

Other Tools

Power BI

SQL

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

"In the Home view, By clicking on a button, users will be directed to the corresponding page, including: Info Finance

The Finance View provides a comprehensive analysis of financial data, offering insights into revenue generation, and expenditure patterns

Project Details

"The objective of this project is to construct a singular, comprehensive report tailored for stakeholders across sales, marketing, finance, and executive teams. Emphasis will be placed on the following key components:

Establishing a sturdy foundation through robust data modeling.
Crafting a user-centric report design to enhance accessibility and usability.
Providing actionable insights through drillable data exploration."

Live Interactive Dashboard

Python Project

Entertainer Data Analysis

Escape stress with entertainment! Film, TV, radio, and print media offer a retreat from daily worries. Dive into movies, shows, music, news, and books—the entertainment industry's array of delights await, providing relaxation and ease in facing life's challenges.

View Project
Engagement

View Project
on GitHUB

Explore detailed insights on entertainers through comprehensive data analysis, empowering a deep dive into their performances, trends

Delve into in-depth data analysis for the top 5 actors and actresses, uncovering trends, performance metrics, and audience reception for unparalleled

Project Details

The dashboard offers insights tailored to user needs, with dropdowns for selecting entertainers and filters for movies by rating and year.

Live Interactive Dashboard

PowerBI Project

Sales Insights

I crafted a Power BI dashboard to analyze AtliQ hardware's sales trends over the past four years, with the potential to boost revenue by at least 7% in the upcoming quarter.

View Project
on GitHUB

Analyze revenue, profit margin, and sales quantity for actionable insights.

Conducted SQL analysis, connected to Power BI, performed ETL, currency conversion, created measures, and adjusted report based on stakeholder feedback

Project Details

Experience the power of data-driven decision-making with my meticulously crafted Power BI dashboard, tailored to analyze AtliQ hardware's sales trends spanning the last four years. Gain valuable insights into sales performance, identify key patterns, and uncover actionable strategies to propel revenue growth.

Live Interactive Dashboard

PowerBI Project

AtliQ Hospitality Analysis

Tasked with addressing declining market share for AtliQ Grands luxury hotels, our mission is to construct a dashboard pinpointing root causes and guiding stakeholders toward strategic solutions for market resurgence.

View Project
Engagement

View Project
on GitHUB

It's the dashboard which I have created for analysis.

This image represents the data view which shows connections with facts and dimension tables.

Project Details

🏨 Title: AtliQ Hospitality Analysis 📊🔑

🔍 Project Overview:
AtliQ Grand, a prominent 5-star hotel chain in India, is facing revenue challenges due to ineffective decision-making and fierce competition. They're seeking to leverage "Business and Data Intelligence" for informed decisions.

📋 Objectives:
This data analysis initiative aims to empower AtliQ Grand's Revenue Team with actionable insights from historical data. As a data analyst, my mission is to deliver key findings, establish metrics, construct an insightful dashboard, and provide actionable recommendations to enhance decision-making.

💡 My Achievements:
✅ I've fostered connections between various datasets.
✅ I've grasped essential metrics and terminology in the hospitality domain
✅ I've devised measures and KPIs to monitor revenue across different segments, including room types, booking platforms, and occupancy rates, enabling a detailed analysis of revenue performance.

Hello, I am

Sana Afreen

1

3

1

About

Technical

My

Customer Performance Report

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Entertainer Data Analysis

Sales Insights

AtliQ Hospitality Analysis

Awards

Contact Me

Email

Github

Linkedin

Call

Sana Afreen

Download Resume