Dear Teacher, You have shown me a right direction. Now I will develop a fantastic dashboard that has never done before in my organization. Thanks alot for such a wonderful lesson

@virtual_school

6 ай бұрын

Glad to help you. Thanks for your kind words.

muito bom! faz mais

@virtual_school

5 күн бұрын

Thanks

Wow I never used direct query mode. This is so interesting!! Nice share

@virtual_school

Жыл бұрын

Glad we could help. Thanks for appreciation.

Superb...😊

@virtual_school

Жыл бұрын

Thanks 🤗

Awesome 👍👍👍👍😎😎😎

@virtual_school

Жыл бұрын

Thanks for your appreciation. We are happy that you liked our effort.

Wow

thanks for an insightful tutorial. based on what you have done, if I want to update the data how will it be done.

@virtual_school

10 ай бұрын

Normally you have sale applications in your store where your salesmen enter sales, and the system is updated. The sql query mimics that.

thanks for a wonderful video, i love it... how do you use a real world dataset to update in real time on a bi dashboard

@virtual_school

3 ай бұрын

There are many examples for real-life realtime datasets. Large organizations perform many transactions every minute. Other than that various plants/machines realtime readings are a good example.

@DanielKwakye02

3 ай бұрын

@@virtual_school So how do you connect, what syntax do you write

@virtual_school

3 ай бұрын

Depends upon scenario. I prefer directquery because it is the simplest.

Hi thank you for this. I just started learning. But this is done with data that you generated with a loop. Is there a way to do it where the dashboard is automatically updated in real time with data as soon as someone updates information on an excel sheet? Basically the pipeline goes from Excel - SQL - BI automatically :)

@virtual_school

Жыл бұрын

Please refer to this page: learn.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources Excel is not DirectQuery supported which is required for realtime data refresh.

@virtual_school

Жыл бұрын

Loop is used for simulation and demonstration. If information is entered through a system such as sales software, it will be updated in real time just like the the information generated by loop is being updated.

@unnamed99

Жыл бұрын

@@virtual_school thank you so much!

will it work same on power bi service as well after publishing the report??

@virtual_school

Жыл бұрын

If a report is based on local server, it wont work online (in real time). To make it work online, you have to connect it to an online server. Procedure is same.

hi thank you for thit tuto pleas when we should use or creat data wearhouse ?

@virtual_school

Жыл бұрын

Although from your question, context is not very clear, but generally we create and use a data warehouse when information becomes too big and complex to be handled by few people or systems. And on the output end, we need realtime data for business intelligence and analysis, and integrated from various sources.

@Mohamed-yb2xy

Жыл бұрын

@@virtual_school ok thank you i know my question was not clear becaus i am still a beginner in bi, i have one more question, i know data mart is a part of data wearhouse but in term of designing is it true that the design of a data wearhouse is a goupe of fact tables and thiere dimensions and a data mart is just a part of this design (one fact table and its dimensions)?

@virtual_school

Жыл бұрын

You can ask as many questions as you like. Simply put, there could be a thousand sources from where you can collect data to form a data warehouse. Not entire data warehouse is meant (or even allowed to be used) for one group of people or for one purpose. So just like thousands of input sources, there could be hundreds of output destinations as well. Those can be called marts. Suppose your data warehouse contains all the sales, marketing, finance, hr data obtained from internal and external sources i.e. customers, governments, competitors, partners, stakeholders, employees etc. When you disseminate this information, you don't allow access to all information. You provide some data to govt, some to public, some to employees, some of it goes to marketing people, some of it is meant for stakeholders etc. So what you do? you make data marts to create chunks of data for each group, purpose, period, filter, criteria etc. That is the general understanding of data warehouse and mart we have.

@virtual_school

Жыл бұрын

The objective is to have minimum fact tables in a data mart, but you can have more.

@Mohamed-yb2xy

Жыл бұрын

@@virtual_school ok thank you very much pleas i know your chanel has great practices can you promote to me other resources books or youtube chanels where i can find projects done step by step that can help me understand more the BI domain.

which version of power bi did you use, I cant seem to find the 'page refresh' button in my version

@virtual_school

5 ай бұрын

Page referesh is only available when you connect data as directquery. Looks like you skipped that step in the tutorial.

Where can I get the dataset for this dashboard? Please tell me.

@virtual_school

3 ай бұрын

There is no dataset. The data is created by sql query (to mimick realtime transactions) and is displayed by Power BI in realtime.

But only works in desktop, not in service

@virtual_school

Жыл бұрын

Yes, this is a Power BI desktop exercise. There are limitations to the Power BI dashboards. That is why I also use Google Charts. With them, you can do anything. However people use scripts to refresh report server dashboards in seconds as well. I will explore that as well, some day.

not working for postgre

@virtual_school

Ай бұрын

This tutorial is based on SQL Server. I read online that npgsql can help you connect to postgre using direct query.

Why you don't add Data sets with tutorial others nothing benefits without practice

@virtual_school

Жыл бұрын

Data is randomly created using SQL query. You can create your own version of random data for this exercise. We do provide datasets where needed.

Kindly Also share the Excel file dataset. Waiting.

@virtual_school

Жыл бұрын

The data is generated randomly in SQL server. Therefore the data is not available in excel. Just follow the video and by the end you will have an SQL database. Excel file is not required for this exercise.

There is no benefit of your video, if you are not provide dataset in the description

@virtual_school

2 ай бұрын

This is a tutorial on "Realtime SQL Data". You cannot provide a dataset on that. The entire process on how to create this realtime data (database, table and query) is explained in the first portion of video which I think you have missed. The query that "GENRATES" data is explained at @10:30.