Navigating the World of Data

Embark on your data analysis career journey today

Unlock the full potential of data with Nepsix’s comprehensive 16-week Data Analysis Training Program

Enroll Now

Who is this course for?
Young and Advance People Looking For Job Students & Recent Graduates Entrepreneurs & Business Owners Beginners & Career Changers Freelancers & Consultants:

What do I need to Join this training?

Each Participant must have to the following:

  • A laptop/ Computer with Working webcam and Mic.
  • A Browser Installed on your PC and Fast Internet
  • Working Gmail Account to Access Google Drive
  • Zoom for Online Participants
  • A Willing and Consistent Mind

Tools and Technologies:

Microsoft Excel

  1. Introduction to Data Analytics
  2. Introduction to Microsoft Excel
  3. Formatting and Managing Data
  4. Formulas and Functions
  5. ETL Process in Excel
  6. Data Visualization
  7. Excel Pivot Table and Chart
  8. Excel Dashboards
  9. Data Analysis in Excel
  10. Case Studies

Power Bi

  1. Introduction to Power BI
  2. ETL Processes in Power BI
  3. Data Modelling
  4. Data Visualization in Power BI
  5. Dax and Measures
  6. Power BI Dashboards
  7. Power BI Service and Sharing
  8. Integration with Other Tools
  9. Case Studies

Structured query language (SQL)

  1. Introduction to SQL
  2. Basic SQL Commands
  3. Data Manipulation with SQL
  4. Advanced SQL Queries
  5. Data Analysis with SQL
  6. Window Functions
  7. Working with Dates and Times
  8. Exporting and Importing Data
  9. Connecting SQL with Reporting Tools like Power BI and Tableau
  10. Case Studies
  11. Portfolio Structuring and Interview Preparation

What is a Capstone Project

A capstone project in a Data Analysis course at Nepsix is a comprehensive assignment where students apply their learned skills to a real-world data problem.

It encompasses defining a problem statement, gathering and preparing data, performing exploratory analysis, and applying statistical and machine learning methods to analyze the data.

The project culminates in interpreting the results and presenting the findings in a detailed report or presentation. This project demonstrates a student’s ability to conduct end-to-end data analysis, from problem identification to data-driven conclusions, and is a crucial part of their academic and professional portfolio.

× How can I help you?