April 2014 ~ A brief introduction to Power Tools? ~ John Miner


Presenter: John Miner

Topic: A brief introduction to Power Tools.

Downloads: Available on CraftyDBA.com

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 on the Adventure Works 2012 DW database can leverage these tools.

I will be covering the following topics in this presentation:

  • Grabbing data with Power Query.
  • Transforming data with Power Query.
  • Storing data with Power Query.
  • De-normalizing data for speed.
  • DAX language is in the tabular data model.
  • Power Pivot tables and charts.
  • Adding slicers to Power Pivot.
  • Adding the WOW effect with Power View
  • Various Power View reports.
  • Filtering vs drill down.
  • Using the map to plot real world data.
  • Story telling with tours.


John has over twenty years of IT experience including a Masters degree in Computer Science from the University of Rhode Island with concentrations
in database technologies and programming languages. He also has Microsoft Certificates for Database Administration (MCDBA) and System Administration (MCSA).

John is currently a Senior Platform Engineer at Atrion. He is the PASS chapter
leader for Southern New England SQL Server Users Group.

This entry was posted in Meetings and tagged , , , , . Bookmark the permalink.

Comments are closed.