Ottawa SQL Server User Group

Ottawa SQL Server User Group                       

Next Meeting

Thursday,

January

15

A Tour Through Power Pivot

-

Featured Presentation:

A Tour Through Power Pivot

Michael McKiernan

Microsoft PowerPivot for Microsoft Excel 2013 or higher provides ground-breaking technology. It allows fast manipulation of large data sets, streamlined integration of data (mashups), and the ability to effortlessly share your analysis through such products as Microsoft SharePoint. This is a product that empowers both analysts and decision makers given its Rapid Application Development capabilities. The presentation will cover an end to end fictional case study using real world data. Among the features to be highlighted: 1. Importing data : Excel’s ability to consume a variety and volume of data. 2. Working with Excel’s Data Model to define relationships and manipulate data. 3. Role and Use of DAX. Data Analysis Expressions (DAX) is the standard PowerPivot formula language that supports custom calculations in PowerPivot tables and Excel PivotTables. 4. Visualization Capabilities with Reporting in Excel 2013: Some examples


About Michael:
Michael McKiernan

Season Schedule - 2014/2015 

  • Thursday September 18, 2014 (6:15 PM - 8:45 PM)
  • Thursday October 16, 2014 (6:15 PM - 8:45 PM)
  • Thursday November 27, 2014 (6:15 PM - 8:45 PM)
  • Tuesday December 9, 2014 (6:15 PM - 8:45 PM)
  • Thursday January 15, 2015 (6:15 PM - 8:45 PM)
  • Thursday February 19, 2015 (6:15 PM - 8:45 PM)
  • Thursday March 19, 2015 (6:15 PM - 8:45 PM)
  • Tuesday April 7, 2015 (6:15 PM - 8:45 PM)
  • Thursday April 23, 2015 (6:15 PM - 8:45 PM)
  • Thursday May 14, 2015 (6:15 PM - 8:45 PM)

Will update shortly, please also see our Meetup Group for more details http://www.meetup.com/OttawaSQLServerUserGroup

Our events (meetings) activities are also published on MeetUp -> Ottawa SQL Server User Group (Ottawa PASS)

 http://www.meetup.com/OttawaSQLServ­erUserGroup/


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids