Data Analyst
CurrentData Analysis, Data Visualization, Data Cleaning & Processing, Data Manipulation• Conducted in-store analysis of product items, focusing on those with low-profit margins, and conducted inventory analysis to identify underperforming items, resulting in a 10% increase in profits through optimized product ordering.• Developed interactive Tableau dashboards for real-time insights, streamlining the process of generating reports.• Utilized Microsoft… Show more Data Analysis, Data Visualization, Data Cleaning & Processing, Data Manipulation• Conducted in-store analysis of product items, focusing on those with low-profit margins, and conducted inventory analysis to identify underperforming items, resulting in a 10% increase in profits through optimized product ordering.• Developed interactive Tableau dashboards for real-time insights, streamlining the process of generating reports.• Utilized Microsoft Power Automate to automate repetitive tasks, thereby enhancing operational efficiency.• Received recognition for constructing interactive Tableau dashboards that provided stakeholders with immediate access to vital sales data, enabling well-informed decision-making.• Addressed client requirements by effectively gathering data from remote access software and various sources in Excel, ensuring comprehensive data collection by identifying the relevant business tasks.• Improved data processing by cleaning, processing, and consolidating datasets from monthly/weekly reports, facilitating data analysis on a quarterly, semi-annual, or annual basis, in accordance with the business requirements, utilizing Excel/SQL.• Enhanced data integrity by formatting, sorting, filtering, eliminating duplicates, and addressing missing values.• Delivered valuable insights by manipulating, aggregating, and exploring data through Excel/SQL, leveraging pivot tables, VLOOKUP, and other tools to generate summary statistics and descriptive analytics.• Enabled data-driven decision-making by performing inferential analysis, making predictions, and drawing conclusions from the data.• Enhanced data accessibility and comprehension by crafting engaging visualizations and interactive dashboards.• Effectively communicated findings and insights to stakeholders in a clear and comprehensible manner. Show less