Final Delivery

The Final Solution: KoopaKonstruct Manager

The BPMN diagram below is a simple representation of our KoopaKonstruct Manager.

In summary we are using Hololenses to inspect a chosen area where we want to e.g. hang up a coat rack, build a table, and similar. In order to make the Hololenses smart, we have integrated OpenAI. We are using Function calling to provide instructions about the requested project, information about necessary materials and quantity.This is where we are making our KoopaKonstruct really smart.

As real #Crawlers we use OpenAI’s Function calling to dynamically create the search criterias based on natural language. Google Speach to text is used to capture the natural language query. We are really integrating into everything that flips bits #Embedding numbnuts! With help of the search criterias, we are able to provide critical information further into the supply chain, meaning all the way down to the FinOps where we are improving critical business processes (this will be explained later in this blog post).

Below is a picture from the Hololenses where we use a button to speak with AI:

GPTVision helps us interpret work drawings and breaks it down into the steps needed, so that we can get a clear instruction of what materials we need, how many and how to build the desired object. Using Power Automate, we are able to share and send the item details and necessary quantity into FinOps.

As an addition to the OpenAI magic, we have also created a canvas app that is integrated in the Hololense #PlugN’Play. From this app you can perform business processes, such as triggering sales orders, check inventory status, and 4 different Power BI reports to monitor sales orders and follow up late deliveries #Dash it out.

And here is where we really improve business processes; when the information is sent to FinOps we use X++ code to check inventory status. If materials are in stock, a sales order is created and sales order confirmation is sent. If there are no (or not enough) materials in stock, we also create a purchase order in addition to the sales order. A link between the purchase order and sales order is created, enabling the ability to understand where the demand is coming from. Additionally, to make the KoopaKonstruct Manager adaptable to e.g. construction companies, we have created the possibility to link the purchase and sales orders with projects. This provides a lot of possibilities for detailed project management for the finance geeks.

Below is our argumentation to why we believe we should score high on all 4 categories!

Most Extreme Business Value

Our team embarked on a quest to redefine the meaning of business value, and we present to you KoopaKonstruct Manager – a solution that not only orders products through Hololenses but catapults business efficiency into a realm beyond imagination.

Automating the Complete Supply Chain with Hololenses

We harnessed the power of Hololenses to revolutionize the way products are ordered. One user, equipped with the mighty Hololens, registers the necessary quantity with a mere wave of the hand, triggering a Power Automate flow like a seasoned Mario collecting power-ups.

The adventure doesn’t stop there! Our Power Automate flow seamlessly transmits the order information to FinOps using the Execute action. The magic unfolds as FinOps automatically generates a sales order and a purchase order based on inventory stock. But here’s where the plot thickens – these orders are not solitary entities; they are linked together, creating a dynamic duo that unravels the mystery behind each purchase. There is no need to spend as much as a second wondering how or why the orders were created; the link indicate that there is a demand behind each purchase order.

See yourself sitting in an ordering office at a company where the customers are able to generate sales orders by only entering a demand. And, in addition to the automatic creation of sales order, imagine that you did not have to study the master plan to generate the purchase order as it is automatically created! And as a side salsa, you did not even have to trigger the sales order confirmation as it is sent automatically. So, while you are sitting there wondering about what to do with your life (and how long it takes before the CEO finds out that you are useless as the power of Power Automate and X++ took your job), you can relax and focus on other more important things in life, such as playing a Super Mario game.

Power Stars: Automated Project Linkage

But wait, there’s more! We also increased the business value for construction and engineering enterprises. With the ability to automatically link both the purchase and sales orders to projects, we’ve bestowed upon industries that thrive on projects a golden opportunity to enhance their efficiency and project management. It’s not just about ordering; it’s about constructing a bridge to a new era of project-linked prosperity.

The Warp Whistle to Most Extreme Business Value

We make a bold claim for the “Most Extreme Business Value” category in this year’s ACDC Hackathon. Here’s why our adventure deserves the highest score:

  1. Efficiency: Our solution isn’t just about ordering; it’s about efficiency power-ups that automate the entire supply chain process, from order initiation to linkage in FinOps.
  2. Dynamic and Time-saving: The automatic creation of linked sales and purchase orders provides unparalleled visibility into demand and supply, laying the foundation for strategic business decisions.
  3. Project Linkage: For construction and engineering businesses, our automated project linkage is a treasure trove of golden coins, offering enhanced project management capabilities and business value beyond the ordinary.
  4. Adaptable: Our solution is not only limited to the B2B-market, but can also be used for the B2C-market. Making the app available to customers, they can create orders automatically and receive high quality service as the complete supply chain has become even more efficient.

Excellent User Experience

We have created a Super Mario inspired canvas app that is adapted into the Hololenses. In other words, our app transforms ordinary into extraordinary!

Features:

Killer AI

Whether you’re a seasoned AI veteran or just dipping your toes into the mushroom-filled waters of innovation, our solution is a testament to the power that AI holds in shaping the future.

KoopaKonstruct Manager is not just a game-changer; it’s a game-transformer. Through the mastery of machine learning, we’ve empowered our solution to evolve, adapt, and learn from the challenges it encounters. From predicting order quantities to optimizing supply chain processes in the real world (and in FinOps), our AI-driven approach is a power-up for efficiency and foresight.

In the quest for the Killer AI “crown”, KoopaKonstruct offers more than just automated processes. It also includes magic in form of predictive insights, providing a glimpse into the future of demand, supply, and project landscapes. Strategic decision-making becomes second nature as our AI-driven system transforms data into actionable intelligence.

A mind of its own

In the pursuit of the existential risk badge, our AI solution goes beyond mere execution—it thinks, learns, and adapts with a mind of its own. Through autonomous decision-making capabilities, it navigates the complexities of supply chain processes and provides responses not even a 20 year old is able to find without searching the web.

KoopaKonstruct isn’t just smarter than a 5th grader; it engages in intelligent conversations that transcend the limitations of a classroom. It doesn’t just provide answers; it grapples with FinOps and supply chain complexities, understands nuances, and offers insights that reflect a level of intelligence resembling a dynamic dialogue.

Why KoopaKonstruct Manager deserves the Killer AI “crown”

  1. Innovation Beyond the Blocks: KoopaKonstruct isn’t confined to the traditional boundaries. It breaks through the blocks of conventional solutions, paving the way for a new era of AI-driven innovation.
  2. Adaptability in Every Pixel: Our solution dynamically adapts to the ever-changing business environment, ensuring resilience and adaptability in every pixel of our solution.
  3. Mind Mastery: Our AI isn’t just a tool; it’s a mastery that elevates KoopaKonstruct into a symphony of efficiency, intelligence, and strategic foresight.

Pandoras Box

Equipping a Hololens with AI that can answer questions, order materials, and assist in selecting the right materials and tools for any project based on online instructions transforms DIY into an accessible experience for the less handy. This technology takes the guesswork out of building, offering tailored advice on what to build, the best materials and tools for the job, and even suggesting projects that match your interests and available space. It’s like having a personal tutor and assistant rolled into one, guiding you through the entire process from conception to completion. This seamless integration of technology with hands-on work not only makes crafting projects more approachable for beginners but also enriches the experience with educational value, ensuring that anyone can undertake and succeed in their DIY endeavors with confidence.

Streamlining Race Analysis: Power BI Dashboard for Mario Kart Performance 

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

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

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

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..

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 !?

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!

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!

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.