May 2007 - Posts

Microsoft Office SharePoint Server 2007 Receives U.S. Department of Defense 5015.2 Certification

Finally!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I got a message about this from Arno early this morning. Well for some of us it means that answering some recent RFPs would be alot easier than expected (let's say it came right on time). 

Enterprise Content Management and Records Management Education

There is so many examples even today of badly implemented Records Management solutions. This, besides being professionally embarrassing in the industry, also discourages many clients from going ahead with any Enterprise Content Management and Records Management solution in any near future, creating fewer opportunities for all of us in the industry as well as keeping South African growth and maturity in Enterprise Content Management and Records Management behind the rest of the world.

Because of such cases many Public and Private Sector clients today give up on the whole idea, and shelf it for later, indefinitely.

I strongly suggest that teams and companies involved in implementing Enterprise Content Management, particularly Records Management don't just go for a quick buck and rather send their key consultants and solution architects to attend available courses to first learn the concepts behind such solutions, because believe it or not, knowing technically how to implement such solutions is simply not enough.

Many Microsoft Competency centers today are only now embarking on such implementations as Sharepoint 2007 is still a fairly new product carrying fairly new (for Microsoft) concepts with it.

Below are some links of some degrees and courses that can help your organization and employees:

http://stbweb02.stb.sun.ac.za/mikm

http://www.aiim.org/education/certificate.asp

http://www.national.archives.gov.za/rms/rmc.htm

PerformancePoint Server 2007 and how it positions itself with the rest of the Microsoft BI offering

Remember my last blog entry when I talked about Sharepoint 2007 Excel Services and Excel?

The stack looked something like the one below:

By adding PerfomrancePoint Server Microsoft is adding a new layer to the stack that addresses Performance Management.  Microsoft wants to make BI more complete, more corporate and more accountable.  By more complete, they mean more subject areas and the whole BI process.  They need to break these down separately.  Most users, when they do personal BI, generally consume one, maybe two data sources, but rarely multiple subject areas.  So we might analyze the sales of our store.  Maybe we're focusing on how to understand our revenues based on time of day. But on the other hand, imagine being the district manager and doing this across your stores.  If one of those stores pays outrageous rent, the right answer might be to shut that store down.  Or move it.  All the sales analysis in the world is wasted until you discover and address the real performance issue.  With respect to the BI process, Microsoft defines the ‘five questions' of BI.  These are:

  • What happened?
  • What is happening?
  • Why?
  • What will happen?
  • What do I want to happen?

The first two are really about monitoring your business.  The third is analysis, plain and simple.  The last two are really about planning.  And it's a cycle.  You see something happening, you delve into it and you make a plan to address it.  Or you have a plan, you watch for actual results.  If they are anomalous, you do some analysis.  In Performance Management PPS 2007 supports the whole Monitor, Analyze, Plan cycle.  Today Microsoft has two fully released products in the market at this tier of the stack.  Business Scorecard Manager 2005 is a tool for monitoring a business.  It, working with SQL Server Analysis Services and SQL Server Reporting Services, answers those first two questions; What happened?  And what is happening?  ProClarity 6.2 is a tool that adds value to Analysis Services and address the third question; Why?

PerformancePoint Server 2007 merges these two tools.  It's important because not only does it address the last two questions, it adds the corporate aspect of trusting your decisions, and the accountability.

By corporate, we mean two things.  First, decisions should be made using data that reflects corporate reality.   Going back to my sales analysis from earlier, using data at the store level might lead to one set of decisions.  But when I factor in corporate effects, like regional and national costs, I might make a very different set of decisions.  So PerformancePoint includes an engine that does consolidation, allocation and inter-company eliminations.  The second part of this is making decisions in the context of the corporate process.  So if I want to budget more advertising money in my region, that plan needs to be approved by my boss.  Or my sales forecast has to go to my district manager before it gets locked down.  PerformancePoint includes features for implementing your company's business process in the decision making flow.

Lastly, BI has been a ‘read-only' business for too long.  The IT department delivers a great, clean, trusted data layer.  The users grab that data in rich tools like Excel and they develop insights.  But what happens after that?  Unless you translate your insights into a plan, and record that plan somewhere, we'll never know if your insights, and your actions, made a real difference.  So let's say I do my store analysis.  I use complete data, sales and expenses.  I use corporate data, fully burdened by allocated costs.  And I decide that we need to move two inside sales reps out to the sales floor.   In PerformancePoint, we record that decision.  You've effectively changed your resource allocation.   You are now accountable for that decision.  Next month, or maybe next quarter, we can compare your forecast with the new resource allocation to actual data.  We'll all know if that was a good decision or not.  And one of the great things about accountability is, the flip-side of that coin is audit-ability.  In PerformancePoint, we know who saw what data, because we log that, who made what decision, because we made BI read-write and of course, we know the result.

The other nice feature of PPS is that because we're at this higher level of the stack, we can give each user the right amount of data to make a decision; not too little and not too much.  Generally we use Excel.  So, for example, when the sales forecast is due, we send the sales rep a link to a spreadsheet.  In fact, it's a link to the PPS server.  When the user hits that link, we generate a spreadsheet that has the right amount of data for that user, the correct, current data.  They add their inputs to the forecast, submit it and we move it along to the next person in the business flow, usually the manager.  The user never had to hunt for data, never saw too much data or the wrong data.  We record what they did, when they did it.  And the whole time, the user was just ‘using Excel' something they already know how to do.   This is good for users of course, but it's good for IT departments too.  Because, deep down, we've taken this formerly document oriented, hard to control, hard to manage process and made it a centrally managed, controlled, database process.  But the users just keep using Excel...

Anyway, that's the stack.  SQL Server as the technical BI platform.  Office as the user platform.  And PerformancePoint as the business platform.

Information sourced from various Microsoft sources

Microsoft Office Business Applications (OBA) Presentation and Demo

On Thursday 17th of May I did an internal presentation to my colleagues and consultants at Business Connexion on Microsoft Office  Business Applications (OBAs) focusing mainly on Retail OBAs and also an overview on Health, Finance and Manfacturing OBAs, followed by Sharepoint 2007 Business Intelligence solutions (beautiful blend of Enterprise Content Management and  Business Intelligence).

Due to popular demand I will have to redo this demo (and due to some interruptions) this coming Thursday.

Demo and the presentations were based mainly on my knowledge acquired from my trip to Redmond (see my earlier blogs) as well as standard Microsoft demos and presentations (as seen on TechEds etc).

Soon I will also be doing a presentation and demo on PerformancePoint Server 2007 as well as internal training (only for BCX employees). At the later stage (in agreement with my management and possibly Microsoft) I wouldn't mind doing it for the community too (actually I would love to).

Also I would also like it if there is someone in the community with similar interest and knowledge, who would like to join me in this initiative.

In the mean time, please don't hesitate to contact me should you need any more info or any help with respect to these technologies and initiatives.

Sharepoint 2007 Excel Services and Excel 2007 - Microsoft Business Intelligence

At the heart of today's Microsoft's Business Intelligence offering lies SQL 2005, this is where (chronologically) Microsoft began.

Besides the relational engine, SQL Server provides three key components that support the three key technical activities, or verbs, of BI.  Integration Services is the ETL tool.  It lets you pull together data from multiple sources and create, or synthesize, new information.   It's high-performance, with a very rich feature set.  Analysis Services let's you express, and calculate, business logic.  You want to enrich your data with consistent, centralized calculations that express the way the company thinks about its data, and its business.  Reporting Services addresses distribution of data and information, to end-users, via reports.  These can be ad-hoc reports built using Report Builder.  Or they may be production reports delivered, on a schedule, through email or your corporate portal, typically Sharepoint 2007 and Excel Services.

Once you can trust your data, the next step is to address and support the insights your employees derive from that data.  Microsoft Office and the Office Server System, via Excel and Sharepoint 2007 with Excel Services, address the need to ‘trust your insights'.    We have a lot of end-user tools.  But just letting your users loose with an OLAP tool and a server full of cubes will not lead to consistent, quality insights.  First, you'd be making your users find the data.  And who's to say two people trying to explore the same opportunity will find the same supporting data.  Yes, we want creativity, but we don't want one department working off this year's numbers while another only finds last year's.  The related problem is that users often find too much data.  We don't really need everyone accessing every piece of data in the company.  The other issue companies face at this middle level is a daunting investment in training users on these tools.  There is a staggering amount of shelf-ware in the OLAP tools market.  In the Microsoft stack, we use Sharepoint 2007, in particular the Business Data Catalog, to help users find relevant, fresh data.  Excel is the tool that most end-users already know. Allowing it to publish itself with some of its basic functionality to Sharepoint 2007 via Excel Services in a web format propels Excel to a whole new level.  In Office 2007 Microsoft built a tight link between Excel and SQL Server Analysis Services that makes analysis of centrally calculated and managed data a first-hand experience.

Determine resource requirements to support Excel Services and view examples of suggested architecture for Excel Services

For more information about Office Excel 2007:
http://office.microsoft.com/excel

For more information about Microsoft SQL Server 2005 Analysis Services:
http://www.microsoft.com/sql/technologies/analysis/default.mspx

For more information about Office Excel 2007 PivotTable dynamic views:
http://office.microsoft.com/en-us/excel/HP101773841033.aspx

Another good resource for information about Office Excel 2007 is the Excel blog:
http://blogs.msdn.com/excel/

For a TechNet webcast, "Office Excel 2007 and SQL Server 2005 Analysis Services Integration Explained" (Level 200):
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032299077&EventCategory=5&culture=en-US&CountryCode=US

For more information about language identifiers in the 2007 Office system: http://technet2.microsoft.com/Office/en-us/library/f5fee727-df49-4ef7-b073-dd6c08dfecfa1033.mspx?mfr=true

My upcoming internal PerformancePoint Server 2007 Presentation and Demo

Since I'm busy putting a demo together for PerformancePoint Server 2007 CTP2 (released on 10th of April 2007) I've come to realize what a beast it actually is. Knowing basically that the merge of Business Scorecard Manager 2005, Proclarity 6.2, Office 12, SharePoint 2007 and SQL 2005 technologies gave birth to this monster I never quite expected for it to be light on resources or for that fact enjoy being installed on one box alone.

To put everything into perspective, the kind of solutions that you will give to the potential PerformancePoint Server client will most likely be the full Microsoft BI offering.

Think of the whole Microsoft Business Intelligence offering basically in terms of three things:

  • Applications, which is PerformancePoint Server 2007
  • End-User Tools, which is Excel 2007 and SharePoint Server 2007
  • Business Intelligence Platform, which is SQL 2005

It can span across many servers and/or clusters, depending on the size of the organization and its requirements.

My current setup for the upcoming demo is the PerformancePoint Server 2007 CTP2 image from the connect site running on:

Operating System: Microsoft Windows Server 2003 SP1 Enterprise Edition

Database: SQL 2005 SP2 Enterprise Edition

If you want to see examples of suggested deployment scenarios and find out more about PPS requirements you need access (unless you already have it) to the Microsoft Connect site and be part of the PerformancePoint Server 2007 CTP2 program to download the software and documentation.

Still no news regarding Sharepoint 2007 Records Management DoD certification

14th of May came and went and no news as yet. Still the only solution that makes Sharepoint 2007 Records Management DoD certified is Sharepoint 2007/Livelink 9.7 combination (see one of my previous blog entries).

Please if you find out something before I do, reply to this post, or just send me an email.

Meanwhile I'm about to embark on implementing a Sharepoint 2007 Records Management solution for one of our government clients. I will share some of my more interesting experiences on this blog as they come.

My main concern is proper application and usage of policies once the solution is implemented and in production.

While you're waiting you can maybe read Russell Stalters' explanation on what makes Sharepoint 2007 Records Management solution eligible for DoD certification here (courtesy of Uriel on www.informationworker.co.za).

Top Ten Principles for Records Management

Enterprise Content Management and all that is part of it (namely: Document Management, Records Management and Archiving, Business Intelligence etc.) is really a union of quite simple concepts which are still slowly revolutionizing every bit of today's business and society in all parts of this world.

I usually spend my spare time scouring the internet comparing my best practices and concept definitions regarding Enterprise Content Management (to be used for implementing products such as Microsoft Office SharePoint Server 2007). Sometimes when I find simpler and better ways (above all "simpler") of explaining such concepts I try to reiterate them to others that might find them useful (look at my previous blog entry).

One of those things is this Top Ten Records Management Principles as explained by Carl E Weise of AIIM, as stated below:

  • Records will be routinely created, shared, used and stored in electronic form
  • There will be an increase in individual responsibility for managing information; only one copy of an information object will be stored; there will be greater use of short cuts and hyperlinks; a the culture of sharing information encouraged
  • Access to information will be controlled; there will be increased oversight using audit trails; there will be backup and recovery of computer systems (actually testing recovery processes before they are needed); users will share information except where access cannot be permitted for a defined reason (such as sensitive information)
  • ‘Capture' is the process of declaring, classifying and storing a record; information will be indexed (metadata will be applied to the records); indexing will be based on the organization's taxonomy and thesaurus; ERM will require the minimum possible effort from users
  • File structures (classification scheme) will increase sharing, improve access and collaborative working; users will be able to define file structures suitable for their local business needs; records management professionals will ensure that the file structure in constantly updated
  • Powerful searching capabilities will be available and will operate across the entire IT infrastructure; search capabilities will find information without precise details; search capabilities will be subject to access controls
  • Every information item will have an 'owner' responsible for its management, protection and eventual disposal; owners will provide guidance on use of the information; information governance will need regular reviews
  • Retention schedules will govern information removal; archiving and disposal actions will be scheduled automatically; retention schedules will be reviewed annually
  • Collaborative working features, "a working practice whereby individuals work together to a common purpose to achieve business benefits", will be available to users who need them; will requires a flexible culture; workflow will be used for routing records; different workflow capability levels will be implemented; collaboration will be implemented alongside ERM
  • The software and organizational structure will support the environment envisaged in the ERM policy statement

What is Enterprise Content Management?

It's not enough to "manage" content.

Enterprise Content Management (ECM) is the technologies used to capture, manage, store, preserve, and deliver content and documents related to organizational processes. ECM tools and strategies allow the management of an organization's unstructured information, wherever that information exists.


Content at Work
It's not enough to "manage" content. Of course, the ability to access the correct version of a document or record is important, but companies must go further. Content must be managed so that it is used to achieve business goals. Central to this strategy are the tools and technologies of ECM, which manage the complete lifecycle of content, birth to death. To drive understanding of these tools, this poster highlights a typical process for a piece of content as well as four primary areas in which content, and ECM, is fundamental to the success of your company: Compliance, Collaboration, Continuity, and Cost.

While there are ECM technologies, more importantly, ECM is an ongoing and evolving strategy for maximizing how your content is to be used. Use the information below as a starting point to review a common content lifecycle. Map a current process to see where you may find overlap and room for improvement for the applications and strategies that your business is developing. The information below only hints at the complexity inherent in any process that deals with managing an organization's content. As always, you must match up the technology tools to address YOUR businesses needs. Technology can enable streamlined management of content, but the underlying strategy must come first.

Compliance
The key to a successful compliance strategy is integrating the idea of compliance success into your business-not viewing compliance as a project that can be completed and then considered "finished." While painful, complying with regulations should be viewed as an opportunity to improve common business processes and not just an ongoing cost to the business. It is no secret that there can be high costs associated with your compliance initiatives for both technology and employees. Only securing compliance for one regulation such as Sarbanes-Oxley or HIPAA will cause your costs to continue to grow as each new regulation is delivered over the years. To help limit the risk and cost, proactive ECM strategies must be developed within key areas, such as records management and business process management. Ensuring that the proper business practices are followed and that content is properly captured, stored, managed, and disposed of at the appropriate and legal time in its lifecycle. Developing a compliance initiative properly will tap many areas of expertise, particularly legal, IT, and records management; all in support of the overall business objectives of the organization. Individuals from each of these areas must contribute their knowledge and perspectives to ensure the benefits of a sound compliance program. While compliance is not always a technology problem, information technology, and the massive growth of unstructured content, contributes to corporate exposure. The tools of ECM, properly used, can help reduce the overall cost of compliance to the business.

Collaboration
Collaboration is the art of working together. The key to strong collaboration is utilizing the set of technologies-instant messaging, whiteboards, online meetings, email, etc.-that allow work to take place wherever and whenever needed. It's good business; groups can accomplish more than individuals. Collaboration allows individuals with complementary, or overlapping, areas of expertise to create better results faster than before. With today's collaborative tools, business units and teams can work together anytime-whether in adjoining offices or a world apart. The technology can now address operational objectives like saving time, streamlining processes, cutting costs, and improving time to market. With the many different types of collaborative tools available, companies must be sure they select the correct tool for their business need. Functionality can be broadly grouped into (1) communication channel facilitation, which enables short-lived interaction such as chat, instant messaging, white boarding, etc.; (2) content lifecycle management, which manages content objects involved in a business process; and (3) project facilitation, which organizes and simplifies the way that people work toward a common goal. However, there is a catch with collaboration. When using collaborative tools, you must be aware of records management, knowledge capture, and compliance requirements. For some industries, all customer communications must be kept. And, for a collaborative product design process, companies must be sure that the results are kept as business records.

Cost
While ECM can be a costly initiative, what are the costs of not properly managing your content? The cost of not implementing ECM tools is too often left unmeasured until too late. Things like the cost of long legal proceedings, the loss of repeat business through the inability to perform simple customer service interactions, and the cost of typical business process delays are easy to measure after the fact-lawyers' time, the cost to acquire new customers, and FTE salaries. Understanding the cost of these potential losses will allow you to see that ECM investments have valuable benefits that often can be measured, but not always. The key is to set your key metrics for success up front and measure your success based on those expectations. Measuring the revenue based on improved information in the call center can be done as well as measuring the cost benefits of improvements in process speed for a loan application, claim process, or FDA drug approval (to name a few). The improvements will not always show on the final balance sheet but they are out there. While identifying a direct ROI can be difficult, it is not impossible to see the impacts of the improved process efficiency on the business. ECM tools can make your organization more efficient and drive down the cost of doing business. These technologies provide value to your organization by more efficiently organizing information for its subsequent retrieval, use, and, ultimately, disposition. Plus, as these tools are used by more organizations, it becomes part of how you work. What's the ROI on a telephone? Yet, you wouldn't think of doing business without one, would you?

Continuity
Keeping a business going 24x7 is the task of business continuity planning. While often mentioned with disaster recovery, business continuity planning is the overall strategy for ensuring that operations continue in the event of any disruption-natural or man-made. Disaster recovery is more narrowly focused on getting an organization's IT infrastructure going again, a subset of business continuity. Because the lifeblood of most businesses today is represented by electronic documents, ECM has a key role to play in continuity. After all, without access to the most vital electronic documents, a business is dead in the water. ECM technologies allow the creation of centralized repositories where all vital corporate information can reside. The method of storage will vary depending on how critical the content is to the company-from off-site back up tapes to redundant, mirrored sites separated by geography and on different power grids. A strong continuity plan will show you that not all content is critical. Companies must prioritize their content to determine how quickly content needs to be back online in the event of a disaster. Business continuity begins with a sound plan and high-level executive support. Next, mission-critical processes and the entities on which they are dependent must be determined, followed by a business impact assessment to determine the impact of a disruption, or losing, those processes. Defining what a business considers a disaster and explaining how key processes will be recovered are the next steps in the plan. A crisis operations center should also be established with procedures for chain of command and other roles. Finally, don't forget to update and test the plan annually or as business needs change. Effectively delivering on a continuity plan will enhance your ability not only to recover during a system failure but will enable you to better define the priority of your business content and improve your overall ECM strategy.

BUSINESS PROCESS MANAGEMENT/WORKFLOW
The tools that move content throughout an identified business process, such as claims processing. BPM solutions are frameworks that can be used to develop, deploy, monitor, and optimize multiple types of process automation applications-including processes that involve both systems and people. Consider which processes are candidates for automation, and whether they require some degree of ad hoc processing or manual intervention. Workflow is now commonly associated with the manual processes of managing documents. Workflow handles approvals and prioritizes the order documents are presented. In the case of exceptions, workflow also escalates decisions to the next person in the hierarchy. These decisions are based on pre-defined rules developed by system owners.

CONTENT AND DOCUMENTS
Unstructured content enters an organization's IT infrastructure from a variety of sources. Regardless of how a piece of content enters, it has a lifecycle. Follow a document through its lifecycle as viewed through the use of ECM technology.
1. Electronic Unstructured Data: email, instant message, text document, spreadsheet, etc.
2. Electronic Forms
3. Paper Documents/Forms

SCANNING
Paper generally enters the organization through a scanner, or sometimes, a multifunction device. In centralized scan operations, large volumes of paper are put into the system by dedicated workers. In distributed operations, smaller volumes of documents are captured with lower volume scanners or multifunction devices closer to their point of creation.

DOCUMENT IMAGING
Software captures the image of the paper document. Increasingly, electronic document images have the same legal status as a paper document.

FORMS PROCESSING
Business forms are ingested into the system. Most forms today are "structured"-the location of the form elements are known. The ability to process unstructured forms, those without a pre-defined form template, is improving.

RECOGNITION
Technologies that allow paper information to be translated to electronic data without manual data input. Recognition technologies have progressive capabilities from optical character recognition (OCR) to intelligent character recognitions (ICR) and are important for converting large amounts of forms or unstructured data to usable information in a content management system.

CATEGORIZATION/TAXONOMY
A taxonomy provides a formal structure for information, based on the individual needs of a business. Categorization tools automate the placement of content (document images, email, text documents, i.e., all electronic content) for future retrieval based on the taxonomy. Users can also manually categorize documents. Critical step to ensure that content is properly stored.

INDEXING
An essential part of the capture process, creates metadata from scanned documents (customer ID number, for example) so the document can be found. Indexing can be based on keywords or full-text.

DOCUMENT MANAGEMENT
Document management technology helps organizations better manage the creation, revision, approval, and consumption of electronic documents. It provides key features such as library services, document profiling, searching, check-in, check-out, version control, revision history, and document security.

RECORDS MANAGEMENT
Content of long-term business value are deemed records and managed according to a retention schedule that determines how long a record is kept based on either outside regulations or internal business practices. Any piece of content can be designated a record.

EMAIL MANAGEMENT
As the de facto standard for business communication, removing emails from the server and saving them to a repository isn't enough. Email must be classified, stored, and destroyed consistent with business standards-just as any other document or record.

WEB CONTENT MANAGEMENT
Web content management technology addresses the content creation, review, approval, and publishing processes of Web-based content. Key features include creation and authoring tools or integrations, input and presentation template design and management, content re-use management, and dynamic publishing capabilities.

DIGITAL ASSET MANAGEMENT
Similar in functionality to document management, DAM is focused on the storage, tracking, and use of rich media documents (video, logos, photographs, etc.). Roots of the technology are in the media and entertainment industry, currently experiencing growth, especially in marketing departments. Digital assets typically have high intellectual property value.

REPOSITORIES
Structured and unstructured-the core of many ECM systems. This is where the data resides and where much of a company's investment in ECM resides. A repository can be a sophisticated system that costs hundreds of thousands of dollars, or as simple as a file folder system in a smaller company. The key is to have information that can be found once it is placed in the system.

STORAGE
Content needs to "live" somewhere. Storage technology (optical disks, magnetic, tape, microfilm, RAID, paper) provide options for storing content online for rapid access or near- or off-line for content that isn't needed often.

CONTENT INTEGRATION
Enables disparate content sources to look and act as a single repository.

MIGRATION
As storage media ages, content must be moved to new media for continued accessibility.

BACKUP/RECOVERY
Backing up content in various formats and/or locations helps to ensure business viability in the face of a disaster.

SEARCH/RETRIEVAL
One of the greatest benefits of a strong ECM system is the ability to get out what you put in. By having strong indexing, taxonomy, and repository services, locating the information in your system should be a snap.

SYNDICATION
Distribution of content for reuse and integration into other content.

LOCALIZATION
Recasting content based on the needs and cultural mores of different global markets.

PERSONALIZATION
Drawing on a taxonomy and based on established user preferences, various types and subjects of content can be delivered via user-defined preferences.

PUBLISH
Content gets where and to whom it needs to go through a number of tools. Content can be delivered via print, email, websites, portals, text messages, RSS feeds.

PAPER ELECTRONIC
Portal, Intranet, Extranet, Email, Fax

SECURITY
Restricts access to content, both during its creation and management as well as when delivered. 1. Digital Rights Management - prevents the illegal distribution of rights-managed content by restricting access to content down to the sentence level as well as granting/restricting permissions for forwarding and accessing content.
2. Digital Signatures - ensures the identity of a document sender, and the authenticity of the message.
3. PKI - uses a public and private key pair held by a trusted third party to transact business over the public Internet.

COLLABORATION
Collaboration technologies enable individual users, such as employees or business partners to easily create and maintain project teams, regardless of geographic location. These technologies facilitate collaborative, team-based content creation and decision-making.

LONG-TERM ARCHIVAL
Content that must be preserved over decades must be saved to media, such as paper and film-based imaging, with longevity to match.


Written by Bryant Duhon, AIIM - The ECM Association, Jeetu Patel and Rick Tucker, Doculabs

Please do yourself a favour and become very familiar with these concepts that define Enterprise Content Management.

Philosophy Behind PerformancePoint Server 2007

PerformancePoint Server 2007 above all addresses the whole concept of Performance Management.

Performance Management according to Gartner:

Combination of management methodologies, metrics, and IT (applications, tools and infrastructure) that enables users to define, monitor, and optimize results and outcomes to personal or departmental objectives while enabling alignment with strategic objectives across multiple organizational levels (personal, process, group, departmental, corporate or business ecosystem"

Gartner - October 2006

"Understand Performance Management to Better Manage Your Business"

Performance Management today has the following gaps and weaknesses and PPS was in fact developed to address Business Intelligence and all of these problems that we see today:

Limited integration

Only 26% of companies have tightly integrated planning and reporting processes.  Logically, a high degree of integration would be expected between the business strategy, the operational and financial plans, and what is then reporting and forecast.  The whole objective of the process is to translate strategies into results.

Lack of consistency

Only 56% of the financial measures are reporting during the planning process - no wonder many organizations complain of the lack of accountability for results"

Poor Understanding and communication of Strategy

Only 25% of organizations freely share strategy plans where 60% of world-class companies do so.

Too financially focused

Nearly half of all companies view the planning process as financial and annual.  Financial plans and budgets cannot be linked directly to the strategy they support.

Costly

The average billion-dollar company devotes 23,000-25,000 person-days each year to planning and management reporting.  A best practice company can produce more effective plans and reports in about half the time. <11-13 full time people>.

Slow and Tedious

Much of the time dedicated to planning and reporting is wasted.  On average, over 50% of professional staff time is spent collecting and validating data rather than analyzing and planning.  At best practice companies, 88% of time is spent performing analysis.

Calendar Driven reports prevent flexibility

The ability of an organization to get the right information at the right time in order to make timely decisions should be an indicator of the company's flexibility, however 92% of all management reporting is available only one predetermined calendar basis, typically monthly while only 8% of management reporting is available on demand. 

Too detailed

Average company financial plan is 372 line items.  Best practice companies operate with at least a 3rd of that.  The is no evidence that more details provide better accuracy

Isolated performance management makes analysts slaves to their spreadsheets.

Spreadsheets greatest strengths are also greatest weaknesses.  Great independence and flexibility but issues with basic quality assurance and control processes.  Other issues include back-up, accuracy of the calculation routines security and data integrity.

On average 30% of end users have access to online applications for ad-hoc reporting compared to almost all for best practices companies.

(Source:Best Practices in Planning and Management Reporting by David A. J. Axson)

 

PerformancePoint was created following the whole Microsoft Business Intelligence concepts and above all it is a business-driven application.

PerformancePoint, and in the capacity of its 4 main capabilities, namely :

  • Monitoring
  • Analytics
  • Planning, Budgeting, Forecasting
  • Reporting and Consolidation

 addresses the above mentioned weaknesses and goes forward in improving Performance Management by bringing values in number of ways, like:

Business Driven -  this value appeals particularly to business analysts, the power users.   Using the application they can drive consistent rules and logic.  This enables individuals to be more effective and the organization to be more agile.

Functionality - PPS is very feature rich.  The product has all the functionality customers can expect if they need to plan, budget, forecast, scorecard, dashboard their business activities and use management reporting and consolidation.  In addition, all users work with a single data model whether they are monitoring, analyzing and planning.

People - PPS is powerful because it can reach all users.  Competitive solutions have not been effective in the last decades because they only touch a few individuals inside businesses.    With PPS, all users are empowered to participate in performance management in a familiar and collaborative environment.

Value - Any customer using Microsoft for BI will find a compelling offer in PPS.    With PPS, Companies increase adoption and lower costs by extending their Microsoft investment for performance management needs.

To quote Microsoft on this one:

PerformancePoint is a business-driven application that brings functionality and value to their people"

There will be more posts of more technical nature on PerformancePoint soon, so watch this space..........

To find out more about how Microsoft Business Intelligence can turn data into knowledge, register here for a complimentary 2006 Microsoft Business Intelligence Resource Kit DVD.

How Microsoft Research Project AURA can complement Sharepoint 2007 ECM solutions

On the Day 4 of my pilgrimage to Redmond I met with Marc Smith. Marc Smith is a Senior Research Sociologist leading the Community Technologies Group at Microsoft Research in Redmond.

My goal was one new intriguing project that Marc at Microsoft Research was responsible for, namely Project AURA.

A - Advanced

U - User

R - Resource

A - Annotation

This is one of those really great technological ideas. My definition of a great technological idea is something that is very simple yet very powerful at the same time, where simplicity itself allows for many other doors to be open, infinite solutions and possibilities. Such ideas motivate you to think of new applications of the same concept all the time, it forever plays with your imagination.

 

All this windows mobile application does is it uses your cell-phone camera to scan the barcode, recognize it and send the info contained in the barcode to a web services prompting a response from the remote web application which appears cell-phone’s internet browser. Basically, it allows people using mobile devices to collectively author and access annotations on physical objects.

To give you one of the examples, imagine the following:

Let’s say you browse around Expensive Books (you all know which store I’m talking about) and you see the long awaited book on C#.NET 3.0, after browsing the book you turn it around to take a look at the price and you get that sensation that is surprisingly similar to a swift kick in the groin: entirely unpleasant. But then you put on a smile and you pull out your cell-phone which is running Windows Mobile, you press to activate AURA and you take a snapshot of the barcode on the book. In a minute you get comparative pricing back from amazon.com, MSNshopping, Kalahari.net and many other that you subscribe to. You click on the item with desired pricing and Voila! your book is on its way to be delivered for half the price.

What this is, in this case, is that this store, shopping mall and the whole world is one big shopping window for one or many online businesses, and the whole shopping experience is safe and secure, done easily from the palm of your hand. 

 

What can it do for your SharePoint 2007 solution and Enterprise Content Management besides the above?

Well maybe enable mobile Physical File Tracking as part of Records Management, maybe enable viewing and retrieving of scanned electronic documents and records from your document management and archiving solution on your mobile device, maybe allow you to retrieve stock levels in the store from just scanning a barcode of the label of the product, again on your mobile device, maybe even retrieving invoices for purchased products and inventory, etc etc…. you figure out the rest. 

Please see attached video about AURA, or if that doesn't work download it here.

For more information and demos, please don't hesitate to contact me.

Format: wmv
Duration: --:--

MOSS 2007 Records Management DoD Certification

Some of you, who’s main obstruction to deploying MOSS 2007 Records Management solutions (especially to the Government) was lack of required certifications (not mentioning the maturity of the product) especially the big DoD certification, might remember early announcement that Microsoft is slotted to take the DoD 5015.2 certification test on May 14, 2007.

Well its seven days and counting now.

Don’t get me wrong, I’m not really against using third party products to complement SharePoint solutions like Meridio and OpenText Livelink by providing more mature Records Management offering, I was even genuinely excited about OpenText providing the first U.S. Department of Defense (DoD) 5015.2 certification for records management of Microsoft Office SharePoint Server (MOSS) 2007 business data early March this year (not just because Livelink RM happens to be another one of my main Enterprise Content Management skills, and it’s really an awesome and powerful product).

But there is something about providing scalable ECM solutions that involves two or more vendors that genuinely freaks me out when it comes to serious support and administration. If something really serious happens and certain vendor support finds out that one of their options is to blame the other vendor, they will most definitely do it, you can be sure of it, leaving you in a perpetual hell of finger pointing, hence why I’m so happy that this date is coming closer.

Before we usually had to use Meridio for Records Management and K2.NET as a workflow component with the good old SharePoint 2003 in order to provide Microsoft ECM solutions to our clients, but then all of our prayers were answered and Microsoft Office SharePoint Server (MOSS) 2007 was released that included all that was missing from its 2003 predecessor (More Rich Collaboration and Document Management, Workflow (WWF and BizTalk) and Records Management).

Microsoft’s prudent strategy in partnering with more established and experienced ECM companies in the market to compensate for some initial parts (mostly Records Management) of their ECM offering that were perceived (wrongly) as more inferior, proved (and continued) to be very effective (coupled with much more appealing licensing model), and allowed to gain a lot of the current ECM market very rapidly. 

                

They are gradually now catching up with their competition and taking them out slowly (just watch). This will be the main reason for them soaring straight into the 4th Gartner quadrant for this year (another one of my prediction).

MOSS 2007 Records Management offering is truly a powerful and beautiful solution, and after May the 14th we will finally be able to prove it to all our clients.

P.S. For more info on MS RecMan, also check Microsoft Records Management Team Blog