Study : Using Qlik Sense for Data Scientist to understand the data with Descriptive Statistics

[lazurens2]

The power of Aggregation: To demonstrate data relative to one or more category in the data. (Useful tool of focus) Counter Functions :

• RecNo, RecIter Counter Aggregation :
• Count, MissingCount, NullCount, NumericCount, TextCount

Statistical Aggregations :

• Min, Max, Sum, Avg, Mode, Median, Std, Skew, Kurtosis, Fractile, Correlations

Statistical test functions :

• Chi2, T-test, Z-test

Financial Aggregation :

• IRR, NPV, XIRR, XNPV

[lazurens2]

• Data Source : Public Data Repository There are many dataset that could be used to demonstrate the use of Qlik Sense for Data Analysis as a step that comes before any Predictive Modeling.
• Data Topic : (Banking) ,

Title	Area
Bank Marketing	Banking
Daily Demand Forecasting Orders	Retail
Absenteeism at work	Human Resources
Insurance Company Benchmark	Insurance

1. Create a QS applications for each Dataset
2. Create Dashboards with KPis and Visualizations that demonstrate the use of Stats Functions, and how to derive insights that help us in our predictive modeling.
3. Record a short video for each appliation, to demonstrate how it works, and to show the usefulness of this staging step. Doc