Power BI: Realtime Sales Simulation using SQL Server and Direct Query (Portfolio Project)

[@zeeshanazeem5212]

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]

Glad to help you. Thanks for your kind words.

[@gabrielr8642]

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

[@virtual_school]

Glad we could help. Thanks for appreciation.

[@SharifIddrisu-b4n]

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]

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

[@DanielKwakye02]

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]

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]

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

[@virtual_school]

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

[@Mohamed-yb2xy]

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.

[@prashant5917]

Superb...😊

[@virtual_school]

Thanks 🤗

[@anthonytomastomontanez9929]

Awesome, thanks

[@virtual_school]

You are very welcome.

[@pepper_lab]

Awesome 👍👍👍👍😎😎😎

[@virtual_school]

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

[@DuhaMohammed-n7j]

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

[@virtual_school]

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

[@srdouglas1026]

muito bom! faz mais

[@virtual_school]

Thanks

[@mysticftw627]

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

[@virtual_school]

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

[@nglife8710]

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.

[@unnamed99]

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!

[@ChrisRestrepo]

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.

[@AshishAnand-ry1kt]

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.

[@shankart3349]

Wow

[@bilalshahbaz3615]

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.

[@mushabbahashfaq3949]

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.

[@RajinderKumar-ny5xz]

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

[@virtual_school]

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.