BUSINESS STATISTICS

Introduction to Statistical Analysis

Counting, Probability, and Probability Distributions | Sampling Distributions | Estimation and Hypothesis Testing | Scatter Diagram | Anova and Chisquare | Imputation Techniques | Data Cleaning | Correlation and Regression.

 

Introduction to Data Analytics

Data Analytics Overview | Importance of Data Analytics | Types of Data Analytics | Descriptive Analytics | Diagnostic Analytics | Predictive Analytics | Prescriptive Analytics | Benefits of Data Analytics | Data Visualization for Decision Making | Data Types, Measure Of central tendency, Measures of Dispersion | Graphical Techniques, Skewness & Kurtosis, Box Plot | Descriptive Stats | Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval

 

Python

·       Introduction to python

·       Install python & environment setup

·       Python data types

·       Python Variables

·       Python Functions

·       Control statements

·       Lists, tuple, & ranges

·       Python dictionaries

·       Python Sets

·       Python Built-in-functions

·       Python object oriented

·       Exceptions

·       Operators

·       String operators in python

 

Excel: Basics to Advanced

Excel tutorial | Text to Columns | Concatenate | The Concatenate Function | The Right Function with Concatenation | Absolute Cell References | Data Validation | Time and Date Calculations | Conditional Formatting | Exploring Styles and Clearing Formatting | Using Conditional Formatting to Hide Cells | Using the IF Function | Changing the “Value if false” Condition to Text | Pivot Tables | Creating a Pivot Table | Specifying PivotTable Data | Changing a PivotTables Calculation | Filtering and Sorting a PivotTable | Creating a PivotChart | Grouping Items | Updating a PivotTable | Formatting a PivotTable | Using Slicers | Charts | Creating a Simple Chart | Charting Non-Adjacent Cells | Creating a Chart Using the Chart Wizard | Modifying Charts | Moving an Embedded Chart | Sizing an Embedded Chart | Changing the Chart Type Changing the Way Data is Displayed | Moving the Legend | Formatting Charts | Adding Chart Items | Formatting All Text | Formatting and Aligning Numbers Formatting the Plot Area | Formatting Data Markers | Pie Charts | Creating a Pie Chart | Moving the Pie Chart to its Own Sheet | Adding Data Labels | Exploding a Slice of a Pie Chart | Data Analysis − Overview | Types of Data Analysis | Data Analysis Process | Working with Range Names | Copying Name using Formula Autocomplete | Range Name Syntax Rules | Creating Range Names | Creating Names for Constants | Managing Names | Scope of a Name | Editing Names | Applying Names | Using Names in a Formula | Viewing Names in a Workbook | Copying Formulas with Names | Difference between Tables and Ranges | Create Table | Table Name | Managing Names in a Table | Table Headers replacing Column Letters | Propagation of a Formula in a Table | Resize Table | Remove Duplicates Convert to Range | Table Style Options | Table Styles Cleaning Data with Text Functions | Removing Unwanted Characters from Text | Extracting Data Values from Text | Formatting Data with Text Functions Date Formats | Conditional Formatting | Sorting | Filtering | Lookup Functions | Pivoting | effective | learning of VBA and macros

 

DATA SCIENCE USING PYTHON

·       Numpy:

·       Introduction to Numpy

·       Creating arrays

·       Indexing Arrays

·       Array Transposition

·       Universal Array Function

·       Array Processing Array Input and Output

·       Matplotlib: Data Visualization

·       Python for Data Visualization

·       Welcome to the Data Visualization Section

·       Matplotlib

·       Pandas

 

SQL Syllabus

·       Introduction to MySQL. Installation of MySQL Server. Download Sample Database. Load Sample Database to work.

·       Writing Basic SQL

·       Restricting and Sorting Data

·       Working on DDL Commands

·       Working on DML statements

·       Working on multiple tables and Retrieve records from multiple tables

·       Working on subqueries

·       Use of built-in function in SQL

 

Power BI

·       What is Power BI Desktop and How to download and install it in Windows 10?

·       Walkthrough of Power BI software

·       Importing csv data inside power BI

·       Importing Excel Data inside Power BI

·       Creating First Visualization (a bar chart) in Power BI and Formatting It

·       Creating first Slicer in Power BI and formatting it

·       Creating Date Slicer / Filter in Power BI and Formatting It

·       Create Numeric Slicer / Filter in Power BI and Formatting It

·       Changing Slicer Look and Feel with Selection Type

·       How to create Power BI Stacked bar Chart

·       How to Create Power BI Pie Chart

·       How to create Power BI Donut Chart

·       How to Create Stack Area Chart

·       How to Create and Customize Line and Stacked Bar Chart in Power BI

·       How to Create and Customize Power Bi Cluster Bar and Line Chart

·       How to connect power bi with Wikipedia website and import data

·       How to create and format funnel chart in power bi

·       How to Create and Format Power BI Scatter Chart

·       How include or exclude a part of visualization in power bi

·       How to Create and Conditionally Format Power BI Matrix or Pivot Table

·       How to Create and Conditionally Format Power BI Table

·       Power BI Relative Date Filter Tutorial

·       Power BI Advance Date Filtering Tutorial with Example

·       Power BI DAX Function Sumx Tutorial | SUM vs SUMX

·       Power BI DAX Function Average Tutorial | Average vs AverageX

·       Power BI Dax Function MinX Tutorial | Min vs MinX | Finding Minimum of Calculation

·       Power BI DAX Function MAXX Tutorial | MAX vs MAXX | Finding Maximum Value of Calculation

·       Power BI Median and Medianx Function with Example

·       Power BI – Conditional sum of two or more than two categories

·       Power BI – Counting Distinct Values

·       Power BI – How to count table rows | Row Count Function

·       Power BI – Counting Missing Values

·       Power BI – How to Create Dynamic Calendar

·       How to Calculate MTD (Month to Date) Rolling Total Values

·       How to Calculate QTD (Quarter to Date) Rolling Total Values

·       How to Calculate YTD (Year to Date) Rolling Sum

·       Sorting Power BI Visualization

·       Sorting Power BI Visualization on another Column

·       Power BI TopN Filter to Display the Top or Bottom Values in the Chart

·       Power BI Hidden Filters and How to View them

·       How to remove duplicate values using power query

·       How to merge queries in power query

·       How to append queries – power query

·       Converting Text to Lowercase Uppercase Trim Suffix and Prefix

·       Extracting Text from Long Text or String

·       Unpivot data in power query

·       Sorting Data in power query

·       Replacing Values in power query

·       Split Column values in power query

·       Grouping data in power query

·       Final Project

·       Topic: Dashboard Creation (Data set we work on totally depends on HR Data set)

·       Doubt clearing session