Vaishali

Vaishali Rode [відкрити контакти](див. вище в блоці «контактна інформація») | [відкрити контакти](див. вище в блоці «контактна інформація») |LinkedIn |Github|
Skills: Programming Analytical Tool Database:
SQL (structured query language) || Power BI, Excel || MySQL
Other: Data Manipulation, Data Visualization, Communication, Willingness to learn collaborate with the team
Projects:
Sales Analytics Report-[Excel |Power Query|Pivot Table] July 2023
• 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.
• As it used DAX measure for calculations, it provided a better user experience and flexibility.

Business 360- Brick & mortar, e-commerce [Excel |Power BI | SQL]
https://app.powerbi.com/view?r=eyJrIjoiY2I4ZjVlZjMtNjVmNC00OTFmLTg4NWYtNTg2MDhjZDdkZDU1IiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9 Aug 2023
• Customize a multifunctional Power BI dashboard to analyze AtliQ Hardware’s sales trends over the global market by collecting data by two different sources (Excel/CSV file and SQL database.
• Build a data model and visualization in Power BI and optimize the report with DAX studio, which improves the performance by5%.
• The dashboard enabled AtliQ Hardware to analyze the different departments of sales trend and make data driven decision, leading to a projected 10% revenue acceleration and 20% reduction in data related expenses.

Hospitality Analysis-Hotel Chain Business [power BI, Excel] https://app.powerbi.com/view?r=eyJrIjoiZTNjMWQzMzEtZmVlOC00N2YyLWE2OTAtMTZkOTVmNzZhZDFhIiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9 Jan 2024

• AtliQ Grands noticed a loss in a market share and revenue over a few months. To diagnose the cause of this loss they needed a way a way to analyze this. I streamlined a dashboard in Power BI using 3 months of data.
• With this dashboard, the revenue team of AtliQ Grands turn to gain insights into their revenue trend. could help them regaining their revenue and market share by 20% in the next month.

Certification and Awards:
SQL: Beginners to Advance for Data Professional
Excel: Mother of business Intelligence
Power BI: Data Analytics for All Levels

Education:
• BSc,LLB-Bbachelor of Law(Business law) (Nagpur University, India)