Senior Power BI Developer · People & Business Analytics

Power BI reports
people actually trust.

I design semantic models, advanced DAX and decision-ready dashboards for Finance, HR & Operations — validated against the source before they reach the business.

I'm Angela Ruiz Gallego, BI analyst with 10+ years turning ERP and HR data into reporting that teams use every day.

Power BIAdvanced DAXSQLPower Query MPBIP · TMDLPythonMicrosoft Fabric
0
years in enterprise BI
0
business-critical BI solutions
0
operational efficiency gain
0
stakeholders trained
Experience acrossConsultingHealth & ResearchBankingAuditHR / People
Professional Profile

Bridging business and technology

Senior Power BI Developer & Data Analyst with 10+ years in analytics and reporting, developing end-to-end BI solutions, aligning business requirements with technical specifications and delivering trusted insights.

Strong expertise in Power BI, advanced DAX, Power Query (M), SQL and dimensional modelling, building semantic models, robust KPIs and dashboards across Finance, HR & Operations.

Experience integrating ERP data (SAP S/4HANA, Oracle, Fundanet), SQL Server, APIs, Excel and SharePoint, using Python (Pandas), Power Query and Power Automate for transformation, validation and workflow automation.

Focused on data quality, governance, performance and stakeholder collaboration. Exploring Claude-assisted BI development, PBIP, TMDL and Power BI Modeling MCP for model inspection and documentation.

Currently focused on

  • Power BI semantic models & TMDL
  • AI-assisted workflows: Claude, PBIP & MCP (exploring)
  • Microsoft Fabric & Lakehouse (upskilling)
  • SQL / Gold-layer reconciliation & data quality
  • Performance tuning, RLS / OLS & governance
Technical Skills

The stack

BI & Visualization

Power BIPower BI ServiceRLS / OLSGovernanceDashboard UXDrill-throughTooltips

Data Modelling & Architecture

Star SchemaSnowflakeMedallion Arch.Semantic ModelsData ArchitectureData LineageTMDLHistorical Snapshots

Data Analysis

Advanced DAXKPIsTime IntelligenceComplex MeasuresDAX OptimizationData Quality

Programming & Analytics

Python (Pandas)Data TransformationAutomationExcelETL / ELT

Data Integration

SAP S/4HANAOracleFundanet ERPAPIsSharePointSQL ServerDBeaverPower Query (M)Power Automate

Cloud, Platforms & Tools

Microsoft Fabric (learning)Lakehouse ConceptsDataflowsTabular EditorDAX StudioGit & GitHub

AI-assisted BI · Exploring

Claude AIPower BI Projects (PBIP)Power BI Modeling MCPAI-assisted DAX / SQL reviewSemantic model documentation
How I can help

Power BI work, end to end

Available for freelance and remote projects. Clear scope, documented models and reports your stakeholders can rely on.

01

Power BI reports & dashboards

From business questions to a published, governed report.

  • Requirements & KPI definition
  • Report UX, navigation & drill-through
  • RLS / OLS and Power BI Service setup
02

Model audit & DAX optimisation

Faster, simpler, trustworthy semantic models.

  • Star-schema & relationship review
  • DAX performance tuning (DAX Studio, Tabular Editor)
  • SQL reconciliation against source data
03

HR & People Analytics

Headcount, turnover, absence and talent reporting built on solid snapshots.

  • Monthly headcount & movement models
  • Turnover, seniority, age & absence KPIs
  • SAP / ERP HR data integration
Work Experience

Where I've delivered

  • Development of end-to-end Power BI solutions for Finance, HR, Operations and Project Management, from business requirements to reporting
  • Built a People & Talent analytics suite for a multi-company consulting group: 7 report pages, 30+ tables and 130+ DAX measures on monthly headcount snapshots, turnover, seniority, age and absence (see case study)
  • Migration of SAP HR organisational data (PPOME) into the semantic model, validated through SQL reconciliation and monthly baselines
  • Design and optimization of dimensional and semantic models, including complex DAX calculations, relationships and historical employee snapshots
  • SQL validation and reconciliation against Gold-layer datasets: duplicate records, source inconsistencies, filter behaviour and data-granularity checks
  • Data integration and ETL/ELT using SQL, Python (Pandas), Excel, SharePoint, Power Query (M) and Power Automate
  • Integration of ERP data (SAP S/4HANA), APIs, SharePoint and SQL Server; collaboration with business and data engineering stakeholders
  • Model performance and governance: DAX Studio, Tabular Editor, query folding, RLS / OLS, refresh management and documentation
  • Using TMDL to work with semantic model definitions; exploring Claude, PBIP and Power BI Modeling MCP for AI-assisted analysis and documentation
Key Achievements
  • Delivered 5+ business-critical BI solutions across Finance, HR & Operations
  • Designed multi-domain reporting frameworks for a unified analytical view
  • Improved data validation, KPI consistency and model maintainability across reporting areas
  • Power BI dashboards for real-time KPI monitoring across research, clinical and operational areas
  • Dimensional data models (star & snowflake) for scalable, efficient analytics
  • Integration of multiple sources through ETL pipelines (SQL, Python, Power Query)
  • Training sessions and workshops driving BI adoption across teams
  • Key contributor to Andalusia's strategic project "Portal I+D+i"
Key Achievements
  • Improved operational efficiency by 60% through automation and integration
  • Reduced analysis time by 40% with optimized dashboards
  • Trained 30+ stakeholders; contributed to ISCIII accreditation (2024)
  • ERP systems for project and financial management; reporting aligned with business needs
  • Interactive dashboards with Power Query, Pivot and Excel, reducing reporting time by 40%
Key Achievements
  • Reduced reporting errors by 30% through automation
  • Key role in securing over €5M in funding for AI and innovation projects
  • Interactive Power BI dashboards for KPIs on projects, research activity and performance
  • Automated ETL with Power Query, SQL, Excel and Tableau; dimensional models and EDA
  • Extraction and analysis from Fundanet ERP for project tracking, budgeting and funding
Key Achievements
  • Led digital transformation, improving operational efficiency by 70%
  • HR performance evaluation system (+25% tracking accuracy); ISCIII accreditation (2016)
  • Financial dashboards for forecasting and performance monitoring in a banking environment (BBVA)
  • Budgeting and reporting with QlikView and Oracle; reduced reporting time by 25%
  • Financial analysis and accounting in international business environments
  • Excel-based reporting tools; support in audit and financial control
Selected case studies

A more personal way to present my projects

Selected case studies presented in a quieter, more editorial style. I want each case study to feel personal and exploratory — combining the original visual reference with an interactive web recreation built with synthetic data. This way I can show the analytical logic, filters and tooltips without exposing confidential information.

01 / HR ANALYTICS SUITE · NEW

People & Talent AnalyticsLatest project

Interactive case study · synthetic data

Project objective

Give HR and leadership a single, trusted view of the workforce of a multi-company consulting group: headcount, hiring and leaving, turnover, age, seniority and absence — consistent month to month and across companies, countries and staff groups.

Behind the dashboard

  • Seven-page report: Executive Summary, Headcount, Turnover, Average Age, Seniority, Absence Hours and Data Export
  • Semantic model with 30+ tables and 130+ DAX measures built on monthly employee snapshots and hiring/leaving facts
  • SAP HR (PPOME) organisational data migration, validated with SQL reconciliation and baseline checks
  • Role-based cost visibility, custom SVG navigation and DAX performance tuning
  • Developed as a Power BI Project (PBIP / TMDL) with version control

Interactive demo

Fictional companies and employees · try the filters and pages
Open full screen ↗

Portfolio recreation with synthetic information. It reproduces the structure and logic of a client report without any real company or employee data.

02 / PEOPLE ANALYTICS

Workforce Insights Dashboard

Interactive case study · synthetic data

Project objective

Understand workforce evolution, identify changes in headcount, and explore hiring, attrition and workforce composition through a consistent executive-to-detail reporting experience.

Behind the dashboard

  • Four coordinated views: Executive Overview, Workforce Structure, Hiring & Attrition, and Compensation
  • Shared slicers by department, region, employment type and reporting period
  • Monthly workforce snapshots, headcount and movement KPIs, and drill-down analysis
  • Interactive charts and contextual details built with synthetic data

Interactive demo

Explore the fictional dataset, filters and interactions

Portfolio demonstration with synthetic information. Not connected to company records or a live Power BI report.

03 / PEOPLE ANALYTICS · MONTHLY MOVEMENTS

Hiring & Leavers by Month

Interactive case study · synthetic data

Project objective

Monitor monthly hiring and departures, understand net staff movements and explain differences between companies and staff groups.

Behind the dashboard

  • Monthly hiring, leaving and net-movement measures
  • Company and staff-group breakdowns with expandable detail
  • Historical snapshots and comparable reporting periods
  • Coordinated filters, KPI cards and detail tables built with synthetic data

Interactive demo

Explore the fictional dataset, filters and interactions

Hiring & leaving by company

Monthly movements · last six months

Portfolio note: this is a JavaScript demonstration inspired by the original Power BI design; it does not connect to an employer’s data or reproduce its actual DAX formulas.

Portfolio demonstration with synthetic information. Not connected to company records or a live Power BI report.

04 / ADVANCED DAX · SVG

Daily Time-Tracking Timeline

Interactive case study · synthetic data

Project objective

Help teams interpret day-by-day time allocation and identify billable hours, non-billable work, leave, training and pending approvals in a compact visual timeline.

Behind the dashboard

  • Employee-by-day matrix and SVG-inspired status encoding
  • Business rules represented through visual categories and contextual colour
  • Filtering by team and activity, with hover details
  • Recreation based on the DAX + SVG technique documented in the linked case study

Interactive demo

Explore the fictional dataset, filters and interactions

Read the original DAX + SVG LinkedIn case study ↗

Portfolio demonstration with synthetic information. Not connected to company records or a live Power BI report.

05 / AVAILABILITY · SKILLS · RLS

Employee Availability & Skills

Interactive case study · synthetic data

Project objective

Find the right available people for projects by combining skills, proficiency, location, assignment dates and remaining capacity in a single decision-support workflow.

Behind the dashboard

  • Four linked pages: People & Availability, Skills, Service Line Analytics and Export
  • Strategic, Project and Skills slicers with AND logic for multiple required skills
  • Date-aware allocation and employee detail including project assignments
  • Expandable Employee → Skills matrix, office map and simulated restricted cost visibility using fictional data

Interactive demo

Explore the fictional dataset, filters and interactions
Open interactive dashboard in full screen ↗

Portfolio demonstration with synthetic information. Not connected to company records or a live Power BI report.

Background

Education & certifications

Education

Master in Data Analytics
PONTIA.TECH · Python · Git & GitHub · ML
2023 – 2024
MBA
IMF Business School
2014 – 2015
International Business Admin.
European Business School
2002 – 2007

Certifications

PL-300 — Power BI AnalystIn Progress
DP-600 — Fabric EngineerIn Progress
Data Analysis & BI
Unicorn Project · 2022
Excel Expert & Dashboards
CEF · 2015

Languages

Spanish
Native
English
B2 Upper-Intermediate · Toronto immersion