Logo

+917454030920

info@uplifters.in

Data Analyst

You will receive a gentle introduction to data analysis, the job of a data analyst, and the tools required for the position in this course. You will learn stuff of the duties and capabilities of a data analyst and talk from numerous data specialists who will share their career-starting advice and ideas. You will learn how to distinguish between the responsibilities of data scientists, data engineers, and data analysts in this course.

Classes: Evening Online Live Classes ( 5 days a week - Monday to Sunday)
Course Duration: 15 weeks, i.e., 150+ hours

Placement Guaranteed Program

₹59,999 ₹120,000 50% Off

starts from 3,333/month

Pay After Placement

₹10,000 (upfront fees)

+ 20% of CTC (max ₹200,000) after placement

For Freshers Only

Classes in Hindi + English language
Live Lectures with instant doubt resolutions
Interview Preparation from first day
Soft Skills Preparation
Resume Building & Career Guidance by Experts

Highlights of the Course

  • Python
  • DSA in Python
  • Data Science Maths
  • SQL
  • EXCEL
  • PowerBI/Tableau
  • DataSources
  • Cloud Basics
  • Machine Learning Fundamentals
  • Interview Preparation
  • Industry Project

Course Curriculum

Explore your Learning Journey

  • Basic formulas like sum, count, sum if, count and others
  • Data cleaning like changing the format, using filters and others
  • Conditional formatting like removing duplicates and others
  • Data Visualisation
  • Pivot Tables
  • Advanced formulas like Vlook up, Hlookups, Slicers, Micros, Nested if, Power query and others
  • Data analysis / Statistical tools like Regression, correlation, etc

  • Database Installation & Overview
  • Fundamentals of SQL
  • RDBMS vs DMBS
  • Creating Database
  • SQL Commands - DDL, DML,DCL,TCL,DQL
  • SQL Operators
  • SQL Constraints
  • SQL keys
  • SQL Joins
  • SQL Functions like Aggregation functions.
  • SQL Subqueries
  • Advanced SQL queries
  • Capstone Project

  • Basic Arithmetic Operations
  • if-else statements
  • input-output operations
  • Data types- String, int, char etc
  • Typecasting
  • Loops- for/while
  • Lists, Set, tuples etc
  • Inbuilt function, lambda function, iterator, generator
  • Exceptional handling
  • Import & Introduction of Python libraries like matplot, numpy for creating graphs etc.
  • And other Advanced topics like OOPs concepts.

  • Power BI basics
  • DAX
  • Data Connection
  • Sorting & Filtering Data
  • Data Visualization, reports & charts
  • Data Analytics
  • Geo Maps
  • Dashboards
  • Managing Worksheets

  • Chi squared test
  • Hypothesis testing
  • Normal Distribution
  • Data Wrangling
  • KNN imputation method
  • Clustering
  • Outliers
  • Statistical model
  • Regression
  • Central tendency – Mean, Median & Mode
  • Standard Deviation
  • Variance & Covariance
  • Sample size
  • Descriptive & inferential Statistics
  • T-test
  • Z-test
  • F-test

  • Number series
  • Coding Decoding
  • Directions
  • Blood Relations
  • Linear Arrangement
  • Ranking Arrangement
  • Ratio and Proportion
  • Time and Work
  • SI and CI
  • Profit and loss
  • Averages
  • Upstream and Downstream

  • Food Ordering Management- SQL project
  • IMDB-Movie- Analysis- Excel Project
  • Financial Performance Analysis- Power BI Project
  • Customer Segmentation- Python Project

WHAT IS THE DATA ANALYST PROGRAM?

This Data Analyst program will teach you how to master descriptive and inferential statistics, hypothesis testing, regression analysis, data blending, data extraction, and forecasting. You will also gain expertise in data visualization techniques using Power BI / Tableau, and learn how to organize data and design dashboards. You will learn Python programming and other required skills to become a Data Analyst.

WHY BECOME A DATA ANALYST?

The World Economic Forum predicts that, by 2025, Data Analysts will be one of the hottest jobs in the market. Organizations view data analysis as one of the most crucial skills due to the value that they can derive from data. With the ever-increasing demand for data analytics today, the value of Data Analysts is continuing to grow, creating new jobs, and career advancement opportunities.

IS A DATA ANALYST COURSE WORTH PURSUING AS A CAREER?

Pursuing a Data Analyst course is a strategic and valuable career choice. The field's continued growth and relevance offer job security, competitive salaries, and versatile applications across various industries. Data analysts have opportunities for career progression and can transition into roles like data science or business intelligence. Success, however, hinges on staying current with evolving data tools and techniques. It's essential to weigh the educational investment in time and cost.

WHO SHOULD DO THE DATA ANALYST COURSE?

  • Any graduate, postgraduate, working Professionals who have logical, mathematical, and analytical skills.
  • Professionals working on Business intelligence, Data Warehousing and reporting tools
  • Statisticians, Economists, Mathematicians
  • Fresher from any stream with good Analytical and logical skills.
  • Vaibhav Varshney

    Vaibhav Varshney

    NIT Allahabad
    Tejas Networks

  • Umang Sangal

    Umang Sangal

    NIT Allahabad
    Ex- UBS ( Swiss bank)

  • Ritika Garg

    Ritika Garg

    DTU
    AvancePR

  • Abhijeet Singh

    Abhijeet Singh

    BITS Pilani
    Ex- Trinkerr

  • Vaidehi Deshpande

    Vaidehi Deshpande

    College of Engineering, Pune (COEP)
    Ex-UBS ( Swiss bank)

  • Ravi Gautam

    Ravi Gautam

    IIST
    Raga.ai

  • Anubhav Mittal

    Anubhav Mittal

    JSS Academy of Technical Education, Noida
    Ex- Virtusa

  • Sandeep Gaur

    Sandeep Gaur

    NIT Allahabad
    Ex - MMT

  • Prerna Chaudhary

    Prerna Chaudhary

    M.S.U
    Soft Skills Trainer

  • Vaibhav Varshney

    Vaibhav Varshney

    NIT Allahabad
    Tejas Networks

  • Umang Sangal

    Umang Sangal

    NIT Allahabad
    Ex- UBS ( Swiss bank)