Skip to content

README.md

Latest commit

 

History

History
58 lines (45 loc) · 2.67 KB

README.md

File metadata and controls

58 lines (45 loc) · 2.67 KB

📊 Data Analyst Assignment Portfolio

Status Excel MySQL Power BI Tableau

📖 Overview

This repository contains a collection of data analysis assignments demonstrating proficiency in the full data analysis lifecycle—from data cleaning and manipulation in Excel and SQL, to advanced visualization and storytelling in Power BI and Tableau.

Each folder corresponds to a specific tool and contains problem statements, datasets, and solution files.

📂 Repository Structure

1. EXCEL Assignment

Focus: Data Cleaning, Pivot Tables, and Advanced Formulas.

  • Key Tasks: * Performed data cleaning (removing duplicates, handling null values).
    • Created Pivot Tables to summarize key metrics.
    • Used advanced functions (VLOOKUP, INDEX-MATCH, IF statements) for analysis.

2. MySQL Assignment

Focus: Database Management and Querying.

  • Key Tasks:
    • Wrote complex SQL queries to extract actionable insights.
    • Used JOINS, GROUP BY, and Window Functions for data aggregation.
    • Analyzed trends and performance metrics directly from the database.
  • Files: Contains .sql scripts with queries and solutions.

3. PowerBI Assignment

Focus: Interactive Dashboards and Business Intelligence.

  • Key Tasks:
    • Built interactive dashboards to visualize KPIs.
    • Used Power Query for data transformation (ETL).
    • Implemented DAX measures for custom calculations (e.g., Year-over-Year Growth).

4. Tableau Assignments

Focus: Data Visualization and Storytelling.

  • Key Tasks:
    • Created story points to present analytical findings.
    • Visualized geographical data and time-series trends.
    • Designed user-friendly dashboards for stakeholders.

🛠️ Tools & Technologies

  • Data Processing: Microsoft Excel, MySQL
  • Data Visualization: Microsoft Power BI, Tableau Public
  • Concepts Applied: ETL, Data Modeling, DAX, SQL Querying, Data Storytelling

🚀 How to Use

  1. Clone the repository: 
    git clone [https://github.com/imskipper/Data-Analyst-Assigment.git](https://github.com/imskipper/Data-Analyst-Assigment.git)