> For the complete documentation index, see [llms.txt](https://thesigmaschool.gitbook.io/home/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://thesigmaschool.gitbook.io/home/course-curriculum/data-analytics-professional.md).

# Data Analytics Professional

**Course Description**

Learn to transform raw data into meaningful insights using Excel, SQL, Python, Statistics, and Power BI through hands-on projects and real-world case studies. Designed for college students preparing for internships, placements, and careers in data analytics.

**Course Duration:** 30 Weeks

**Class Schedule:**

* 3 Classes per Week
* 1.5 Hours per Class

**Batch Timings:** Multiple batches available.

**Seat Availability:** Limited seats per batch.

**Contact:** Contact the institute for batch timings, seat availability, and enrollment details.

***

### Detailed Course Curriculum

<details>

<summary><strong>Module 1: Data Analytics &#x26; Python Setup</strong></summary>

* What a Data Analyst does and career roadmap
* Google Colab, Anaconda & VS Code setup
* Working with Python environments

</details>

<details>

<summary><strong>Module 2: Python Programming Fundamentals</strong></summary>

* Variables, data types & operators
* Conditional statements & loops
* Lists, Tuples, Sets & Dictionaries
* Functions, Lambda, Map & Filter
* Modules, File Handling & Exception Handling

</details>

<details>

<summary><strong>Module 3: Data Analysis with Python</strong></summary>

* NumPy fundamentals
* Pandas DataFrames & Series
* Data cleaning & manipulation
* Reading data from multiple sources
* Data visualization with Matplotlib & Seaborn

</details>

<details>

<summary><strong>Module 4: Statistics for Data Analysis</strong></summary>

* Descriptive statistics & sampling
* Probability distributions
* Correlation & covariance
* Central Limit Theorem
* Hypothesis Testing, T-Test, Z-Test & ANOVA

</details>

<details>

<summary><strong>Module 5: Exploratory Data Analysis (EDA)</strong></summary>

* Handling missing values & outliers
* Feature engineering & data encoding
* Real-world dataset analysis
* Google Play Store, Flight Price & Red Wine case studies

</details>

<details>

<summary><strong>Module 6: SQL for Data Analytics</strong></summary>

* SQL queries & database operations
* Filtering, sorting & aggregations
* Joins & subqueries
* Window functions & Common Table Expressions (CTEs)

</details>

<details>

<summary><strong>Module 7: Power BI</strong></summary>

* Power Query & data transformation
* Interactive dashboards & visualizations
* Data modeling & DAX
* Reports, KPIs & business insights
* Publishing & sharing dashboards

</details>

<details>

<summary><strong>Module 8: Capstone Projects</strong></summary>

* Sales Analytics Dashboard
* HR Analytics Dashboard
* Financial Dashboard
* End-to-end industry-style portfolio projects

</details>