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.
A brief introduction to Power Tools.
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.
The following four products started off as add-ins for Excel. Now, some of them are an integral part of MS Office 2013.
• Power Query
• Power Pivot
• Power View
• Power Map
It is not surprising that these four business intelligence products have a cloud offering in Office 365.
Today, we will explore how a typical BI request for the Adventure Works 2012 DW database can leverage these tools.
1 – Grabbing data with Power Query.
2 – Transforming data with Power Query.
3 – Storing data with Power Query.
4 – De-normalizing data for speed.
5 – DAX language is in the tabular data model.
6 – Power Pivot tables and charts.
7 – Adding slicers to Power Pivot.
8 – Adding the WOW effect with Power View
9 – Various Power View reports.
10 – Filtering vs drill down.
11 – Using the map to plot real world data.
12 – Story telling with tours.
Presentation and Code
Excel Worksheet (rename & uncompress)