Product Design

BI(Business Intelligence) is a set of processes, architectures, and technologies that convert raw data into meaningful information that drives profitable business actions.It is a suite of software and services to transform data into actionable intelligence and knowledge.

BI has a direct impact on organization's strategic, tactical and operational business decisions. BI supports fact-based decision making using historical data rather than assumptions and gut feeling.

BI tools perform data analysis and create reports, summaries, dashboards, maps, graphs, and charts to provide users with detailed intelligence about the nature of the business.

Image result for why business intelligence Business intelligence can help companies make better decisions by showing present and historical data within their business context. Analysts can leverage BI to provide performance and competitor benchmarks to make the organization run smoother and more efficiently.

Syllabus

• What is Qlik? Why Qlik?
• Unique Features compared to Traditional BI Tools
• Complete Data warehousing Basics Qlik Products
Day 2: PROOF OF CONCEPTS
• Loading multiple data sources
• Relational Databases
• Data Source Files like Excel, CSV, and Txt etc.
• Creating folder structure
Day 3: STYLING UP
• Properties of sheet objects, document, list boxes
• Objects in Qlik
• Front end Visual design
• Setting background frames
• Font, Colors, Image setting
Day 4: DATA MODELING
• Introduction to Scripting
• Function in Qlik
• Creating calculated fields in script
• Joins, keep, concatenate
• Cleansing dirty data
• Cross tab
• Hierarchy
• Generic function
Day 5: CREATING DASHBOARD
• Visualization for KPI's (Key Performance Indicator)
• Charts in Qlik