Data Analytics Course In Islamabad

• What is Data Analytics
• Role of a Data Analyst
• Types of Data Analytics
• Tools & Software Overview
• Data Analysis Workflow
• Introduction to Excel
• Course Setup

• Excel Interface Overview
• Workbooks & Worksheets
• Cells, Rows & Columns
• Basic Formulas
• Data Types in Excel
• Formatting Cells
• Sorting & Filtering

• Logical Functions (IF, AND, OR)
• Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
• Text Functions (CONCAT, LEFT, RIGHT, MID)
• Date & Time Functions
• Error Handling (IFERROR)
• Nested Formulas
• Formula Auditing

• Charts (Bar, Column, Line, Pie)
• Conditional Formatting
• Sparklines
• Pivot Tables Basics
• Pivot Charts
• Slicers & Filters
• Dashboard Overview

• Power BI Overview
• Power BI Desktop Installation
• Interface & Workspace
• Data Sources & Connections
• Importing Data
• Data Types & Transformation
• First Visualizations

• Relationships in Power BI
• Data Tables & Fact Tables
• Dimensions & Hierarchies
• Calculated Columns
• Measures (DAX Basics)
• Time Intelligence Functions
• Data Cleaning in Power Query

• Interactive Reports
• Advanced Charts & Graphs
• Slicers & Filters
• Drillthrough & Tooltips
• Conditional Formatting
• Custom Visuals
• Dashboard Design

• Introduction to Databases
• Relational Database Concepts
• MySQL Installation
• MySQL Workbench Overview
• Tables & Schemas
• Data Types in MySQL
• Basic Queries (SELECT, WHERE)

Sorting & Filtering

Aggregate Functions (SUM, AVG, COUNT)

Grouping Data (GROUP BY, HAVING)

Joins (INNER, LEFT, RIGHT, FULL)

Subqueries & Nested Queries

Views

Indexing Basics

• INSERT, UPDATE, DELETE
• Primary & Foreign Keys
• Relationships
• Constraints
• Transactions & Rollback
• Stored Procedures Basics
• Query Optimization

• Connecting MySQL to Power BI
• Importing & Transforming Data
• Data Refresh Setup
• Combining Multiple Data Sources
• Building Interactive Reports
• Real-time Dashboards
• Performance Tips

• Project Planning & Scope
• Data Collection & Cleaning
• Data Analysis Using Excel & Power BI
• Dashboard Development
• SQL Queries for Analysis
• Presentation of Findings
• Career Guidance & Portfolio Setup