Speaker(s): Wylie Blanchard
Duration: 60 minutes
Track: BI Information Delivery
Your end users want to analyze data in your data warehouse. They want it yesterday and they want to do it themselves so that it’s done “right”. Welcome, PowerPivot, a tool that analyzes data from your data warehouse by combining the power of Analysis Services models and your SQL Server Data warehouse within the familiar interface of MS Excel. In this presentation well explore the Analysis Services BI Semantic model & PowerPivot in Excel… Love, Like or hate Excel – Your end users are familiar with it and PowerPivot is the best thing to happen to it in years.
Get the step by step guide:
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…
The Chicago SQL BI User Group hosts monthly meetings for SQL and Business Intelligence professionals to meet, learn, and network. Speakers present a different topic each month covering both SQL BI topics and relevant non-SQL technologies. Dinner, refreshments, and door prizes are provided by sponsors. This meeting was held on Saturday, March 15, 2017, 6:00 PM at Microsoft Technical Center, 200 E Randolph St. Suite 200, Chicago, IL 60601.