To make sure our employees make the right decisions if an resource report is good opportunity or not, we have crated a Power BI report that gathers all the existing data and presents them in a way they can easily read and understand. Making them better at decide if a registered request is something they should recommend or not. Using the good old Powershell scripts to create reports and saving data, thrive and thru Bice templates for deploying Azure resources and HTML to display them within the Power App and presenting them using the everlasting Power BI never goes out of fashion.
This document explains the key performance indicators (KPIs) and visual metrics used in the Craft Portal dashboard. The dashboard is implemented using Generative Pages with React and integrates with Microsoft Dataverse for data retrieval. Minecraft API assets are used to enhance the visual design with authentic item icons.
Theme & Display Modes
The dashboard supports both Light Mode and Dark Mode.
Light Mode:
Dark Mode
KPI Definitions
1. Summary Cards
These cards provide a high-level overview of procurement activity:
Total Projects: Total number of Projects in the system.
Open Projects: Projects currently open for bidding.
Total Bids: Total number of bids submitted across all projects.
Wandering Traders: Total number of registered vendors.
2. Project Status Distribution
A donut chart showing the distribution of projects by status (Draft, Open, Closed, etc.). This helps users quickly understand the current lifecycle state of all projects.
3. Bid Status Distribution
This chart visualizes the ratio between submitted bids and selected (winning) bids, helping procurement teams evaluate bid conversion efficiency.
4. Win Rate by Trader
A horizontal bar chart displaying each trader’s win rate as a percentage of bids won versus bids submitted.
5. Projects per Month
This chart shows how many projects were created per month, allowing stakeholders to identify trends, seasonality, and workload distribution over time.
6. Top Wandering Traders Leaderboard
A ranked leaderboard displaying traders based on total wins. This gamified view encourages competition and makes vendor performance easy to compare.
7. My Projects Table
A detailed table listing all projects with sorting and search capabilities. Users can drill into and view individual projects directly from the dashboard.
Dashboard Overview Screenshot
Technical description for the Code Connoisseur category.
Generative Pages with React
This dashboard is built as a Generative Page component, which allows for dynamic, AI-assisted UI generation within the Microsoft Power Platform ecosystem. The component is written in TypeScript/React and utilizes:
Fluent UI React Components (@fluentui/react-components) for base UI elements
Custom Minecraft-styled components for visual theming
DataGrid for tabular data display with sorting and filtering
Microsoft Dataverse Integration
The dashboard connects to Microsoft Dataverse using the dataApi prop provided by the Generative Pages runtime.
Minecraft Item Icons
All icons in the dashboard are sourced from the Minecraft API, a free public API that provides official Minecraft item and block images.
We have, lists, graphs, a lot of stats and a copilot that comments based on the data we store in dataverse. It looks amazing. And it gives a lot of value to both administrators and users.
And we crammed it all into one big ol dashboard!
Datamining
Back to the data mining. We are soon putting out QR codes (“IOT devices”), that all of you will be able to use, to try and win a really nice creeper light!
Right now, we are collecting data internally, testing the system. But in an hour, everybody will give us data to use. We will collect randomly spawned items, which time, how many of them, the rarity of the item, and aswell if something fails, we will log it. We will also be saving the geo location data to show where the best items are showing up.
We will also be asking for phone numbers, to send sms to those who wants to know if they are winning or losing.
The data will be used for insights, so we can look at who is winning, give people cool insights powered by copilot and our cool dashboard.
We just went from “dummy data for the demo” to “live Dataverse feeds driving every quota card” in the CCCP Factory Portal dashboard. No more hardcoded 2,450 wheat units that never change. Now it’s real: fetch the resource table, pull the actual quantities and thresholds, calculate percentages on the fly, and display it with proper color-coded progress bars and badges.
The Power Pages Liquid templating lets us use `{% fetchxml %}` to query Dataverse, loop through results with `{% for resource in resourceData.results.entities %}`, and map resource names to icons/colors. Clean. Efficient. Soviet-approved.
And the UI? CCCP-themed gradients, golden stars, muted colors that don’t burn your retinas at 2am. Cards with colored top borders (amber for wheat, green for potatoes, orange for carrots). Progress bars that actually mean something because they’re tied to real inventory levels. We made sure to let the user know by a quick glance how much the inventory carry right now, plus giving amazing visuals with progress bars and percentage numbers that represent the units.
We didn’t use the drag-and-drop builder for this. We pro-coded the entire dashboard as a custom web template in VS Code using Bootstrap 5, CSS Grid, and modern responsive design patterns. Downloaded the portal with PAC CLI, built it locally with proper version control, then pushed it back. That’s how you get pixel-perfect layouts and custom FetchXML integration that actually scales.
And if it is responsive you ask? Well..
We are claiming the “Dash it out” badge, because dashboards aren’t just for show, they’re for running a production facility where every unit counts and every threshold matters. But at the same time, let’s put some extra effort into making it looks nice! 🙂 Now back to work, Comrade. The village demands real-time analytics!
Running a Minecraft server without dashboards is like mining diamonds blindfolded. So naturally, we fixed that with Power BI.
Our dashboard turns raw server telemetry into something you can actually brag about. CPU usage over time shows when the world is working hard (or hardly working). Player statistics tell us how active the realm really is. And yes we even track the boring stuff, like server version and the maximum number of players…
This isn’t a dashboard for vibes. It answers real questions:
It’s clean, readable, and just detailed enough to feel professional? Kinda …while still monitoring a blocky with atleast 4 graphs
The orders are flying in like owls in the morning, and you are losing track. Our solution is giving the back-office of your shop an easy overview over new orders and sales. Integrated into your CRM-system.
Data is synchronized through Dataverse to Fabric with the Fabric Link.
Dash It Out: In the spirit of the Marauder’s Map, we have conjured a dashboard that is both visually stunning and incredibly informative. This dashboard is not just a collection of graphs and KPIs; it is a powerful tool designed to provide valuable insights.
Current Total Points Handed Out for the Semester: Much like the House Points Hourglasses in the Great Hall, this graph shows the total points awarded throughout the semester, giving us a clear view of the academic achievements and contributions of our students.
Who Awarded the Most Points: This chart reveals the professors who have awarded the most points. It highlights the dedication and encouragement provided by our esteemed faculty members, fostering a competitive yet supportive environment.
Sum of Points Awarded by House: This graph, reminiscent of the House Cup standings, displays the total points awarded to each house. It provides a visual representation of the friendly rivalry between Gryffindor, Hufflepuff, Ravenclaw, and Slytherin, motivating students to strive for excellence.
Statistics About the Professors Who Awarded Points: This report, much like the meticulous notes of Hermione Granger, details the statistics of the professors who have awarded points. It includes insights into their teaching styles, frequency of awarding points, and the impact of their encouragement on student performance.
Creating this dashboard was we utilized our preferred data visualization framework, leveraging its capabilities to build a solution that is both robust and user-friendly.
At Team PowerPotters, we believe that knowledge is power, and what better way to empower potion masters than by providing them with real-time insights? Our Power BI report transforms data from Dynamics 365 Finance and Operations (FO) into an intuitive, visually compelling dashboard, providing immense business value to the alchemy lab.
Here’s why our dashboard deserves the Dash It Out badge and how it brings clarity to even the most complex potion-making processes.
🪄 A Dashboard with Real Business Value
Our Power BI report is designed for maximum utility in the alchemy lab, offering critical insights at a glance. Let’s explore its key components:
1. Current Inventory Overview
The dashboard displays the current stock of potion ingredients and finished potions, allowing potion masters to keep tabs on inventory levels without manually checking shelves.
This ensures the lab runs smoothly, with no delays caused by missing ingredients during critical production runs.
2. Recent Potion History
Potion masters can view a history of recently completed potions, providing insight into production trends and helping manage demand.
This data empowers Snape and his assistants to identify which potions are in high demand and adjust future production accordingly.
3. Live Production Updates
The heart of the dashboard is the latest production order section, which displays:
Potion Name: The potion currently being brewed.
Production Status: Directly linked to FO, showing real-time updates (e.g., “Pending Approval,” “In Progress,” “Completed”).
Production Order Reference: A clickable link back to FO for detailed information.
Quantity: The number of potions in the current production batch.
Bill of Materials Visualization: A breakdown of the ingredients required to complete the production, ensuring all materials are on hand.
This section enables potion masters to monitor active production closely, addressing issues like delays or ingredient shortages in real time.
✨ The Technical Magic Behind It
The Power BI report is powered by data directly pulled from D365FO using an OAuth legacy connection, ensuring accurate and timely updates.
Data Collection Process:
OAuth Integration: Data is securely extracted from FO tables, including production orders, inventory levels, and bills of materials.
Power BI Cloud: The dashboard will be published to the cloud and set to update at regular intervals, keeping the data as current as possible.
Future Vision: If time and licenses permitted, we would configure Fabric tables as a data source, enabling live, real-time updates for even greater accuracy.
🧙♂️ Why This Dashboard is Business-Critical
Real-Time Insights: Potion masters have access to live data on production and inventory, reducing downtime and ensuring smooth operations.
Transparency: The link to FO production orders allows for deep dives into production details when needed, keeping all stakeholders informed.
Inventory Management: By visualizing ingredient levels and recent potion production, the dashboard helps prevent shortages and ensures the lab runs like a well-oiled machine.
Efficiency: The bill of materials visualization eliminates guesswork, ensuring potion makers always know what they need for the next batch.
🐍 Why We Deserve the Dash It Out Badge
Our Power BI report exemplifies what the Dash It Out badge is all about:
Business Value: The dashboard delivers actionable insights, enabling better decision-making and smoother workflows in the alchemy lab.
Real-Time Data: By pulling data directly from FO and automating updates, we’ve created a near-live reporting tool that ensures potion makers are always informed.
Visual Impact: With intuitive charts, tables, and visualizations, the dashboard is as user-friendly as it is powerful.
Scalability: Our design ensures that the dashboard can grow with the lab’s needs, with the potential for real-time updates through Fabric in the future.
🔮 The Future of Alchemy Analytics
With our Power BI report, we’ve brought transparency and efficiency to potion-making, proving that even the most magical processes can benefit from data-driven insights. We humbly submit our case for the Dash It Out badge and invite you to explore the magic of analytics with Team PowerPotters: acdc.blog/category/cepheo25.
When building applications that leverage AI technologies, monitoring performance is crucial for ensuring that the system operates smoothly. One powerful tool for this is Azure Application Insights, which allows us to collect, analyze, and visualize telemetry data in a way that provides both technical insights and an understanding of user interactions.
Azure Application Insights is an Application Performance Management (APM) service that helps you monitor your applications in real-time.
In this post, we’ll show how we used Azure Application Insights to create dashboards that track key metrics for our Sorting Hat, focusing on GPT prompt and response tokens, response times, user interactions, and language distribution. These insights can help us optimize the performance of our AI model, identify trends, and make data-driven decisions.
Let’s break down the key metrics that we are tracking:
GPT Prompt & Response Tokens: The number of tokens used in GPT prompts and responses can have a significant impact on performance and cost.
Average, Minimum, and Maximum Response Time: These metrics provide an overall view of how long the application takes to respond.
Response Time Distribution: This helps us understand how response times vary across different requests.
Response Time vs. Tokens: This allows us to correlate response time with the number of tokens used.
Active User Chats: Monitoring how many users are actively chatting with the AI at any given moment helps gauge the engagement level.
Language Distribution: When application supports multiple languages, this metric helps to track which languages are being used most often.
Average, Minimum, Maximum and Standard Deviation response time in last 30 days: These metrics help ensure that the application performs optimally and allow us to identify any unusual behavior or potential bottlenecks.
