Data Visualization using Qlik Sense

Introduction

• Presenter: Vishnu
• Topic: Data visualization using Qlik Sense
• Purpose: By the end of the tutorial, subscribers will be able to use Qlik Sense professionally, regardless of technical background.
• Company: Qlik Tech - BI services provider since 1993 serving 1700+ customers globally.

Today's Discussion

• What is data visualization?
• Importance of data visualization in business.
• Why BI tools are necessary for data visualization?
• End users of BI applications.
• Top BI tools in the market.

What is Data Visualization?

• Definition: Process of converting data into information (charts, diagrams, pictures) to aid decision-making.
• Purpose: Transform raw data into understandable insights that positively impact business decisions.

Steps of Data Visualization

1. Extraction
   • Extract data from various data sources (big data, cloud, SQL, flat file systems, Excel).
   • Store extracted data locally to ensure availability.
2. Modeling
   • Clean and format data to prepare it for visualization.
   • Handle null values, remove unnecessary columns/rows, create inter-table links, and generate calendars for time series operations.
3. Visualization
   • Create charts and diagrams from the modeled data.
   • Dimensions: Columns from the model layer.
   • Metrics: Operations performed on dimensions (count, sum, average, standard deviation).

Importance of Data Visualization

• Easier Insight Derivation: Visualizing data helps in quickly understanding information and making decisions.
• Example:
  • Without Visualization: Analyzing data in a tabular form (e.g., sales transactions) using manual calculations.
  • With Visualization: Using Qlik Sense dashboard to create visualized metrics such as sales quantity, sales value, current order status, time series trends, and country-wise sales.

Benefits of Data Visualization

• Quick understanding: Provides immediate insights into data.
• Decision-making: Allows businesses to focus on actions rather than spending time analyzing raw data.
• Interactive Filters: Users can filter and view data dynamically (e.g., viewing only US sales in the dashboard).
• Efficiency: Pre-configured metrics and dashboards update automatically with new data, saving time and effort.

Conclusion

• Data visualization is critical for businesses to make informed decisions swiftly.
• BI tools like Qlik Sense make data visualization accessible, even for non-technical users.

Stay tuned for more in-depth tutorials on using Qlik Sense for professional data visualization.