About Me
Hi! I'm Kelly Ville, and I'm a Business Intelligence DeveloperI have strong expertise in Power BI, SQL, Alteryx, Qlik Sense, and data engineering.I'm experienced in designing interactive dashboards, building scalable data warehouses, and automating complex workflows to deliver actionable business insights.Proven ability to collaborate with diverse stakeholders, streamline reporting, and mentor junior team members.I'm passionate about empowering organisations to make data-led decisions and improve operational efficiency.
Skills
Power BI | Power Apps | Power Automate | SQL | Excel | Qliksense | Alteryx
Excel - 20+ years
Qliksense - 5+ years
Power BI - 5+ years
SQL - 20+ years
Featured Projects
SQL | Power BI
HR Analytics Dashboard
Replaced a manual process by creating a SQL script and Power BI dashboard to pull and visualise HR Data.
Certifications
• Alteryx Foundation & Designer Core Micro-Credentials (Data Preparation, Manipulation, Transformation) — 2023• Alteryx Machine Learning Micro Credential — 2023• Microsoft DP-900 Azure Data Fundamentals — 2023• Ongoing: Microsoft DP-202 Azure Data Engineering Certification• Udemy Courses: Azure Databricks & Spark SQL, IT Project Management, Metadata Management, Python, Data Governance, Data Quality, QlikSense Data Architect, and more
Publications and Achievements
• Contributor to landmark The Lancet research articles on hip and knee replacement outcomes using National Joint Registry data.• Supported National Joint Registry 8th, 9th, and 10th Annual Reports with critical data analysis and database management.
Testimonials
Global Head of TalentKelly’s technical expertise, analytical mindset, and can-do attitude were instrumental in building over 90 mentoring relationships across our global workforce. She quickly grasped our needs, created the right data connections, and delivered results we simply could not have achieved without her.Head of IT Governance, Risk and ComplianceKelly transformed our risk metrics into actionable insights, enabling us to clearly identify high-risk areas and reduce cyber risk across the organisation. Her purposeful collaboration and ability to make data meaningful have been invaluable to our team.Head of HR OperationsIn an urgent HR situation, Kelly’s prompt, precise data support allowed us to respond effectively and without delay. Her reliability and problem-solving skills make her an absolute pleasure to work with.
SQL | Power BI
HR Analytics Dashboard
HR Workforce Demographics Dashboard – Power BI
Built an interactive HR analytics dashboard using data sourced from Kaggle and transformed in Power Query. The dashboard tracks workforce demographics and trends between Fiscal Quarters and compares, here 2017 Q4 and 2018 Q4 are selected and compared, providing key insights for HR planning.Key Features:Cleaned and modelled raw HR data with Power Query for accurate analysis.Visualized KPIs including total employees, gender split, average age, and average tenure with year-over-year change.Delivered interactive charts for department headcount, age distribution, ethnicity breakdown, job roles by gender, and marital status.Enabled HR teams to monitor diversity, workforce structure, and demographic shifts over time.Tools & Skills: Power BI, Power Query, Data Cleaning, Data Modelling, KPI Design, Interactive Visuals