Data Analyst Bootcamp
The Data Analyst Bootcamp is an intensive, hands-on program designed to take learners from zero to job-ready data analysts. The bootcamp covers data analysis with Excel, SQL querying, building dashboards and reports with Power BI, statistical fundamentals, data visualization principles, and data-driven decision-making. Training is based on real business datasets and case studies, helping participants gain practical skills required for Data Analyst and BI Analyst roles.
Üstünlüklərimiz
Professional Mentors
Guidance and support from experienced specialists
Practical Learning
Not just theory — hands-on experience through real projects
Modern Technologies
Python, AI, web development and other trending fields
Career Support
CV preparation, interview simulations and access to job opportunities
Curriculum
Module 1 — Excel Fundamentals & Data Analysis
- 1.Introduction to Microsoft Excel Arithmetic manipulation Logical formulas (IF, AND, OR, IFERROR, etc.) Error types (#DIV/0!, #REF!, #VALUE!, etc.) Text functions (LEFT, RIGHT, MID, LEN, CONCATENATE, etc.) Conditional formatting (rules, data visualization) Date and Time functions Math and Trigonometry functions Statistical functions Data validation Advanced filter What-if analysis Lookup and Reference functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH) Pivot Tables Charts (Column, Line, Pie, Bar, Histogram, etc.) Hyperlink Final Exam (Project)
Module 2 — Power BI
- 1.Power BI Desktop overview Data sources and data connections Power Query (cleaning, transforming, merging, appending) Data modeling and relationships DAX fundamentals DAX measures and calculated tables Charts and visualizations Slicers, KPIs, and maps Dashboard creation Workspace and dataset management Row-level security Incremental refresh Publishing and sharing Final Exam (Project)
Module 3 — SQL (Microsoft SQL Server)
- 1.Data and database concepts Database platforms and types SQL basics DDL, DML, DCL, TCL Transactions and permissions Filtering, sorting, and limiting Aggregation and grouping Joins Subqueries Analytical functions Views, functions, and procedures Practice 1 and Practice 2 Final Exam (Project)
Our Top Graduates
Bu kurs üçün hələ məzun məlumatı əlavə olunmayıb.
Our Teachers
Market Salaries
1000-1500 AZN
Junior
1 year experience
1500-2500 AZN
Middle
1–3 years experience
3500+ AZN
Senior
3+ years experience
Frequently Asked Questions
idtech is a modern learning ecosystem providing education in technology, programming, and digital skills.
You can register by filling out the form in the 'Apply' section on our website.
Our courses are suitable for both beginners and those looking to deepen their expertise.
Yes, lessons are available both online and in classrooms.