Data Science Internship

Data science internship is a robust training program that spans state-of-the-art techniques of working with data and generating insights. (This training covers data analytics, which is only a sub-field within the field of data science).

You will learn how to build decision intelligence for businesses and organizations using data science techniques and tools. You will work with data from various sources and be trained on how to use machine learning algorithms to make sense of data and be able to automate decision-making processes for growth and engagement.

Data science is the world’s most in-demand field due to the enormous data generated by modern processes and technologies. This program teaches data science skills for overseas and local jobs and course content that aligns with overseas universities

What you will Gain from the Data Science Internship

  • ● Supportive and innovative teaching environment
  • ● Extra support sessions weekly
  • ● Practical teaching from resourceful and internationally trained instructors
  • ● Certification and Solid Project Portfolio
  • ● Employability skills
  • ● Job vacancies board
  • ● Course content that aligns with the data science industry internationally.

Technology Tools in this Internship

  • ● Python
  • Advanced Microsoft Excel and/OR Microsoft Power BI
  • ● SQL

Course Outlines

Foundational Statistics

Understanding Statistics in Plain English
When to Use a Particular Statistical Test

Python And Application Programming

You Will Learn To Understand Decision Support Systems Using Data Insights. You Will Work Your Way Up From Learning To Code, And Application Development To Leveraging Data To Automate Decision-Making Processes Across Various Industries And Fully Understand The End-To-End Process Of It.

COURSE OUTLINE 

Introduction to Python Programming
Git and GitHub for Version Control
Data Types, Arithmetic Operations, Python Lists, and List Comprehension
Conditional Statements (If Else, Elif, For Loops and While Loops)
Python Function Basics to Advanced
Project Design
Building and Deploying your First Python Application
Working with Numpy
Working with Pandas 1 & 2
Data Quality Assessment, Cleaning, Transformation and Reduction 1 & 2
Exploratory Data Analysis (EDA)
Data Visualization
Reading Data from SQL Databases using Python
Data Science in Industries
Introduction to Machine Learning and Machine Learning Algorithms
Introduction to Deep Learning and Advances in Deep Learning
Machine Learning with Regression
Machine Learning with Classification
Time Series Modeling
Final Industry Project

Basic to Advanced Excel 

This Excel fundamental to advanced course will equip you with the skills needed for data analysis and decision-making in various real-office scenarios. You will master using Excel for various use cases.

Module 1: Excel Fundamentals

  • Introduction to Excel
    • Understanding the Excel interface and basic navigation.
    • Entering and formatting data.
    • Basic calculations using Excel formulas.
  • Working with Functions
    • Exploring common Excel functions (SUM, AVERAGE, COUNT, etc.).
    • Using functions for basic data analysis.
    • Absolute and relative cell references.
  • Data Management and Visualization
    • Sorting and filtering data.
    • Creating basic charts (bar, line, pie).
    • Data validation and conditional formatting.
  • Advanced Formatting and Efficiency
    • Advanced formatting techniques.
    • Introduction to PivotTables.
    • Tips and tricks for working efficiently in Excel.

Module 2: Intermediate Excel Techniques

  • Advanced Functions
    • Using logical functions (IF, AND, OR).
    • Lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH).
    • Text functions for data manipulation.
  • Data Analysis Tools
    • Introduction to Excel’s What-If analysis tools.
    • Goal Seek and Scenario Manager.
    • Data Tables and Solver.
  • PivotTables and PivotCharts
    • In-depth PivotTable creation and customization.
    • PivotCharts for visual data analysis.
    • Slicers and Timelines.
  • Data Automation
    • Introduction to Macros and VBA (Visual Basic for Applications).
    • Recording and running macros.
    • Creating simple automation scripts.

Module 3: Advanced Excel Techniques

  • Advanced Data Analysis
    • Array formulas and advanced formula nesting.
    • Building complex calculations.
    • Introduction to Power Query for data transformation.
  • Data Models and Power Pivot
    • Creating data models in Excel.
    • DAX (Data Analysis Expressions) functions.
    • Combining multiple data sources.
  • Advanced Charting and Visualization
    • Advanced chart types (scatter, bubble, radar, etc.).
    • Customizing charts for meaningful insights.
    • Building interactive dashboards.
  • Excel Efficiency and Best Practices
    • Excel tips for efficiency and productivity.
    • Collaboration and data sharing in Excel.

MICROSOFT POWER BI

Microsoft power bi training will equip you with powerful skills for visualizing data from various sources by aggregating them on a dashboard for data-driven insights. You will build a fully interactive business intelligence dashboard for a real-life use case.

Introduction to Power BI for Decision Intelligence:
– Overview of Power BI and its significance in decision-making.
– Understanding the Power BI interface and its core features.
– Exploring data visualization concepts and best practices.
Introduction to Power BI for Decision Intelligence:
– Overview of Power BI and its significance in decision-making.
– Understanding the Power BI interface and its core features.
– Exploring data visualization concepts and best practices.
Data Preprocessing and Transformation in Power BI:
– Importing data from various sources into Power BI.
– Data cleaning, formatting, and handling missing values.
– Applying data transformation techniques to optimize data for analysis.
Introduction to Relationships and Model:
– Understanding the importance of data relationships in Power BI.
– Creating and managing relationships between different data tables.
– Designing an efficient data model for enhanced analysis capabilities.
More on Data Preprocessing and Transformation:
– Advanced data shaping techniques using Power Query Editor.
– Combining and merging data from multiple sources.
– Handling complex data transformations and calculations.
Introduction to DAX, Measures, and Calculated Columns:
– Introduction to the Data Analysis Expressions (DAX) language
– Creating measures and calculated columns for data analysis.
– Applying DAX functions to perform advanced calculations and aggregations.
Creating Data-Intelligent Visualization Reports and Dashboards:
– Designing visually appealing and interactive reports.
– Implementing various types of visualizations, such as charts, tables, and maps.
– Utilizing advanced features, such as slicers, drill-through, and bookmarks.

SQL

SQL is the language of databases. This course will equip you with practical skills in working with a popular database. You will learn how to query databases, extract data and transform data for further analysis.

COURSE OUTLINE

Introduction to Relational Database Management System:
– Understanding the fundamentals of relational databases.
– Exploring the components and structure of a database.
– Getting familiar with key database concepts, such as tables, columns, and relationships.
Hands-on MySQL Database:
– Setting up and configuring a MySQL database for practical exercises.
– Navigating and interacting with the MySQL command-line interface.
– Executing basic SQL queries to retrieve and manipulate data.
Creating SQL Database:
– Designing and creating a SQL database using appropriate data types and constraints.
– Defining primary keys, foreign keys, and relationships between tables.
– Ensuring data integrity and normalization principles.
Grouping and Summarizing Data with SQL:
– Using SQL’s aggregate functions (e.g., SUM, AVG, COUNT) to summarize data.
– Grouping data based on specific criteria for meaningful analysis.
– Applying filters and conditions to aggregate data effectively.
Using SQL to Select Data from More Than One Table:
– Understanding the concept of table joins in SQL.
– Utilizing different join types (e.g., INNER JOIN, LEFT JOIN, RIGHT JOIN) to combine data from multiple tables.
– Writing complex queries involving multiple tables to extract relevant information.
Using SQL Views:
– Creating and utilizing SQL views to simplify complex queries.
– Understanding the benefits and practical applications of views.
– Modifying and updating data through views.
Using SQL Sub-Queries:
– Leveraging sub-queries to perform nested and correlated queries.
– Incorporating sub-queries in various parts of a SQL statement.
– Applying sub-queries for advanced filtering and data manipulation.
Using SQL to Insert, Update, and Delete Data:
– Inserting new records into a database using SQL’s INSERT statement.
– Updating existing data using SQL’s UPDATE statement.
– Deleting unwanted data using SQL’s DELETE statement.
Using SQL Transactions:
– Understanding the concept of transactions in database operations.
– Implementing transaction control statements (BEGIN, COMMIT, ROLLBACK) to ensure data consistency and integrity.
– Handling errors and managing transactional operations effectively.

CLASS SCHEDULES (Please Select Physical or Online Training, Physical Training is Only Available in Nigeria (Abuja) for now. Our online training is also an excellent choice):

  • ● Online Training: (Class Days are: 8 pm, Thursday – Saturday). This time can be changed based on where your instructor is located, which will be matched to the time zone of where you live. You will receive further information on this before you begin your program).

  • ● Face-to-Face/Physical Training (Only available in Abuja, Nigeria for now): Class days are Monday, Wednesday and Thursday (10 am – 3 pm).

PROGRAM DURATION: 3 Months

OUR INSTRUCTORS ARE BASED AT THESE LOCATIONS:

  • ● U.K (Instructors Only teach Online Classes)
  • ● U.S/CANADA (Instructors Only teach Online Classes)
  • ● Abuja, Nigeria (Instructors teach both Face-to-Face and Online Classes)

Note: This program will have instructors from a combination of or any of these locations. You will normally be expected to be taught by instructors from any of these locations based on where you live.

REGISTRATION: Fill out the Form Below to Register and to Receive the Course Fee with a very Flexible Instalment Plan.

What Our Trainees are saying