In this course, you will embark on a hands-on learning journey that covers a wide range of topics, from the basics of web development to advanced Angular concepts. You'll start with a solid foundation in web development principles, including HTML, CSS, and JavaScript, and gradually progress to more complex topics.

• Module 1: Business Statistics and Data Analytics Foundations

  

  
  Introduction to Statistical Analysis

  • Basics of Counting, Probability, and Probability Distributions
  • Sampling Distributions, Estimation, and Hypothesis Testing
  • Scatter Diagram, ANOVA, and Chi-Square Tests
  • Correlation and Regression Analysis

  
  Data Cleaning and Preparation

  • Data Cleaning Techniques, Imputation Methods
  • Identifying Outliers, Handling Missing Values

  
  Introduction to Data Analytics

  • Data Analytics Overview: Types and Importance
  • Descriptive, Diagnostic, Predictive, and Prescriptive Analytics
  • Central Tendency and Dispersion Measures
  • Graphical Techniques, Skewness, Kurtosis, Box Plot
  • Sampling Variation, Central Limit Theorem, Confidence Interval

  

• Module 2: Excel for Data Analytics

  

  
  Excel Basics to Advanced Techniques

  • Text to Columns, Data Validation, Conditional Formatting
  • Functions: IF, Concatenate, Absolute/Relative References
  • Date and Time Calculations, Text Functions for Cleaning Data
  • Pivot Tables and PivotCharts for Data Summarization
  • Advanced Charting Techniques: Pie, Line, Scatter, Waterfall, etc.

  
  Data Analysis and Management in Excel

  • Range Names, Tables vs. Ranges
  • Filtering, Sorting, Lookup Functions
  • Remove Duplicates, Table Formatting and Style Options

  

• Module 3: SQL for Data Analytics

  

  
  SQL Fundamentals

  • Basics of SQL Queries: SELECT, WHERE, ORDER BY
  • Single-Row and Conversion Functions, Conditional Expressions

  
  Data Aggregation and Manipulation

  • Group Functions, Joins, Sub-Queries, and SET Operators
  • Data Manipulation (INSERT, UPDATE, DELETE) and Schema Management
  • Using Views, Indexes, and Data Dictionary Views for Management

  
  Advanced SQL Techniques

  • Working with Large Data Sets, Handling Time Zones
  • Regular Expressions, SQL for Data Cleaning and Analysis

  

• Module 4: Data Visualization with Tableau

  

  
  Connecting and Preparing Data in Tableau

  • Connect to Various Data Sources (Excel, SQL Server, Google Sheets)
  • Hierarchies, Data Blending, and Data Joining

  
  Basic to Advanced Charting and Reporting

  • Creating Standard Charts: Bar, Line, Heatmaps, Tree Maps, Scatter Plots
  • Advanced Visuals: Waterfall, Bullet Graphs, Gantt, Bump, Lollipop Charts
  • Working with Calculated Fields, Ranking, Running Totals

  
  Dashboard and Story Creation

  • Building Dashboards and Interactive Filters
  • Creating Stories for Data Presentation
  • Using Tableau Server for Publishing and Sharing

  

• Module 5: Power BI for Business Intelligence

  

  
  Power BI Essentials

  • Power BI Overview, Connecting to Data Sources, Data Preparation
  • Using Power BI Desktop and Power BI Service

  
  Creating and Formatting Visualizations

  • Basic Charts, Custom Visuals, Slicers, and Filters
  • Dashboards and Tile Management, Real-time Data Analysis

  
  Publishing and Collaboration

  • Sharing Reports, Embedding Reports in SharePoint, Power BI Mobile
  • Workspace and App Management, Data Sharing, and Permissions

  
  DAX for Data Modeling

  • Introduction to DAX Functions: Date, Filter, Logical, and Text Functions
  • Advanced DAX Calculations, Parent-Child Functions, and Data Relations

  

• Module 6: Python for Data Analytics

  

  
  Python Basics for Data Analysis

  • Python Syntax: Variables, Data Types, Operators
  • String Manipulation, Lists, Dictionaries, Tuples
  • Input/Output and Simple Formatting, Deep vs. Shallow Copy

  
  Data Processing in Python

  • Importing Libraries (Pandas, NumPy), Data Frames, Data Cleaning
  • Exploratory Data Analysis (EDA), Statistical Functions
  • Data Visualization Basics: Matplotlib, Seaborn for Basic Plots