by Felix Ralphs | Sep 4, 2024 | Felix Ralphs
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...
by Felix Ralphs | Mar 21, 2024 | Felix Ralphs
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...
by Felix Ralphs | Mar 21, 2024 | Felix Ralphs
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...
by Felix Ralphs | Mar 20, 2024 | Felix Ralphs
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...
by Felix Ralphs | Mar 17, 2024 | Felix Ralphs
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...
by Felix Ralphs | Mar 15, 2024 | Felix Ralphs
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...
