Anand Cinenkanolu

Data Ananlyst

[email protected]

Hello, I am

Anand Cinenkanolu.

1

Excel
Project

3

PowerBI
Projects

2

SQL
Projects

About Me

About Me
I am a Data Analyst with a strong passion for turning raw data into actionable business insights. With expertise in Power BI, SQL, and Excel, I specialize in data visualization, reporting, and business intelligence.

What I Do
📊 Data Visualization – Creating interactive dashboards and reports to uncover trends and drive business decisions.
🔍 Data Analysis – Cleaning, transforming, and analyzing large datasets to extract valuable insights.
🚀 Business Intelligence – Leveraging data to optimize sales, operations, and workforce management.

Tools & Technologies
✔ Power BI – Dashboard design, DAX calculations, Power Query
✔ SQL & MySQL – Querying, data extraction, performance analysis
✔ Excel – Advanced formulas, data cleaning, reporting
✔ Python (Pandas) – Data processing, automation

💡 Interested in collaborating or hiring me? Feel free to reach out! 📩 [[email protected]]

Key Skills

Power BI Desktop

Power BI Service

Problem Solving

Advanced Excel

MySQL

Effective Communication

My Projects

Busniess Insights 360

Domain/Function: Brick & Mortar and E-Commerce

AtliQ Sales and Finance Analysis Reports

Domain/Function: FMCG

Shield Insurance Analysis

Domain/Function: Insurance

Ad-hoc Consumer Goods Analysis

Domain/Function: Consumer Goods

AtliQ Hardwares On Demand Data Insights

Domain/Function: Consumer Goods

Atliq Grand Hotel's Comprehensive Analysis

Domain/Function: Hospitality

My Experience

My Experience:

Data Analyst Intern (Virtual Internship). April 2025 - May 2025
AtliQ Technologies, Gujarat.

Data Analyst Internship at AtliQ Technologies

- Key Responsibilities & Learning:

· Data Quality Management: Implemented standardization, duplication, and normalization techniques to ensure data integrity and improve processing efficiency across multiple datasets.

· Business Intelligence Analysis: Performed ad-hoc and variance analyses using Excel and Power BI, focusing on market trends, order volumes, and identifying critical data discrepancies.

· Database Query Optimization: Enhanced MySQL query performance through systematic fine-tuning, improving data extraction accuracy for complex analytical requirements.

· Reporting Automation: Developed automated solutions for client network operations reporting, significantly reducing manual processing time and increasing operational efficiency.

· Technology Impact Analysis: Analyzed 5G adoption dashboards to assess impact on financial performance, operational metrics, and customer behavior insights.

· Dashboard Development: Created an interactive Power BI dashboard for Shield Insurance, visualizing customer acquisition trends and revenue growth with advanced filtering and dynamic features.

· Stakeholder Communication: Translated complex data findings into actionable insights for business stakeholders, supporting data-driven decision-making processes.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Microsoft Fabric Mini: For Data Analysts

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/Anand-Cinenkanolu/

GitHub

https://github.com/Anand-Cinenkanolu

PowerBI Project

Busniess Insights 360

Domain/Function: Brick & Mortar and E-Commerce

Developed a comprehensive Power BI dashboard that revolutionized AtliQ Hardware's business intelligence. Analyzed 1.8+ million data points across 5 key domains: finance, sales, marketing, supply chain, and executive performance, delivering actionable insights for strategic decisions.

View Project
on GitHUB

𝗛𝗼𝗺𝗲 𝗣𝗮𝗴𝗲: Intuitive dashboard hub enabling one-click access to Finance, Sales, Marketing, Supply Chain & Executive views for all domains.

𝗘𝘅𝗲𝗰𝘂𝘁𝗶𝘃𝗲 𝗩𝗶𝗲𝘄: High-level command center displaying key business metrics and competitor comparisons, giving executives instant insights.

Project Details

𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲: AtliQ Hardware struggled with fragmented data across departments, hindering strategic decision-making.

𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻: Built a unified Power BI dashboard integrating 1.8+ million data points from Excel/CSV and MySQL databases. Developed robust data models connecting 10+ tables using advanced Power Query and complex DAX formulas.

𝗞𝗲𝘆 𝗙𝗲𝗮𝘁𝘂𝗿𝗲𝘀:
• Interactive visuals with filters, slicers, and drill-downs.
• Cross-departmental insights for finance, sales, marketing, supply chain, and executive teams.
• Performance optimization using DAX Studio.
• Bookmarks for seamless navigation.
• Deployed on Power BI Service for enterprise access.
• Implemented stakeholder feedback loops for user adoption.

𝗜𝗺𝗽𝗮𝗰𝘁: Transformed decision-making with real-time visibility, enabling data-driven strategies that identified strengths, weaknesses, and growth opportunities across all departments.

Live Interactive Dashboard

Excel Project

AtliQ Sales and Finance Analysis Reports

Domain/Function: FMCG

Analyzed FMCG financial performance via Excel-based reports tracking customer sales metrics and market targets. Built dynamic dashboards using pivot tables, Power Query, and DAX to identify revenue gaps and optimization opportunities.

View Project
Engagement

View Project
on GitHUB

This report compares actual sales performance against sales targets across global markets. While India led with $161.3M in sales, several markets like

This report highlights the net sales performance of AtliQ Hardware's key customers from 2019 to 2021. It showcases significant growth, with Amazon and

Project Details

𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗢𝘃𝗲𝗿𝘃𝗶𝗲𝘄:
Built comprehensive sales and finance analytics reports for AtliQ Hardware analyzing performance, financial health, and market trends. Developed dynamic Excel reporting system processing customer discount patterns and identifying revenue optimization opportunities across divisions/regions.

𝗧𝗲𝗰𝗵𝗻𝗶𝗰𝗮𝗹 𝗦𝗸𝗶𝗹𝗹𝘀:

• Engineered automated pivot table architecture with real-time refresh
• Built Power Query ETL pipeline reducing reporting time by 85%
• Implemented DAX functions and Power Pivot for advanced calculations
• Designed conditional formatting enhancing visual appeal and readability
• Created drillable dashboards for granular data exploration

𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗺𝗽𝗮𝗰𝘁:

Created actionable Excel reports enabling sales strategy optimization and revenue growth. Analytics framework empowered leadership to monitor KPIs, evaluate top-performing products, assess market profitability, and make data-driven decisions for market adaptation.

PowerBI Project

Shield Insurance Analysis

Domain/Function: Insurance

Collaborating with Shield Insurance, I created a Power BI dashboard to analyze sales performance and customer behavior across 5 cities. The solution uncovered revenue trends, customer segments, and growth opportunities in the market.

View Project
Engagement

View Project
on GitHUB

Overview Analysis tracking Shield Insurance performance across 5 cities. Analyzed revenue trends, demographics, and KPIs for strategic decisions.

Customer segmentation reveals age-based patterns. Identified 31-45 as the core revenue segment and 17-24 as the untapped growth opportunity.

Project Details

The Challenge:
• Fragmented data across 5 major cities in India.
• No unified insights for strategic decision-making.
• Need to optimize multiple sales channels for improved performance.
My Solution:
During my internship at AtliQ Technologies, I collaborated with Shield Insurance to build a Power BI dashboard for actionable insights. The key features included:
• Revenue Trends & Sales Metrics: Tracked growth across sales channels and regions.
• Customer Segmentation: Analyzed demographics and policy adoption.
• Channel Performance: Compared offline, direct, and digital sales channels.
Key Discoveries:
• Offline agents: Contributed 55.6% of revenue.
• Digital channels: Saw 15% MoM growth.
• 31-45 age group: 31.5% of revenue.
• Delhi-NCR: Top market, while Indore showed expansion potential.
Business Impact:
• Optimized resource allocation.
• Enabled data-driven decision-making.
• Identified growth opportunities and informed marketing strategies.

Live Interactive Dashboard

SQL Project

Ad-hoc Consumer Goods Analysis

Domain/Function: Consumer Goods

Answered 10 key business questions for AtliQ Hardwares using SQL. Turned raw data into insights on sales, customers, and market trends. Built a clear visual deck with takeaways to help leadership make faster, smarter decisions.

View Project
on GitHUB

AtliQ 8 major markets across the APAC region: India, Indonesia, Japan, Philippines, South Korea, Australia, New Zealand, and Bangladesh.

Highest vs Lowest Manufacturing Costs Insight: Product pricing is tiered. Cost range: $240.45 vs $0.89.

Project Details

Ad-hoc Consumer Goods Analysis (SQL Project)

Company: AtliQ Hardware (electronics and computer peripherals)

𝗢𝗯𝗷𝗲𝗰𝘁𝗶𝘃𝗲:
Help leadership answer 10 high-priority business questions using SQL.

𝗞𝗲𝘆 𝗙𝗼𝗰𝘂𝘀 𝗔𝗿𝗲𝗮𝘀:
• Market performance
• Customer behavior
• Product growth
• Sales & profitability

𝗪𝗵𝗮𝘁 𝗜 𝗗𝗶𝗱:
• Wrote efficient SQL queries using CTEs, window functions, joins & filters
• Transformed raw Data into clear, actionable business insights
• Built a visual deck with executive-level summaries
• Shared key takeaways for faster decisions

𝗦𝗸𝗶𝗹𝗹𝘀 𝗔𝗽𝗽𝗹𝗶𝗲𝗱:
• Technical: SQL (joins, CTEs, case statements, optimization)
• Analytical: Insight framing, business mapping
• Soft Skills: Storytelling, stakeholder communication, visual thinking

SQL Project

AtliQ Hardwares On Demand Data Insights

Domain/Function: Consumer Goods

𝗔𝘁𝗹𝗶𝗤 𝗦𝗮𝗹𝗲𝘀 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 | 𝗦𝗤𝗟 𝗗𝗮𝘁𝗮 𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻 Developed an automated analytics platform that: ✔ Streamlined sales reporting & supply chain forecasting ✔ Improved forecast accuracy by 15% via SQL optimization ✔ Identified top-performing markets/products with dynamic ran

View Project
on GitHUB

Written Sample Query

Created a stored procedure to fetch the details of the Market, fiscal year and Top n

Project Details

𝗔𝘁𝗹𝗶𝗤 𝗦𝗮𝗹𝗲𝘀 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 | 𝗦𝗤𝗟 𝗗𝗮𝘁𝗮 𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻
Developed an automated analytics platform that:

▪️ Streamlined sales reporting & supply chain forecasting
▪️ Improved forecast accuracy by 15% via SQL optimization
▪️ Identified top-performing markets/products with dynamic ranking

𝗧𝗲𝗰𝗵 𝗦𝘁𝗮𝗰𝗸: Advanced SQL functions, parameterized procedures, data modeling

PowerBI Project

Atliq Grand Hotel's Comprehensive Analysis

Domain/Function: Hospitality

AtliQ Grand leverages data analytics to recover lost revenue, boost occupancy, and drive smarter decisions. This hospitality BI project highlights how interactive dashboards can translate complex booking data into clear business insights.

View Project
on GitHUB

Welcome to AtliQ Grand’s dashboard – navigate easily between insights with a clean, inviting landing screen.

Track key hotel KPIs at a glance: revenue, RevPAR, ADR, occupancy, category share, and weekly performance.

Project Details

AtliQ Grand, a premium hotel chain, faced revenue drops and stiff competition. I built a Power BI dashboard to help them regain market share using data-driven decisions.

Dashboards Developed
• Overview View – Tracks KPIs: Revenue, ADR, RevPAR, Occupancy %, Realization %
• Executive View – Explores revenue by city, platform, room type, and cancellation trends
• Weekly Trends – Visualizes booking patterns and revenue shifts

Key Insights
• Revenue fell 28.17% in the last 4 days
• RT2 room type is the top earner
• Mumbai contributed 13.59% of total revenue
• MakeMyTrip & LogTrip drive most bookings
• June had 25.09% cancellation rate
• AtliQ Blu rated 72.54% higher than AtliQ Seasons

Skills Used
Advanced DAX, UX design, executive storytelling, hospitality analytics, and Power BI