{"id":32,"date":"2016-03-28T16:33:30","date_gmt":"2016-03-28T16:33:30","guid":{"rendered":"http:\/\/cat5sheetstorm.com\/?p=32"},"modified":"2016-03-28T16:45:32","modified_gmt":"2016-03-28T16:45:32","slug":"microsoft-data-insights-summit-trip-report","status":"publish","type":"post","link":"http:\/\/cat5sheetstorm.com\/?p=32","title":{"rendered":"Microsoft Data Insights Summit: Trip Report"},"content":{"rendered":"<p>I finally returned home last night after a two week &#8220;walkabout&#8221; from Wisconsin to Seattle and back. \u00a0Visiting family along the way, camping on Puget Sound and in the mountains of Wyoming &amp; Montana. \u00a0The excuse for the trip was the <a href=\"http:\/\/datainsightssummit.com\/\">Microsoft Data Insights Summit in Bellevue on March 22-23<\/a>.<\/p>\n<p><a href=\"http:\/\/datainsightssummit.com\/\" rel=\"attachment wp-att-35\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-35\" src=\"http:\/\/cat5sheetstorm.com\/wp-content\/uploads\/2016\/03\/2016-03-28_0937-300x46.png\" alt=\"2016-03-28_0937\" width=\"300\" height=\"46\" srcset=\"http:\/\/cat5sheetstorm.com\/wp-content\/uploads\/2016\/03\/2016-03-28_0937-300x46.png 300w, http:\/\/cat5sheetstorm.com\/wp-content\/uploads\/2016\/03\/2016-03-28_0937.png 611w\" sizes=\"auto, (max-width: 300px) 85vw, 300px\" \/><\/a><\/p>\n<p>This was the first year for this conference. \u00a0Excel is back into the spotlight\u00a0as a serious player in the enterprise &#8212; a platform for data analysis, integration, presentation.\u00a0The focus was PowerBI&#8230;and Excel. \u00a0But mostly PowerBI. \u00a0And most of the presenters were Microsoft employees.<\/p>\n<p>The keynote was\u00a0a whirlwind of new features. \u00a0PowerBI.com is constantly evolving. \u00a0I&#8217;m not sure whether its a smarter move to dive in now or wait for things to settle down. \u00a0Some of the whizbang stuff is cool, but we&#8217;ve got a lot of unsexy plumbing to rig up before we can implement the razzle dazzle of Sand Dance and Apple Watch dashboards. \u00a0Most Excel users, SQL DBAs and software developers won&#8217;t realize how\u00a0big this change is going to be until\u00a0Office 365 and PowerBI are more widely adopted.<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/jH7BVpVMsEw\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>If you haven&#8217;t seen PowerBI tools in Excel, Leif Brenne (Excel Sr. Program Mgr at Microsoft) does an <a href=\"https:\/\/www.youtube.com\/watch?v=RwUSUjRGKVM&amp;list=PL1N57mwBHtN1fuBRfWFhuInZa3KY5EL36&amp;index=4\" target=\"_blank\">intro for Excel users<\/a>.<\/p>\n<p><a href=\"http:\/\/www.powerpivotpro.com\" target=\"_blank\">Rob Collie<\/a>\u00a0not\u00a0only knows the tech, but he understands the reality of implementation and <a href=\"https:\/\/youtu.be\/0WwFJ0Zg3d8\" target=\"_blank\">had a lot to say about why enterprise should embrace what he calls &#8220;Modern Excel&#8221;<\/a>. \u00a0Beyond just technical walk throughs, we need more of this kind of wisdom born of experience.<\/p>\n<p><a href=\"http:\/\/www.sqlbi.com\" target=\"_blank\">Alberto Ferrari<\/a>&#8216;s DAX sessions were\u00a0so popular he had to add more to the schedule. \u00a0DAX is the language of Power Pivot &amp; SQL Server Analysis Services. \u00a0You don&#8217;t need to learn DAX to use Power Pivot to &#8220;join&#8221; tables and build a simple data model in Excel, but if you want to understand what&#8217;s happening behind the scenes and implement some customized tricks you&#8217;ll want to learn DAX. Two sessions on video here:\u00a0\u00a0<a href=\"https:\/\/youtu.be\/klQAZLr5vxA?list=PL1N57mwBHtN1fuBRfWFhuInZa3KY5EL36\" target=\"_blank\">DAX 101<\/a>\u00a0and <a href=\"https:\/\/youtu.be\/6ncHnWMEdic?list=PL1N57mwBHtN1fuBRfWFhuInZa3KY5EL36\" target=\"_blank\">Advanced DAX<\/a>.<\/p>\n<p>Tuesday I participated in a focus group with Microsoft. We signed non-disclosure agreements, got a free pen and sat down to have our brains picked by some sharp &amp; friendly MS folks. \u00a0But, honestly, it was like a group therapy session. \u00a0I learned a lot from the other attendees at the table.\u00a0Everyone had different\u00a0challenges but a lot in common too. \u00a0Fascinating and stimulating to hear their ideas and workarounds.\u00a0Customers like Johnson Controls,\u00a0Archer Daniels Midland, Metro Bank &amp; the Republican National Committee share their stories, v<a href=\"https:\/\/www.youtube.com\/playlist?list=PL1N57mwBHtN26j4PGNQ91VCxHAxkl0_C5\" target=\"_blank\">ideos here<\/a>.<\/p>\n<p>At the hotel lounge, I\u00a0met a software developer who was building a product\u00a0to automatically refresh Power Query using MS\u00a0Task Scheduler. Which interested me because I&#8217;d just tackled the problem a different way (VM + batch file + VBA). \u00a0Any minute now Microsoft may add a &#8220;schedule refresh&#8221; feature\u00a0to Power Query and make all our DIY solutions obsolete. \u00a0That&#8217;s how fast things are changing lately. (PowerBI.com has automatic refresh and it&#8217;s working great for me on a nightly basis.)<\/p>\n<p>More later&#8230;I have a pile up of work to catch up on.<\/p>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-48 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=http%3A%2F%2Fcat5sheetstorm.com&amp;text=via%20Cat5Sheetstorm\" style=\"font-size: 0px;width:48px;height:48px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"48\" height=\"48\" style=\"display: inline;width:48px;height:48px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"http:\/\/cat5sheetstorm.com\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/96x96\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-48 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Microsoft%20Data%20Insights%20Summit%3A%20Trip%20Report&amp;body=via%20Cat5Sheetstorm:%20http%3A%2F%2Fcat5sheetstorm.com\" style=\"font-size: 0px;width:48px;height:48px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"48\" height=\"48\" style=\"display: inline;width:48px;height:48px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"http:\/\/cat5sheetstorm.com\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/96x96\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>I finally returned home last night after a two week &#8220;walkabout&#8221; from Wisconsin to Seattle and back. \u00a0Visiting family along the way, camping on Puget Sound and in the mountains of Wyoming &amp; Montana. \u00a0The excuse for the trip was the Microsoft Data Insights Summit in Bellevue on March 22-23. This was the first year &hellip; <a href=\"http:\/\/cat5sheetstorm.com\/?p=32\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Microsoft Data Insights Summit: Trip Report&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-32","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/cat5sheetstorm.com\/index.php?rest_route=\/wp\/v2\/posts\/32","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/cat5sheetstorm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/cat5sheetstorm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/cat5sheetstorm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/cat5sheetstorm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=32"}],"version-history":[{"count":3,"href":"http:\/\/cat5sheetstorm.com\/index.php?rest_route=\/wp\/v2\/posts\/32\/revisions"}],"predecessor-version":[{"id":36,"href":"http:\/\/cat5sheetstorm.com\/index.php?rest_route=\/wp\/v2\/posts\/32\/revisions\/36"}],"wp:attachment":[{"href":"http:\/\/cat5sheetstorm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/cat5sheetstorm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/cat5sheetstorm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}