Xian's Page
(Check Gallery)

Christian De Alba Robles

'Xian' De Alba Robles (XeDAR)DATA ANALYTICS PROFESSIONAL

Seasoned analytics professional with a decade of experience driving growth and innovation in B2B and B2C BPO data analytics. Consistently delivers increased profits, reduced costs, and enhanced customer service through incisive KPIs, actionable reports, and strategic process improvements. Proven leader, adept at managing teams of 6-15 and communicating insights to over 3,000 employees and diverse clients.

I’m passionate about data, but outside of work, I’m deeply inspired by Korean culture, food, TV series, and movies. I previously worked in South Korea for several Korean companies, but the highlight of my time there was the opportunity to join the One Philippine Embassy Family. I served as an Interpreter/Translator for the Overseas Workers Welfare Administration (OWWA) and represented the Philippine Overseas Labor Office under the Department of Labor and Employment (DOLE) as part of the labor office staff.

Currently affiliated with Power Bi Pilipinas Community (Facebook Group) and Data Analytics Philippines as moderator for both group.

Thank you Power BI Pilipinas!

I am truly honored for being selected as one of the judges for the recently concluded Power BI Pilipinas 1st Data Challenge. See you on the next challenge next year!

Power BI Pilipinas 1st Data Challenge

I’m truly honored to be one of the judges for this contest. As such, I wanted to share my own take on the DBM Project DIME data. Please check out my live Power BI dashboard below to see how I analyzed and visualized it

What sets my dashboard apart is that it identifies and lists potentially problematic projects using several straightforward fraud detection techniques applied directly to the raw data. Surprisingly, even without complex analytics, these simple methods were enough to flag almost half of the total projects as high-risk.

Please open the dashboard in a new tab and view it in full-screen mode for the best experience:

Alternative (slightly shorter and more engaging):

UDF KPI Card Visuals

UDF Topic 03: KPI Card Example

Hey guys! I’m excited to give you a sneak peek at my current personal project. I’m building my own library of reusable visuals!

In this video, I’ll be showing a custom KPI card that’s super easy to create. I hope it inspires you to explore how to build your own User-Defined Functions (UDFs) and learn some SVG coding along the way.

I’ve tested this custom visual using KPIs from a SaaS-type project, and it works great!

Stay tuned for my next video — I’ll be showing how to build UDFs that you can use in your own projects.

Watch demo video here : https://www.facebook.com/share/v/17X2FJ2BDS/

2-in-1 : Monthly and Quarterly

Time for another visual inspiration. Did you know that this is all Power BI native visual? This is a line and stacked column chart. All you need to do is put a hierarchal x-axis values for year, quarter and month (in my case i replaced month with a 1 letter Month column). For the column y-axis, your sum or count measure for example. for line y-axis, create a measure for quarterly total of the initial measure. Last but not the least, add you Quarter to the Legend. Play around the settings for some other cool stuff like adding markers to the line values.

Quarterly Total value is the sum of the 3 monthly totals under the same quarter.

Visual Calculation for Visualization

I’ve been asked so many times how to highlight the top and bottom values in visuals. I used to do it with DAX formulas — but if you’re not yet familiar with Visual Calculations, things just got way easier!

Watch the video here : https://www.facebook.com/share/p/1FTvQDK8NM/

User-Defined functions

Did you know that UDFs (User-Defined Functions) can also be used to create reusable visuals? In this example, I've created a double-odometer/gauge to visualize the equivalent status of a measure's value. It also provides the starting and ending values for each of those statuses.

The final product is a DAX function that uses only two variables: the measure name for the percentage value and the size factor of the visual. Yes, the visual size is dynamic.

This can be improved further by making the colors variables too. Even the number of statuses can be made dynamic. Indeed, UDFs are the game-changer that many have been waiting for so long. If you haven't tried creating UDFs... consider this a sign!

PS,

I would like to thank my client for allowing me to post this visual that I created for them. Hats off!

Read article here : https://www.facebook.com/share/p/17FDWkBXdP/

Union and more!

September 05, 2025

It is possible to have a table with more than one measures at the bottom. Open the description here:
https://www.facebook.com/share/p/1CkYoLnVKD/

Sunburst Chart

September 05, 2025
Apologies for not posting anything in a while. I’ll be adding more content soon!

This visual requires a Power Query data transformation—from a vertical table to a horizontal one.

However, it’s not a simple walk in the park. You first need to determine the maximum number of slices per Risk Rating, based on its Risk Descriptions within each Risk Category.

Daxdakan Live 2025 Speaker!

Still buzzing from the Power BI Pilipinas event on July 4, 2025, from 1PM to 8PM! Huge thanks to Sir Tony Cua & Ma'am

Doher Drizzle Pablo for masterminding this epic knowledge-sharing fest—you’re the true champions! 🚀 Big shoutout to Microsoft for hosting us in their stellar venue, the perfect backdrop for innovation. To my fellow speakers, you brought 🔥 topics that lit up the room. And to everyone who joined in-person or via Teams—your passion & curiosity made it unforgettable! 🙌

Much love to the Power BI Pilipinas community for letting me share & learn with you all. Let’s keep pushing the limits of what’s possible with data! More events like this, please—the future’s shining bright! 🌟

Timelines

May 21, 2025

This is one of the visuals I have used during the Covid19 pandemic showing the effects of implementing a strict or relax covid restrictions. They have different levels and depending on what has been in placed, we can either see a surge or decrease of covid infected patients.

I am planning to use this but with a twist to one of the on-going data challenges.

Multi-line works!

May 04, 2025.

Overcrowded data bars?

Someone from our FB GC page asked help about data bars and so I showed them multi-lines is another option. But with a twist of course. Like the image on the left, the twist is that you can see all lines' same path as dashed light gray lines. This help you compare a particular line by deselecting them using a slicer while your chosen line becomes the highlight of the view! All native visual. Creativity is the key. What do you think?

link : https://www.facebook.com/share/p/1CLUpWH2n2/

DAX NEWS (May 01, 2025) :
I have joined DSA's Data Analytics Challenge. End of submission is on May 15, 2025. Below is my entry. It is still under development but I already loaded it with the following :

Main tab - Diagnostic Center (Executive Page)
- A dynamic page with dynamic Q&A view. Choose from 37 Measures I have created for the main page (Executive View)
- Automatic-highlighting of Max and min per chart.
- Fast calculations. 21 different charts with 37 measures, that's 777 visuals you can use for insights / informed decision-making
- add the capability to slice date periods.
Insights : encounter Class - Age Group
- Added Lined-bubble chart. This is all native visuals. Creativity is the key!
- This customized visual allowed me to use dimensions on both x and y axis having size of bubble determine its easy-to-understand comparison per age group per encounter class.
- Provided a comprehensive Insights and Recommendations on the tab
Reactive Sankey Chart!
- Normally, you would need to a paid subscription to use a custom sankey chart visual or those available have limitation on what you can add.
- So I got the inspiration from an Power BI MVP and developed my own version. Aside from being able to create the data prep automatically so t will automatically refresh whenever there is new data, I made it to filter other visuals based on user-selected category on the sankey chart.
- Currently developing it to become fully-dynamic so it will be easier to use together with other visuals.
- I have laid out 6 different categories and how the breakdown of revenues per category move to another.
Deep Dive.
- Some more visuals for insights extraction.
Triage analysis
- This is like a swiss-knife for this dashboard. With 39 measures, simultaneously being refreshed against each other. It's quick it's full of insights. view current year values of any measure. See it's PY, YoY, YoY %, CM, PM, SMLY, MoM, MoM%, CMoSMLY, CMoSMLY %, and many more not added on the view. I'll create a drillthrough page to be able to view other available measures.
- But for this page, 39 measures, and 14 slicer measures, that's 546 of measure values you can use to derive insights!
- Dynamic formatting. From duration (like 1 day, 8 hrs, 2mins) to Currency, etc. everything is dynamically formatted.
- Even shows the period data were summarized

Enjoy the dashboard below!!!

Tiny and Big Bubbles!

May 01, 2025 https://www.facebook.com/share/p/1CgyWy9V7b/

I'm so satisfied! Yes I have created this view without using any custom visual! As much as possible, I have been using purely native visuals or a visual that I have coded manually or improved from the web. Having to see the code by creating it or modifying an existing one, this gives me the satisfaction that I am within bounds of security level being enforced by my client or previous employers. What do you think of the lined-bubble charts below?

SaaS - Subscription - Billing Data

Posted April 21, 2025
https://www.facebook.com/share/p/1BoMd3V69u/

One of th most challenging analysis I have worked with is from those companies with subscription data. Calculating their MRR, ARR, LTV, LTV2CAC ratio, etc. is not easy but definitely satisfying.

There's so much insights you can get and those are industry-standard KPIs.

I hope I can work with subscription data again or those with binding contracts.

KPI Card

https://www.facebook.com/share/p/167yTGUWNp/
April 19, 2025

Pearson's Correlation Coefficient

https://www.facebook.com/share/p/1AKcmyy1ib/

Scatter Plot

Posted April 19, 2025

Male vs Female
Posted : April 14, 2025
https://www.facebook.com/share/p/16HGFy1c3N/

I made a custom dynamic formatting measure using DAX for the male and female ratio!

My vey own Venn Diagram!

Posted April 12, 2025
https://www.facebook.com/share/p/1FHCEb5bWQ/

Yes. I created this Venn Diagram that automatically calculates its center points that when plotted, would show actual sizes of overlapping areas. Still developing it to perfect the overlapping colors, but this is definitely a good addition to my own visuals. You can only see same circle sizes, not dynamic Venn Diagram visualizations. This one is different. I hope I can perfect it so that I might be able to publish and sell it someday!

Current Key Responsibilities

1. Team Leadership:
Lead, mentor, and supervise a team of reporting and analytics professionals.Provide guidance, support, and performance feedback to team members.Foster a collaborative and innovative team culture focused on delivering high-quality insights.
2. Reporting and Analysis:
Collaborate with cross-functional teams to understand data needs and requirements.Oversee the creation and delivery of regular and ad hoc reports that provide actionable insights.Ensure the accuracy, integrity, and consistency of data used for reporting purposes.
3. Data Interpretation:
Analyze and interpret complex data sets to identify trends, patterns, and opportunities.Provide strategic recommendations based on data-driven insights to support decision-making.
4. Strategy Development:
Collaborate with stakeholders to understand business objectives and challenges.Contribute to the development and implementation of data-driven strategies and initiatives.Help define key performance indicators (KPIs) and metrics to track progress.
5. Process Improvement:
Continuously evaluate and enhance reporting processes to streamline data collection and analysis.Identify opportunities to automate reporting tasks and improve efficiency.
6. Data Governance:
Ensure data quality and integrity by implementing and maintaining data governance practices.Establish data standards and best practices to uphold the accuracy and reliability of reports.
7. Stakeholder Communication:
Present findings and insights to senior management and other stakeholders.Communicate complex data concepts in a clear and concise manner to non-technical audiences.

Mission

Transform raw data into clear, actionable insights through innovative dashboards and reports. I am committed to becoming the lead expert in training Reports Analysts on automation and dashboard creation, ensuring they acquire the skills needed to excel. My goal is to spearhead successful projects that not only elevate the company’s reporting capabilities but also drive strategic decision-making and enhance overall business performance.

Vision

To revolutionize our data reporting and dashboard capabilities by creating intuitive, dynamic visualizations that drive actionable insights and strategic decision-making. By leveraging Power BI's advanced features, I aim to deliver real-time, interactive dashboards that empower stakeholders to seamlessly explore data trends, monitor key performance indicators, and uncover hidden opportunities for growth.

My goal is to build a data-driven culture where informed decisions are made effortlessly, ultimately enhancing operational efficiency and fostering innovation across the company.

Page updated

Report abuse

Xian's Page(Check Gallery)