Advanced Power BI Realtime Project: Using Same Dashboard for Data Input and Output into SQL Server

The provided subtitle describes an advanced Power BI tutorial on creating real-time data connectivity through change detection and auto-refresh. Goal is to create a Power BI project enabling real-time data entry into a SQL Server database from the Power BI dashboard. The tutorial uses M language and Power Query for data transformation.The web page creation…

Read More

Power BI:The Clock – Episode 2 | Displaying a Clock in Power BI with Current Time using SQL & XAMPP

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…

Read More

Automating Data Loading from Online Analyzer flat files to SQL Database & BI Dashboard

This tutorial addresses the challenge of automatically loading data from an online production plant analyzer, generating flat files every five seconds, into an SQL database. The preferred method is direct storage in the SQL database, but the tutorial explores an alternate approach for learning purposes. The tutorial begins by creating an HTML file using JavaScript…

Read More