Data Analysis – Djas Digital Hub

About Course

This Data Analysis and Visualization course equips learners with practical, hands-on skills to collect, clean, analyze, and visualize data for effective decision-making. Participants will explore Excel, SQL, Power BI, and AI-powered tools like Microsoft Copilot to automate insights and simplify complex analysis.

By the end of the course, learners will confidently transform raw data into actionable insights and interactive dashboards. The program concludes with a 2-week project portfolio phase to help learners demonstrate their readiness for real-world data roles, create a professional brand, and set up freelancing platforms.

Build a solid foundation in Microsoft Excel for data analysis and visualization.
Use AI Copilot in Excel and Power BI to simplify formula writing, data cleaning, and insight generation.
Validate, clean, and structure data efficiently using modern tools.
Analyze and query structured data using SQL.
Design compelling dashboards and visualizations in Excel and Power BI.
Apply AI-driven features for data storytelling and summarization.
Present insights effectively using storytelling techniques for business decision-making.
Build a strong professional brand and online presence for data career growth.
Work on a project portfolio integrating business understanding, data preparation, analysis, visualization, and storytelling.

Course Content

WEEK 1 – Introduction to Data Analytics & Excel Basics

Introduction to Data Analytics
Data Analytics Career Paths and Tools Overview
How to Build a Social Media Brand that Sells (Personal Branding for Data Professionals)
Understanding the Excel interface and data types
Basic Excel functions: SUM, AVERAGE, COUNT, IF
Cell referencing

WEEK 2 – Data Cleaning & Manipulation in Excel

WEEK 3 – Advanced Excel for Data Analysis

WEEK 4 – Introduction to SQL (Relational Databases)

WEEK 5 – SQL Queries and Data Manipulation

WEEK 6 – Introduction to Power BI

WEEK 7 – Data Modeling, DAX, and KPIs

WEEK 8 – Power BI Visualization & Storytelling

WEEK 9 – How to create a professional brand and set up freelancing platforms.

WEEKS 10–12 – PROJECT PORTFOLIO PHASE

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

WEEK 1 – Introduction to Data Analytics & Excel Basics

Introduction to Data Analytics

Data Analytics Career Paths and Tools Overview

How to Build a Social Media Brand that Sells (Personal Branding for Data Professionals)

Understanding the Excel interface and data types

Basic Excel functions: SUM, AVERAGE, COUNT, IF

Cell referencing

WEEK 2 – Data Cleaning & Manipulation in Excel

Data cleaning tools (TRIM, CLEAN, SUBSTITUTE, VALUE)

Converting lists to tables, sorting, filtering, and total rows

Logical and conditional formulas: SUMIF, AVERAGEIF, COUNTIFS

Introduction to XLOOKUP and joining datasets

WEEK 3 – Advanced Excel for Data Analysis

Using AI Copilot for quick data summaries and transformations

Pivot tables and pivot charts

Calculated fields and timeline tools

Building dynamic Excel dashboards

Mini Project: Create an Excel dashboard for sales analysis

WEEK 4 – Introduction to SQL (Relational Databases)

Installation and setup of SQL environment

Understanding Databases, DBMS, RDBMS and Relationship keys

Writing basic SQL queries: SELECT

Removing Duplicates

Writing SQL queries: WHERE Clause and predicates, ORDER BY, TOP, BETWEEN, IN, LIKE etc

WEEK 5 – SQL Queries and Data Manipulation

Aggregate functions: SUM, COUNT, AVG, MIN, MAX

GROUP BY, HAVING

Understanding Joins: INNER, LEFT, RIGHT, FULL

Using AI assistance for query

Mini Project: Query a sample database to extract insights

WEEK 6 – Introduction to Power BI

Power BI Installation

Understanding Power BI interface and workflow

Connecting to data sources

Formatting data types

Cleaning and Transforming data in Power Query

WEEK 7 – Data Modeling, DAX, and KPIs

Understanding relationships and cardinality

Creating calculated columns and measures using DAX

Time intelligence functions and creating a Date Table using DAX

Building KPIs: Total Revenue, Total Cost, Total Profit, Profit Margin %

WEEK 8 – Power BI Visualization & Storytelling

Visuals: Cards, KPIs, Pie, Bar, Map, Table, Gauge

Filters and slicers (including Top N)

Storytelling with data – creating a narrative-driven dashboard

Leveraging AI insights and summaries in Power BI

Publishing and sharing reports via Power BI Service

Final Project Briefing and Preparation

WEEK 9 – How to create a professional brand and set up freelancing platforms.

Building Your Resume and LinkedIn Profile for Data Roles

Setting Up Career Professional Page and Freelance Platforms (Upwork,etc.)

Leveraging Social Media to Promote Your Data Projects

WEEKS 10–12 – PROJECT PORTFOLIO PHASE

Class participation and hands-on practice

Mini projects after each tool module

Final project portfolio and presentation

Student Ratings & Reviews