Data and analytics
Data Analytics (Python, SQL, Excel & Power BI)
- Schedule
- Every Friday 9:30 AM to 12:00 PM
- Length
- 16 classes
- Course fee
- Tk 12,000
- Paid at once
- Tk 11,000
Classes running
Course details
Data and analytics
Admission closed
Data Engineer with Python & Machine Learning
Master essential skills in Python, data pipelines, and machine learning to become an expert in handling and analyzing data.
Ready to advance your career in data engineering? Join CDIP’s Data Engineer with Python & Machine Learning course. Master essential skills in Python, data pipelines, and machine learning to become an expert in handling and analyzing data. With our top-notch training, you’ll be prepared to meet the high demand for data engineering professionals in today’s data-driven world. Enroll now and unlock your potential!
Who this course is for
- Senior students preparing for a Data Engineering career.
- Graduates entering the field of Data Engineering and Machine Learning.
- Professionals enhancing their data skills and advancing their careers.
- Entrepreneurs leveraging data engineering for informed business decisions.
How the course works
- Experienced Trainers: Learn from industry experts.
- Hands-on Projects: Real-world training.
- Certification: UIU certification upon completion.
- Career Support: CV development, interview simulation, counseling, and job placement assistance.
- Flexible Schedule: Weekly one class (Saturday).
Course outline
1Week 1: Python Part1
- Python Env Setup, Intelij Student subscription
- Data Types
- Strings
- Strings Manipulation
- Control Flow if else
- continue and break
- For, While
2Week 2: Python Part-2
- List
- Dictionary
- Tuple
- Set
- Regex
- List Comprehension
- Project Discussion
3Week 3: Python Part-3
- Assignment 1
- Class, Function, and Methods
- Inheritance
- Polymorphism
- GIL
- Threading
- Multiprocessing
4Week 4: Python Part-4
- Generator
- Iterator
- Map, Reduce, and filter
- lambda
- Assignment 2
- CV Discussion
- CV Prepare
5Week 5: Git + CV prepare
- Create a public and private project
- Pull, Push, and PR creation
- Code Review
- Fix merge conflict
6Week 6: Docker + Cv prepare
- CV Prepare
- Docker image
- Docker Container
- Docker registry.
7Week 7: Pandas Part-1
- File processing with pandas
- Official doc
- Iloc, Iloc, iat
- Query on the data frame
- Datetime types
- Hands-on
- Assignment
8Week 8: Pandas Part-2
- Melt
- Merge
- Join
- Pipe
- Hands-on
- Assignment
9Week 9: Pandas Part-3
- Squeeze, explode
- Clip
- Hasnans
- Group by, Pivot
- Eval
10Week 10: Beautiful Soup
- Soup
- HTML parser
- XML parser
- find
- get all a
- Pretty-printing
11Week 11: Selenium Part1
- Web Driver
- Why
- visiting any web pages
- setting values for the text field
- Assignment
12Week 12: Selenium Part2
- Wait in selenium
- write your own driver
- multiple page handling
- Popup handling
- Hands-on
13Week 13: Database with Python Part 1
- MySql/Postgresql
- Creating table
- Simple CRUD operations in SQL
- Views
- Indexing, Partitioning
- Connect DB with Python
- Assignment
14Week 14: Database with Python, Part 2
- Insert data and pull data
- How to handle on conflict
- ORM SqlAlchemy
- How to handle huge amounts of data?
- divide and conquer
- Real-life example with data
15Week 15: Project Submission: 60 %
16Week 16+17: DWH Concepts
- Normalization
- BCNF
- DIM and Fact Table Design
- Hands-on example with Assignment
- SCD Table
- SCD Type 1
- SCD Type 2
- Hands-on
17Week 18: Project Support
- Project Support
18Week 19: Project Submission (90%)
19Week 20: Project Support
- Any blocker, any sort of support
20Week 21: Introduction to TensorFlow and Machine Learning
- Introduction to TensorFlow
- Overview of Machine Learning
- Basic Data Handling using TensorFlow
21Week 22: Introduction to Time Series and Forecasting
- Understanding Time Series
- Introduction to Time Series Forecasting
- Basic Time Series Analysis in TensorFlow
22Week 23: Building and Training Time Series Forecasting Models in TensorFlow
- Advanced Time Series Analysis Techniques
- Building Time Series Forecasting Models using TensorFlow
- Evaluating Performance and Making Predictions
23Week 24: On-demand extra class
- Extended support for the project
Assessment and certificate
- Verification Process: Assignment
- Question Answer Session
- Assessment Exam
- Project
- Final Interview
- Project submissions: 60% (Week 15), 90% (Week 19)
- Certificate will be given after successful course completion
Taught by
Course terms
CDIP terms and conditions apply to every course.