Sanapathi Shanmukha Rao

Sanapathi Shanmukha Rao

Data Analyst
India
Telugu, Hindi, English

About Me

Passionate and motivated data analyst eager to leverage skills and knowledge to help organization by digging deep into complex datasets to uncover valuable insights that drive business decisions.

PROJECTS

Business 360- [Power BI | SQL | Excel | Dax Studio]

Duration : 31-Oct-2025 - 30-Nov-2025

Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market by gathering data from 2 different sources (Excel/CSV files and a SQL database). ● Built data model and visualizations in Power BI, and optimized the report with DAX studio which improved the performance of the report by 5%. ● Developed a dashboard that enabled Atliq Hardware to analyze department sales trends, driving a projected 10% revenue acceleration and a 20% reduction in data-related expenses.

Hospitality Analysis – [Power BI | Excel]

Duration : 31-Jul-2025 - 29-Aug-2025

Customized a Power BI dashboard using 3 months of hotels and bookings data, pinpointing reasons for declining market share and revenue at AtliQ Grands. ● Empowered the Revenue Team with actionable insights and findings, predicting a rapid 20% recovery in both revenue and market share within a month.

P&L Report - [Excel | Pivot Table | Power Query]

Duration : 14-Jul-2025 - 30-Jul-2025

Generated a comprehensive P&L report for AtliQ Hardware FY 2022, utilizing advanced features in Excel such as Pivot Tables and DAX to provide granular insights into revenue streams and expense categories. ● Automated data cleaning using Power Query, which can rescue around 4 hrs of repeated manual work. ● Deployed DAX-based calculation models, resulting in a 30% increase in report accuracy and providing users with more nuanced, flexible data insights.

Certifications

power bi

be10x · Ahmedabad, India · 2025

data analyst

Simplilearn · Ahmedabad, India · 2025

Skills

MySQL Python Structured Query Language (SQL) Microsoft SQL Server Power BI Advanced Excel Pivot Tables Power Query DAX DAX Studio
Report this Profile?