Skip to content

Home
About
Professional Courses
Kids Courses
- Short Courses
- Kids Bootcamp
Workshops
- Professional Workshops
- Winter / Summer Bootcamp
Contact

Home
All Courses
Business & Accounts
Data Analysis & Business Intelligence

Data Analysis & Business Intelligence

Curriculum

11 Sections
24 Lessons
10 Weeks

Expand all sectionsCollapse all sections

Introduction to Data Analytics
1
- 1.0
  Session 1: Overview of data analytics and its importance.
Module 2: Excel for Data Analysis (Part 1)
2
- 2.0
  Session 2: Excel Basics: Tables, sorting, filtering, and formatting.
- 2.1
  Session 3: Advanced Excel Formulas & Functions.
Module 2: Excel for Data Analysis (Part 2)
2
- 3.0
  Session 4: Pivot Tables: Creation, styles, and slicers.
- 3.1
  Session 5: Dashboards and Data Visualizations in Excel.
Module 3: Introduction to Power BI
4
Module 4: SQL Basics (Part 1)
2
- 5.0
  Session 10: SQL Syntax, SELECT Statements, and Filtering Data.
- 5.1
  Session 11: Joins and Subqueries in SQL.
Module 4: SQL Basics (Part 2)
2
- 6.0
  Session 12: Nested Queries and Data Aggregation with GROUP BY and HAVING.
- 6.1
  Session 13: SQL Data Analysis Techniques.
Module 5: Python for Data Analysis (Part 1)
2
- 7.0
  Session 14: Python Basics: Variables, Loops, and Conditional Statements.
- 7.1
  Session 15: Introduction to Pandas for Data Manipulation.
Module 5: Python for Data Analysis (Part 2)
2
- 8.0
  Session 16: Data Cleaning: Handling Missing Values, Outliers, and Transformations.
- 8.1
  Session 17: Data Visualizations with Matplotlib and Seaborn.
Module 6: Advanced Power BI
3
Module 7: Advanced SQL Techniques
2
- 10.0
  Session 21: Window Functions and Common Table Expressions (CTEs).
- 10.1
  Session 22: Reporting and Exporting Query Results.
Module 8: Advanced Python Analytics
2
- 11.0
  Session 23: Time-Series Analysis and Regression Models.
- 11.1
  Session 24: Predictive Modelling with Scikit-learn.

Session 10: SQL Syntax, SELECT Statements, and Filtering Data.

Activity: Write SQL queries to retrieve specific data from a database.

Session 9: Publishing and Sharing Reports in Power BI.

Session 11: Joins and Subqueries in SQL.

Address : UAE

Sharjah Research, Technology, and Innovation Park, Block B - B18-196, Sharjah,United Arab Emirates.

Saudi Arabia

Office No. 7, 1st Floor, ALJMAZ Building Prince Sultan Bin Abdulaziz Rd, Above Dunkin Donuts Al Olaya, Riyadh 12221,Saudi branch

Information

About
Contact

All Categories

Professional Courses
Kids Courses

States

All Rights Reserved PNY Trainings.

Modal title

Main Content