Wednesday, 26 April 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Power BI Workshop | Grant Paisley
Author: Grant Paisley Date Posted: 8/08/2013 5:59:29 PM
Power BI Workshop | Grant Paisley
========================================

Power BI = Power Pivot, Power View, Power Query and Power Map

These are availaible now!
Power Pivot, Power View are built in to Excel 2013 Professional Plus

Power Query (was Data Explorer)
Power Map (was Geoflow)
http://office.microsoft.com/en-us/excel/power-bi-download-add-in-FX104087144.aspx

It will also soon be available on Power BI for Office 365..
http://office.microsoft.com/en-us/excel/power-bi-FX104080667.aspx

So we are again *all* going to build a powerpivot model together based on the public crime statistics
OR bring your own data to build a model and we will help you with any questions.

You will need the data source files
https://skydrive.live.com/?cid=7F54C55164E91D4E&id=7F54C55164E91D4E%21336


So you *need*
* laptop (charged)
* Excel 2010 with PowerPivot
http://www.microsoft.com/en-us/download/details.aspx?id=29074

* OR Excel 2013 in Microsoft Office 365 ProPlus (has PowerPivot)
http://technet.microsoft.com/en-US/evalcenter/hh973391

* OR you can use the virtual lab environment (we have wireless)
http://www.microsoft.com/en-us/sqlserver/learning-center/virtual-labs.aspx



Add-ins you don't need but may consider.
=========================================
OLAP PivotTable Extensions
http://olappivottableextend.codeplex.com/

Data Mining Add-ins SQL 2012 Excel 2010 and Excel 2013
http://www.microsoft.com/en-us/download/details.aspx?id=35578

Workbook Size Optimizer for Excel 2010 or Excel 2013
http://www.microsoft.com/en-us/download/details.aspx?id=38793




See you there.

Please register so we know how much Pizza to order!

Grant
grant@angrykoala.com.au

Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30PM Networking (Pizza & Drinks provided) 6:00PM Session | On: Tuesday, 13 August 2013