Archana Mohan

Data Analyst | Power BI | SQL | Python | Excel

About Me

I am a Data Analytics professional transitioning from a Software Development background into Data Analytics. I have completed a Diploma in Data Analytics and am building practical projects focused on transforming data into meaningful business insights.

            My focus: Data Analysis, Business Intelligence,
            Data Visualization, KPI Analysis, and Data-driven Decision Making.
        

Technical Skills

Data Analysis

SQL Python Excel Statistics

Business Intelligence & Visualization

Power BI Tableau Data Visualization KPI Analysis

Analytics

Data Cleaning Exploratory Data Analysis Business Insights Prompt Engineering

Featured Project

Customer Support Ticket & Service Quality Analytics

A Power BI project analyzing customer support operations to evaluate ticket trends, SLA compliance, resolution efficiency, customer satisfaction, and agent performance.

Analyzed 2,330 customer support tickets
Evaluated First Response and Resolution SLA performance
Analyzed customer satisfaction and support efficiency
Built interactive Power BI dashboards for operational insights

Dashboard Preview

Customer Support Ticket & Service Quality Analytics

Executive Overview Dashboard

SLA and Service Quality Dashboard

Operations and Agent Performance Dashboard

Ticket Insights Dashboard

Cloud Project Dashboard Preview

Cloud Service Usage & Cost Analytics

Cloud Cost Executive Overview Dashboard

Cloud Cost and Service Analysis Dashboard

Cloud Resource and Regional Analysis Dashboard

Cloud Usage and Data Quality Dashboard

More Projects

Cloud Service Usage & Cost Analytics

Analyzed cloud service costs, resource utilization, regional spending, and data quality using SQL, Python, and Power BI.

Analyzed 10,000 cloud usage records
Identified major cost drivers across cloud services
Reviewed resource utilization and data quality
Built four interactive Power BI dashboard pages

Amazon Product Category Revenue Dominance Analysis

A Python-based e-commerce analytics project examining product category revenue contribution to identify dominant revenue-generating categories.

Analyzed Amazon sales data using Python
Explored revenue contribution across product categories
Developed insights to support e-commerce decisions

Education

Diploma in Data Analytics

B.Tech – Computer Science & Engineering

Let's Connect

I am currently building my Data Analytics portfolio and exploring opportunities in Data Analytics and Business Intelligence.

LinkedIn GitHub