Rockhurst University – Kansas City 2016 – SQL Saturday #548

RT @RobKraft : I’m learning about power tools for Excel/sql server from @WylieBlanchard1 at #sqlsat548. He is a good presenter!

Session Description:

Analyze & Visualize SQL Server Data w/ PowerPivot, PowerView & Excel

Speaker(s):  Wylie Blanchard

Duration: 75 minutes

Track: Analytics and Visualization

Your end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they’d prefer to utilize a familiar application like MS Excel. Welcome PowerPivot, a tool that retrieves data from your data warehouse by combining the power of SSAS models and your SQL Server Data warehouse within the familiar interface of MS Excel. In this presentation well explore SSAS BI Semantic model, PowerView, PowerPivot in Excel.

Accompanying Materials:

Presenation SlidesDemo

Get the step by step guide:

Analyze & Visualize SQL Server Data w/ Power Pivot & Power View in Excel

In this tutorial we’ll use Microsoft Excel to retrieve data from our SQL Server database. We’ll then model, analyze and visualize the data using Excel’s Power Pivot and Power View features…

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event was held on Sep 24 2016 at Rockhurst University, 1100 Rockhurst Road, Kansas City, Missouri, 64110, United States