Tag: Excel

  • SQL Saturday Chicago 2017

    SQL Saturday Chicago 2017

    Analyzing SQL Server Data using PowerPivot in MS Excel 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…

  • Chicago SQL BI User Group March 2017 – @CNUG_

    Chicago SQL BI User Group March 2017 – @CNUG_

    Upcoming event:  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…

  • SQL Saturday 595 – Cleveland Ohio 2017

    SQL Saturday 595 – Cleveland Ohio 2017

    Session Description: Analyzing SQL Server Data using PowerPivot in MS Excel 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…

  • Approaching January 1st, 2017

    Approaching January 1st, 2017

    With the 1st day of 2017 approaching let’s take a look at a few of my activities from 2016. Wylie Blanchard.

  • Chicago .NET Users Group – Microsoft Corporation 2016

    Chicago .NET Users Group – Microsoft Corporation 2016

    SESSION DESCRIPTION: Technology Enhancements for SQL Server 2014/2016 Developers Speaker(s):  Wylie Blanchard Duration: 75 minutes Your team is planning to upgrade from an early version of SQL Server environment. Learn what’s new and which features and enhancements are really important to the work life of a SQL Server Developer. In this presentation, we’ll explore SQL…

  • Use Video as a Tool to Enhance Speaking Skill and Create Web Content #TSQLTuesday

    Use Video as a Tool to Enhance Speaking Skill and Create Web Content #TSQLTuesday

    You’re a new technical speaker and you’re looking for new ways to grow platform skills and possibly create more content for your website/blog. Here’s how you can do both at the same time. Video record your live presentations. Why? Two reasons. Video recording your presentation offers three ways to get constructive feedback ↓ Video recording your presentation…

  • Rockhurst University – Kansas City 2016 – SQL Saturday #548

    Rockhurst University – Kansas City 2016 – SQL Saturday #548

    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…

  • Indiana Wesleyan University – Indianapolis 2016 – SQL Saturday #530

    Indiana Wesleyan University – Indianapolis 2016 – SQL Saturday #530

    Session Description: 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…

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

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

    Last updated 05-13-2017 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. Activate the Power Pivot & Power View add-ins          Open MS Excel 2013\2016          Go to File > Options > Add-Ins          In the Manage box, click COM Add-ins> Go…