I am writing a series of articles related to Qlik Sense and visualizations. Here is my first article creating an app and loading the data. First, we know about data analytics and Qlik Sense.
Data Analytics
Data Analytics refers to the set of quantitative and qualitative approaches to deriving valuable insights from data. It involves many processes that include extracting data and categorizing it to derive various patterns, relations, connections, and other such valuable insights from it. Today, almost every organization has morphed itself into a data-driven organization, and this means that they are deploying an approach to collect more data that is related to their customers, markets, and business processes. This data is then categorized, stored, and analyzed to make sense out of it and derive valuable insights from it.
Qlik Sense
Qlik Sense is a complete data analytics platform that sets the benchmark for a new generation of analytics. With its one-of-a-kind associative analytics engine, sophisticated AI, and high-performance cloud platform, you can empower everyone in your organization to make better decisions daily, creating a truly data-driven enterprise.
If we want to build data analytics or learn about qlik sense we can signup here for free and can build apps with the 30 days free trial.
After creating an account in qlik, now login here into the qlik cloud and create a new app by clicking on AddNew and followed by a new analytics app. Now give a name and create an app.
Qlik sense is an ETL Tool that means we can Extract, Transform, and load the data in the same space.
Now open the app to add the data. We can add the data directly by just drag and drop the data file or through the script editor.
The data manager loads the available data and gives recommendations for associations.
Now apply all recommended associations and then load the data. when associations are applied then it looks like this.
Once loaded the data, now go to the sheet section and click on the edit sheet. Here we can do visualizations by just drag & drop.
Before creating the first visualization, we need to know about dimensions and measures.
Dimension: Dimensions determine how the data in visualization is grouped. For example, total sales per country or number of products per supplier. You typically find a dimension as the slices in a pie chart or on the x-axis of a bar chart with vertical bars. We can simply assume dimension is a column of a table that contains qualitative data.
Measures: Measures are calculations used in visualizations, typically represented on the y-axis of a bar chart or a column in a table. Measures are created from an expression composed of aggregation functions, such as Sum or Max, combined with one or several fields. We can simply assume that the measure is a column of a table that contains numerical data.
Now drag & drop Bar chart and give the category name as a dimension and the sum of sales as a measure.
That’s it, we have created our first app and visualization in the qlik sense.
If you want to refer to qlik sense documentation then you can go here
If you love my work feel free to give me a clap. It encourages me to write more articles.
