vedika hirwani

Data Analyst

TechChefzDigital

Sep 2022 - Present

Developed interactive dashboards using Power BI to visualize key performance indicators. Analyzed large datasets to identify trends and insights for strategic decision-making. Provided analytical support for marketing initiatives, driving targeted campaign strategies based on data insights. Extracted and cleaned data from SQL Server using SQL and Power Query, including handling duplicates, missing values, and data standardization. Performed data transformation in Power Query and designed a star schema data model to enable efficient and scalable reporting. Developed interactive Power BI dashboards providing executive, product, and customer-level insights, utilizing DAX measures for key Sales KPIs (Revenue Growth, Regional Sales) and Marketing KPIs (Marketing ROI, Customer Acquisition Cost, Conversion Rate). Built user-friendly reports with drill-down capabilities, slicers, filters, and bookmarks to support data-driven decision-making. Validated data accuracy using SQL and Excel prior to publishing on Power BI Service, ensuring reliable reporting and seamless scheduled refreshes. Delivered measurable business impact, driving ~10% growth in regional sales, improving marketing ROI by ~12%, enhancing sales planning accuracy, and optimizing campaign performance by identifying high- and low-performing channels.