Speaker(s): Wylie Blanchard
Duration: 60 minutes
Track: BI Information Delivery
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:Analyzing SQL Server Data using PowerPivot in MS Excel_SQLSaturday 595_Cleveland 2017_Wylie-Blanchard_Great-Tech-Pros
Get the step by step guide:
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event was held on Feb 04 2017 at Hyland Software, 28500 Clemens Rd., Cleveland, Ohio, 44145, United States