{"id":1498,"date":"2022-04-06T18:11:35","date_gmt":"2022-04-06T18:11:35","guid":{"rendered":"https:\/\/addpowerbi.com\/?p=1498"},"modified":"2024-05-31T19:47:39","modified_gmt":"2024-05-31T19:47:39","slug":"predictive-power-bi-home-prices-in-seattle","status":"publish","type":"post","link":"https:\/\/addpowerbi.com\/?p=1498","title":{"rendered":"Predictive Power BI &#8211; home prices in Seattle"},"content":{"rendered":"\n<center>\n    <div class=\"powerbi-container\" id=\"pbi-container\" \n         pbi-resize=\"powerbi\" \n         pbi-resize-img=\"https:\/\/addpowerbi.com\/wp-content\/uploads\/2022\/04\/please-stand-by.gif\" \n         pbi-resize-src=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiMjI3ZmFmNjEtOTRmYS00ODcwLWI1MjItZDhlMzI2MzE3ODZiIiwidCI6IjFiYzU2MWYyLTJkODktNDEyOS1iZmYzLTFiZWRiYWNiMDQ1MyJ9\" \n         pbi-resize-min-width=\"300\" \n         pbi-default-width=\"600\" \n         pbi-default-height=\"636\" \n         pbi-resize-width=\"600\" \n         pbi-resize-height=\"636\" \n         pbi-resize-load-event=\"page-load\" \n         pbi-resize-header=\"true\" \n         pbi-resize-m-src=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiZTFlZDhkNWEtMGQ1NC00ZGJkLTkwYzUtNWZmNzQ4ODNhNzJiIiwidCI6IjFiYzU2MWYyLTJkODktNDEyOS1iZmYzLTFiZWRiYWNiMDQ1MyJ9&amp;amp;pageName=ReportSection85310c9d00a85306a026\" \n         pbi-resize-m-width=\"600\" \n         pbi-resize-m-height=\"636\">\n        <iframe class=\"powerbi-iframe\" id=\"pbi-iframe\"\n                title=\"Adventure Works Financials\" \n                src=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiMjI3ZmFmNjEtOTRmYS00ODcwLWI1MjItZDhlMzI2MzE3ODZiIiwidCI6IjFiYzU2MWYyLTJkODktNDEyOS1iZmYzLTFiZWRiYWNiMDQ1MyJ9\" \n                frameborder=\"0\" \n                allowFullScreen=\"true\" \n                onload=\"hideLoadingImage()\">\n        <\/iframe>\n        <div pbi-resize-wait-txt=\"\u25b6 Show interactive\" \n             pbi-resize-load-txt=\"Loading...\" \n             pbi-resize-rdy-txt=\"\u25b6 Show interactive\"\n             style=\"display: none;\"><\/div>\n    <\/div>\n<\/center>\n\n\n\n<p>I chose this project because I wanted to explore Power BI and R script to do statistical analysis. When I found a dataset online of Seattle home prices 2014-2015 I thought this was a perfect case. My goal here was to test the data, create a predictive model, test the predictive model and then create a user interface for the user.<\/p>\n\n\n\n<p>Then I came across Diana Arciniega&#8217;s article where she literally chose the same data for a multiple regression analysis. Her choice for a user interface with the dataset is so sublimely simple that I immediately decided I wanted to emulate her solution.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"552\" height=\"466\" src=\"https:\/\/addpowerbi.com\/wp-content\/uploads\/2022\/04\/image.png\" alt=\"\" class=\"wp-image-1509\" srcset=\"https:\/\/addpowerbi.com\/wp-content\/uploads\/2022\/04\/image.png 552w, https:\/\/addpowerbi.com\/wp-content\/uploads\/2022\/04\/image-300x253.png 300w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><figcaption class=\"wp-element-caption\">The House Price Predict-o-matic.<\/figcaption><\/figure>\n<\/div>\n\n\n<p>My approach to this problem differed substantially from Diana. I used R script in power query to calculate the slope of the independent variables and the adjusted R Square and R. This meant I could just use the exported results instead of creating Dax formulas. I created a dynamic scatter gram to compare the dependent value price against multiple independent variables.  I built a test of correlation, covariance, fit and residuals to test the predictive power of the model. And the model itself doesn&#8217;t plug in the slope numbers but instead looks them up using LOOKUPVALUE. This allowed me to change the parameters in the R script to test the impact of adding and removing independent variables to try to get the strongest fit.<\/p>\n\n\n\n<p>The real point of this short blog post is sing praises of Diane&#8217;s solution. That interface is simply beautiful.<\/p>\n\n\n\n<p>You can check out Diana Arciniega&#8217;s blog &#8220;How to Do Multiple Linear Regression in Power BI&#8221; <a href=\"https:\/\/iterationinsights.com\/article\/multiple-linear-regression-in-power-bi-with-r-script\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"here\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I chose this project because I wanted to explore Power BI and R script to&hellip;<\/p>\n","protected":false},"author":1,"featured_media":1503,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[4],"tags":[33,18,32,34],"class_list":["post-1498","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-design","tag-multiple-regressive-analysis","tag-power-bi","tag-predictive-power-bi","tag-r-script","has-content"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/addpowerbi.com\/index.php?rest_route=\/wp\/v2\/posts\/1498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/addpowerbi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/addpowerbi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/addpowerbi.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/addpowerbi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1498"}],"version-history":[{"count":12,"href":"https:\/\/addpowerbi.com\/index.php?rest_route=\/wp\/v2\/posts\/1498\/revisions"}],"predecessor-version":[{"id":1799,"href":"https:\/\/addpowerbi.com\/index.php?rest_route=\/wp\/v2\/posts\/1498\/revisions\/1799"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/addpowerbi.com\/index.php?rest_route=\/wp\/v2\/media\/1503"}],"wp:attachment":[{"href":"https:\/\/addpowerbi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/addpowerbi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/addpowerbi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}