PRECIOUS CHINAGOROM AGUBATA

Applied VLOOKUP and XLOOKUP functions to retrieve and match data across multiple worksheets, streamlining data consolidation processes.

Built robust formulas to automate data extraction, efficiently answering complex analytical questions and reducing manual effort.

Structured datasets to significantly improve accessibility and reporting efficiency, enhancing overall data management.

Generated summarized insights from integrated data sources, supporting comprehensive cross-sheet analysis and decision-making.

Performed extensive data cleaning, removing duplicate IDs and correcting spelling inconsistencies to improve data quality by over 15%.

Identified and eliminated invalid values, including infinite entries in price fields, ensuring data integrity for accurate analysis.

Calculated total sales value using Quantity × Price per Unit, providing accurate revenue metrics for performance tracking.

Created a structured summary table showcasing regional sales performance and product distribution for strategic insights.

Cleaned and prepared a retail sales dataset, ensuring readiness for in-depth analysis and reporting, improving data reliability.

Analyzed customer purchasing behavior based on income level, marital status, education, occupation, and region, identifying key demographic trends.

Developed an interactive Excel dashboard utilizing Pivot Tables, slicers, and dynamic charts to visualize sales performance and trends.

Generated actionable insights on regional purchasing trends and the influence of commute distance on bike sales, informing marketing strategies.

Designed and developed an interactive sales dashboard in Power BI, tracking key business metrics including Total Sales ($298K), Total Profit ($60K), and Average Order Value ($2.98K).

Built dynamic visualizations to analyze sales trends across months, regions, and product categories, enabling rapid identification of performance patterns.

Implemented drill-through functionality and filters, improving user interactivity and enabling detailed customer-level analysis.

Created robust data models and structured datasets, ensuring efficient reporting and scalability for future analyses.

Delivered actionable insights on top-performing regions (East: $93K) and products (Accessories: 23%), directly supporting strategic decision-making.

Cleaned and standardized multi-year datasets (2012-2024), eliminating duplicates and correcting inconsistencies to ensure data integrity and accuracy.

Consolidated multiple worksheets into a structured dataset, enhancing data accessibility and preparation for comprehensive analysis.

Developed impactful visualizations to effectively analyze crime trends, offence distribution, and category comparisons across different years.

Produced a structured report summarizing key patterns and insights identified in the dataset for informed decision-making.

Designed and created a relational database with Customers and Orders tables, establishing primary and foreign key relationships for data integrity.

Inserted and structured transactional sales data, optimizing it for analytical queries and reporting efficiency.

Utilized SQL for basic queries to extract meaningful insights from the sales database, supporting data-driven decisions.