Data Analytics

Overview:

Data Analytics is one of the cores of the tech industry, our Data Analytics course is designed to you with essential skills for driving innovation and making strategic decisions. It is ailored to meet the needs of beginners and those looking to enhance their analytical abilities, this course is ideal for anyone who is kickstarting their Data Analytics career or aiming to upskill. Regardless of your background or experience level, our course is designed to empower you to leverage on the power of data effectively.

With a flexible delivery model, our course fits seamlessly into your busy schedule, allowing you to progress at your own pace. Divided into different modules, learning becomes convenient while balancing other commitments. Join our transformative Tailored Data Analytics Training Programme today to unlock the potential of data and pave your way to a successful career as a proficient Data Analyst in the tech industry.

REGISTER NOW!

What You Will Learn

  • Foundational Concepts: You will understand the basics of data analysis using Microsoft Excel, Power BI, and SQL. Learn how to work with data, analyse it, and present your findings clearly.
  • Hands-On Experience: You will gain hands-on experience by diving into practical exercises and projects. You’ll get to work with real data, create reports and dashboards, and run queries to find answers to different data related problems
  • Expert Guidance: you will get tips and guidance from experienced instructors who know their stuff. They’ll help you navigate through the tools and techniques of data analytics with ease.
  • Project Portfolio: You will build and showcase your skills with projects that demonstrate what you can do with Microsoft Excel, Power BI, and SQL. You will display your ability to analyze data and make smart decisions based on your findings.

By the end of the course, you’ll be equipped with the skills you need to excel in data analysis using Microsoft Excel, Power BI, and SQL, setting you up for success in the tech industry.

Curriculum Overview:

MICROSOFT EXCEL
  • Introduction to Microsoft excel
  • Excel functions/formulas
  • Data visualization: charts and graphs
  • Pivot tables
  • Building dashboards and interactive dashboard
  • Power query & power pivot
POWER BI
  • Introduction to Microsoft power bi
  • Data modelling
  • Introduction to Dax (Data analysis expression )
  • Dax functions
  • Creating reports and dashboard
  • Power bi service
SQL – STRUCTURED QUERY LANGUAGE
  • Introduction to STRUCTURED QUERY LANGUAGE (SQL)
  • Relational Databases, working with Database and Table
  • Basic SQL and Data Manipulations
  • SQL Aggregations
  • SQL Data Cleaning
  • SQL JOIN (working with multiple tables)
  • SQL Sub-queries and Temporary Table
  • SQL Window Functions

Course Outline:

· Duration: 12 Weeks

· Training Structure: Interactive lectures, Project based learning activities and Internship.

· Schedule: Classes held every Monday, Tuesday and Thursday from 7:00 PM to 8:30 PM.

· Level: Designed for beginners, no prior experience required and for Intermediates.

· Prerequisites: None.

· Start Date: Course begins on March 4th 2024.

Who Is This Program For:

This course is designed for:

  • Those new to data analysis, eager to learn the basics.
  • Individuals aiming to build a strong foundation in data analytics using Microsoft Excel, Power BI, and SQL.
  • Those with some experience in data analysis, looking to broaden their skills,
  • Those with some experience in data analysis, looking to broaden their skills.
  • Anyone interested in the practical applications of data analytics across various industries, from business intelligence to decision-making.
  • Whether you’re a complete beginner or have some experience, this course offers a clear learning path to help you succeed in the field of data analytics. Join us on this enlightening journey into the world of data analysis.
REGISTER NOW!