{"id":6035,"date":"2017-02-10T17:32:32","date_gmt":"2017-02-10T17:32:32","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/premier_developer\/?p=6035"},"modified":"2019-02-14T20:27:40","modified_gmt":"2019-02-15T03:27:40","slug":"power-bi-a-case-study-to-end-homelessness","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/premier-developer\/power-bi-a-case-study-to-end-homelessness\/","title":{"rendered":"Power BI\u2013A case study to end homelessness"},"content":{"rendered":"

Keith Anderson<\/a>, <\/strong>Senior ADM, shares a practical example of how Power BI quickly transformed a project using simple, out-of-the-box features to integrate data and provide visualizations.<\/em><\/p>\n

\n

I had the opportunity recently to work with the Connecticut Coalition to End Homelessness (CCEH) on their yearly Youth Point-in-time (PIT) Count event<\/a>.\u00a0 Microsoft worked with them on a pro-bono basis to create a mobile application using Xamarin.\u00a0 Microsoft Developer Experience engineers in collaboration with Nutmeg Consulting created a survey application that could be loaded onto devices running iOS, Android, or Windows through the magic of Xamarin and taken out into the field by anyone with such a device to survey Connecticut homeless youth.\u00a0 The data was to be collected and analyzed for use in their admirable goal to end homelessness.<\/p>\n

Almost as an afterthought, Power BI<\/a> was suggested as a way to visualize the data to the coordinator of the youth PIT count streaming in from the survey collectors in real time.\u00a0 This allowed the coordinator to better organize resources during the event and catch potential problems.\u00a0 Here is an example of a dashboard that literally took a few minutes to put together, and yet, was extremely useful to the coordinator during the event.<\/p>\n

I had no prior Power BI experience before this.\u00a0 I was amazed at how easy an interactive dashboard could be created using four visualizations.\u00a0 I had the benefit of targeting a relational data source, so the relationships came in to Power BI already defined.\u00a0\u00a0 The Map visualization was extremely powerful.\u00a0 Using the address fields, the Map was able to geocode and render them appropriately using Bing maps technology.\u00a0 Each point on the map represented a location where a survey was performed.\u00a0 The points were interactive in that consumers of the dashboard could select them and the survey details and questions and answers were rendered in the Table and Multi-Row Card visualizations.\u00a0 Conversely, the Slicer visualization, here rendered as a dropdown list and tied to the survey giver, could be used to show only surveys given by a specific survey giver on the map.<\/p>\n

\"powerbi_map\"<\/a><\/p>\n

This functionality came mostly out-of-the-box.\u00a0 I did minimal data manipulation to get the address in a format that could be geo-coded, but this was nothing that would cause any Excel user to bat an eye.\u00a0 In fact, using Power BI felt a lot like using other Office products, such as Word, Excel, PowerPoint, etc., and I found it to be mostly intuitive.<\/p>\n

This barely scratches of the surface of what Power BI can offer.\u00a0 This was a throw-away ad-hoc dashboard used operationally during a data collection event, and in some ways, more impressive because of it.\u00a0 Going back to Excel as an analogy, how many times have you created a spreadsheet to manipulate some data and convey it to others?\u00a0 The power of the spreadsheet is in its simplicity and elegance.\u00a0 The power of Power BI seems to be along the same vein.<\/p>\n

It also doesn’t escape me that the CCEH use was also an IoT scenario.\u00a0 Microsoft has recently extended Power BI functionality to more easily attach streamed real-time data sources:<\/p>\n

https:\/\/powerbi.microsoft.com\/en-us\/blog\/using-power-bi-real-time-dashboards-to-display-iot-sensor-data-a-step-by-step-tutorial\/<\/a>.<\/p>\n

Power BI also comes with a RESTful API any dashboard can be integrated into just about any modern business application.\u00a0 I know I will be looking for opportunities to evangelize and use this more going forward.<\/p>\n

\n

Premier Support for Developers<\/strong><\/a> provides strategic technology guidance, critical support coverage, and a range of essential services to help teams optimize development lifecycles and improve software quality.\u00a0 Contact your Application Development Manager (ADM) or email us<\/a> to learn more about what we can do for you.<\/p>\n","protected":false},"excerpt":{"rendered":"

Keith Anderson, Senior ADM, shares a practical example of how Power BI quickly transformed a project using simple, out-of-the-box features to integrate data and provide visualizations. I had the opportunity recently to work with the Connecticut Coalition to End Homelessness (CCEH) on their yearly Youth Point-in-time (PIT) Count event.\u00a0 Microsoft worked with them on a […]<\/p>\n","protected":false},"author":582,"featured_media":37840,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[307,88],"class_list":["post-6035","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-permierdev","tag-powerbi","tag-xamarin"],"acf":[],"blog_post_summary":"

Keith Anderson, Senior ADM, shares a practical example of how Power BI quickly transformed a project using simple, out-of-the-box features to integrate data and provide visualizations. I had the opportunity recently to work with the Connecticut Coalition to End Homelessness (CCEH) on their yearly Youth Point-in-time (PIT) Count event.\u00a0 Microsoft worked with them on a […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/6035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/users\/582"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/comments?post=6035"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/6035\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media\/37840"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media?parent=6035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/categories?post=6035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/tags?post=6035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}