JoelBlogs - Joel Jeffery's Microsoft 365 Blog

Microsoft 365, SharePoint, Teams and Office 365 Architecture, Development, Administration and Training

  • Home
    • Sitemap
  • Articles
    • #SPThingADay
    • SharePoint Online
      • SharePoint Online – Drag and Drop and Large File Uploads
    • SharePoint 2016
    • SharePoint 2013
      • Content Database Changes to the AllUserData Table
    • SharePoint 2010
      • Administration
        • Disable CRL Checking
        • Excel 2010 & PowerPivot
        • Limits & Thresholds
        • PeoplePicker AD Errors
        • Recycle Bin Behaviour
        • Renaming a Server
        • Service Pack 1
        • Unattended Installs
        • Uninstall All SharePoint 2010 Solutions via PowerShell
        • User Alert Management
        • Virtualised SharePoint
        • Visio Stencils for Administrators
      • Development
        • Audience Membership Workflow Activity
        • Base Types, Lists & Content Types
        • BCS & Offline Sync
        • Debugger Skipping Lines
        • Development Laptop Spec
        • Enabling JavaScript IntelliSense
        • Event Receivers & Deployment Jobs
        • FavIcons & SPUrl
        • Google Maps Sandbox Web Part
        • Group By Content Type for List Views
        • Locale Stapler / Master or Default Locale
        • Removing Default Editor Parts
        • Sandbox Embedding Resources
        • Solution Sandbox Introduction
        • SPPersistedObject
        • Restoring Deleted SPSites in SP1
        • SPWebConfigModification 1
        • SPWebConfigModification 2
        • STSADM copyappbincontent vs. Install-SPApplicationContent
        • Workflows for Beginners
        • Workflow InitiationData Seralizer
    • SharePoint 2007
      • Alternate Access Mappings
      • Excel Services
      • Excel Services UDFs & Excel Client 2007
      • Experiences from the Field
      • InfoPath & Forms Server
      • Kerberos & SSRS
      • Records Management
      • Web Application Service
      • WSS vs MOSS
  • Training
    • SharePoint Admin Links
  • Downloads
    • Summary Slides for PowerPoint
    • CodePlex Projects
      • Audience Membership Workflow Activity
      • Google Maps Sandbox Web Part
      • Group By Content Type in List Views
      • Locale Stapler / Master or Default Locale
      • SharePoint Outlook Connector
  • Hire Me!
    • MCP Transcript
    • Résumé/CV

Self Service Business Inteligence with Excel 2010 and PowerPivot

November 18, 2010 by Joel Jeffery

In this video, Microsoft show us some of the new features in a product that’s quite close to my heart… Excel. Honestly!

Excel 2010 is the first version of the product that really embraces desktop, browser and mobile channels in a high fidelity way. On the desktop, Excel is better than ever. It’s packed with new features such as Slicers and Sparklines. Slicers are visual selectors that let you intuitively slice and dice pivot tables, and Sparklines are tiny charts that fit in a single Excel cell driven from data on your workbook.

Next is Windows Phone 7’s exceptional support for Office documents including Excel and things living in SharePoint.

Finally, whilst I’m talking about SharePoint, I should mention Office Web Apps – the online version of the Office Suite. You can use this for free on SkyDrive, or to make use of Excel Services and Excel Web App together. Office Web Apps can be installed on top of any SharePoint edition including Foundation.

One of the new features in Excel client is multi-user edit. This tells you when others are editing the document you’re working on. You can see their edits, live, as you move from cell to cell. Amazingly, this feature is also available in Office Web Apps via the browser. Impressive stuff. I really like Excel Web App – just compare it to Google Docs and see how much of your Excel workbook gets lost or deleted by Google.

Excel 2010 also has an awful lot for the enterprise. PowerPivot is a new product to accompany Excel 2010 and SQL Server 2008R2. The Excel end lets business users easily build impressive and useful dashboards out of in-memory OLAP cubes running on SQL 2008R2. Because it’s in memory, a) you need a shedload of RAM, and b) it’s incredibly fast.

Lastly, Excel Services 2010 extends the functionality of the previous products by taking advantage of Windows 2008R2 high performance clusters, and lets us run the Excel calculation engine in a grid or private compute cloud. For customers in the banking or scientific sectors this means it can reduce complex computations from hours down to minutes or seconds.

Filed Under: SharePoint Tagged With: Business Inteligence, Excel 2010, Excel Services 2010, Office Web Access

Joel is a full-stack cloud architect who codes. He is a Microsoft Certified SharePoint Online, SharePoint Server and Azure specialist and Microsoft Certified Trainer.
He has over 20 years' experience with SharePoint and the Microsoft .NET Framework.
He's also co-founder of Microsoft Gold Partner JFDI Consulting Ltd. Read More…

Recent Posts

  • Microsoft Flow Tip #1 – Word Templates and Hiding Empty Repeating Sections
  • SharePoint PowerShell Tip #1 – Select-Object and FieldValues
  • Popular Misconceptions – Microsoft Teams relationship with SharePoint
  • Course: Microsoft 365 Certified Teamwork Administrator
  • Audience Targeted Searches in Modern SharePoint Online
MCT 2020-2021
Microsoft Teamwork Administrator Associate
Joel's Acclaim Profile
Joel's Microsoft Profile

Tags

Administration Architecture Certification Cloud Development freetraining Information Architecture intranets MCP Microsoft Microsoft Architecture Microsoft Azure microsoftsharepoint migration Mobile Development MOSS Office 365 office365 Office 365 Permissions PowerShell SaaS SharePoint SharePoint 2010 SharePoint 2010 Training SharePoint 2013 SharePoint Administration SharePoint Administrator SharePoint Architecture SharePoint Developer SharePoint Development sharepointia SharePoint Online sharepointonline SharePoint Search SharePoint Training SharePoint Videos Silverlight SOA SPThingADay TechEd 2007 Training Videos Windows Phone 7 WSS

Copyright © 2022 Joel Jeffery, SharePoint Architect