Data Analysis Concepts, Tools and Techniques using E-View, R

Course Outline
Course Title: Data Analysis Concepts, Tools & Techniques using E-View, R,
E-Views is a modern econometric, statistics, and forecasting package that offers powerful analytical tools within a flexible, easy-to-use interface. Using E-Views, you can quickly and efficiently manage your data, perform econometric and statistical analysis, generate forecasts or model simulations, and produce high-quality graphs and tables for publication or inclusion in other applications. E-Views is designed with your workflow in mind. The innovative user interface simplifies every step of the process, from data input and import to data visualization, statistical analysis, estimation, forecasting and model solving, and publication quality presentation output.
Statistical Data Management and Analysis using R course provides an insight into quantitative data management and analysis (exploring, summarizing, statistical analyzing, visualizing). R is an open source software with many features for quantitative data management and analysis.
This hands-on course will endeavor to practically take the participants through the two software’s E-view and R.
E-Views-Econometrics
Types of Data
What are the different sites for data citations
How to import data in E-views
checking the stationarity of the data
converting time series data into panel data
Estimating and Interpreting OLS
Assumptions of Classical Linear Regression Model (CLRM)
Detection and Removal of Autocorrelation
Detection and Removal of Heteroskedasticity
Normality using Jorque Bera test
Johansen cointegration test
Estimation and interpretation of ARDL model
Data Science with R
Introduction to data Science with R
✓ What is analytics & Data Science?
✓ Common Terms in Analytics
✓ Analytics vs. Data warehousing, OLAP, MIS Reporting
✓ Relevance in industry and need of the hour
✓ Types of problems and business objectives in various industries
✓ How leading companies are harnessing the power of analytics?
✓ Critical success drivers
✓ Overview of analytics tools & their popularity
✓ Analytics Methodology & problem-solving framework
✓ List of steps in Analytics projects
✓ Identify the most appropriate solution design for the given problem statement
✓ Project plan for Analytics project & key milestones based on effort estimates
✓ Build Resource plan for analytics project
✓ Why R for data science?
Data Importation & Exportation.
✓ Introduction R/R-Studio – GUI
✓ Concept of Packages – Useful Packages (Base & Other packages)
✓ Data Structure & Data Types (Vectors, Matrices, factors, Data frames, and Lists)
✓ Importing Data from various sources (txt, dlm, excel, sas7bdata, db, etc.)
✓ Database Input (Connecting to database)
✓ Exporting Data to various formats)
✓ Viewing Data (Viewing partial data and full data)
✓ Variable & Value Labels – Date Values
Data Manipulation.
✓ Data Manipulation steps
✓ Creating New Variables (calculations & Binning)
✓ Dummy variable creation
✓ Applying transformations
✓ Handling duplicates
✓ Handling missing’s
✓ Sorting and Filtering
✓ Sub-setting (Rows/Columns)
✓ Appending (Row appending/column appending)
✓ Merging/Joining (Left, right, inner, full, outer etc)
✓ Data type conversions
✓ Renaming
✓ Formatting
✓ Reshaping data
✓ Sampling
✓ Data manipulation tools
✓ Loops (Conditional, iterative loops, apply functions)
✓ Arrays Data Analysis- Visualization
✓ Introduction exploratory data analysis
✓ Descriptive statistics, Frequency Tables and summarization
✓ Univariate Analysis (Distribution of data & Graphical Analysis)
✓ Bivariate Analysis (Cross Tabs, Distributions & Relationships, Graphical Analysis)
✓ Creating Graphs- Bar/pie/line chart/histogram/boxplot/scatter/density etc)
✓ R Packages for Exploratory Data Analysis (dplyr, plyr, gmodes, car, vcd, Hmisc, psych, doby etc)
✓ R Packages for Graphical Analysis (base, ggplot, lattice,etc)
Introduction to Predictive Modeling
✓ Concept of model in analytics and how it is used?
✓ Common terminology used in analytics & modeling process
✓ Popular modeling algorithms
✓ Types of Business problems – Mapping of Techniques Linear Regression
✓ Interpretation of results – Implementation on new data
✓ Introduction – Applications
✓ Assumptions of Linear Regression
✓ Building Linear Regression Model
✓ Understanding standard metrics (Variable significance, R-square/Adjusted R-square, Global hypothesis ,etc)
✓ Assess the overall effectiveness of the model
✓ Validation of Models (Re running Vs. Scoring)
✓ Standard Business Outputs (Decile Analysis, Error distribution (histogram), Model equation, drivers etc.)
✓ Interpretation of Results – Business Validation – Implementation on new data Logistics Regression.
✓Introduction – Applications
✓Linear Regression Vs. Logistic Regression Vs. Generalized Linear Models
✓Building Logistic Regression Model (Binary Logistic Model)
✓Understanding standard model metrics (Concordance, Variable significance, Hosmer Lemeshov Test, Gini, KS, Misclassification, ROC Curve etc)
✓Validation of Logistic Regression Models (Re running Vs. Scoring)
✓Standard Business Outputs (Decile Analysis, ROC Curve, Probability Cut-offs, Lift charts, Model equation, Drivers or variable importance, etc)
✓Interpretation of Results – Business Validation – Implementation on new data
Time series Forecasting
✓ Introduction – Applications
✓ Time Series Components (Trend, Seasonality, Cyclicity and Level) and Decomposition
✓ Classification of Techniques (Pattern based – Pattern less)
Way forward After the Training
Participants will develop a work plan through the help of facilitators that stipulates application of skills acquired in improving their organizations. ASPM will continuously monitor implementation progress after the training.
Training Evaluation:
Participants will undertake a simple assessment before the training to gauge knowledge and skills and another assessment after the training in-order to monitor knowledge gained through the training