# PRECIOUS CHINAGOROM AGUBATA - Aspiring Data Analyst Source: https://hello.cv/preciousagubata Anambra ## Links - Email - Phone ## About Aspiring Data Analyst with comprehensive training in data collection, cleaning, analysis, and visualization from the 3 Million Technical Talent (3MTT) program. Proven ability to transform complex real-world datasets into actionable insights through statistical analysis, interactive dashboards, and robust reporting using Python, Excel, Power BI, and SQL. Combines strong analytical thinking with effective communication to drive data-driven decision-making and enhance business performance. ## Work ### Data Analyst | 3 Million Technical Talent (3MTT) Implemented advanced lookup functions and structured datasets in Excel to automate data extraction and enhance reporting efficiency. - 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. ### Data Analyst | 3 Million Technical Talent (3MTT) Executed comprehensive data cleaning and regional performance analysis for sales data, enhancing data accuracy and reporting efficiency. - 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. ### Data Analyst (Dashboard Developer) | 3 Million Technical Talent (3MTT) Developed an interactive Excel dashboard for bike sales, analyzing customer purchasing behavior and regional trends to drive sales 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. ### Data Visualization Specialist | 3 Million Technical Talent (3MTT) Designed and developed an interactive Power BI sales performance dashboard, tracking key business metrics and delivering actionable insights. - 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. ### Data Analyst (Project Lead) | 3 Million Technical Talent (3MTT) Led a data cleaning, merging, and visualization project using Excel to analyze multi-year crime data and generate actionable insights. - 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. ### Data Analyst (Database Developer) | 3 Million Technical Talent (3MTT) Designed and implemented a relational SQL database for sales analysis, enabling efficient storage and querying of transactional data. - 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. ## Education ### Nnamdi Azikiwe University | Political Science ## Certificates ### Data Analyst - 3 Million Technical Talent (3MTT) 3 Million Technical Talent (3MTT) | 2025-12-31 ### AI Career Essentials ALX Africa | 2024-12-31 ### Virtual Assistant ALX Africa | 2024-12-31 ### Excel Essentials for Reporting David Brown Online Training | 2020-12-31 ## Skills ### Data Analysis & Tools - Data Cleaning & Preprocessing - Descriptive & Inferential Statistics - Data Visualization (Excel, Power BI, Tableau) - Python (Pandas, NumPy, Matplotlib, Seaborn) - SQL (basic queries) ### Software & Office Productivity - Microsoft Word - Excel - PowerPoint - Canva for data reporting visuals - Internet Research ### Soft Skills - Analytical Thinking - Problem Solving - Attention to Detail - Communication & Reporting - Time Management - Team Collaboration ## Interests ### Professional Interests - Data Analysis & Business Intelligence - Data Visualization & Reporting - Evidence-Based Decision Making - Predictive Analytics ## Source Read this profile on Hello.cv: https://hello.cv/preciousagubata Create your free profile at https://hello.cv