Session 1 : Introduction to Probability

1. Understanding the definition of probability
2. When to add probabilities and when to multiply probabilities
3. Data, Distribution and Probability Density Function: Practical uses
4. The Central Limit Theorem and what it means
5. Moments
6. Covariance and Co-relation : Foundation and Interpretation

Session 2 : Conditional Probability & Bayesian Analysis

1. Intuitive understanding of Conditional Probability
2. Understanding Naive Bayes Probability theorem
3. Application of Naive Bayes in Drug testing
4. Hands-on Application of Bayesian analysis in spam filtering.

Session : 1 Fundamentals

1. Normalization & why it's done
2. Standard Score & and how it helps
3. Deviation Scores
4. Understanding the Deviation Score with an Example

Session : 2 Hypothesis Testing

1. What is a Hypothesis?
2. What are Null and Alternative hypothesis - Examples
3. Calculating the P-Value & Significance Level Alpha
4. T-Tests(one sample, two samples)
5. The Chi-Square Test of Independence
6. Test of Independence and Tests of Homogeneity
7. Conclusion , Exercises and Solutions

DATAtab is a WebApp for statistical analysis which is quickly capturing the market with its simple yet powerful statistical modules. Tens of thousands of people across the world are using DATAtab for their analytical needs. We will learn how to use datatab in this section. The best part about this workshop is that each one will get a one month subscription of DATAtab to practice and understand.

Session 1 : Introduction to DATAtab

1. Importing your data
2. Data pre-processing
3. Defining the NULL, NAN, and NV
4. Color Setting
5. Defining the Variables
6. Data Labelling and Encoding in DATAtab

Session 2 : Basic visualization using DATAtab

1. Box plot
2. Bar chart
3. Histogram
4. Scatter plot
5. Line chart
6. Bland-Altman plot
7. Pareto chart

Session 2 : Advanced computation

1. Correlation
2. Hypothesis Testing
3. t-Test
4. Mann-Whitney U-Test
5. Chi-Square Test

PowerBI is the new buzzword in the market. Microsoft's powerful business intelligence tool has an edge when it comes to big data analytics. We will get a peek into its powerful modules and how it can become the go-to tool for generating insights from multidimensional data.

Session 1 : Introduction to Power BI

1. What is Power BI
2. Installing Power BI Desktop, Settling up Project and Connecting to source file.
3. Power BI Query Editor Interface overview
4. Course Outline.

Session 2 : Introduction to Power BI

1. Welcome to Power BI Desktop
2. Attached Files
3. Understanding Power BI Desktop
4. Explore Data Model Interface
5. Creating Project File , Settings and Query Editor

Session 3 : Introduction to Power BI

1. Power BI Query Editor
2. Connecting Power BI Desktop, Source File and Query Editor
3. Working with Rows
4. Filters
5. Remove Blanks and Empty Rows
6. Appending Files
7. Working with Columns
8. Replace values and error
9. Format and Error Handling
10. Close, Apply and Close&Apply
11. Working with Queries (Error Queries)
12. Pivot and Unpivot the data
13. Column Split