Continued from Chicago SQL BI User Group March 2017 – @CNUG.
Self Service BI With a Tool End Users Already Know & Love
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.
Download: Presentation Slides – Demo
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…
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.