Technology & Data

Data Analytics

15 Days (40 Hours)
Online
Dr. Aghapy Nabil

Course Overview

An intensive Data Analytics Bootcamp designed to transform how you deal with numbers—shifting from random analysis to data-driven, evidence-based decision-making. Master Excel, SQL, and Power BI through hands-on projects featuring real-world Sudanese economic data

Who Should Attend?

Junior & Mid-level Data Analysts • Business & Sales Analysts • Department Heads & Managers • Entrepreneurs & Business Owners • Financial Analysts & Accountants • STEM & Economics Graduates • Market Researchers & Economists

Learning Objectives

  • Master data collection and cleaning techniques
  • Learn statistical analysis methods
  • Develop data visualization and storytelling skills
  • Use tools like Excel, Power BI, SQL
  • Interpret and present data insights effectively

Curriculum & Syllabus

  • Data analysis lifecycle and types of analytics (descriptive, diagnostic, predictive, prescriptive)
  • Understanding data types and measurement scales
  • Data quality and governance
  • Setting up analytical objectives
  • Ethical considerations in data analysis

  • Data sources and collection methods (surveys, APIs, databases)
  • Data wrangling and preprocessing (handling missing values, outliers)
  • Data transformation and normalization
  • Data integration and merging
  • Exploratory data analysis (EDA) techniques

  • Modern Data Ecosystem
  • Power Query (Extract, Clean and Prepare a Data)
  • Filtering and Sorting data
  • Look up Function
  • Pivot Tables Features
  • Data Visualization and Slicer Reports
  • Statistical Tools
  • Create Interactive Dashboard

  • Introduction to Microsoft Power BI
  • Data wrangling, Connecting and Shaping a Data (ETL in Power BI)
  • Harnessing the Power of Data with Power BI
  • Creating a Data Modeling Schema
  • Calculated Field with DAX
  • Data Analysis and Visualization (Reports, and Dashboards)
  • Power BI Optimization tools (SLR , Share , manage workspace)

  • Introduction to SQL and RDBMS
  • Data Definition Language Commands
  • Data Manipulation Language Commands
  • SQL Functions
  • SQL Nested Query
  • SQL JOIN
  • Connect SQL with MS Power Bi and MS Excel
  • Practice on Real Data Analytics Case Study
● Open for Enrollment

Ready to Advance Your Career?

Confirm your seat today to secure your training spot.

Enroll Now
Track Technology & Data
Instructor Dr. Aghapy Nabil
Start Date 2026-9-3
Duration 15 Days (40 Hours)
Delivery Mode Online
Certification Data Analytics Certificate of Completion