Showing posts with label BI and Reporting. Show all posts
Showing posts with label BI and Reporting. Show all posts

Wednesday, October 20, 2010

Graph in Sharepoint

It is amazing, you can now have your own Graphs in SharePoint and that is without much programming efforts. We can now use SPGraphviz.

It is one of the amazing tool which is freely available for create your own graphs.

Wednesday, December 2, 2009

SharePoint BI

A very good 6 Parts article on SharePoint's role in BI.

Part 1 – Getting to Know You – Intro to SharePoint BI

Part 2 – Sell! Sell! Sell! Why Build a Dashboard Anyway?

Part 3 – KPIs – Where do I Come From?

Part 4 – Dissecting Dashboards

[Awaited for the articles to release]

Part 5 – We Really Need to Talk – Scorecards & Reports

Part 6 – Beware the Bogeyman – Securing Dashboards

Thursday, June 18, 2009

Enumerate Roles and Groups from the site

In one of our application we have to create a Report which Enumerate Role Assignments to retrieve Groups and Users Permissions from the Site.
MOSSHowTo has provided a good solution for that. Click here...

Create a Report from an Analysis Services 2008 Database and deploy it in SharePoint 2007

I am trying to deploy the reports created using SSRS to MOSS.
I have found very good link which described with the screen-shots. Read more...

Thursday, June 4, 2009

Tuesday, February 17, 2009

Working with Reporting Services Using Microsoft Sharepoint

There are many instances in which the business process requires executive reports or some company performance reports to show up on intranet sites. Companies do use different portals to build their intranet sites. Microsoft’s SharePoint technology is one such tool. The main task is how we display the reports stored under SQL Reporting Services on the SharePoint site. Microsoft does provide two Web parts with SQL Reporting Services SP 2. In this section I will share information on using the current web parts provided by Microsoft and then explain what exactly happens behind the scenes to display the report. Click to learn more how???

Monday, February 16, 2009

Trend Reporting Against a SharePoint List

A programme manager I work with wanted to view trend information regarding the projects in his portfolio. His problem was that weekly reports were all well and good but with around a dozen projects under his wing he could not readily visualise where projected milestone delivery dates were, in general, getting worse or better.
To meet this requirement I knew that we had to create a 'snapshot' record on a regular basis, which would be completed by individual project managers. Some information would need to be recorded each week, with one variable field - the Forecast Date.

Sunday, February 15, 2009

Visual Indicators for the Masses: KPIs in WSS

All of us must measure something in order to see if we are meeting our goals. They can be financial goals, customer satisfaction goals, or amount of work done measurements. KPIs (Key Performance Indicators) are a way to quickly gauge how you are doing, not by having to go through and analyze measurements through a spreadsheet, but through some simple visual indicators.
Putting KPIs into your dashboard allows you and your team to get an immediate view into how you are doing on your goals and measurements.

SharePoint comes with really cool web parts for presenting key performance indicators, but these are only available in the Enterprise edition. If you are running Windows SharePoint Services or SharePoint Server Standard, it is not available.

The only limitation of this concept is that you can only build KPIs on top of data stored in SharePoint lists.

Friday, February 13, 2009

Create Chart from SharePoint List Data

How do you create a Chart in SharePoint using List data? I tried different approaches and at the end I found a better solution. Chart Web Part which demonstrate Silverlight feature as well.
For a small demo you can also visit http://www.wssdemo.com/Pages/graph.aspx