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.
Unveiling the Power of Regex in SQL
Regular expressions, commonly known as regex, are powerful tools for pattern matching and text manipulation. While SQL is traditionally known for its ability to handle structured queries and data manipulation, integrating regex into SQL queries can enhance your data...
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
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
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...
Using Facebooks Prophet To Create Weather Forecast Data
Introduction In a recent project, my task was to generate weather forecast data for a Tableau dashboard aimed at helping users pinpoint ideal locations along the east coast of Australia based on their weather preferences. To kick off the project, I gathered data from...
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 4 ( Creating an Interactive Time Line in Power BI)
Introduction For the fourth day of Dashboard Week, the challenge was to use the website https://moneypuck.com/data.htm to collect data on American ice hockey statistics across various metrics. As someone who knows little about ice hockey, this presented an interesting...
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
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
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...