Apr

09

Posted by : Kevin Coetzee | On : April 9, 2012

I am sure we can agree. When it comes to Project Management, there are a number of approaches and methadologies. Over the next few posts, I am not trying to advocate any particular approach but rather I am trying to show ideas of how to use SharePoint 2010 as a Project Portal. Hofeully these posts will inspire some ideas and then you can share those ideas with the communities. My aim is to show the concept of this portal site and then you can take the idea and expand it. One of the assumptions I’ll make over these next few posts , is that you have average understanding of the basics of SharePoint (e.g. Differance between a Team site and Blank Site Template). There is no need to know any coding or have any development skills. What will you need at minimal to build this Project Portal? At Minimal : A SharePoint 2010 Foundation instance / Office 365 Instance with appropriate permissions.

For my portal I am going to structure my Project Site in a Hierachy in one Site Collection. I will have one Top Level Site (this being the Project / Programme Landing Page). Then each Porject site will be a sub-site under this. As a basic starting point, I’ll consolidate all the projects into a dynamic “dashboard” on this landing page so that we can ge a high-level overview of all the project sites that have been created. You howver may decide on a completely differant approach and this is completely up to you.

When it comes to a a “starter” project site, what are some of the key elements I look for? With a quick chat to our project managers, they consolidated the following lists of items that would be important and nice to have:

  1. Important

  • Issue Register
  • Risk Register
  • Project Task List linked to Microsoft Project 2010
  • Action Items for none Project Tasks but possibly linked
  • Project Calendar (Consolidated Leave Calendar, Action Item Due dates..etc)
  • Project Document Store
  • Change Log / Change Requests
  • Project Announcements (More Social)
  • Web Based
  • Secure and Versioned
  • Easy to reproduce

2. Nice to Have

  • Requirements List to be linked to requests
  • Possiblity to run a “Sprint Type” Approach
  • Linked to the above – to have a dynamic story board for the sprints (i.e. Sticky Notes on a white board)

SO LETS BEGIN!!!!

[Originally - I was going to type this all out and then decided that I'm way to lazy for that- so I'll be providing a Video recording instead to assist - see you in the next post]

[On Hold] – I’m delaying the output of these videos to End May as I’ll be on Vacation and really do not “feel” like doing “work” stuff – So see you all end of May!

Apr

04

Posted by : Kevin Coetzee | On : April 4, 2012

Ove the last couple of months, I have had a number of requests for a Project Management portal within SharePoint 2010.

There are some great books written on this subject by authors such as @meetdux (follow on twitter) and number of once off posts on various components.

Over the next couple of weeks I’m going to doing a few posts especially for our “End Users” and “Super Users” around building a good starting point for a PMO portal.

It will be in no way on the level of an EPM but a great place to start off as a foundation. During the posts I will point to some options from CodePlex as well as Commercially available options.

I am also going try some options to give you ideas for using various methadologies, such as scrum(Burn Down Charts, Story Boards..etc)

If there is anything you’d especially like me to cover, let drop a comment here or on twitter (@kevincoetzee) and I’ll see if I can fit it in. So let me go away and start preparing for my first post next week.

Jan

31

Posted by : Kevin Coetzee | On : January 31, 2012

Today one of my support colleges ran into this error when one of the busines users tried to open up an excel document through Office Web Apps.

After a couple of minutes of debugging, it came down to a simple access issue. After running the powershell script below, all seemed to be happy again…

$webApp = Get-SPWebApplication “http://mywebappname.com

$webApp.GrantAccessToProcessIdentity(“domain\excelserviceaccountname”)

Oct

31

Posted by : Kevin Coetzee | On : October 31, 2011

Today I got a call from one of my colleges who was focusing on getting better user adoption by using SharePoint mysite. She went ahead and added a number of items under “ask me about” option. Once she tried to go to the people search, she found that the items were not coming through.

My instinctive answer was to run a full index process. After doing this, it really didn’t help much. Then it hit me!!! Profile Service! Well after adjusting a single property in profile serice it all worked again! Here are the brief steps I had to do.

Log into Central Admin. Go to Manage Service Applications. Select the User Profile Service. Edit it and change the Search Settings to Indexed.

 

Oct

21

Posted by : Kevin Coetzee | On : October 21, 2011

This year I had the priviledge in presenting at the Tech-Ed Africa Conference for Microsoft for the 4th year running.. One of the sessions I presented was killer real world powerpivot examples.

The session was origanally done by a “crazy” Australian ,Grant Paisley from Angry Koala, at the North American Tech-Ed. I took the same principle but gave it a bit of a South African Twist.

First I began with a dataset from the National Sea Rescue Institute , and focused around end-user functions in PowerPivot as well as some basic banding in DAX. I then looked at a proof of concept PowerPivot example which originally connected to SAP and was based around HR data. Then I went into some common examples of ATM transactions and Aged Payment Analysis. Final I showed some tricks around Maps and Data (courtesy Microsoft).

All in All I believe the session went off well and the ratings from the audience, seems that they appreciated it.

As promised, Attached to this post is the PPT files as well as all the Excel Examples for anyone to play around with. Thanks everyone for attending

PowerPivot – Shark Attack Example

PowerPivot – HR Example

PwerPivot – ATM Transactions Example

PowerPivot – Aged Payments Example

PowerPivot Presentation

 

 

Aug

19

Posted by : Kevin Coetzee | On : August 19, 2010

A survey of the key enhancements to Microsoft’s business analytics capabilities

Microsoft SharePoint has a long history of bringing BI (business intelligence) capabilities to users, but it’s generally done so with a mishmash of acquired technologies revamped to fit the Microsoft model, look, and feel, and pieced together like Frankenstein. SharePoint 2010 changes that, taking BI to the next level.

The key concept behind BI (to avoid becoming BS) is that you have data amassing daily, hourly, even each second, and you need to do more than simply monitor that data or record that data. You need to analyze it, you need to share it, you need people to take ownership or accountability for it today — not three months from now when that information may be worthless to your company.

[ Read the InfoWorld Center's review of SharePoint 2010. | Stay up to date on the key developments in Microsoft and Windows technology with InfoWorld's Technology: Microsoft newsletter. ]

Thus the push today for right-time business intelligence. It’s all about delivering the right information to the right people in the right format at the right time. The end result should be optimized decision-making.

Let me explain what the SharePoint BI components are and do.

In SharePoint 2010, the BI tools are Microsoft Excel, the PowerPivot Add-in for Excel, Excel Services, Visio and Visio Service, PerformancePoint Services, Report Builder, and Reporting Services, all running off SQL Server, which includes SSRS (SQL Server Reporting Services), Integration Services, and Analysis Services.

Combining SharePoint with Excel or Visio allows users to create workbooks or diagrams and share that information with others easily. However, the Excel and Visio services also allow data to be updated and refreshed by pulling the latest data from various data sources. So, building your workbooks or Visio diagrams from dynamic data does not require manual adjustments on your part.

The free PowerPivot combines an Excel add-in and an SQL Server 2008 R2 add-in to supercharge Excel by letting users do self-service analytics and BI collaboration around large data sets.

PerformancePoint Services allows you to build rich dashboards that pull from a variety of different data sources (such as SharePoint lists, relational data stores, OLAP cubes, and Excel Services). Dashboards might include scorecards, reports, and KPIs (key performance indicators) that provide a summarized view of your business analytics.

There are some serious improvements in PerformancePoint 2010 over its 2007 predecessor. A huge one is the fact that it no longer resides as a stand-alone server but is now an integrated part of the Enterprise SharePoint product. That moves it off the IIS/SQL structure of the past and lets it now use SharePoint document libraries and lists for content storage. The changes in design make for a better backup/recovery strategy, plus they enhance security by authenticating through SharePoint.

New PerformancePoint Services features include enhanced scorecards, reports with built-in drill-down features so you can access information quickly, and calculated metrics that allow you to create calculations that use multiple data sources. You can also view variance metrics to help you see differences between your target values and your actual values, for identifying concerns and risks. And the Decomposition Tree feature from the original ProClarity vesion of the product, which helps keep the top performers on the top of the tree when you are analyzing data, has now become a visualization report type.

To me, SharePoint 2010′s BI capabilities certainly feels a lot more cohesive than those in SharePoint 2007. What do you think? Have you begun working with SharePoint 2010′s BI features? How do they stack up to other tools you’ve worked with?

This article, “How SharePoint 2010 brings BI to the next level,” was originally published at InfoWorld.com. Read more of J. Peter Bruzzese’s Enterprise Windows blog and follow the latest developments in Windows at InfoWorld.com.

Apr

12

Posted by : Kevin Coetzee | On : April 12, 2010

“We need information but all we have is data!”

This is the message managers often complain about. If there is anything that IT has ever done right it is the ability to collect nearly every single bit of data imaginable — from data that is written or keyed-in to a computing device, to images like signatures and X-rays. We even record voice and video these days.

One manager told me over coffee: “I’ve got data coming out of my ears. I don’t know how to make sense of it!”

Part-time solutions have been around for many years. I say “part-time” because the solutions solve only “part of the problem, part of the time.” Product marketers have labeled these as business intelligence (BI) tools.

Wikipedia defines business intelligence as applications and technologies which are used to gather, provide access to, and analyze data and information about their company operations.

The goal of BI tools is to allow anyone using the information provided to make better business decisions. But there are a few problems with traditional BI tools.

BI is mostly associated with report delivery. Usually there are few people within an organization who actually know how to use BI tools. These users hold on to this ‘control’ because they probably get a kick out of the power they have over others.

More importantly, such specialty creates job security. But the net effect has been dissatisfaction with what was purchased, and concern over making further investments in the future.

BI tools’ failure rests in the business unit’s failure to communicate their needs and IT’s failure to ask the right questions. The result is solutions that fail to deliver expectations.

“Previous perceptions of BI didn’t factor the value provided in managing and making sense of the information assets contained within every enterprise,” says V.R. Srivatsan, vice president of Asia South for Business Objects.

“However, this is changing as both technology and the business will with which to use it are maturing resulting in BI becoming a key business process driver within today’s enterprise,” Srivatsan adds.

BI wish list

Suganthi Shivkumar, managing director for ASEAN & India at Hyperion Solutions, notes that business managers want tools that give them increased insight into the dynamic nature of the global marketplace and allow them to identify areas of profitability.

They expect IT to unlock information that is potentially trapped between silos of applications scattered throughout the enterprise.

“Today’s regulatory institutions and business climate are very unforgiving towards any kind of expectation variances or financial discrepancies that may be construed as malfeasance or misconduct. This forces companies to put a lot of rigor in their planning and reporting processes. To produce reports with confidence is critical in the choice of BI tools,” Shivkumar says.

Having a single version of the truth is also just as important. Finally organizations want to have clear visibility of their operations including accurate demand-revenue-expenses forecasts to better deploy resources and capitalize on opportunities.

Business intelligence has emerged as a strategic initiative and investment priority for companies. But because departmental objectives vary, it would be easy to lose sight of the core objectives of the company and to deploy BI tools (sometimes from different vendors) to satisfy those needs.

The net result of such a strategy is a proliferation of disparate systems that not only do not effectively inter-operate with each other but complicate the matters.

The good news is that despite all the not-so-glorious past of BI tools, CEOs still believe that BI tools play an important role in today’s competitive environment.

Global competitive pressures, and mergers and acquisitions are putting constant pressures on restructuring and finding additional sources of profitability. CEOs want insight to help them steer the business through these turbulent times.

For decades companies have been spending millions on enterprise resource planning (ERP), customer resource management (CRM) and data warehousing (DW) tools. With so much information locked in repositories, CEOs are putting pressure on IT to unlock information trapped in those systems.

After Enron, it’s no longer enough to produce reports on time. Accuracy and consistency of reporting have become paramount and discrepancies can mean jail time for even the rich and powerful.

Who is responsible?

Changing the way things get done

Business intelligence has emerged as a top strategic initiative and investment priority for CEOs, but not surprisingly department objectives vary. Having learned from the past, IT is working to standardize on the type of tools it will deploy across the organization.

Users from across the business, not just managers, want quality information on demand, and are no longer willing to wait for IT to serve it. They also want the flexibility and ease of use in engaging tools that they are familiar with (the nearly ubiquitous use of Microsoft Office). And they want their information delivered consistently.

Business users need tools and solutions which not only can deliver information, but can manage information and produce information by integrating with their current systems. Finally they need to be able to tie operational information to financial information.

Minimizing the risk of failure

Business author and management expert Peter Drucker said there is nothing worse than doing the wrong thing well. Why does this happen? Because people don’t understand the company plan or have visibility into how the business is performing.

It happens because people are not accountable for their part of the strategy, or can?t rely on their information to make good decisions.

One of the greatest failings of BI has been in how it gets deployed. Intelligence demand often starts out at a specific department where the scope is tactical and thus deployment is departmental in scope.

The result is a proliferation of tools serving the unique needs of specific departments. Unfortunately, the lack of consistent visibility across the enterprise means that these tools will have limited impact and may not even be aligned with the corporate objectives.

Have you read through a BI tool manual lately? You will notice that it isn’t designed to be used by a layman? Many of today’s BI tools are used by so-called power users who act as gatekeepers of the information. The result is BI tools do not get widespread adoption.

“BI tools must not be limited to those within an organization based on technical skills or of a certain department. To maximize the adoption of the BI tools within the organization, all employees should be given access to the information they need to make business decisions,” advises Shivkumar.

BI is no longer just about the report, but what’s IN the report. Just as business dynamics are constantly changing, BI tools must evolve from a report-centric to information-centric approach that delivers “actionable” insight.

Therefore, it needs to be universally recognized within the organization that BI supports improving performance. BI is a tool that is able to deal with the past, present and future and is the power to provide insight that leads to true competitive differentiation.

The only way to maximize the value of BI is to focus on the total picture — information management, production and delivery that ensures consistent information, and the ability for users to analyze and re-purpose data.

Only then can a standard be identified and adopted across the entire enterprise.

Peep at the future

The current software trend is that of Software as a Service (SaaS) and BI tools are not immune to this trend. In addition, search and web collaboration are functionalities embedded in what vendors are calling the Business Intelligence 2.0 revolution.

Srivatsan cites the example of an emergency room doctor who could use search within BI to scour a broad set of data sources to find out how many instances of food poisoning have been reported in the past 24 hours, where people are affected, and determine common causes.

This real-time access to trustworthy data could help medical professionals spot and prevent widespread outbreak of food-related illnesses.

Companies can also look forward to more collaborative BI such as instant messenger BI where a sales team could have an IM discussion over a dashboard that shows sales performance below objectives, thereby speeding the process for establishing the next steps for addressing the situation.

Imagine being able to call upon BI tools to provide analysis of data as it comes in. This is, after all, what business managers want — the ability to analyze and perform “what if” scenarios with data as it comes in from the field. No waiting for periods to close. What you have is the ability to make decisions at the right time, right place and in the right context.

Final advice

Gartner’s vice president for research, Andreas Bitterer believes that business intelligence needs to be a continuous process for it to be of value. So stop thinking of it as a project.

Srivatsan: “Few organizations have a comprehensive enterprise BI strategy or clearly defined BI standards. Companies with a patchwork of disparate BI technologies are facing the consequences, including, rising deployment, maintenance and training costs, inconsistent information, and frustrated employees who cannot get timely answers to business questions.

By reducing the number of BI tools, companies can save money, have confidence in and control over business data, and give employees the information they need to do their jobs well, he adds.

By Jose Allan Tan (http://articles-hub.net/2010/04/why-companies-need-business-intelligence)

Dec

22

Posted by : Kevin Coetzee | On : December 22, 2009

In the previous Blog entry, we focused on the introduction to how Excel Services is managed in SharePoint 2010. In this post we’ll look at the a new concept in SharePoint 2010 – Managed Services.

Continue Reading

Dec

14

Posted by : Kevin Coetzee | On : December 14, 2009

As many know Business Intelligence is something that many Business users strive for. Now Microsoft has undergone many variations of their Business Intelligence offerings.

Continue Reading

Oct

21

Posted by : Kevin Coetzee | On : October 21, 2009

Switch to our mobile site