Skip to content

albainfantes-data/Mini-task-Portfolio

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Data Analytics Portfolio

About Me

I am an aspiring Data Analyst with experience in SQL, Excel, and data visualization.
My focus is on transforming raw data into structured, reliable insights that support business decision-making.

I enjoy working across the full data workflow, from data cleaning and validation to analysis and dashboard creation, with a strong emphasis on clarity, accuracy, and practical insights.


Skills

  • SQL (data extraction, joins, aggregations, validation checks)
  • Excel (data cleaning, formulas, pivot tables, dashboards)
  • Data Cleaning & Quality Assurance
  • Business Intelligence & Dashboard Design
  • Data Analysis & Reporting

Projects

1. Excel Sales & Operations Analysis

A data cleaning and analysis project focused on improving data quality, calculating key business metrics, and building an interactive dashboard in Excel.

  • Data cleaning (duplicates, missing values, formatting)
  • Revenue and performance calculations
  • Operational KPI dashboard
  • Data visualization using Excel charts

📁 Folder: excel-data-analysis/


2. SQL Sales & Support Analysis

A relational database analysis project using multiple tables to evaluate sales performance, customer behavior, and support operations.

  • Data validation and referential integrity checks
  • Revenue and order analysis using joins and aggregations
  • Support ticket analysis and escalation tracking
  • Business logic consistency checks

📁 Folder: sql-data-analysis/


3. BI Dashboard (Sales & Operations Insights)

An interactive dashboard built using SQL-processed data to visualize key business KPIs and operational metrics.

  • Revenue and order performance tracking
  • Customer support analysis
  • Payment and operational efficiency insights
  • Interactive filters and KPI cards

📁 Folder: bi-dashboards/


Tools Used

  • Excel
  • SQL
  • Data Visualization
  • Pivot Tables
  • Business Analysis Techniques

Focus Areas

  • Data Cleaning & Integrity
  • Business Performance Analysis
  • Operational Efficiency Metrics
  • Dashboard Reporting

Objective

To develop practical, real-world data analysis projects that demonstrate the ability to:

  • Clean and structure raw data
  • Extract meaningful insights using SQL
  • Present findings through clear and effective dashboards

📬 Contact

Email: ele220644@gmail.com

About

Data analytics mini portfolio demonstrating SQL, Excel, and dashboarding skills. Covers data cleaning, transformation, and analysis to convert raw datasets into reliable insights. Highlights proficiency in querying, data validation, and building clear, professional visualizations for decision-making.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors