Skip to main content

Posts

QlikView interview questions and answers

What are the unique features of QlikView? (a)Data Association is maintained automatically. (b) The structure, data and calculations of a report are all held in the memory (RAM) of the server. (c) Data is compressed to 10% of its original size. (d) Visual relationship using colors. What is Incremental Load? The concept of loading only the new or changed records from the source into the QlikView document is called Incremental Load. How you connect QlikView to Database? QlikView can connect to data base using ODBC connection created for the database. What is Dashboard? A dashboard is a QlikView document which shows many matrices together and the values in the sheet objects can change dynamically upon selection of certain value in one of the Sheet Objects. Why do we need a Master Calendar? The Master calendar is required when we want to create some additional date values which are not already captured in the data that is being analyzed. For example finding the quarter ...

How to Choose the Right Data Visualization

Data visualizations are a vital component of a data analysis, as they have the capability of summarizing large amounts of data efficiently in a graphical format. There are many chart types available, each with its own strengths and use cases. One of the trickiest parts of the analysis process is choosing the right way to represent your data using one of these visualizations. In this article, we will approach the task of choosing a data visualization based on the type of task that you want to perform. Common roles for data visualization include: showing change over time showing a part-to-whole composition looking at how data is distributed comparing values between groups observing relationships between variables looking at geographical data The types of variables you are analyzing and the audience for the visualization can also affect which chart will work best within each role. Certain visualizations can also be used for multiple purposes depending on these factors....

How to Select a Data Visualization

WHAT IS A DATA VISUALIZATION? A data visualization  (often referred to as a  chart  or  graph ) is a graphical representation of data. Its goal is to convey information in a clear and succinct format. Data visualization is as much an art as it is a science. Selecting the right type of chart and adding features that will enhance the visualization while keeping it readable can be quite challenging. HOW TO SELECT A DATA VISUALIZATION There are many of types of charts that are easily available in most data visualization products. For example, Chartio provides over 15 types of charts - and each chart can have multiple variations. If you’re an advanced data modeler, you have hundreds, if not thousands, of options using data programming languages. So how do you select what chart to use? In general, you want to select the most straightforward visualization that will convey the point you want to make. When selecting a visualization, always think from the...