• Search for:

    Data Analysis Syllabus

    What You’ll Learn:

    📊 Module 1: Microsoft Excel (Basic to Advanced)
    • Build dynamic spreadsheets with formulas, charts, and pivot tables.
    • Master data cleaning, sorting, filtering, and advanced functions.
    • Use Excel’s powerful data analysis tools like Lookup Functions, Conditional Formatting, and more!
    💻 Module 2: SQL – Oracle/SQL Server
    • Extract, manipulate, and manage data using SQL.
    • Learn how to join multiple tables, run complex queries, and perform data aggregation.
    • Gain proficiency in DDL and DML statements for effective database management.
    📊 Module 3: Power BI
    • Visualize and analyze data from multiple sources with Power BI.
    • Create stunning interactive dashboards and reports.
    • Learn advanced features like DAX functions, and mobile integration for on-the-go analysis.
    📈 Module 4: SPSS Statistical Software
    • Conduct advanced statistical analyses including regression, ANOVA, and correlation tests.
    • Perform time series forecasting, decision trees, and longitudinal analysis.
    • Learn to use SPSS for data manipulation, visualization, and reporting.
    COST: N200,000.00 or $150 or £100P ACCOUNT NAME: TEKBISERV LTD, ACCOUNT NUMBER: 1221395988, BANK NAME: Zenith Bank Plc.

    Click to apply here

    Data Science course syllabus

    Module 1: Python
    • Environment set-up
    • Jupyter
    • Python Numpy
    • Python Pandas
    • Python Matplotlib
    Module 2: Statistics
    • statistical concepts used in data science
    • Difference between population and sample
    • Types of variables
    • Measures of central tendency
    • Measures of variability
    • Coefficient of variance
    • Skewness and Kurtosis
    Module 3: Inferential statistics
    • Normal distribution
    • Test hypotheses
    • Central limit theorem
    • Confidence interval
    • T-test
    • Type I and II errors
    • Student’s T distribution
    Module 4: Regression and Anova
    • Regression
    • ANOVAR square
    • Correlation and causation
    Module 5: Exploratory data analysis
    • Data visualization
    • Missing value analysis
    • The correction matrix
    • Outlier detection analysis
    Module 6: Supervised machine learning
    • Python Scikit tool
    • Neural networks
    • Support vector machine
    • Logistic and linear regression
    • Decision tree classifier
    Module 7: Tableau
    • Working with Tableau
    • Deep diving with data and connection
    • Creating charts
    • Mapping data in Tableau
    • Dashboards and stories
    Module 8: Machine learning on cloud
    • In this lesson, you will learn ML on Microsoft Azure
    COST: N200,000.00 or $150 or £100P ACCOUNT NAME: TEKBISERV LTD, ACCOUNT NUMBER: 1221395988, BANK NAME: Zenith Bank Plc.

    Click to apply here