Weekly Newsletter Signup

• Upcoming
  Live Online Workshops

  • Excel and SharePoint: I didn’t know you could do that!
  • Easy Tabs Interface - Simple SharePoint Navigation for Complex Information
  • Train the Trainer: Materials and Resources for in-house SharePoint Training
  • Become Your Company’s SharePoint SuperStar!
  • Hack SharePoint Web Part Displays with XSLT
  • Business Solution: Health Care Case Management
  • Killer Calendars in SharePoint
  • The Basics of Content Types
  • Business Solution: Create a Compliance Report Intake System in SharePoint
  • Business Solution: Manage Input with Dynamic Feedback Forms
  • Live Blogging at SharePoint Conference 2009

• Ongoing Series

  • Article Archives (1000+)
    All Authors
  • This Week in SharePoint with Joel
    Joel Oleson
  • jQuery for Everyone
    Paul Grenier
  • The Calculated Column
    Dessie Lunsford
  • The Data View Web Part
    Laura Rogers
  • Stump the Panel: Q&A
  • Subscribe to the Weekly Newsletter

• Authors

  • Dessie Lunsford
  • Laura Rogers
  • Lee Reed
  • Mark Miller
  • Jim Bob Howard
  • Paul Galvin
  • Paul Grenier
  • Toni Frankola
  • Woody Windischman

• SharePoint Resources

  • Bits of SharePoint
  • Codeless Solutions for SharePoint
  • Get the Point
  • Innovation Matters
  • Path to SharePoint
  • Paul Galvin
  • SharePoint 911
  • SharePoint Blank
  • SharePoint Blogs at SharePointU
  • SharePoint for Non-Developers
  • SharePoint Forums at SharePointU
  • SharePoint Screencasts
  • SharePoint Use Cases
  • Social Media Talk Tweets
  • The Sanity Point
  • The Weekly Newsletter  

Although implementing a KPI dashboard like this one might look complicated it is not. By using the Data View Web Part you can create your own dashboards plus extras. The solution does not do anything special (only displays colorful icons) but your managers will love it.

With Mark Miller as the host, Laura Rogers will demonstrate just how flexible and useful the Out-of-the-Box Web Parts are in MOSS. She will take a detailed look at the Filter, KPI, Excel Web Access, Outlook Web Access, Business Data Catalog, and Data View Web Parts. She will then look at how to customize some of these web parts using SharePoint Designer while still adhering to the Industry Best Practices. All of this is done without using any code. This session in itself is a best practice, because it is best to learn what SharePoint can do out-of-the-box, before writing any code.

The script below, combined with such a list view, will plot a Google Chart showing those totals dynamically. The chart scale is automatically adjusted with the maximum value to be charted so it fits the designated size in the script. Once implemented, you can hide the list view web part so only the chart will render on the page. You can also play around with chart parameters within the script, to change chart type, style, size, colors or even build more complex charts. Take a look at the Google Chart API page for reference.

The EWA web part allows you to incorporate the charts and tables from Excel that are driving your business into a dashboard page in SharePoint. Perhaps on one page you would like to display one chart with product sales YTD and another chart with revenue dollars per Sales Representative. Using the EWA web part you would be able to do this; the charts could be located in the same spreadsheet or in separate spreadsheets.

Planning and organizing SharePoint lab in a virtual environment. Organizing a “SharePoint team”
Planning your sites with Mind Manager. Simple, easy, effective use cases and scenarios you could deploy to your intranet site. Creating KPIs on top of Windows SharePoint Services
Using simple web parts and scripts to change SharePoint UI: collapse quick launch, adjust a web part size automatically, add menu items, create preview panes and much more

There are so many things as an end user you can do with Excel Services however it can be hard to get started. There are not a lot of resources out there for end users to begin using Excel Services, so I aim to fix that. Over the next few months, I will be writing a blog series on how to best utilize Excel Services. This first post will cover the basics, what is it and what you need to do to get started. After that we will move on to more complex stuff like parameters, promoting pivot tables, connecting filters to your charts and tables.

Christophe at Path to SharePoint is at it again. This guy’s got some really cool stuff going on. In addition to making EndUserSharePoint.com look good, the functionality he is able to produce out of the box is something that deserves a deepdive.