Tag Archives: Dash It Out

Streamlining Race Analysis: Power BI Dashboard for Mario Kart Performance 

Posted on by

Introduction 

Creating visually engaging and insightful dashboards in Power BI is a game-changer in data visualization. This post focuses on building an effective dashboard for analyzing Mario Kart race performances, emphasizing both aesthetics and business value. 

Dashboard Overview 

The dashboard comprises two main pages: the Overview Page for summarizing race results and the Analysis Page for detailed data exploration. 

Overview Page Highlights 

Track Popularity: Graphical display of most-chosen tracks. 

Player Rankings: Visuals showing the best and worst performers over time. 

Top Karts and Drivers: Easy-to-read charts highlighting popular choices. 

Analysis Page Features 

Dynamic Data Table: Customizable view using field parameters for in-depth analysis. 

Slicer Panel: Enables quick data filtering for different variables. 

Balancing Design and Utility 

The key is to combine visually appealing elements with actionable insights, ensuring each part of the dashboard serves a practical purpose. For instance, understanding player preferences can guide marketing strategies, while top performer analysis might influence game development. 

Power BI’s Role 

Leverage Power BI’s capabilities for: 
 

Efficient Data Modeling: Smooth handling of extensive race data. 

Custom Calculations: Using DAX for unique insights. 

Interactive Visuals: From basic charts to advanced graphics for user-friendly analysis. 

Conclusion 

This Power BI dashboard for Mario Kart race analysis not only demonstrates technical skills but also the importance of meaningful data presentation. It’s an ideal blend of form and function, turning complex data into accessible and actionable insights. 

Note: This condensed draft provides a structured approach to crafting a blog post focused on creating a business dashboard in Power BI, using Mario Kart race data as a case study. Expand with specific examples or screenshots as needed. 

One Dashboard To Rule Them All

Posted on by

Badges we claim:

  • Dash It Out – for providing great summary of case management

Meet the dashboard of our app. We let the managers keep up with what is happening in the system. They can see case and technician information and see how long it takes to solve cases on average.

We also added Q/A section in case managers want more specific information.

Here we show case solve duration so managers can keep track of sla/kpi.

Another chart showing average rating of cases and which technician completed it to show best employee of the month.

We also show how many cases we recieve by severity and average completion time of cases by severity.

Power BI Dash it Out and Glossy Pixles

Posted on by

Our game produces data on game configuration, high score and completed games. This is visual data that we love to look at so we better understand the users.

We have had quite the journey in learning on this badge. Consultant had never used Power BI before and created this as their first post.

Eventually after receiving help from community members and judges the graph matured and materialized itself to something more presentable.

Piping our way through the Azure Cloud

Posted on by

To make our amazing service Tubi work, a lot of cloud is needed. We aim to make the plumber’s job easier by recommending the best layout for where the pipes should go, and for that, we need AI. We have trained a model in Custom Vision to recognize all components in a bathroom that need water. So, when the plumber uploads a floor plan to our Static Web App, the image is sent to our Azure Function App backend in C# Asp.net through our own API. But both the image and the equipment list must be stored somewhere. Therefore, we have also connected to Azure Blob Storage. Then last but not at all least. The people working in the back office have instant interactive reports available to help them with filing and billing through Power BI and alerting the using an automated flow (Badges: Feature Bombing)

Sometimes it works, and that’s plenty

Databases are good, but sometimes it’s easier to just dump everything in one place until you need it again. Yes, it might not be very scalable or very normalized. SQL became too heavy, and we already needed a Blob storage to store the images, so we also dump the order data in the same blob storage as JSON files. It’s old fashioned way of serverstorage, and a bit dirty, but it works! (Badges: Nasty hacker, Retro badge)

Power the backoffice

As the final list of components are decided, they still have to be approved from the accounting team in the office. To make sure they have all the information they require, we have developed a Power BI dashboard to crawl through our registered data and make sure the orders are handled properly (Badges: Crawler, Dash it Out, Dataminer). And to make sure the orders are handled easy and fast, the dashboard is embedded into teams and an alert is automated by using a logic app to make sure the workers can receive and cooperate in realtime (Badges: Embedding Numbnuts, Go with the flow, Pug N’ Play, Power user love, Right Now, Stairway to heaven).

Dash out, the old way..

Posted on by

We have created a dashboard in dynamics, and in that context we feel obliged to ask for the retro badge at the same time. Dynamics is fun to deal with when it comes to a lot, but dashboard and charts feels like it has been collecting dust since 2008 (poor thing). Its reliance on outdated aesthetics compromises functionality and accessibility.

Our “PlumbBoard” shows the key values in our enviroment
– Certifications Renewal
– PlumbScore: The number of individuals trying to obtain certification through our ‘Plumber PowerUp’ games
– Invoices: With an overview of when the invoices are due
– Contacts: It’s also important to have some indications of our different memberships. In our case, we have plumbers and members.



A Day of Triumph: Unlocking Multiple Badges in a Single Sprint !?

Posted on by

Streamlining Efficiency: The “Go with the Flow” Badge Achievement

In the pursuit of optimizing business productivity within our solution, the implementation of an ALM pipeline has been a game-changer. This automated transfer of solutions between environments not only saves significant time and effort but also ensures that both unmanaged and managed versioning packages of the solution are seamlessly transitioned. Furthermore, the integration of a Power Automate flow for the approval of deployments has elevated our operational efficiency, marking a significant milestone in our journey to “Go with the Flow.” This achievement underscores our commitment to leveraging workflow automation for enhanced productivity.

Uniting Power and Simplicity: The “Power User Love” Badge

Our solution showcases an exemplary blend of low-code platforms with pro-code customization, embodying the #ProCodeNoCodeUnite philosophy. By implementing a Power Pages site for user interface and login, coupled with a PCF component coded in React and TypeScript for a gamified course, we demonstrate the power of integrating professional coding standards with low-code solutions. This approach not only streamlines development but also opens up a realm of possibilities for creating robust, user-friendly applications.

Gamification at Its Best: Achieving the “Mario Badge”

Elevating user interaction through gamification, the implemented PCF component with interactive controllers to navigate through course levels. Each course represents a level, challenging users to advance and showcase their proficiency. This gamification aspect not only makes learning more engaging but also encourages users to level up their skills in a fun and interactive environment.

Visual Insights: The “Dash It Out” Badge

Our solution now features a Power BI report embedded within the Power Pages site, along with additional reports for user access to high scores and admins for an overview of active players and their progress. These reports, showcasing at least four graphs, gauges, or KPIs, highlight the business value of our dashboard. The integration of these visual insights ensures that both users and administrators have a comprehensive understanding of performance metrics at their fingertips.

Adaptive Excellence: Securing the “Chameleon” Badge

The responsiveness of the Power Page, adapting automatically to all devices and screen sizes, exemplifies our solution’s versatility. This inherent adaptability ensures that our application delivers a consistent and user-friendly experience across various platforms, earning us the “Chameleon” badge. It’s a testament to our dedication to creating solutions that are not only powerful but also universally accessible.

Double dash it out!

Posted on by

Literaly, double dash it out. We ❤️ power apps, and want to show you our latest innovation by claiming both Dash it Out and Power User Love.

First off we have created a dashboard with banana-related statistics. We used power pages with the super fun liquid code template language to create a total overview of stats in our admin Banana Portal™ (Hopefully Donkey Kong won’t find the url):

The Banana Portal™ also includes a banana pickup route planner for the Norwegian Road Authority. Every detected banana is registered in Dataverse, added as a waypoint, and voila! An optimised route is calculated. Combining power pages (low code) and typescript:

Edit: added photos of the actual power page.

Business in the Front, Party in the Peach Mini Games: Where Fun Meets Fortune!

Posted on by

This post has the topic within Most Extreme Business Value category

Dataminer

Dash it out

At first glance, Peach Mini Games might seem like pure fun – a temporary escape from the realities of everyday life and an invitation to indulge into a dream. However, that’s where one truly misses the mark. When deeply exploring Peach Mini Games it is like stepping into a classic ‘Mullet’ situation: Business in the front, party in the back. Or maybe it is the other way around. Anyway…

You’re met with vibrant colors, pixel-perfection that would make anyone envious, and scalability smoother than a cat’s movement. But beneath this lies a complex tapestry of business value.

Hangman
Through our Hangman game, one not only learns the player meanings of words but also how they are spelled. Research has shown that the use of Hangman for these purposes is highly effective. Studies indicate that this method is motivational for learning, providing a playful approach that makes it more engaging for participants. Additionally, research suggests that interactivity, such as actively participating in game-based learning like Hangman, can enhance vocabulary and spelling skills more effectively than traditional methods.

Reference: https://jurnal.untan.ac.id/index.php/JEEP/article/viewFile/57-65/75676588091

Quiz
To complete the task of saving Mario, Princess Peach must pass a quiz. The quiz is integrated with ChatGPT and serves both as an entertaining and educational part of the game. At the same time, the concept is so versatile that it can be directly applied to create business value in the field of education.

Imagine a scenario where one configures a quiz within a specific subject area. Students can use this quiz to practice and identify knowledge gaps, while ensuring they rely on reliable sources. This setup provides teachers with control over information access, limiting students’ searches to a secure environment instead of allowing unrestricted internet browsing.

Statistics
Similar to how the games described above can motivate learning, our PowerBI scoreboard can better equip teachers to understand what students know and what they need to work on, both on a group and individual level. The statistics can pinpoint specific areas that require more attention, ensuring teachers use their time effectively and work in a more data-driven manner.

Five badges in one poost?

Posted on by

Toad, a character widely recognized as Mario’s loyal companion, assumes a different role in our scenario. Instead of assisting Mario, Toad will be guiding Princess Peach through the perilous landscapes of the Mushroom Kingdom. Known for his extensive knowledge, Toad has documented everything in his personal wiki, which serves as a comprehensive guide to their world. In our application, Toad will utilize this knowledge to answer Princess Peach’s queries via a chat interface. This interactive feature will allow Princess Peach to navigate her journey with greater confidence and understanding.

Toad, an AI bot powered by Copilot Studio, learns from the web and adapts to new data. It uses advanced machine learning algorithms to understand and interpret information. This continuous learning makes Toad a versatile tool for tasks like data analysis, content creation, and problem-solving. It represents the next generation of AI, ready to assist with its ever-growing knowledge. (New text added here)

Live demo of Toad:

Who can resist the thrill of a captivating game? Our app takes you on an exhilarating journey, brimming with elements of gamification. It features a sophisticated scoring system for our beloved Princess Peach, tracking her progress throughout the game.

Live demo of score:

But that’s not all! Princess Peach has access to a dynamic Power BI dashboard, allowing her to review her progress and identify her strengths and areas for improvement. This interactive tool serves as a constant motivator, pushing her to strive for excellence

Last night, we celebrated a significant achievement as we won the award for ‘Excellent User Experience’ for Thursday. This accolade is a testament to the hard work of our experienced UX designer, who has crafted a fabulous Figma prototype to assist our developers. This victory leads us to the final chapter of our journey.

Last but not least, we invite you to step into the world of our application. Here, a vibrant pink palette, reminiscent of Peach’s dress, meets a shiny and glossy user interface, crowned with a touch of yellow, much like Peach’s crown. Our design choices, carefully considered for ease of navigation, make interacting with our app not just user-friendly, but a truly delightful experience. (New text added here)

Color palette from Figma

Live demo of shiny and glossy design (the design is not 100% complete in this video):

This post was edited 03.02 12:40

New text is marked with: (New text added here)

  • Added live demo of bot and some text
  • Added live demo of gamification
  • Added live demo of glossy design, picture and some text