About Me
Data analyst with functional areas in data visualization and data analysis. Skilled in Power BI, Power Query, data modelling, DAX, ETL, reporting and dashboarding, Python basics, MS Excel, and MySQL, with project experie…
Data analyst with functional areas in data visualization and data analysis. Skilled in Power BI, Power Query, data modelling, DAX, ETL, reporting and dashboarding, Python basics, MS Excel, and MySQL, with project experience in building dashboards and analytics reports for sales, finance, hospitality, and HR data.
Experience
Project Experience
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 the data cleaning using Power Query, which can rescue around 4 hrs. of repeated manual work.
Implemented Sales and Finance Analytics Report, revealing key insights like India's highest gross margin of 51.6 million, supporting informed decisions and strategic business growth.
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%.
The dashboard enabled AtliQ hardware to analyze different department sales trends and make data-driven decisions, leading to a projected 10% revenue acceleration and 20% reduction in data-related expenses.
Designed a Power BI dashboard to understand AtliQ hardware’s last 4 years' sales trends.
This dashboard could assist in raising the revenue at least by 7% in the next quarter.
Project Experience
Tailored a Power BI dashboard using 3 months of data, aiding AtliQ Grands in analyzing market share & revenue decline.
With this dashboard, the Revenue team of AtliQ Grands was able to gain insights into their revenue trend.
This could help in regaining their revenue and market share by 20% in the next month.
Project Experience
Built a Power BI dashboard covering different KPIs (Present %, WFH %, and SL %) to track Attendance by HR of business at AtliQ Technologies, a Technology Company with 3 months of data.
This Analysis can potentially save 20% of their investment in the expansion.