Data Analyst
- Utilized Power BI's data import functionality to connect to the SQL Server database and extract relevant sales data for analysis.
- Employed Power Query within Power BI to clean the extracted sales data, addressing inconsistencies, removing duplicates, and handling missing values to ensure data accuracy.
- Developed a comprehensive data model within Power BI, establishing relationships between sales data tables and other 8 datasets to facilitate analysis.
- Created visually compelling dashboards in Power BI, leading to a 20% increase in data interpretation speed and a 50% improvement in decision-making accuracy, enabling swift adjustments and more effective strategies.
- The range length report for evaluating sales representatives has resulted in a 60% reduction in bonus payouts, effectively safeguarding the company's reputation.
- Conducted in-depth analysis of sales trends over time, identifying patterns, seasonality, and potential areas for growth or improvement.