Today’s project focused on designing and building a professional profile dashboard that showcases my data skills and experience in a structured format.
Data Structure and Mock Dataset Creation
For this project, I used Gemini to create mock data.
I started by defining the structure of the data. I created three core tables:
- Experience
- Qualifications
- Projects
Each table was designed to reflect a different part of my professional background. I then prompted Gemini to generate the mock data based on my actual work experience and education.
To ensure the model was relational, I introduced a shared Experience ID field across tables, allowing them to be connected cleanly within Power BI.
Dashboard:
Dashboard Design Approach
The dashboard was structured into clear sections to make it easy for users (e.g. employers) to scan and understand quickly.
1. Executive Summary
This section includes:
- A professional photo
- A short personal summary
- Key KPI-style metrics
- Direct links to my LinkedIn and Tableau Public profiles
The aim was to create an immediate snapshot of who I am and what I bring.
2. Career Timeline
This section visualises my career progression across all roles. Each role includes interactive tooltips showing:
- Tenure
- Role title
- Key skill areas
- Impact delivered
This makes it easy for employers to quickly understand both context and contribution at each stage of my career.
3. Projects Overview
Projects can be filtered by client type rather than naming specific organisations. For example, instead of naming clients directly, I categorised them as “bank”, “football club”, or similar sectors. The table with these names can filter the rest of the projects section.
This section includes:
- A donut chart showing project type distribution (e.g. data visualisation, research, API integration)
- A bar chart showing tool usage across all projects, displayed as a percentage breakdown
This provides a clear view of both my data experience and technical exposure.
4. Skills and Qualifications
The final section covers:
- Technical and soft skills
- Certifications (Alteryx and Tableau)
- University degree classification
This acts as a consolidated summary of capabilities and formal education.
Key Challenge
The most complex part of the build was the career timeline visual. It required advanced DAX calculations and the use of string concatenation techniques to build dynamic tooltips that clearly communicate impact at each role.
Final Thoughts:
Although challenging and hard to go in the right direction on the data generation side, this was a very insightful and enjoyable project. It showed me how we can harness the interactive capabilities of Power BI to create an interesting CV alternative for employers to engage with.