Breaking down information silos - Part 2

It has been a while since I posted Part 1 – let’s just say I was distracted by life.

Let’s continue…

Forgot to mention I took over mid-project. By then, the customer has agreed to leave direct data integration out of the project scope and adopt a POC approach to see if we could surface the data. That certainly made life easier.

As we dived deeper and found out more about how the business users created and consumed the reports, we discovered that another BI Project was running in parallel. So, the question is: “Why Vorsite?” BI is not our core competency and we have been upfront to the customers. However, we are experts in hooking MOSS up to Enterprise Content Management systems so we understand how important it is for end users to go to a single point of entry to access the information they need to do their jobs. After all, the biggest pain point (for the existing desktop tool) was the multiple source/location/copy of the “same” reports.

So, we really need to deliver a solution which will be perceived as value-add as well as make sure that it is scalable and extensible.

The first Excel report contained the group's overall financial report. PerformancePoint Monitoring Server came into the picture. We built a couple of scorecards that provided at-a-glance insights into non-performers. These scorecards were based on flat data which has been imported into a SQL database and a cube. This addressed the need of top leadership so that they could take actions. Depending on needs, we planned to add analytic reports/graphs to present the data in different views in future phase(s).

For the Business Unit Managers, they needed details and made profit center accountable.

In order for profit center managers to follow the money trail, we needed to integrate the second set of Excel reports which were pulling data directly from a cube owned by a different group. We decided to use Excel Services and create an Excel Services report in the Dashboard Designer. There was no reason to rebuild something which worked plus we did not have write access to the cube to manipulate the hierarchy of the dimensions and produce an analytic report with all the columns our customers wanted to see.

Finally, we created a page in MOSS. When I saw the PerformancePoint Dashboard item Web Part, I honestly thought that was the coolest thing ever existed. A fellow colleague who is a developer will probably yell at me for simplifying the complexity in pulling everything together but it really did seem easy: just add and drop the filter, scorecards and reports you need! (That’s definitely the PM talking.)

Thanks to the hard work of a dedicated team, the above was successfully pushed out to production. We generated so much excitement in the super user group that we were approached to look into how we could convert an Excel forecast management tool into a web-based tool and integrate that into the new platform!

We are hiring!

Vorsite is looking for passionate individuals that are interested in driving and producing Enterprise 2.0, Collaboration, and Search solutions. Whether you enjoy sales, development, consulting or support, we are interested in hearing from you! We are recruiting for our offices in Seattle and Charlotte. Send your resumes and a brief description of your interests to careers@vorsite.com .

Breaking down information silos - Part 1

What do you do when the customer gives you a couple of Excel Spreadsheets and you are asked to “expose the data” in SharePoint using PerformancePoint? Make things happen!

As a Program Manager at Vorsite Corp., I was recently asked to run this project. I pretty much walked away from the initial internal project briefing wondering how to translate “make it pretty”; “wow me!” etc. into user requirements. But, it’s my job to scope the requirements and see structure in “chaos” – should be a walk in the park, right?

Here are the facts:
- Two Excel Spreadsheets containing data pulled from different data source. Several hidden worksheets with columns performing vlookup/complex if-else statements to derive values for use in multiple pivot tables representing the data in different views

So, what’s the problem with using the Excel spreadsheets?

I like to approach problem using a scenario. So, picture this:

You are a new hire in the Marketing group. As a Business Unit Manager, You are responsible to track budget spend and keep management informed of how you spend the money. Because of the nature of the business, you have to collaborate with several other business units/external vendors to run a full marketing campaign. As a result, you distribute your budget among several individuals. So, you have a group of people who commit to spending X amount of your money but you have no visibility to the actual amount until the invoices go through the financial systems. You quickly realize that you need to look at multiple systems to follow the money trail. The monthly meeting is tomorrow – where do you look? Jim, your analyst, said the latest Excel reports are stored in the shared network drive – access is open to all – can you trust the data? Where do you start? Over 10 campaigns and it’s already 2 in the morning. Do you even need to be concerned at all? Or maybe you can simply pray that forecast always equal actual in real life.

Don’t take me wrong. I love Excel. And I marvel at the complexity of these two reports. I just think that it should be easier when you need more information. Plus, nothing prevents me from tweaking the figures to my advantage. If everybody brings a different copy of the report to the meeting, how can decision makers gain true insights into business performance?

If I got you hooked so far – stay tuned for more…

Bridging the gap, enterprise 2.0 with SharePoint

Bridging the gap between new and old methods for online communications within an organization can be challenging at a minimum...the Podcast that Rano Joshi presented this month discusses how enterprise 2.0 can be incorporated into a SharePoint solution to alleviate the pains of online communications within organizations... http://research.pcpro.co.uk/data/document.do;jsessionid=C4B19A34B091062A43185D9A551F6949?res_id=1225284892_758&src=pcpro

More information:
Today more than ever CEOs are asking their CIOs and IT organizations to play a bigger role in the company's growth initiatives by providing tools to enhance collaboration and foster dynamic communication across departments, ultimately to engage more customers and bring more goods and services to market.

Using rich blog, wiki, RSS, mashup & social-networking solutions combined with the enterprise content management and search capabilities of SharePoint, SharePoint customers are well positioned to create a competitive advantage in good or bad economic times by leveraging the benefits of Enterprise 2.0.

Listen to this podcast to learn how Vorsite has worked with the world's largest software company to implement an Enterprise 2.0 solution that provided a comprehensive business productivity platform that combined traditional collaboration solutions with newer social-computing technologies in an enterprise environment.

Source for Information around Enterprise Search, Collaboration, and Enterprise 2.0

Vorsite is the premier provider of leading enterprise-wide content management integration and search solutions that connect authorized users to business-critical information stored across back-end systems, and provides real-time access to secure content, enabling IT to deliver true content lifecycle and compliance management.

Vorsite's technology connects end-users to content within the organization allowing users to collaborate within the context of the business process in which they are involved, while using the familiar user interface of SharePoint. In addition to their SharePoint deployment, many organizations want to implement a social networking solution to enable better collaboration and a new platform for delivering up-to-date and relevant information for the organization, while also providing a forum for increased levels of efficiency and collaboration. Vorsite is helping some of the world's most successful companies across the globe to derive significant value from Enterprise 2.0 technologies.