Overview
Course Description
The Tek-Z Data Analytics course equips learners with analytical skills to process, visualize, and interpret data using tools like Excel, Python, Power BI, and SQL. Ideal for professionals aiming to transition into the analytics domain.
What you'll learn
- Fundamentals of data analytics and visualization
- Data cleaning, transformation, and interpretation
- Hands-on analysis using Excel, Python, and SQL
- Dashboard creation with Power BI & Tableau
- Business insights through case studies
Course Features:
- Real-world data projects
- Tool-based learning modules
- Lifetime access to course materials
- Professional certification
Course Content
Installation of Anaconda Prompt
Jupyter Notebook-An Overview
Shorcut Lkeys in Jupyter Notebook
Data Types in Python
Rules for Naming the Variables List, Tuple, Set, Dictionary
"Introduction to Files and directories Introduction to the command prompt or terminal paths"
Text files Reading from a text file Opening a file using `with`
If, else if and else condition
For and While Loop
Machine Learning Libraries Numpy-Hands on
Pandas-Hands on
Learn how to explore, visualize, and extract insights from data
Data Visualization
Matplotlib-Hands on
Seaborn hands on
You need to think statistically and to speak the language of your data
Measures of Central Tendency
Measures of Dispersion
IQR Statistics-Hands-On
Classification, Regression, Fine-tuning your model
Supervised Learning
Unsupervised Learning
Linear Regression
Metrics in Linear Regression Hands-on in Linear Regression
Logistic Regression
Metrics in Logistic Regression
Hands-on in Logistic Regression
Linear regression
Metrics for Linear regression
Introduction to Data Preprocessing Standardizing Data
Exploratory Data Analysis Missing Values Outliers
Standardization Mnormalization Feature Scaling and Selection
Decision Tree
Bagging
"Boosting Random Forest"
Neural Network
“Use data science packages, analysis, visualization, create model, extract pure data etc”
Excel Functions
Conditional Formatting
Pivot tables
Dashboards
Basics of database schema
Importance SQL Clauses
SQL Joins
Introduction to Power BI desktop
ETL pipeline in Power BI
Calculating fields with DAX
Visualising data with reports
AI functionalities of Power BI