Juls

Juls

An IT Chartered professional (CITP BCS) with more than 15 years working with data across multiple industries. Juliana has great experience with stakeholder management, she has liaised with important clients worldwide within Oil & Gas and Infrastructure (Water Sector). She is highly proactive, efficient and communicates effectively with clients to ensure all the requirements are met. Microsoft Power BI Certified (PL-300) passionate about turning data into insights to improve business decision-making. Solid analytical and problem-solving skills, familiar with programming languages such as MATLAB, DAX and SQL. Fully registered STEM Ambassador and creator of the LinkedIn Newsletter STEM Demystified, aiming to demystify STEM, inspire the next generation and support local community.
  • Joined: 25 June, 2024
  • Articles: 155
  • Comments: 2

The Date Dimension Awakens in Power BI

Promotional graphic titled “FRAMING DATA FOR SUCCESS” in bold lettering. Subtext reads “Learning Power BI & Accessible Design,” with a red play button icon and the handle “@AccessibleBI.” Juliana Smith, wearing a grey sweater, appears in the background. The image is framed with a yellow border.

I can’t count the number of times I’ve been asked, “Why do we need a separate Date Table? Can’t we just use the date columns in our dataset?” And honestly, I get it. When you’re new to Power BI or…

Tracking Project Benefit in Power BI – Part 2

Promotional graphic titled “FRAMING DATA FOR SUCCESS” in bold lettering. Subtext reads “Learning Power BI & Accessible Design,” with a red play button icon and the handle “@AccessibleBI.” Juliana Smith, wearing a grey sweater, appears in the background. The image is framed with a yellow border.

Welcome back to the second part of our series on Tracking Project Benefit in Power BI! In the first part, we laid the foundation by structuring our data model and establishing the necessary relationships. We discussed the importance of this…

Tracking Project Benefit in Power BI – Part 1

Promotional graphic titled “FRAMING DATA FOR SUCCESS” in bold lettering. Subtext reads “Learning Power BI & Accessible Design,” with a red play button icon and the handle “@AccessibleBI.” Juliana Smith, wearing a grey sweater, appears in the background. The image is framed with a yellow border.

In my years reporting on project controls, I’ve often been asked to visualise financial benefits over time. Tracking realised vs expected benefits is crucial for decision-making, but finding the right way to present this data can be tricky. At first,…

P6 Exports Nightmares? Power Query to the Rescue!

Promotional graphic titled “FRAMING DATA FOR SUCCESS” in bold lettering. Subtext reads “Learning Power BI & Accessible Design,” with a red play button icon and the handle “@AccessibleBI.” Juliana Smith, wearing a grey sweater, appears in the background. The image is framed with a yellow border.

If you’ve ever tried bringing a Primavera P6 export into Power BI, you know the struggle. I’ve been there too! Working in Project Controls and reporting on project schedules, I’ve lost count of how many P6 extracts I’ve had to…