Ritesh

Ritesh

Data Analyst
India

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…

Experience

Project Experience

AtliQ Hardware

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

AtliQ Grands

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

AtliQ Technologies

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.

Skills

Data Analysis Professional Excel MySQL Python Power BI Data Cleaning & Modeling Reporting & Dashboarding Power Bi Python (Basics) Data Visualization Data Analysis Data Cleaning Data Modeling Reporting Dashboarding Power Query Data Modelling DAX Power BI Services ETL Data Reporting Data Transformation MS Excel Pivot Table Pivot Chart Lookup Functions Excel Functions Data types Queries Subqueries Joins CTE Window functions Aggregate functions DAX Studio SQL CSV
Report this Profile?