dimplat tech logo
[object Object] hero image

DATA ANALYTICS

learn the latest analytics tools and techniques, how to work with SQL, the languages
of R and Python, the art of creating data visualizations, and how to apply statistics and
predictive analytics in a business environment.I

duration svg

Chat with us

ADMISSION REQUIREMENTS

  • Educational Background:

    • You don't need to have a certificate to apply for this diploma program. We expect anyone to take the program
  • Work Experience and Certifications:

    • You don't need to have work experience to learn this traxk
  • Language Proficiency

    • The Course is conducted in English, so applicants must have a basic understanding of the English language to effectively engage with the curriculum and participate in discussions.

COURSE OUTLINE

In this immersive 6-month Data analysis course, you will achieve the following learning outcomes

star icon

Introduction to the course

  • Objectives and learning outcomes
  • Excel Basics
  • Overiew of Excel interface and features
  • Data Manipulation
  • Data entry and formatting
  • Sorting and filtering data
  • Using conditional formatting
star icon

Advanced Excel Functions

  • Lookup functions (VLOOKUP, HLOOKUP)
  • Data validation
  • Text functions
star icon

Data Visualization

  • Creating chearts and graphs(bar, line, pie, scatter)
  • Pivot Tables and Pivot Charts
  • Dashboard creation
star icon

Practical Exercise

  • Dimpalt Technologies | Data Analysis Curriculum | obinwa Chinma Joy
  • Module 2: Data Analysis with Power BI
star icon

Introduction to Power BI

  • Overiew of Power BI and its components
  • Connecting to data sources
star icon

Data Transformation and Modeling

  • Using Power Query for data cleaning
  • Data modelling basics
  • Creating relarionships between tables
star icon

Data Visualization

  • Creating and customizing visualiztion (charts,map,tables)
  • Using slicers and filters
  • Designing and interactive dashboards
star icon

Advanced SQL

  • Subqueries and nested queries
  • Using slicers and filters
  • Designing interactive dashboards
star icon

Github for Data Analysts

  • Introduction to Github and version control
  • Creating a Github account
  • Uploading projects and datasets
  • Writing effective README files
  • Best practices for code documentation
  • Building a Portolio
  • Importance of a professional portfolio
  • Showcasing projects using Github Pages or other Platforms
  • Tips for creating an impactful portfolio
  • Creating a Professional CV
star icon

Key components of a data analyst CV

  • Highlighting relevent skills and projects
  • Tailoring the CV for different job applications
  • Linkedin for Data Analysts
  • Creating a LinkedIn account
star icon

Practical Exercise

  • Setting up Github, LinkedIn, and portfolio site
  • Uploading projects and optimising profiles

COURSE TUITION FEE

DIPLOMA/ON SITE MODE

PRIVATE PHYSICAL CLASS:

₦400,000

GENERAL PHYSICAL CLASS:

₦250,000

This fee can be paid in up to 2
installments

DIPLOMA/VIRTUAL MODE

PRIVATE VIRTUAL CLASS:

₦250,000

GENERAL VIRTUAL CLASS:

₦150,000

This fee can be paid in up to 2
installments

CAREER OUTCOME

Prepare to become a Data analyst

  • Demonstrate your proficiency in portolio-ready projects
  • Earn your Diploma Certificate
  • Quality for in-demand job roles as a Data Analyst

Subscribe to Our News Letter

Subscribe today and get special offers, coupons and news