Data Analyst
Transform Raw Data
into Clear Insights
About Program
Key Highlights
Access to learning management system
30+ Industry Projects & Case Studies
Case-study based training by industry
experts
Help in resume building and
interview preparation
Certiificate of completion
Capstone project
Course Curriculum
Analytics with Microsoft Excel
Duration: 16 hrs live (No of learners <= 25)
Minimum Qualification: Graduate or apprearing
Introduction to Analytics using Excel
1 Basics of excel formatting, conditional formatting
2 Filter and sort
3 Functions - Text, Logical, Lookup, Datetime, Arithmetic, Statistical
4 Excel Solver, What if Analysis
Data summary using Pivot table
1 How to create Pivot Table
2 Aggregtaion using Pivot tables
3 Custom Aggregation in Pivot Table
4 Creating a Calculated Field
5 Using Slicer
6 Pivot table for Dashboarding
Data Visualization and Dashboarding
1 Cretaing Simple Charts
2 Creating a Combination Chart
3 Chart Styles and Formatting
4 Interactive charts
Lesson End Project
Course Curriculum
Basics of Data Management
and SQL
Duration: 16 hrs live (No of learners <= 25)
Minimum Qualification: Graduate or apprearing
Introduction to Database and DBMS
1 Introduction to databases and types of databases
2 Relational Database Management System
3 Entity Relationship Models (ER Diagrams)
4 Normalization
SQL Queries and Operations
1 Introduction to SQL: instalation and setup of MySQL workbench
2 SQL queries: Select, from, where, group by order by
3 Operators: Arithmetic, comparison and logical operators.
4 Functions in SQL: Numerical, String, Aggregation and datetime.
5 Table creation and constraints
6 Data modification: update alter and delete
Advanced SQL Operations
1 Joins in SQL: Inner, Left and Right
2 Window operations
3 Stored Procedures, functions and triggers.
4 Best Practices: View, Common Table Expressions, and indexing
Lesson End Project
Course Curriculum
Data Visualization using
PowerBI
Duration: 16 hrs live (No of learners <= 25)
Minimum Qualification: Graduate or apprearing
Introduction to Basic Concpets
1 Introduction to PowerBI
2 Connecting to data sources
3 Data transformation: Power Query Editor
4 Data Modelling and Data Profiling
5 Basic Charts: bar chart, pie charts, line charts etc.
Advanced Data Transformation and Modeling
1 Advanced Power Query Editor: Intro to M language.
2 DAX (Data Analysis Expressions) Fundamentals
3 Advanced DAX: Time intelligence, Iterative functions etc.
4 Creating Conditional Columns, Custom Columns, and Hierarchies
Advanced Data Visualization and Dashboards
1 Customizing Visualizations: Drilling, Conditional Formatting, etc.
2 Creating Interactive Reports: tooltips, bookmarks, page navigation
3 Using AI Visuals, Forecasting and What-If Parameters
4 Best Practices in Dashboard Design
5 Publishing, Sharing, and Administering Power BI
Lesson End Project
Course Curriculum
Python Programming
Duration: 20 hrs live (No of learners <= 25)
Minimum Qualification: Graduate or apprearing
Introduction to Python and core data-structures
1 Why Python?
2 Python IDEs and working with Jupyter lab
3 Basic Data types and type casting
4 List, tuple set and dictionary methods
Control Statements, Loops and Functions
1 Control Statements
2 For and While loops, nested loops
3 Functions in depth(Def, lambda), Generator functions
4 Scope of variables
Module Basics and Numpy
1 Creating and importing modules
2 Numpy arrays and important functions
String Functions and regular expressions
Python memory Management
Error handling, logging and debugging
Lesson End Project
MEET YOUR MENTORS
Nimisha, Founder and Managing Director of Learners
Galaxy, is an alumnus of NIT Trichy. She carries a
decade of experience in AI training and consulting.
She worked with Cargill Foods, one of the largest
privately-owned corporations in the world.
NIMISHA PANDEY
Shubham Pandey, CEO of Learners Galaxy, is
an alumnus of the Indian School of Business
Hyderabad. With over 13 years of experience
in Data Science, he brings a wealth of
knowledge to his role. Before joining Learners
Galaxy Pvt. Ltd., Shubham honed his skills at
renowned companies such as Publicis,HCL
Technologies, and American Express.
SHUBHAM PANDEY
LAND YOUR DREAM JOB
PREPARING FOR PLACEMENT SUCCESS
RESUME BUILDING
Craft a standout resume that rises above the competition.
Discover how to tailor your resume for each job description,
ensuring it reflects your unique qualifications and increases your
chances of being shortlisted effortlessly.
INDIVIDUAL DEVELOPMENT
we facilitate the development of each student by tailoring
educational experiences to their unique strengths, interests, and
learning styles. Through personalized feedback, adaptive learning
platforms, and interactive content, we empower students to
progress at their own pace, cultivate essential skills, and reach their
full potential.
MOCK INTERVIEW
Prepare for your significant moment with guidance from experts and
mentors. Receive valuable feedback to ensure you're primed to
perform when the opportunity arises.
