ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

My Journey to CBAP - Part 3

Updated on April 10, 2012

Accounting for Your Experience

The real work in getting your CBAP application submitted comes in with accounting for your professional hours, and then recording these hours into the application form. Unless you are in the very fortunate position of having up to 10 years of timesheets at your disposal, you have a substantial task ahead of you.

Fortunately the application form takes this into account, and only requires a statement of total project hours, and then a percentage allocation to each knowledge area. I had several goes at getting this information down, and in doing so became very familiar with the layout of the individual project sections. In the end I decided to create a spreadsheet based on the field requirements and layout of the application form. This made transcribing my hours from the spreadsheet quick, and after having laboured over the spreadsheet to make sure that I had correctly accounted for each project’s hours speed was important to me.

My approach to tackling this was as follows:

  1. Create a spreadsheet that I could use to collate my hours.
  2. Build a view of the projects I had worked on.
  3. Determine the key stakeholders for each project.
  4. Determine the amount of time I had worked on each of these projects.
  5. Allocate my hours to the projects in the context of the six knowledge areas.

Step 1: The Spreadsheet

The spreadsheet that I eventually settled on closely mirrors the format of the online CBAP application form itself. I did this because I found that the amount of effort involved in actually transcribing the project detail from the spreadsheet to the online application form was staggering.

I also did not want to record straight into the application form either, because I really wanted to make sure that I had gotten everything correct; dotted the i’s and crossed the t’s if you will. I put in several crosschecks to make sure that my tallying of my hours achieved the minimum requirements, that I had correctly apportioned 100% of the hours across the knowledge areas, and so forth.

You can find the spreadsheet here.

Step 2: The Projects

To build my view of the projects that I had worked on I started with my email. I combed through all of my archived email. I was lucky that I had kept almost all of my project email across the previous 10 years, and I had also mostly kept individual folders for each of the projects.

Step 3: The Stakeholders

Once I had managed to get down the projects that I worked on I started the task of finding (remembering) the key stakeholders on each project. I trawled my mailboxes for project documents that required sign-off because I knew that, by virtue of the stakeholder information I included in these documents, these documents would contain my desired Project Contact and their contact details.

For my older projects I then double-checked the phone number, address and website details, even using Google in some cases to track the current information down. I wanted to make sure that whoever was reviewing my application would be able to contact the company, even if the Project Contact no longer worked at the company.

Step 4: Project Hours

While I was working at sorting out the contact information I was also, almost in parallel, building a retrospective view of my involvement in the project. Where possible, I dug out old project plans. These were great since my commitment to the project was spelled out (even if in the end we had deviated from the plan), and this is still a wonderful starting point.

I could find no supporting project management documentation for some of my projects, so in these cases I simply reviewed both scoping documents and the actual artefacts that I had created, and then applied my memory to assessing the project time commitment.

Furthermore, on a number of the projects that I had worked on I had to factor in non-business analyst work into my tally of hours. The spreadsheet caters to this, and it is very important that you remove these hours from the project hours that you are accruing for each of your submitted projects.

Step 5: Knowledge Area Allocation

The final step in the process is assigning hours to each of the Knowledge Areas, as defined by the BABOK. Concluding your hours allocation successfully requires that you have an understanding of the tasks that comprise each Knowledge Area. DO NOT attempt your hours allocation before you have at least spent some time reading through, and understanding, The Guide to the Business Analysis Body of Knowledge - Version 2.0 Framework.

I found that I could categorise my projects, effectively grouping similar types of projects together. In each of these project groupings I felt that my hours allocation across each Knowledge Area would be much the same. Since you are working with a percentage of time you do not have to be accurate to the second.


  1. The IIBA’s CBAP page should be your starting point.
  2. The Guide to the Business Analysis Body of Knowledge - Version 2.0 Framework is a great overview of the BABOK in general. Get the birds-eye-view here.
  3. Download and read the IIBA’s CBAP Handbook.
  4. You can also check out the IIBA’s Online Application form for the CBAP.
  5. My hours justification spreadsheet template.


This website uses cookies

As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

Show Details
HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
LoginThis is necessary to sign in to the HubPages Service.
Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
AkismetThis is used to detect comment spam. (Privacy Policy)
HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
MavenThis supports the Maven widget and search functionality. (Privacy Policy)
Google AdSenseThis is an ad network. (Privacy Policy)
Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
Index ExchangeThis is an ad network. (Privacy Policy)
SovrnThis is an ad network. (Privacy Policy)
Facebook AdsThis is an ad network. (Privacy Policy)
Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
AppNexusThis is an ad network. (Privacy Policy)
OpenxThis is an ad network. (Privacy Policy)
Rubicon ProjectThis is an ad network. (Privacy Policy)
TripleLiftThis is an ad network. (Privacy Policy)
Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
ClickscoThis is a data management platform studying reader behavior (Privacy Policy)