PowerBI for real-time dashboard

-

 


You might already be using Power BI to create your dashboards and reports, but have you tried to create a real-time dashboard before? Typically, you need to set up a refresh schedule. What if you want to see your dashboard update live, as soon as fresh data comes in? This is where you can use a streaming dataset in Power BI, to view and act on your data in real-time.

Here are some examples of times you could consider using a real-time dashboard:

  • IoT devices: sensors, machinery. Anything with a constant flow of data you would like to view accurate information on. This is a great option for being able to detect anomalies in equipment.
  • Collecting survey responses and viewing feedback immediately
  • Viewing weblogs
  • Inventory Management: monitoring stock levels

Streaming datasets can be created from Power BI Service. When heading over to Power BI Service to create your streaming dataset, you have 3 types to choose from.

The API option is the most accessible for anyone to get started with. Using the API option creates a “Push Dataset”, i.e. the Power BI API takes your data and pushes it into a dataset for you. You can use tools such as Power Automate or PowerShell to add rows into your table. When this happens, your dashboard tiles update automatically with the new data. The benefit of using a push dataset is that data is getting stored in a database in Power BI Service. You can do historical analysis- go back in any point in time and see what occurred. In addition, you also get the full report building features too, like all the visuals and creation of measures.

Azure Stream and PubNub require you to have access to these services and are ideal for IoT use cases. They allow you to rapidly output your data stream to Power BI. If you are currently using Azure Stream Analytics (e.g. such as for monitoring sensors), you can link it up your jobs to Power BI so that you can visualise current levels and trends as they come through in Azure Stream.

Reach out to Prometix if you’re interested in seeing how we can assist you with Power BI and real-time streaming. If you’re looking to upskill your teams on Power BI or the rest of the Power Platform, we can also run training in-house for you.

Prometix as a Microsoft Gold certified partner and certified O365 consultants (Sydney, Canberra, Melbourne & Perth), we have extensive experience in delivering Office 365 based solutions. For more information, please contact us from enquiries@prometix.com.au

 

Comments

Post a Comment

Popular posts from this blog

Microsoft Teams is the home for the modern workplace of the future

-
W hile using legacy systems, users previously had to jump between several different systems through a series of bookmarks or company portals. This constant switching can be incredibly disruptive. According to a June 2015 UC Irvine study, “The Cost of Interrupted Work: More Speed and Stress,” it can take upwards of 23 minutes for a person to regain productivity after such an interruption. Microsoft Teams is the hub for teamwork Microsoft believes Microsoft Teams is the home for the modern workplace of the future. Out of the box, Microsoft Teams brings together the most common tasks that employees need under a single roof, such as chats, meetings, calls, and the productivity suite of Office 365. By combining these together into a sole product, employees can avoid having to constantly switch between various contexts. Instead, they can spend their time within a single team or channel that effortlessly brings together all the relevant information in-context. The Microsoft Power Platfo
Read more

Data Governance with Azure Purview

-
Image
The modern workplace his a data-centric world. Organisations are always increasing the amount of data they must collect, store, and analyse to inform critical business decisions and measure their organisation’s performance. As data becomes increasingly important, so do the tools needed to discover, manage, and track information in the absence of a data governance program. In the absence of a data governance program, the decisions made about key data systems are made by association staff who “own” the system. When there are different owners for systems (which is very common), the result is inconsistencies in data availability, collection, usability, integrity, and security. This instantly causes data quality problems. It also can negatively impact user experience if there is no integration or procedures to update the existing data within your environment. If you and your organisation find yourselves in such a predicament, Prometix highly recommends deploying an Azure Purview solution. 
Read more

Collaboration with SharePoint VS MS Teams

-
With all the hustle and bustle of the workplace, it can be hard to find exactly what you’re looking for or know who to ask. Defining who is working on what and how they’re involved in the project isn’t always a simple task. Although SharePoint has made managing and sharing content easier, it still isn’t as seamless as its end users would hope. Being able to access content and applications all in one place is useful but doesn’t solve the problem of how to organize information that is only relevant to certain groups. The main goal of SharePoint is to facilitate collaboration, but when content is broadcasted to the entire organization, it can make end users unsure which information applies to them. Microsoft has acknowledged this issue with the creation of its new collaboration tools, SharePoint team sites and Microsoft Teams . These allow end users to create separate areas specifically designed for certain projects they’re working on and for the teams they’re working with. By organizi
Read more