DanNdon1/DSA-Data-Analysis-Documentation

A collection of data analysis class projects and exercises completed during my training with IncubatorHub through the Digital Skillup Africa (DSA) program # DSA-Data-Analysis-Documentation A collection of data analysis projects and exercises completed during my training with IncubatorHub through the Digital Skillup Africa (DSA) program. It includes works on data cleaning, visualization, statistical analysis and real-world datasets using tools like Excel, SQL, and Power BI # PHASE 1: Excel Data Analysis Practice This is a documentation on Excel exercises and projects I completed as part of my data analysis learning journey. It showcases practical applications of Excel functions, data cleaning, visualization, and reporting using real-world scenarios ## Learning Focus ### Guided by: Mr. Hameed Mushin I focused on building a solid foundation in the following Excel areas: #### Data Cleaning & Transformation Functions: SUM, SUMIF, COUNTA, COUNT,FIND, SEARCH, COUNTIF, IF, IFS, MAX, MIN, LARGE, SMALL, AVERAGE, LEFT, RIGHT, DATE, OR, AND, BETWEEN, TRIM,UPPOER, LOWER, AND, PROPER, VLOOKUP, PIVOT TABLE and more. #### Exercise: Rearranging messy or unstructured data into clean, structured formats. #### Data Analysis & Reporting #### Exercise: - Pivot Table creation and manipulation - Summary statistics and insights from raw data - Dashboard development for interactive reporting ### Data Visualization #### Exercise: - use of Bar charts, column charts, pie charts, line graphs, and combination charts - Custom chart formatting and dynamic visuals for better storytelling ### Sample Exercises & Mini Projects #### Sales Analysis - Cleaned and analyzed monthly sales data using formulas, PivotTables, and charts. #### Data Cleaning Tasks - Transformed messy datasets into structured tables using formulas and Power Query. #### Pivot Table Exercises - Explored grouping, filtering, and calculations using PivotTables. ### Dashboard Design - Dashboard Design Built a mini dashboard with slicers and charts for dynamic reporting. ### Tools Used - Microsoft Excel 2016 - Power Query (built-in with Excel) - Basic charting and dashboard to …