Course Details

Data Analysis

Forge the path with transformative insights.Drive the decision with precision.

Module 1

  • PYTHON MS – EXCEL
  • POWER BI LOOKER STUDIO PROJECTS
  • Introduction to programming.
  • Data types, Operators, Conditional
    statements.
  • Loops, Functions, Recursion,
  • lambdas, List Comprehensions.
  • Classes and Objects, Exception
  • Handling, Modules, Packages.
  • String handling, Manipulations
  • Numpy, Pandas , Matplotlib and
  • Seaborn
  • Project Work with Assesments

Module 2

  • Database Management System
  • RDBMS and Non RDBMS
  • MySQL, NoSQL, PostGreySQL
  • DDL
  • DML
  • DQL
  • DCL
  • Schema
  • Joins, Nested Joins
  • SQL query Optimisation.

Module 3

  • Introduction to Excel,
  • Advanced Functions and Formulas Data Analysis using pivot tables
    and Visualization techniques
  • Advanced Chart Techniques and
    dashboarding
  • Import data from a range of
    sources, including text files,
    databases

Module 4

  • Connecting to data sources,
  • Creating dashboards and reports
  • Creating visualizations: Bar charts,
  • Pie charts, Etc.
  • Real-time data streaming
    capabilities.
  • Relationships between tables and measures, and use DAX formulas.
  • Advanced features: Calculations, Drill-through, and Hierarchies

Module 5

  • Connecting to data sources,
  • Creating dashboards and reports
  • Exploring data: Views, Fields, and
    Filters
  • Advanced features: Derived tables. Merged queries, and LookML.
  • Dash-Boarding
  • Analytics Dynamic Data Sync using Google
  • Sheets

Module 6

  • The final project will give students
    the opportunity to demonstrate
    their understanding of the tools by
    using one of the tools to create a
    project.