More ITIL Goodness

I’ve not posted anything for quite a while, which is not purely down to laziness!

I am now writing for the good people at Orbus software and a whole range of my ITIL articles are here:

Posted in Uncategorized | Leave a comment

Making the Most of That Last Interview Question (Guest Post)

So much of the interview advice bandied about on the internet is about damage limitation. Advice like “Don’t be late,” or “Dress smartly” is great if you want to avoid sabotaging your interview but if you want to get ahead of the crowd advice gets thin on the ground.

This article is my humble attempt to share a true value-add interview tip, so with no more fluff or fuss…

Just the Tip

The interview is virtually over and it probably feels like the job is won or lost already, there is just that pointless final question left:

“Do you have any questions for us?”

The tip is to answer this with:

“Is there anything I can do between now and starting the job to make me even better suited?”

That line puts the interviewer in a position where they have to verbally say you are perfect for the job (which is no small thing), or name some specific shortcoming and give you another chance at convincing them of your abilities or experience.

Of course, if you are genuinely weak in the named area this is not going to help much. But often it is usually a case of accidental omission on the part of the interviewee. It is all too easy to not give enough coverage on a particular subject which the interviewer may be interested in, especially if the job requires numerous skills or experience.

My Personal Experience

I would never advise anything unless I had used it successfully myself.

And this tip is gold! Since being told about this by a fellow freelancer a few years ago, I have used this approach around ten-fifteen times (as a freelancer I tend to interview every 6 to 9 months) and it has been well received every time.

The usual response is a nod and wry smile from the interviewer(s) as they acknowledge the brilliance of this question. I have even an interviewers compliment me on it and admit they will use it themselves at their next interview.

Does it guarantee you’ll get the job?

No, but nothing will.

There are always factors outside our control. But personally, I can directly credit it with me securing at least three jobs when concerns were raised around my abilities or experience and I was able to address these fears.

Obviously, making this ‘tip’ public potentially weakens it as a strategy for myself, so I’ll probably have to return to asking if it is okay to use the disabled parking if I’m hungover!

About the Author

Dean Paumme is an active freelancer in the Business/IT arena and author of “The Secret Route to Riches: How to make millions with your current career”, a no nonsense, tip laden guide to making the most of your skillset.

Get his book here (

Or here (

The Secret Route to Riches by Dean Paumme

The Secret Route to Riches by Dean Paumme


Posted in Career, Uncategorized | Tagged , , , , , | Leave a comment

Helpful ServiceNow Reporting Articles

I thought putting together a contents list of the ServiceNow reporting blogs I’ve written over the last couple of years for easy reference would be helpful.

So, here it is!
ServiceNow Reporting and Why Direct ODBC Reporting is the Only option

A few Random Tips for ServiceNow Reporting

Reporting Software and ServiceNow

How to Overcome the Top 5 Challenges for ServiceNow  Reporting

Example ServiceNow Report

This post is more around generic ITIL reporting, but may still be interesting:
The Top Three ITIL Reporting Pitfalls (pt 1)

…and this last one has nothing to do with ServiceNow reporting, but I’m including it anyway as someone typically asks:
How to Become an IT Consultant for Fame and Profit

Posted in ITIL, ServiceNow, Uncategorized | Tagged , , | 1 Comment

How to Become an IT Consultant for Fame and Profit

I seem to get more emails asking about how to become a self-employed consultant than I do about any other thing I actually blog about.

I’ve not written that much recently so thought I would put up a quick post with some advice around this subject.

So, my top piece of advice (and only piece of advice!) is to buy this book:

The Secret Route to Riches by Dean Paumme

The Secret Route to Riches by Dean Paumme

(Please note, that is not a paid link, just a graphic I’m not getting paid for!)

The above book costs virtually nothing as a kindle download and covers all the things you need to know to get started as a consultant, whether this is as a Business Intelligence expert or any other IT discipline.

I received this book as a gift, about a decade too late for me, but it would have been a life saver (ok, money saver!) back when I was starting out. It’s packed with practical advice on everything from finding contracts to the correct mind set to make the most of it.

Posted in Business Intelligence, CodeProject | Tagged , , , | Leave a comment

How to Overcome the Top 5 Challenges for ServiceNow Reporting

The Stuff I Don’t Need to Tell You

I am pretty sure that if you’re reading this you already know why good reporting is crucial for successful ITIL and why control beyond the Report Module in ServiceNow is a necessity.

If not, look here.

And as if that isn’t grim enough, nearly two thirds of all Reporting/Business Intelligence projects fail or, at the least, don’t succeed fully.

Your Top 5 Enemies

I have worked on numerous Business Intelligence projects of all shapes and sizes and the same few issues arise across all types of reporting and all business sectors.

1.  Learning the Database

Which data lives in which tables and the different permutations on how they can all link together depending on the business need.

Figuring out all this from scratch is difficult. So difficult I wrote this post to try and help you out.

 2.  Organisational Thirst for Information

Businesses need information, and having to wait for a lengthy BI Project to complete can take months.  This can lead to end user attempts at report development in Excel and Access…which can be great, but often isn’t!

3.  Budget

A full BI Project is expensive and requires a range of skilled individuals to bring it to fruition before you even look at software licenses and hardware.

4.  Skills Shortages

Good BI people are constantly busy.

Finding the right person with the right software knowledge and business sector can be a huge challenge in its own right and ITIL is one of the more complex subjects to report on.

5.  Specialist Software

Reporting software can get very expensive, but even when it doesn’t, it can take a long time to buy through company purchasing procedures making the wait for information last even longer.

Help Me Help You

If you are worried about any or all of the above…you should be!   And these problems are generic, ITIL and ServiceNow come with their own challenges.

Let me help.

I know the data(1) having developed ServiceNow reports for a global market since 2010 (and ITIL reporting since 2004) and have a starter set of 20+ top quality reports that can be used almost instantly(2) for a low price(3) developed by myself(4) in Crystal Reports(5ish!).

Another example of the clear and concise ServiceNow reports available.

An example of the clear and concise ServiceNow reports available.

This pack contains a library of ODBC driven, clear and meaningful, ServiceNow reports which span Incident, Problem and Change management. Covering SLA/OLA/KPI measurement as well as volume and frequency for a holistic view of the service management slice of your ITIL implementation.

If required, these reports can be branded with your company colour(s) and logo at no extra charge.

An example of the clear and concise ServiceNow reports available.

Another example of the clear and concise ServiceNow reports available.

Included in the price is one day of offsite consultancy to aid any reconfiguration needed to match your company’s unique setup.

On-going Support

Crystal Reports is a common skillset, and with this starter pack as the foundation, most Crystal Reports developers should be able to pick it up and expand the suite.


At the least, simply use the SQL and table structures from Crystal Reports as a massive head start in both analysis and development in whatever reporting software you prefer.


Do both! Use the Crystal Reports to satisfy the need for data almost instantly while a more lengthy solution is developed.

I am available for future support, amendments or additional development in Crystal Reports, Qlikview, SSRS, BO/WebI and even Excel/Access (which are comfortably able of meeting BI requirements in the right hands).

I provide offsite support starting at half a day.


Another example of the clear and concise ServiceNow reports available.

Another example of the clear and concise ServiceNow reports available.

Annual Fees Can Kiss My SAAS

So, the actual cost: FREE with only one day of reasonably priced offsite consultancy!

This is a one off fee and support can be hired as and when you need it.  This may seem an odd approach, but I’ve chosen this route for three reasons:

1.  One day (eight hours) should be enough support to get you up and running with the reports.

2.  It makes it very easy to see what a great deal it is, as it would probably cost 2-5 days of consultancy per report.

3.  It is usually easier to get sign-off for a consultant than to purchase a product.

While I would like to sell as many of these packs as possible, I only have so much bandwidth for support and further development and want to ensure I provide a top class service.

To this end, only a limited number of these packs will be released at any one time.

Act Now!

If you want to discuss this offering in more depth, such as the specific reports that make up this library (or anything else around ServiceNow reporting for that matter!), please email me, I love this stuff and am happy to chat about it:

PS: Check out my various ServiceNow blog posts which will be of great help to any organisation looking at professional reporting.

PPS: Of course, I am also available for any bespoke reporting available in a wide variety of software (namely: Crystal Reports, Qlikview, SSRS, BO/WebI, even Excel/Access).

Posted in Business Intelligence, ITIL, ServiceNow | Tagged , , | 1 Comment

4 Tips on Creating an Effective BI Team (Guest Post!)

Thanks to software vendors investing heavily in making their applications easier-to-use, accessible via the Web and more affordable, Business intelligence (BI) software is now a viable option for employees in sales, marketing, operations, and other departments to utilize.
But with the proliferation of these tools, business leaders will have to rethink how they address business intelligence governance, or the roles, responsibilities and guidelines it provides its users to ensure BI tools are utilized correctly and appropriately.
When it comes to setting up these new BI teams for success, leaders should consider these four steps.
1. Establish Structure, Guidance and Boundaries The first step is to establish a hierarchy of roles and responsibilities. For example, larger organizations with a strict chain-of-command would be well served putting together a “BI Bible,” or written guidelines that define who should initiative a project or report, and when. Smaller organizations can drive the direction of its BI users with regular meetings to discuss current and future analysis.
2. Appoint Internal and External Domain Experts While users in sales and marketing positions may contain more domain knowledge, they often lack the technical expertise to utilize BI tools to their full potential. For these reasons, it’s important to identify technical experts to assist users with selecting the right regression to run or most appropriate data to pull.
3. Allow Business Users to Manage Data Organizations should ensure that they are correctly balancing resources to accurately capture data. It’s hard for IT to know where to push for accuracy and where to be more lenient when it comes to data collection and cleansing standards. That’s why it’s important to bring business users to the IT-side of data collection to help make these decisions.
4. Use Successful BI Processes to Solve Bigger Problems Once you establish a successful BI process, apply these methods to find (and answer) new questions within your organization. Businesses that provide guidance, leadership and set-up BI analysts for success have the potential to create a valuable strategic group within the organization.
Has your organization dealt with these issues? How did you address them and create effective business intelligence teams? Please leave a comment with any additional tips or suggestions below! In addition, you can check out more on this topic over on the Software Advice BI Blog at: 4 Steps to Creating Effective BI Teams.
Posted in Business Intelligence | Tagged , | Leave a comment

Business Intelligence Book Review (part 1)

For a bit of variety, I am going to start posting the occasional blog based on the most common questions I receive from readers.  This first blog in the (potential) series is in response to the repeated question I get from this blog, while training or while consulting:

“Can you recommend a good book for….”

Sure, we can all get by and survive by looking up things on the internet as we struggle on specific issues, but to thoroughly learn a subject and become an expert there really is no substitute for a good book.

In particular, I get regular emails asking me which Crystal Reports books I recommend to complement my own.  It seems many people buy my book after struggling with formula writing, then start wondering what else there is to know and which books to read to find out more.

So in this blog I have decided to review some of the better books out there, Crystal Reports and others.

Please note: the cover illustrations link directly to if you want to update your own library.

CRCP Crystal Reports Certified Professional All-in-One by Annette Harper

This book is based on Crystal Reports 10.  We are numerous versions past that.  The CRCP is now called BOCP and exam guides are notoriously bad for anything other than studying for that specific exam.

However, this book is actually my favourite Crystal Reports book.

This book covers everything to an intermediate level and is a great reference for those things you don’t use often (like Mapping).  If you want a reference guide beyond the built-in help files, this book cannot be beaten.

It is for version 10, but the differences between releases are so slight and this book is so good that it is still the best option.

Ignore the terrible and misleading title and invest!

The Complete Reference Guides (Crystal Reports) By George Peck

The Complete Reference Guides exist for a number of IT related subjects and vary in quality.  George’s Crystal Reports books are some of the better ones.

Personally, overall, I prefer Annette’s book, but the Complete References really do cover all the functionality in great depth and are easy to use as a reference book after the initial read.

An added bonus is that they exist in numerous incarnations to match the Crystal Reports versions.

I can’t imagine anyone ever buying more than one of them, but if you want to learn the basic functionality and building blocks in detail, I thoroughly recommend getting the Complete Reference that matches your release of Crystal Reports.


Information Dashboard Design (The Effective Visual Communication of Data) by Stephen Few

This book focuses on the presentation and formatting side of reporting.  I personally would not have thought this subject could justify a full book, but Stephen Few proves my misconception wrong.

Firstly, don’t be put off by the low page count.  It is only 200 pages long, but these pages are bigger than the standard and are all glossy and full colour.  And while it says “Dashboard” in the title of the book, the methods and tips presented are of great help to all report formatting.

Mainly, the book focuses on what data summaries to include within a dashboard and the best methods of displaying data for maximum clarity.

Chapter 3 shows an illustrated list of the worst examples of report formatting.   There is nothing quite like seeing one of your own reports on that list to spur you on to make changes.

The problem with all the new reporting software is that it has so many bells and whistles it is an effort not to include them.  Many times, these serve more to detract from the presentation than compliment the information you are trying to display.

The other issue is that many reports which look beautiful at first glance are actually terrible at displaying data clearly.  This can be due to either the content or the actual formatting and Stephen careful deconstructs all the components to provide guidance on what to do and what not to do.

This book is not an essential to a Business Intelligence expert, but for those who want to ensure they are producing the most useful reports they can: this book is a blessing.

Xcelsius 2008 Dashboard Best Practices by Loren Abdulezer

When it comes to books for software, there is one core thing they should all provide: more information than the help files in the software itself.

This book does not really measure up in this regard.  This is partly due to Xcelsius having a pretty good tutorial built in which takes some beating, but also because it glosses over any of the Excel side of things.

As Xcelsius is so heavily reliant on the Excel data being of a certain format and style, as well as the general approach of charts being based on Excel it is of upmost importance that these aspects be covered in any book for Xcelsius. They are not.

‘Xcelsius 2008 Dashboard Best Practices’ is mainly filled with a lot of generic talk and a distinct lack of practical examples or actual “how to” explanations.

It has some value for those who use Xcelsius exclusively and is more a “things to consider” guide than a specific ‘how-to’.

All that said, for those who want to know all there is to know about Xcelsius, this book is still worth a read as it may fill in a few gaps and the author obviously knows their stuff.

Lastly…Crystal Reports Formulas Explained.

My book!  Obviously it is a bit unfair to review my own book, but it’s my blog and it seems stupid not to put at least put a link!

The cheapest way to buy this book is directly from the publisher, just follow the link attached to the illustration below and use this code: JB665Y to get the Crystal Reports Formulas Explained for the bargain price of £19.99!

Posted in CodeProject, Crystal Reports | 2 Comments