-
Felix Ralphs
Posts
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...
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,...
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...
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...
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...
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...
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...
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...
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...
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...