Business Intelligence Analyst
Current• Analyzing sales data and performance metrics to identify trends, patterns, and insights related to product sales. Utilizing data visualization tools like Tableau, Excel, PowerPoint to present findings in a clear and meaningful manner• Providing Task automation using VBA macros, Creating dynamic reports with PivotTables• Managing large datasets with functions: IF, SUM, INDEX, MATCH, VLOOKUP, XLOOKUP, INDEX MATCH, Named Range• Implemented slicers with VBA automation to enable users… Show more • Analyzing sales data and performance metrics to identify trends, patterns, and insights related to product sales. Utilizing data visualization tools like Tableau, Excel, PowerPoint to present findings in a clear and meaningful manner• Providing Task automation using VBA macros, Creating dynamic reports with PivotTables• Managing large datasets with functions: IF, SUM, INDEX, MATCH, VLOOKUP, XLOOKUP, INDEX MATCH, Named Range• Implemented slicers with VBA automation to enable users to select dynamic time periods for data visualization.• Creating and maintaining regular sales reports, dashboards, and metrics to track KPI's, such as revenue, call attainment, product sold vs promotional enablement, call activity, and sales funnel metrics• Monitoring and tracking sales team performance gaps, providing recommendations for improvement, and supporting sales incentive programs.• Leveraged macros and advanced Excel functionality to automate data processing tasks, resulting in a 30% reduction in report generation time• Developed and maintained complex Excel-based reports and dashboards for tracking KPIs and providing actionable insights• Successfully migrated manual reports to Tableau, improving data accessibility and efficiency.• Implemented Area Scorecard analysis on calls and sales data to provide YTD and TTD metrics.• Utilized LOD expressions to drill down into geography levels, enabling detailed analysis and insights.• Leveraging Tableau's features and best practices to create compelling data visualizations. Choosing appropriate chart types, colors, and layouts to effectively communicate sales trends• Implementing automated data refreshes and scheduling, setting up data connections and triggers to streamline data extraction and integration processes• Provided production support to tableau users and wrote custom SQL to support business requirements Show less