Dashboards In Power BI With Real-time* Data
Khilitchandra Prajapati PASS Chapter, Singapore www.bigator.com Vice President, BI & Data Analytics – UOB, Singapore
Agenda Overview of Power BI Scenarios / Business Cases Streaming Options in Power BI Demo & QA
Overview of Power BI Software As A Service (SaaS), 2nd in its kind Central Reporting under 1 Umbrella Supports Self-Service BI Paginated Reports Seamless integration (Keep expanding horizons) Available any Platform, Any device Cloud & On-Premise versions Find out more: https://powerbi.microsoft.com/en-us/
Scenarios / Cases for Real-time* Monitoring (e.g. Infra support team, Supply Chain) Engagement (e.g. Offers Mgmt. in Service Sector - Hotels) Action (e.g. Fraud detection, Hacking, IoT – earth quake) Optimization (e.g. System testing, Scientific research) More Or your Boss asked for it
Streaming Options in Power BI 2 Options Push Datasets Streaming Datasets
Push Advantages Its Direct Query Can build reports, custom visuals, Q & A, alerts etc. Caveats Slower refresh times API throttling limitations When should we use ? General purpose 3-5 seconds latency accepted r/api-rest-api-limitations
Azure Stream Advantages Very quick refreshes ( 1 Sec) Visuals optimized for real-time refresh scenarios Easy to build and integrate in Dashboard Caveats Limited set of Visuals for Dashboard Good panning is required Data goes into short-lived –Redis Cache store Power BI connects to Redis Cache when Streaming Visual is active on Dashboard When should we use ? Absolutely need “Latest” data (up-to-date data)
PubNub Advantages Very quick refreshes ( 1 Sec) Visuals optimized for real-time refresh scenarios Easy to build and integrate in Dashboard Caveats Limited set of Visuals for Dashboard (data lives @ PubNub) Can not create visual from Data directly Good panning is required 70 SDKs are available (https://www.pubnub.com/docs) Power BI requests data from an existing PubNub Stream (https://www.pubnub.com/) When should we use ? Absolutely need “Latest” data (up-to-date data)
Capability Matrix
Before you start – Keep in mind Reduce to data volume down to only what you need to display on Dashboard For any deeper analysis/operations, store into Database, connect Power BI via import/live connection Be aware of data volume limits (more on REST APIs) Select proper columns for display on Dashboard More: real-time- streaming#using-power-bi-rest-apis-to-push-data
DEMO TIME
Demo Dashboard
Helpful Resources real-time-streaming https://www.youtube.com/watch?v 0YIBHfgasok i/streaming- business-data-to-dashboards/ azure-iot-hubpowerbi/
Thank you Enjoy rest of the Event, Have a great weekend
PubNub Advantages Very quick refreshes ( 1 Sec) Visuals optimized for real-time refresh scenarios Easy to build and integrate in Dashboard Caveats Limited set of Visuals for Dashboard (data lives @ PubNub) Can not create visual from Data directly Good panning is required
Relating to Nonprofit Financial Management, Dashboards : Provide quick, at-a-glance summary of your financial state of affairs. Offer managers, on a daily basis, . Often, dashboards are done in Excel. Excel is good for dashboards that provide a static view, as well as dashboards
This series of tutorials introduces you to dashboards and reports in Salesforce. Salesforce Reports and Dashboards is the term we use to refer to everything dashboards and reports enable you to do with your data. A lot of different features come together to make up Salesforce Reports and Dashboards. Don't get
This series of tutorials introduces you to dashboards and reports in Salesforce. Salesforce Reports and Dashboards is the term we use to refer to everything dashboards and reports enable you to do with your data. A lot of different features come together to make up Salesforce Reports and Dashboards. Don't get caught in the trap of thinking of the
SAP BusinessObjects Dashboards (Editions) Includes connectivity to the SAP BusinessObjects Business Intelligence platform and SAP Netweaver BW, Business Suite. Description SAP BusinessObjects Dashboards Interactive Viewing Enterprise license for viewing dashboards Intended for users who view and interact
Power BI home button 4. Icon buttons, including settings, help, and feedback 5. Search box 6. Favorited dashboards that you use the most 7. Favorite and frequent dashboards, reports and workspaces 8. Reports built by the Power BI Community, picked by the Power BI team Power BI service: Home screen TALLINN UNIVERSITY OF TECHNOLOGY VIRUMAA COLLEGE 30
LIT-12011694 2020-10-29 Release 11.0 Custom Dashboards for the Metasys User Interface. Custom dashboards enable Metasys UI designers to create dashboards that provide the most relevant and critical information to Metasys operators for enhanced
Management containing 7 dashboards, and Sales containing 3 dashboards. Figure 1-1 Note Mr. Iain Wicks has agreed to permit me, albeit for a fee, to distribute his 10 Dashboard Videos along with this book. If you think that these are help-ful to your needs, you may purchase the entire collection of videos at a re-duced cost of 339.15 US from:
paper might assist you in your project. WHAT MAKES A GREAT DASHBOARD? As mentioned above a great dashboard has some simple characteristics. Here are some ideas about what works for users of dashboards and why they work. 3 A dashboard is an information application, and like many of the best apps, the best dashboards don’t .
