top of page

Data Analyst

​

Python Syllabus​​​​

  • Introduction to Python

  • Python Variables

  • Python Comments

  • Data Types

  • Type Casting

  • Python Operators

  • Python Slicing

  • Conditional Statement

  • While Loop

  • For Loop

  • String

  • List

  • Tuple

  • Set

  • Dictionary

  • Function

  • Expection Handling

  • Master Class on Numpy/Pandas

​

​

SQL Syllabus​​​​​​

  • Introduction to Database

  • SQL Commands

  • SQL Installation

  • SQL Data Types

  • SQL Operators

  • SQL Constraints

  • Data Manipulation Language

  • Data Definition Language

  • Data Control Language

  • Select Statement

  • Aggregate Function

  • SQL Joins

  • SQL Subqueries

  • Built-In Function

  • SQL Indexes

  • Case Statement

  • SQL Views

  • SQL Window Functions

​

​

PowerBI Syllabus​​​​​​

Module 1: Quick Start

  • Get Power BI Tools

  • Introduction to Tools and Terminology

  • Dashboard in Minutes

  • Interacting with your Dashboards

  • Sharing Dashboards and Reports ​

​

​

Module 2: Transforming Data with Power BI

  • Introduction to Power BI Desktop

  • Getting Data: Excel vs Power BI Desktop

  • Q&A

  • Import Data

​

Module 3: Modeling with Power BI

  • Introduction to Modeling

  • Setup and Manage Relationships

  • Cardinality and Cross Filtering

  • Default Summarization & Sort by

  • Creating Calculated Columns

  • Creating Measures & Quick Measures

  • DAX FORMULAS

​

Module 4: Power BI Desktop Visualisations ​

  • Creating Visualizations 

  • Color Formatting

  • Setting Sort Order

  • Scatter & Bubble Charts & Play Axis

  • Tooltips

  • Slicers, Timeline Slicers & Sync Slicers

  • Visual, Page and Report Level Filters

  • Drill Down/Up

  • Tables, Matrices & Conditional Formatting

  • KPI's, Cards & Gauges

  • Map Visualizations

  • Custom Visuals

  • Drill through

  • Mobile view

  • END-TO-END POWERBI PROJECT WITH REAL TIME DATASET.

bottom of page