Hellow guys, Welcome to my website, and you are watching Advanced Power BI Realtime Project: Using Same Dashboard for Data Input and Output into SQL Server. and this vIdeo is uploaded by ViSIT at 2024-07-17T05:32:07-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Advanced Power BI Realtime Project: Using Same Dashboard for Data Input and Output into SQL Server |
| Video Uploader | Video From ViSIT |
| Upload Date | This Video Uploaded At 17-07-2024 12:32:07 |
| Video Discription | 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. - Create new tables in the SQL Server database (buyers, products, sales). - Modify table structures (change data type, add columns). - Create a view in the database to combine buyer and product data with a URL for data entry. - Connect Power BI to the SQL Server database and import the tables and view. - Design a Power BI dashboard with visuals (text box, table) to display product information and initiate sales transactions. - Configure the URL in the view to link to a web page for recording sales transactions. - Create a web page (using ASPX and .NET) to capture sales transaction data from the URL and store it in the SQL Server database's sales table. The tutorial uses M language and Power Query for data transformation. The web page creation can be done using other languages (e.g., PHP) as well. #PowerBI #MicrosoftPowerBI #PowerBIPro #PowerBIDashboard #DataViz #BusinessIntelligence #RealTimeData #LiveConnection #DataStreaming #ChangeDetection #AutoRefresh #ASPX #DotNet #WebDev #SalesTransaction |
| Category | Education |
| Tags | Power BI | real-time data | live connection | data streaming | change detection | auto refresh | data visualization | business intelligence | ASPX | .NET | web development | sales transaction |
