it_user6861 - PeerSpot reviewer
Consultant at a tech consulting company with 51-200 employees
Consultant
What QlikView Consultants can learn from the A-Team

Growing up in the 80′s and 90′s, one of my favorite TV shows was the A-Team. Over-the-top, cartoonish action with huge explosions, cars flipping over in mid-air topped off with a cool theme song. And all without anyone getting seriously hurt. This was the perfect TV show for young Barry!

But I’ve grown up since, and my tastes have matured (somewhat). However, there is one thing about the A-Team which I think is still relevant today: the actual A-Team and the well-balanced blend of skills of its members. No matter what an episode’s villain (drug king-pin/shady land developer/corrupt senator/whatever) threw at them, the combined qualities of the A-Team always ensured that they came out on top.

In today’s post, I am going to take a closer look at the skills and qualities of the A-Team, and will explain how they can be translated to the role of a QlikView Consultant. (Or, alternatively, how these roles can be used to staff the perfect QlikView Competency Center.)

-- B.A.: Technical genius and a pragmatic attitude --
Let’s start with the character every kid in my class wanted to be: Bosco “B.A.” Baracus. Forget about the kick-ass hand to hand combat skills and bad temper, as a QlikView Consultant, it’s B.A.’s technical genius that you’ll want to emulate.

Invariably, the A-Team will get pinned down somewhere (usually a barn) by the episode’s bad guys. What follows is a 5 minute montage in which B.A. welds together an entire armored vehicle out of scrap metal. In the next scene, we see the A-Team using this vehicle and some make-shift weapons to defeat the villains. (Who, for some reason, never see this coming, despite the A-Team using the exact same tactic in every single episode)

For a QlikView Consultant, the takeaway is that you should strive to continually improve your technical skills. Besides that, when the situation calls for it, you need to be able to keep your head down and do the work. Doing the work is a lot easier when you have the right tools, in this case not an acetylene torch, but a toolbox of scripts and solutions (either your own, or a third party one such as QlikView Components or QlikView Addict’s Codebox) that you can use to quickly build a solution in a modular, maintainable manner.

-- Murdock: Analytical skills and general knowledge --
Don’t let the goofball impression of H.M. “Howling Mad” Murdock fool you. While he may seem to not be all there, he is in fact a deep and analytical thinker.

Every episode sees Murdock obsessing over a new subject, historical character or object. This greatly annoys B.A., who refers to Murdock as a ‘crazy fool’. (in reality, even though B.A. will never admit it, they’re the best of friends) Despite his strange behavior, throughout the series, it becomes clear that Murdock is an analytical thinker, has a broad general knowledge and is very aware of current events and trends in the world. More than once do his brilliant, out-of-the-box ideas save the team.

While as a QlikView Consultant you’ll probably want to avoid the “raving madman” association, in my opinion, you do need to possess some of Murdock’s analytical and out-of-the-box thinking skills. Not only to apply them to your client’s projects, but also to periodically apply them to your own way of working. There are always ways in which you can improve.
Besides purely analytical skills, you also need to have a broad general knowledge of business processes and functions, as well as general market trends. Technical proficiency may be mandatory to get the job done, but real value is added when you understand the client’s business and market, and because of this, his/her problems and needs. There’s nothing wrong with ‘obsessing’ a little over a new field of knowledge if it helps you become more effective and efficient.

Combining the skills and knowledge of BA and Murdock leads to a T-shaped profile that I believe comes very close to the ideal profile for a QlikView Consultant; a deep, technical understanding of QlikView and peripheral methods, technologies and skills, combined with sound analytical skills, business knowledge and a broad general knowledge. As your experience grows, both the base and the roof of the T become broader and deeper, adding extra value for your clients and making you a more all-round professional.

Of course, we still have two more characters left, and as we’ll see, their skills and knowledge are just as important.

-- Face: Communication skills and persuasion --
Templeton “Faceman” Peck is the A-Team’s suave and smooth-talking con man and womanizer. He is always able to procure whatever supplies the team needs to get the job done.

The superiority of Face’s ability to convince others is demonstrated by the fact that he is able to break Murdock out of the same military hospital in almost every episode. Even after hundreds of successful escapes, each time using the exact same approach, he is still able to convince people that they should let Murdock leave with him. That’s an impressive display of persuasion, rivaled only by the Jedi mind trick.

Of course, womanizing and duping people aren’t really things you should be doing in a professional environment. However, as a QlikView Consultant, you will want to take at least a few pages from Face’s book. You can have best the best technical and analytical skills in the world, they’re useless if you cannot clearly communicate your ideas and are able to rally people around your cause.

Whether it be gathering requirements, getting access to various resources, designing interfaces, presenting your business case or just plain office politics (unfortunately a reality in many organizations), having excellent verbal and written communication skills and being able to present a convincing argument will greatly increase your effectiveness as a consultant.

-- Hannibal: Project management and leadership --
John “Hannibal” Smith is the leader of the A-Team. He is a master tactician, planning for every contingency and always ensuring that “the plan comes together”. His leadership ensures that the team is directed towards the common goal.

He also likes to wear very bad disguises, but nobody’s perfect.

One of the reasons for Hannibal’s continued success is the formulaic approach he takes to his projects. Every episode of the A-Team roughly plays out the same:

Bad guys harass innocent victims → Victims hire A-Team → B.A. says he won’t go on no plane → B.A. gets drugged and is put on the plane → A-Team confronts villains about their dastardly deeds and urges them to stop → Bad guys ignore the advise, take the A-Team by surprise and lock them up → A-Team builds weapons from scrap metal, escapes and beats up the bad guys in a fist fight → Villains go to jail → Credits roll.

You may find a lot of faults in Hannibal’s plan (I certainly see a few) but at least he is following some sort of methodology and he consistently delivers within the agreed-upon 60 minute timeframe. As a QlikView Consultant, you should also be following a consistent methodology to deliver your projects. I prefer to use Scrum, but any method will do, as long as it follows a predictable and consistent process that results in quality output delivered in a timely manner, with the end result meeting the client’s expectations.

Besides Hannibal’s project management skills, the most important takeaway for the QlikView Consultant is his leadership and focus on the end-result. Hannibal is really the one who brings the plan together, by keeping the team together. Without Hannibal, the individual qualities of the A-Team’s member would become unproductive; impulsive action (B.A.), paralysis by analysis (Murdock) and cheap talk (Face). Hannibal ensures that the team maintains just the proper blend of skills and qualities to get the job done, every time.

-- I love it when a plan comes together --
And that’s how I think the skills of the individual A-Team members relate to those of an ideal QlikView Consultant. Unfortunately, like the A-Team, consultants that actually meet this ideal combination of skills and traits are very hard to find. Often one specific ‘personality’ will be more present than others. As a consultant, once you’re aware of this, you can work on developing the other qualities. The Magic A-Team Quadrant (shown below) can be a very useful tool to assess yourself, or your team.

[To see the diagram go to: http://www.qlikfix.com/2013/03/26/what-qlikview-consultants-can-learn-from-the-a-team/]

Besides the ‘All-round QlikView Consultant’, the obvious hero of this story, I’ve added two profiles that I often encounter:

- The IT Consultant: has great technical skills, but has problems understanding the business context of what they are doing. Often delivers exactly what the client asked for, but not what they need. Applications tend not to be used after they leave.
- The Business Analyst/Management Consultant: knows exactly what the client needs, but has problems delivering a technically sound solution. Applications tend to fall over after they leave.

Where are you? And where are you going? Would be very interested to hear about your thoughts in the comments.

PS. Should you be based in the Netherlands and either feel that you already meet the ideal profile, or aspire to attain it; I’m hiring. Drop me a line and let’s chat. And no, unfortunately there is no company van :)

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user225189 - PeerSpot reviewer
BI Project Leader with 1,001-5,000 employees
Vendor
Data Discovery has allowed us to enrich the analysis of data and discover new ways to generate new KPIs.

What is most valuable?

Data Discovery has allowed us to enrich the analysis of data and discover new ways to generate new KPIs. It has also helped us to discover some critical points in our processes.

How has it helped my organization?

Using QlikView models, we've improved after-sales service in several of the products we offer, and we have managed to measure the profitability of our customers.

What needs improvement?

There’s room for improvement with the licensing, as well as memory consumption for certain objects and technical support.

For how long have I used the solution?

I have used this solution for three years.

What do I think about the scalability of the solution?

I have encountered issues with scalability. We have generated models with large amounts of data and have found that the processor and memory of our server has been declining. We do not have something to help us to size the equipment requirements when a big data model is developed in QlikView.

How are customer service and technical support?

Technical support is good, but needs to be better for our local service.

Which solution did I use previously and why did I switch?

We are evaluating Power BI suite and Datazen. We found that these products offer a good level of analysis, but the licensing offer was the deciding factor.

What about the implementation team?

A vendor team did the implementation.

What was our ROI?

We still do not see a significant ROI.

What other advice do I have?

Make an accurate sizing analysis of information, with a view to growth.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
QlikView
May 2024
Learn what your peers think about QlikView. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
771,212 professionals have used our research since 2012.
it_user156729 - PeerSpot reviewer
Business Intelligence Data Architect at a construction company with 1,001-5,000 employees
Vendor
The fact that QlikView provides its own QVD structure, removes all dependency on having a DBMS in place before implementing.

What is most valuable?

The ability to provide drill down functionality quickly and easily into large data sets. Anyone working with a large amount of data in Microsoft Excel and then waiting ages for it to subtotal all that information, will certainly appreciate the speed and efficiency with which QlikView handles data. Users can get a lot more done, and a lot more data can be analysed in a shorter period of time.

The fact that QlikView provides its own QVD structure, as well, removes all dependency on having a DBMS in place before implementing QlikView – so it is cost effective.

The fact that QlikView can literally plug in to so many different types of data sources, as well, is a definite benefit.

The facility to auto-reload at scheduled times is great too!

How has it helped my organization?

My company was recently bought out by a competitor, now forming one group. The organisations are on different versions of a particular ERP solution, and the need immediately arose, from a regional and management executive level, for a dashboard to measure the sales performance of the group as a whole. Using QlikView, we managed to pull information from two different servers - one running off a QVD file structure, the other using a Microsoft SQL Server - and provide a consolidated sales performance model. This allows our executives to be able to examine the performance of their companies from a central point.

What needs improvement?

Some improvement to the user interface (for the developers). It could certainly use a re-vamp. The existing tab structure can be confusing sometimes and the controls that you would expect to find on one particular tab are actually on another.

I'm referring to the properties of the various charts that you can create within Qlikview – this brings up a dialogue box with a number of different tabs along the top;

In my opinion, for example, the tabs “Visual Cues” and “Style” could be combined into one. “Caption” for another example could be renamed to “Title Bar config” or “Chart Config” or something like that. Some aspects of the “Layout” tab could be added to “Presentation”.

The dialogue box itself isn’t quite wide enough, so if you end up going all the way to the right you have to click on an arrow a couple of times to see the tabs all the way to the left again, and you can’t resize it either – Why???. The box itself should be wide enough to encompass the number of tabs in a single view. Either that, or have a maximise / minimise buttons on it to give the users the choice.

There are no doubt a few others I can point out if I give more though to it, just my feeling of the product is that it can be a little unwieldy, especially to people initially learning the program.

For how long have I used the solution?

The company has had the solution for the last five years, I have been involved for the last two.

What do I think about the stability of the solution?

No issues encountered, the solution is stable, and the users are happy with the solutions provided.

How are customer service and technical support?

Customer service and support from QlikView South Africa is first rate. They respond quickly, and are always friendly, professional and very efficient.

Which solution did I use previously and why did I switch?

QlikView was this company’s first foray into making use of an external business intelligence tool.

How was the initial setup?

The setup is fairly simple, but you do have to have a decent level of technical knowledge if you are going to set up a Qlikview Server yourself. Otherwise, I’d suggest the use of a consultant. The client software is very simple to set up.

What about the implementation team?

We implemented through a vendor. The advice I would have is to ensure that you attend all necessary QlikView courses (i.e. designer / developer), to get a very clear idea for yourself exactly how QlikView works. Sometimes sales consultants will over-sell you on the bells and whistles of a product, and when you actually want to make use of it in a particular way, you might not be able to. This has not been the case during our QlikView implementation, but I have experienced other implementations that have been like this.

So you do need to be very clear on:

  • What exactly do you want to get out of a business intelligence solution, what data do you want to manipulate and analyse, etc.
  • For your own sanity, be very clear on how QlikView works and that you will get the solutions out of it that you want.

What was our ROI?

One cannot really place a monetary value on the depth of very valuable information that QlikView can help you extract. My advice also would be to be very clear on the licensing model you want to go for. The QlikView licensing model is complicated, so be sure that whoever is selling QlikView to you explains it thoroughly.

What other advice do I have?

I would suggest having someone in-house doing the development of your models for you, be it dedicated to that role or in addition to another duty. Nobody understands your business quite like you or the people working for you, and that is always advantageous when building solutions for the business. Not to put down external consultants, but doing it this way can save you a bundle into the bargain.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Business Intelligence Consultant at a tech services company with 501-1,000 employees
Consultant
Dashboards are easy to build. It needs built-in monitoring of ETLs.

What is most valuable?

  • Ease of use for end user
  • Analytical reporting
  • Easy-to-build dashboards
  • Self-service reporting
  • Speedy deployment

How has it helped my organization?

The PoC for a new business area was not covered by the management reporting platform (controlling of IT processes).

  • Built-in monitoring of ETLs (there was no advanced tool for monitoring, planning and evaluation ETLs), I work with SAP BW (i.e. RSMO, RSPCM, ST13 transactions), of course there was an option to have additional expert tool but for a lot of additional money
  • Formatted reporting (PDF and export to Excel) - if necessary compile aggregate export to PDF document was not allowed to draw and do parameterized output compile or schedule it as a job with an appropriate distribution to the responsible user group, custom printing to PDF or Excel did not correspond to reality/original

What needs improvement?

  • Built-in monitoring of ETLs
  • Formatted reporting
  • Print to PDF
  • Export to Excel

For how long have I used the solution?

I have used it for half a year.

What was my experience with deployment of the solution?

I had integration issues with SAP BW.

How are customer service and technical support?

Technical support is very good.

Which solution did I use previously and why did I switch?

IBM Cognos was the original MIS platform. Within QV, there are better analytical reporting features.

What about the implementation team?

We implemented it in-house with some external support.

What was our ROI?

ROI is very long, > 5 year estimation.

What other advice do I have?

Assess the possibilities, advantages and disadvantages of the product as a whole with regard to the general characteristics of MIS systems and considering plans to use a management reporting platform across the enterprise.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Business Analyst ( Marketing BI Analytics) at a tech vendor with 10,001+ employees
Vendor
You can use bookmarks for filters, rather than entering inputs every single time.

Valuable Features

The server load, the QVD load, ease of variable declaration, and the different dynamic charts are very valuable to me.

Improvements to My Organization

Our complete BI transformation and production was done through QlikView instead of basic Excel reporting and analysis, reducing manual input, ease of automation and more reliability in numbers, thanks to fewer human input errors.

Room for Improvement

Currently we are building a pane to use filters and select options. For a dashboard, if they would add a "Column value" filter option like what you see in Amazon on the left hand side, that would be useful.

It could also have an autosave feature, which it direly lacks.

A direct feature to export views to PowerPoint, instead of external plugins, could be useful.

Sometimes large files are difficult to read and QlikView crashes midway. So you need to start from scratch. Instead, if it could support reading and processing large files with a lot of records (4 million +), that would be useful. This was one such issue we faced while doing a BI transformation as the data generated was huge.

Use of Solution

I have used QlikView for 3-4 years now.

Customer Service and Technical Support

We did not seek technical support. I simply researched answers in forums and through Google searches, blogs etc.

Implementation Team

With the help of IT teams, the QlikView online servers were set up (one for production, one for testing). So, implementation was done completely in-house.

ROI

ROI can't be measured directly, but the power of BI can be visualized through QlikView.

Pricing, Setup Cost and Licensing

I personally feel the QlikView server license is extremely expensive and might not be affordable for most organizations. However, all clients felt QlikView was so easy to operate, see results live and visualize in great charts, easily copied to PowerPoint. They were able to easily log in, select their regions, time period and view the results in a single shot instead of viewing multiple Excel reports and looking up, etc.
They used bookmarks for their filters and that made it even easier, rather than entering the inputs every single time.

Other Solutions Considered

We evaluated Spotfire, Tableau and finally chose QlikView to be deployed for all dashboards in the organizations.

Other Advice

QlikView can be a powerful tool in your organization if you are serious about a complete BI transformation and moving away from standard Excel reporting.

Given standard training and experience, migrating to QlikView is a very good choice.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Reporting Analyst at a insurance company with 1,001-5,000 employees
Real User
Non-technical stakeholders can quickly engage with and navigate through their data as business information.

Valuable Features

QlikView enables fast visualisation, analysis and navigation through data. It is very flexible, and offers easy-to-develop, quick-value tools for navigating and understanding data.

Improvements to My Organization

QlikView allows non-technical stakeholders to quickly engage with and navigate through their data as business information.

Room for Improvement

Data modelling is often a protracted process, with no toolset available apart from scripting. The consequent data models are not very portable at all.

Use of Solution

I have used this solution for five years, sometimes more intensively than others.

Stability Issues

One of QlikView's greatest strengths is its in-memory handling of large amounts of data. The flipside to this is some ongoing leakage, which makes it sensible to reboot once a week.

Customer Service and Technical Support

Qlik's support model for everyone except large enterprises is through consultant partners, so it depends on the quality of the partner. On the whole, they seem to be good.

Implementation Team

It was implemented via a consultant partner. They were technically very good, but one should ensure the consultant delivers comprehensive documentation. A solution is only as good as the ability to navigate through it and enhance it as the business changes.

Other Advice

Although normal advice would be to mandate that the implementation deliver to business-specific requirements, it is strongly recommended to understand the product's great capabilities, and to exploit the competitive advantages of the product. Otherwise, it becomes just another business intelligence tool blindly shoehorned into a business that doesn't gain the best value and ROI from it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Technical Associate at a real estate/law firm with 10,001+ employees
Real User
The dynamic interactive dashboard is the most valuable feature of the product to me.

What is most valuable?

The dynamic interactive dashboard is the most valuable feature of the product to me.

How has it helped my organization?

Lots of scripting used to be required to build high quality dashboards.

What needs improvement?

This cannot be considered a self-service product. It requires IT support.

For how long have I used the solution?

I have used QlikView for one year.

What do I think about the stability of the solution?

This is quite a stable product, but very huge data loads must be complemented by good hardware. Otherwise, there could be performance issues.

How are customer service and technical support?

Technical support is OK.

Which solution did I use previously and why did I switch?

The only reason we chose this product is its dynamic interactive dashboard. It works well on iPad. We liked the product, as compared to MS BI.

How was the initial setup?

Initial setup is quite straightforward, but it requires good hardware for high data loads.

What about the implementation team?

An in-house team and a vendor team collaborated on the implementation.

What's my experience with pricing, setup cost, and licensing?

It is quite expensive. There are two types of licenses: Named User licenses and Doc CAL licenses.

What other advice do I have?

You need to have good scripting skills.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user254223 - PeerSpot reviewer
Project Manager - Business Intelligence at www.datademy.es
Consultant
We use QlikView to create department dashboards with useful analysis.

What is most valuable?

  • Flexibility
  • Agile development
  • Intuitive
  • Very good performance
  • Excellent user groups

How has it helped my organization?

We use QlikView to create department dashboards. We can create powerful dashboards with useful analysis in a few days.

What needs improvement?

I think its visualization has room for improvement, and I know Qlik Sense has better visualization.

For how long have I used the solution?

I have used it for two years.

What do I think about the stability of the solution?

It's difficult to manage big and complex data models, but the reason is that there isn't a semantic layer in Qlikview, but not having a semantic layer is a good point in other aspects, like agile development.

How are customer service and technical support?

Excellent, very good and active community.

Which solution did I use previously and why did I switch?

I have used Business Objects and Microstrategy. QlikView is a different tool. It has advantages and disadvantages compared to Business Objects or Microstrategy. The main advantages are flexibility and agile development.

How was the initial setup?

It was straightforward.

What was our ROI?

We haven't calculated the ROI yet.

What's my experience with pricing, setup cost, and licensing?

I think the pricing is really competitive.

What other advice do I have?

QlikView is an excellent reporting and data discovery tool. I have used it on a departmental scale, but not on a corporate level so I don't know how it will behave on that level.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free QlikView Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2024
Product Categories
Reporting Embedded BI
Buyer's Guide
Download our free QlikView Report and get advice and tips from experienced pros sharing their opinions.