Introduction Data Analytics Types of Analytics How Data Analyst and Business Analyst Different ? Scope of Data Analytics and Business Analytics Excel Introduction Absolute Reference and Relative Reference
Introduction Data Analytics Types of Analytics How Data Analyst and Business Analyst Different ? Scope of Data Analytics and Business Analytics Excel Introduction Absolute Reference and Relative Reference
What is Statistics ? •Types of Statistics •Descriptive Statistics •Inferential Statistics •Central Tendency •Measure of Central Tendency and Spread Outliars Skewness
One sample t-test Mathematical calculation in detail Two sample t-test Mathematical calculation in detail Paired t-test Mathematical calculation in detail Chi -saquare test Mathematical calculation in detail
•What is Database ? •Types of Databases •What is Structured Query Language (SQL) ? •Database Structure •Creating our First DataBase •Simple Query •SQL Datatypes •Categories of SQL Commands •Database related Queries •Primary Key and Foreign Key •Constraints in SQL
Where clause in SQL (Logical , Arithmetic, comparision) Limit clause in SQL Aggregations in SQL Groupby clause in SQL Order by clause in SQL Tabel Related Queries
TCL Command in SQL Normalization in SQL Dimensional Modelling Key Components of Dimensional Modeling Star Schema Snowflex Schema Introduction of Power BI