I am happy about the opportunity to present at the Rhode Island Business Intelligence User Group on May 12, 2014. <\/p>\n
I have not been to Bryant University since last year and it will be great to see what is new since I last visited.<\/p>\n
I look forward to seeing old friends and meeting new ones. I will presenting the following topic.<\/p>\n
Topic:<\/span><\/p>\n A brief introduction to Power Tools.<\/p>\n Abstract:<\/span><\/p>\n In recent months, there has been a big push for self service business intelligence tools by Microsoft. The center of this universe is Microsoft Excel, a common application used by the typical data analyst.<\/p>\n The following four products started off as add-ins for Excel. Now, some of them are an integral part of MS Office 2013.<\/p>\n \u2022 Power Query It is not surprising that these four business intelligence products have a cloud offering in Office 365. <\/p>\n Today, we will explore how a typical BI request for the Adventure Works 2012 DW database can leverage these tools.<\/p>\n Coverage:<\/span><\/p>\n 1 \u2013 Grabbing data with Power Query. Screen Shots Presentation and Code Excel Worksheet (rename & uncompress) I am happy about the opportunity to present at the Rhode Island Business Intelligence User Group on May 12, 2014. I have not been to Bryant University since last year and it will be great to see what is new since I last visited. I look forward to seeing old friends and meeting new ones. I will presenting the following topic. Topic: A brief introduction to Power Tools. Abstract: In recent months, there has been a big push for self service business intelligence tools by Microsoft. The center of this…<\/p>\n","protected":false},"author":1,"featured_media":4995,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1066],"class_list":["post-7242","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-business-intelligence--john-f-miner-iii--pass--presentation--rhode-island--user-group"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/7242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7242"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/7242\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/4995"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n\u2022 Power Pivot
\n\u2022 Power View
\n\u2022 Power Map<\/p>\n
\n2 \u2013 Transforming data with Power Query.
\n3 \u2013 Storing data with Power Query.
\n4 – De-normalizing data for speed.
\n5 \u2013 DAX language is in the tabular data model.
\n6 \u2013 Power Pivot tables and charts.
\n7 \u2013 Adding slicers to Power Pivot.
\n8 \u2013 Adding the WOW effect with Power View
\n9 \u2013 Various Power View reports.
\n10 \u2013 Filtering vs drill down.
\n11 \u2013 Using the map to plot real world data.
\n12 \u2013 Story telling with tours.<\/p>\n
\nSteps 1 to 12<\/a>
\nSteps 13 to 25<\/a><\/p>\n
\nDocument Bundle<\/a><\/p>\n
\npower-tools-introduction.zip.001<\/a>
\npower-tools-introduction.zip.002<\/a>
\npower-tools-introduction.zip.003<\/a>
\npower-tools-introduction.zip.004<\/a>
\npower-tools-introduction.zip.005<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"