Hartron Advance Skill Centre Chandigarh

Junior Data Analyst

S. No. NOS / Module Name Topics Theory (Hours) Lab (Hours) Learning Outcomes
1 Perform basic calculation using spreadsheet Introduction to data analytics and data science, Windows and Spreadsheet 15 15 • Understand the features of Spreadsheet
• Create & save worksheet/workbook
• Understand layouts, text formats, alignment
• Use basic functions, formulas, sorting
• Understand graphs in Excel
2 Manage structured data Database concepts 15 15 • Introduction to databases & advantages of DBMS
• Keys: candidate, primary, alternate, foreign
• Entity & referential integrity
• ER model & SQL basics
• Knowledge Discovery, Data Mining, Data Warehouse
• Data migration, cleaning & aggregation
3 Analyze data using spreadsheet tool Fundamentals of statistics, Pivot Table, What-if Analysis 30 60 • Data formatting & conditional formatting
• Charts & advanced charting
• Pivot Table & data validation
• Filtering & advanced filtering
• What-if analysis, probability, regression & descriptive statistics
4 Manage data in Open Source tool Linux basics, Ubuntu installation, Commands & Permissions 15 15 • Setup virtual machine & Ubuntu
• File system, mounting, searches
• Text editors, commands, piping & filtering
• Users, groups, permissions & security
5 Visualize data graphically Tableau 20 40 • Introduction to Tableau
• Connect to Excel, CSV & Databases
• Formatting, sorting & charts
6 Installation of Hadoop & Java Programming Hadoop framework & Core Java 15 15 • Install Hadoop & environment setup
• Java basics: OOPs, loops, methods, arrays
• Method overloading & overriding
• HDFS concepts & commands
• Hadoop cluster setup & architecture
7 Manage big data using Hadoop Big Data analytics with MapReduce & Hive 30 30 • Big Data concepts & business importance
• MapReduce implementation
• Hive concepts & case studies
8 Front end application development Java with Hive 20 40 • Advanced Java concepts
• Applets & Swings
• JDBC connectivity, ODBC bridge
• Database connectivity with Applets
9 Implementation of use cases Use cases in Data Analytics 20 40 • Practical implementation of data analytics use cases
10 Employability Skills Soft skills & communication 60 • Job readiness & professional development skills
11 OJT / Project On-the-job training 30 • Hands-on exposure to workplace environment
Total Duration 540 —
S. No. Module Name Topics Theory Hours Lab Hours Total Hours Learning Outcomes
1 Fundamentals of Network and Operating System
  • Basic networking concepts including IP addressing, routing, and protocols
  • Principles of operating systems – file management, system processes, user interfaces
  • Network devices – routers, switches, firewalls and their interactions
  • Network settings configuration and troubleshooting
  • Operating system management, updates and system security
 30 60 90
  • Acquire knowledge of basic networking concepts, including IP addressing, routing, and network protocols.
  • Learn the principles of operating systems, such as file management, system processes, and user interfaces.
  • Understand how different network devices (routers, switches, firewalls) interact within a network.
  • Gain practical skills in configuring network settings and troubleshooting common networking issues.
  • Develop the ability to manage operating system settings, perform system updates, and ensure system security.
2 Fundamentals of Cyber Security
  • Cybersecurity concepts – threats, vulnerabilities, and protocols
  • Data protection – encryption, access control, secure storage
  • Role of security tools – firewalls, IDS/IPS, antivirus
  • User authentication and access control
  • Cyber threat identification and mitigation
 50 100 150
  • Acquire knowledge of key cybersecurity concepts, including threats, vulnerabilities, and security protocols.
  • Learn the importance of data protection strategies, such as encryption, access controls, and secure storage.
  • Understand the role of firewalls, intrusion detection/prevention systems, and antivirus software in defending against cyber-attacks.
  • Gain practical skills in implementing security measures such as secure authentication, authorization, and user access controls.
  • Develop the ability to identify common cyber threats, including malware, phishing, and denial-of-service attacks.
3 Cryptography and Ethical Hacking
  • Cryptographic algorithms and applications
  • Symmetric and asymmetric encryption techniques
  • Ethical hacking methodologies and tools
  • Penetration testing and system vulnerability assessment
  • Public Key Infrastructure (PKI) and digital certificates
 25 35 60
  • Develop a thorough understanding of cryptographic algorithms, their applications, and their role in securing communication.
  • Learn how to implement encryption and decryption techniques, including symmetric and asymmetric cryptography.
  • Understand ethical hacking methodologies and tools used to identify and exploit vulnerabilities in systems.
  • Gain practical experience in securing data and conducting penetration testing.
  • Demonstrate the ability to use cryptographic protocols and ethical hacking tools to strengthen system security.
4 Network and Infrastructure Security
  • Network security concepts – firewalls, IDS/IPS
  • Configuring network security devices
  • Secure network architecture and communication protocols
  • Mitigating common network attacks
  • Network monitoring and traffic analysis
 15 15 30
  • Understand network security concepts, including firewalls, IDS, and IPS.
  • Learn to configure security devices for protecting networks.
  • Understand secure communication protocols (TCP/IP) and network vulnerabilities.
  • Gain expertise in VPNs, network segmentation, and secure wireless setups.
  • Develop ability to monitor and analyze network traffic to detect and respond to threats.
Sub Total (A) 120 210 330 -
5 Employability Skills (B) - - - 60 Students will be able to get additional skills apart from technical skills, to be job ready.
6 OJT / Project (C) - - - 60 Students will be able to learn practical job-oriented working experience.
Total Duration (A + B + C) 120 210 450 -

Junior Data Analyst

  • Data is the heart of every organization's decision today. From e-commerce and banking to healthcare and IT, the companies rely on data to understand trends, areas of improvement and the growth of business. Skilled data analysts who can manage, interpret and visualise data are in very huge demand today worldwide.
  • Our Junior Data Analyst course is structured as a 12 months or 540 hours of learning programme that helps you to learn the skills related to technical and analytical information and structure to start a rewarding career in data analytics. With a perfect balance of theory, lab sessions and project-based learning, this course prepares you to transform raw data into meaningful insights. No need to find more; we are a one-stop solution for the junior data analyst course in Chandigarh.

Course Overview

  • We have a detailed course in which we give deep learning of how data works and how to analyse it for a meaningful output.

Duration: 12 months/540hours

  • Learning Methods: Classroom training + Practical Labs + OJT/Project
  • Focus Areas: Data analysis, visualization, Hadoop, big data, java, tableau and employability skills.

Modules of the course

  • The main modules of the courses are given below, which may help you to understand the overall course in a very easy manner.
  • - Perform Basic Calculation Using Spreadsheet
  • - Manage Structured Data
  • - Analyze Data Using Spreadsheet Tools
  • - Manage Data in Open Source Tool
  • - Visualize Data Graphically
  • - Installation of Hadoop Framework and Java Programming
  • - Manage Big Data Using Hadoop
  • - Front-End Application Development
  • - Implementation of Use Cases in Data Analytics
  • - Employability Skills
  • - OJT / Project

Eligibility Criteria

  • Our eligibility criteria are very simple for any business. The junior data analyst course is open to students who want to start their careers in data analytics; the candidate should have completed it:
  • - 10+2 in any stream, OR
  • - Diploma in IT/CS/Electronics (after 10th , 12th)
  • - Pursuing UG programmes like B.Tech, BCA and BSC.
  • The candidate should have done any one of the above.

Why Choose Our Institute?

  • There are so many reasons to choose us; one of the biggest reasons is that we have years of experience teaching students, and our teachers are aware of all the modern and latest trends and technology. Find the best junior data analyst course in Chandigarh only at Hartron-Chandigarh.
  • - We cover everything from the spreadsheets and SWL to Handoop, big data and tableau.
  • - Hands-on learning experience sessions will make you the most learnt person.
  • - Industry-relevant tools will make you everything related to this learn Hadoop, tableau, SQL and java for complete data analytics exposure.
  • - Expert faculty and trainers with industry and academic experience.
  • - We provide support for placement like resume building, interview preparation and job guidance.

Career Opportunities

  • After completing the junior data analyst course, students can pursue roles such as:
  • - Data analyst – Junior level
  • - SQL Database analyst
  • - Tableau/BI developer
  • - Big data associate
  • - MIS reporting analyst
  • With further training and experience, career growth can lead to roles like Data scientist, business intelligence specialist or big data engineer.

Enroll Today

  • If you are passionate about working as a junior data analyst, solving problems and building your career in analytics, this is the best and right course for you that you can take from Hartron this year in Chandigarh. With structured learning, hands-on practice and experience and project-based training, our junior data analyst course will make you industry-ready in just 12 months. For more information visit our website to know more.
  • Plan to take admission in our next session to learn about the junior data analyst course.