Aspiring Data Analyst | Data Technician Bootcamp
Focused on developing practical skills in data analysis, data visualisation, SQL, and Python programming.
I am building hands-on experience by completing projects using real datasets and industry tools such as Excel, Tableau, Power BI, SQL, and Python.
Retail sales dataset analysis using Excel formulas, filtering, sorting, PivotTables, and charts.
Skills demonstrated:
- SUM, SUMIF, AVERAGE, AVERAGEIF
- VLOOKUP
- Date functions
- Data cleaning and organisation
- PivotTables and charts
🔗 Repository:
https://github.com/grantriches-byte/My-Excel-Projects
Interactive dashboards visualising retail and health datasets to explore trends and patterns.
Skills demonstrated:
- Interactive dashboards
- Filters and slicers
- Data storytelling
- Multiple chart types (bar, line, pie, maps)
🔗 Repository:
https://github.com/grantriches-byte/My-Tableau-Repository
Business intelligence dashboards analysing retail sales and financial performance.
Skills demonstrated:
- Power Query data transformation
- DAX calculated columns and measures
- Interactive reports with slicers
- Data storytelling with visualisations
🔗 Repository:
https://github.com/grantriches-byte/My-PowerBI-Repository
Querying the Northwind database to retrieve and analyse business data.
Skills demonstrated:
- SELECT queries
- JOIN operations
- GROUP BY and aggregation
- ORDER BY sorting
- Relational database analysis
🔗 Repository:
https://github.com/grantriches-byte/My-SQL-Repository
Python programming exercises and introductory data analysis using Pandas.
Skills demonstrated:
- Variables and user input
- Conditional logic and loops
- Calculations and logical programs
- DataFrames with Pandas
- Dataset exploration and analysis
🔗 Repository:
https://github.com/grantriches-byte/My-Python-Repository
- Python
- Pandas
- SQL / MySQL
- Excel
- Tableau
- Power BI
- Google Colab
- GitHub
- Advanced SQL queries
- Data cleaning and transformation
- Data visualisation best practices
- Python for data analysis