The Six main Pre-requisites to become a Quality QlikView Developer:
- Basic knowledge of SQL
- Data Understanding
- Understanding the Business
- Knowledge of data model
- Layout Designing
- Practice & Hard work
No prior programming experience is needed other than basic understanding of SQL, and VB Script, if you require macros or advanced automation. Good SQL Knowledge will get you through the Load Script and Joins. Most companies store their data in databases and you need to understand SQL querying/programming to extract the data.
Ability to read & write SQL queries is a good skill for any QlikView Developer. Good Excel Skills will also help with expression building for charts. The Excel Skills will help to work with lookup functions, String function and Pivot tables in QlikView.
2. Knowledge of Data Model
Data model is the heart of the QlikView Application. Having good understanding of Data Model building techniques is big plus to become a Quality QlikView Developer. Once you have a better idea of how you plan to use the data, and what information is important, it will help you in designing your Data Model.
We should know about Table Structure viz., what is the fact table and what is the dimension table, and also whether we are aware of the linking between the tables and fields.
3. Data Understanding
Information can be visualized in a number of ways, each of which can provide a specific insight. When you start to work with your data, it is important to identify and understand the story you are trying to tell, and the relationship you are looking to show.
Knowing this information will help you select the proper visualization to best deliver your message. QlikView Developer should also be good in Data Visualization.
When analysing data, search for patterns or interesting insights that can be a good starting point for finding your story. Your data is only as good as your ability to understand and communicate it effectively, which is the core focus of the developer.
4. Understanding the Business
For a QlikView dashboard to be of maximum use to a business, it should present insights from every area of that business. This requires the QlikView Developer to have a real understanding of the business and the processes that make it happen. Not only solving problems and designing functionality, it is very important to know the data you are going to deal with.
It is very easy to start development just thinking about the tables, columns and rows, however, you will soon hit the brick wall, just after finishing the scripting. Understanding business data rules is a critical aspect to calculate KPI’s and measures. Last thing you want is a good looking application with jaw-dropping functionality, but not answering any business questions.
As a Developer, we all get excited solving problems and designing functionality, but it is very important to understand the business data for successful QlikView application.
Please be aware about great aesthetics that are required to design effective and efficient dashboards, and set analysis. They really simplify the dashboards. If we understand the business requirements, then we can easily create a very attractive dashboard.
6. Practice and Hard work
The only way to attain success is through practice and hard work.
For more useful resources: please click





Comments
Post a Comment