Community Server Reporting

As I mentioned this weekend our interns have been working on a reporting framework for Community Server. The reporting application requires a separate database as it reads from an existing CS database (incrementally) and then re-organizes the data into a data structure designed for reporting.

Some details and screenshots below:

  • Over 50 reports covering all aspects of Community Server (Blogs, Forums, Photos, Files, and more)
  • Displays many reports using interactive Flash graphs
  • Includes many “Top <x>” style reports, as well as the ability to drill-down and see the full details of the report
  • Allows users to export any report/data into CSV/Excel format
  • Allows users to filter data based on given date ranges
  • Simple tasks to handle migrating and crunching of Community Server data
  • Migration tasks can be easily segregated by application type and function
  • Data can be migrated both incrementally or completely
  • Extendable, flexible reporting framework! Completely customizable
  • Ability to create new reports either programmatically via the API, or declaratively in configuration files
  • Customizable report layouts allow users to easily change the way reports are displayed or shown
  • Full web-based management of reports (adding, editing, disabling/enabling, etc…)

Chart from Blog Popularity Report (weblogs.asp.net for past 3 months)

 

Report from Blog Popularity (weblogs.asp.net for past 3 months):

Below are some of the reports that are supported:

Blogs:

  • Average Posts Per Blog
  • Blog Comments
  • Blogging Frequency per Blog
  • Blog Posts Created
  • Blog Views
  • Highest Rated Blogs
  • Most Popular Blogs
  • Posts Per Category
  • Rss Subscriptions Per Blog
  • Total Posts

Forums:

  • Most Replied To Topics
  • New Users
  • New Forum Posts
  • Average Post to User Ratio
  • Posts by Language / Country
  • Most Active Forums
  • Average Post Frequency
  • Active and Inactive Users
  • Inactive Threads
  • Moderation Statistics

The framework also make it really easy to add new reports either as stand-alone assemblies (for more advanced reports) or expressed through simple XML syntax that can just be plugged in.

Keep reading

All articles
Uncategorized

Do you magnify efficiency?

When you think about designing [something] using technology, do you magnify the efficiency or the inefficiency? I came across this quote from Bill Gates in The 4-Hour Workweek:…

1 min read
Uncategorized

Breast Cancer Awareness Month

I almost let it pass without realizing it. October is Breast Cancer Awareness Month. This is an issue that I’m personally connected to. When I was 21 breast…

1 min read
Uncategorized

Announcing Community Server 2008.5

Last week I announced that Community Server Evolution – a version of Community Server designed specifically for the Intranet – was released. Today I’m happy to announce that…

1 min read