- Hands-on sessions prioritized over theory
- Theoretical aspects covered as needed
- Instructor-led sessions with ample opportunity for doubts clarification
- Industry expert-led training
- Limited students per batch
Python, a high-level programming language, known for its simplicity and versatility. It's widely used in web development, data analysis, artificial intelligence, and more. With its readable syntax and extensive libraries, Python is a popular choice for beginners and professionals alike.
- Types of databases (relational, non-relational)
- Data Manipulation Language (DML) vs. Data Definition Language (DDL)
- SQL commands (CREATE, INSERT)
- Understanding SQL statements
- Create database or schema
- Inserting data into tables
- Writing basic SQL queries
- Syntax of the SELECT statement
- Filtering data with WHERE clause
- Limiting results with LIMIT/TOP
- Using comparison operators (>, <,=, etc.)
- Using logical operators (AND, OR, NOT)
- Using compound operators (LIKE, BETWEEN, IN)
- Use of Set Operators (UNION, UNION ALL, INTERSECTS, EXCEPT/MINUS)
- Use of wild cards in query
- Sorting data with ORDER BY
- Using SQL functions (COUNT, SUM, AVG, MIN, MAX)
- Grouping data with GROUP BY
- Filtering grouped data with HAVING
- Updating existing data
- How to ALTER table ?
- Deleting data or table structure
- Assignment Operators
- Comparison Operators
- Python slicing
- Python Functions
- Simple If Statement
- Nested If Statement
- Use of If with String/Tuple/List/Dictionaries
- Use of Input function
- Simple For loop
- For with Range
- Use of Break/Continue
- Nested For loop
- Simple For loop
- For with Range
- Use of Break/Continue
- Nested For loop
- Simple For loop
- For with Range
- Use of Break/Continue
- Nested For loop
- Simple For loop
- For with Range
- Use of Break/Continue
- Nested For loop
- What is Data frame?
- Pandas functions
-
head/tail/Info/value_counts/len/unique/columns/rename/fillna/dropna/astype/
isna/loc/drop/
read_excel/concat/merge/copy/groupby/pivot_table/to_excel
- Deep dive with data frames and Feature Engineering
- Push data into MySQL database
- Extract data from MySQL database
- Consolidate excel sheets
- Read data from multiple excel files and perform Mapping/Create Summary/Extract into Excel
- Transpose crosstab into table (Convert Date type fields into Date & Values columns)
Microsoft Certified Trainer - 1 Million+ Students
Experienced Tableau specialist adept at
converting business requirements into
impactful visualizations. Skilled in Tableau Server administration,
performance optimization, and report publishing. Proficient in SQL queries
across MySQL, SQL Server, and Oracle. Expertise in creating Data Lakes to
centralize offline data management. Strong ability to define data flows and
templates in Excel and MySQL environments. Knowledgeable in implementing
user filters for row-level security (RLS) and proposing suitable
visualization views aligned with KPIs. Proficient in Tableau features like
LOD, Parameter, Sets, and Actions. Experienced in end-to-end automation of
data and dashboard processes. Well-versed in training team members on new
technologies and BI tools. Expertise in converting excel-based reports to BI
visualizations and writing VBA Macros/Python Script for data preparation.
Analyzes data requirements and designs visualization solutions to meet
client needs. Skilled in data analysis and preparing ad-hoc reports.
Additionally, proficient in Python for data manipulation and analysis,
including feature engineering, data mapping, data cleaning, and aggregation.
Skilled in creating online platforms using Python, HTML/CSS, and JQuery for
data file management with LDAP Authentication. Experienced in Exploratory
Data Analysis (EDA) and assisting team members with machine learning
algorithms for predictions. Utilized Python libraries such as Pandas, NumPy,
Sci-Kit, Scikit-learn, OpenPyXL, and ldap3.
Retail (Apparels/Food Chain/FMCG/Footwear), E-Commerce, NBFC, Electric Vehicle (EV) Industry, Manufacturing.
The highest educational qualifications include a Master of Computer Application (MCA) and a Master's degree in English Literature (MA).
This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.
This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.
Leave a Comment