Welcome to episode two of the clock project!
In the previous episode, we crafted a clock in PowerPoint, complete with animations using Visual Basic Script. Now, in this installment, we’ll integrate that clock into a Power BI dashboard to dynamically display the current time.
Let’s dive right into today’s tutorial!
🕒 Setting Up the Database:
Open SQL Server Management Studio and connect to the SQL Server.
Create a new database for your clock project, and define a table with necessary columns.
🖼️ Preparing Clock Images:
Generate clock images in PowerPoint and VBS.
Copy these images to a web server directory (e.g., XAMPP’s htdocs folder).
🔄 Running SQL Queries:
Use SQL queries to link images to the current time.
Insert data into the table, ensuring it reflects the current time and image path.
📊 Connecting to Power BI:
Delete the previous entry in the table.
Connect Power BI to the SQL Server and load the table.
Import the Image Viewer custom visual and place it on the dashboard.
Set the image viewer’s URL field to the clock image URL from the table.
Enable page refresh with a one-second interval.
🚀 Final Results:
Run the SQL query to update the table continuously.
Witness the animated clock ticking in Power BI Desktop.
🎥 Conclusion:
Our tutorial showcases the seamless integration of a dynamic clock into Power BI. The application of these techniques is limited only by your creativity.
#ClockProject #PowerPoint #VisualBasicScript #PowerBI #SQLServer #DatabaseTutorial #WebDevelopment #DataVisualization #SQLQuery #ImageViewer