Using PowerPivot in MS Excel to analyze SQL Server Data
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.
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…
SQL Server Consultant, Great Tech Pros
Wylie Blanchard, MCSE is an IT consultant, SQL Server professional and web strategist who enjoys helping people learn how to use technology as a tool to amplify their professional lives. He has 15 years of experience in the IT Industry and holds several certifications in SQL and Oracle systems. He is a father of twin-girls, a gadget enthusiast and a self-proclaimed pizza connoisseur.
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event was held on Aug 13 2016 at Indi
ana Wesleyan University North, 3777 Priority Way South Drive, Indianapolis, Indiana, 46240, United States