Felix Ralphs

Felix has a background in mechanical engineering, earning a master’s degree from Sheffield, UK in 2022. Felix recently returned from exploring Southeast Asia and has found a new home in the vibrant city of Sydney. He has a sharp mind for problem-solving and is eager to deepen his expertise and contribute his skills to the Data School. Beyond his professional pursuits, Felix enjoys the outdoors and playing football. His favourite food is pizza.

How to Document Power Query

How to Document Power Query

Why Document? Documenting Power Query workflows in Power BI is vital for clarity, collaboration, and maintainability. It provides insight into each step's purpose, aids troubleshooting, ensures compliance, facilitates knowledge transfer, and serves as a valuable...

Dashboard Week Day 1

Dashboard Week Day 1

In the first day of Dashboard Week, we had to connect to the Twitch IGDB API and gather different types of gaming data. I decided I wanted to explore the evolution of gaming genres, so I connected to the games and genres endpoint. The Twitch API (Application...

How to Optimize Alteryx Workflows

How to Optimize Alteryx Workflows

Simplify Your Workflow Design: Keep it simple, One of the most effective ways to optimize performance in Alteryx is to streamline your workflow design. Break complex processes into smaller, more manageable tasks, and eliminate unnecessary tools or steps. Use the...

Dashboard Week Day 5

Dashboard Week Day 5

Day 5 For the final day of Dashboard Week, we focused on an Oscars dataset, encompassing information about every nominee and winner across all categories since the inception of the Oscars. The goal was to explore the work of renowned directors, analyzing their films'...

Dashboard Week Day 2

Dashboard Week Day 2

Introduction: Embarking on the Dashboard Challenge Week Day 2, my focus was on dissecting the variance in reported crimes across Australia, specifically delving into crime types and gender disparities. Leveraging data from the Australian Bureau of Statistics, I aimed...

Dashboard Week Day 3

Dashboard Week Day 3

Introduction: In the fast-evolving landscape of literature consumption, electronic books (E-books) have emerged as a dominant force, reshaping the way readers access information. For the recent Dashboard Week Challenge 3, my mission was to dive into the NSW National...

Connecting to APIs in Power BI

Connecting to APIs in Power BI

Today's blog will be about how to connect to APIs using Power BI. APIs can enrich your analyses with real-time dynamic data. Power BI actually makes it pretty easy to connect to data through APIs. This blog will provide a step-by-step guide on how to do so and any...

Cross Tab & Transpose Tools Alteryx

Cross Tab & Transpose Tools Alteryx

In today's data-driven world, businesses and organizations are constantly seeking innovative solutions to extract valuable insights from vast and complex datasets. One such powerful tool that has emerged as a game-changer in the realm of data analytics is Alteryx....