Online

Data Analytics Bootcamp

The Data Analytics Bootcamp is a Beginners’ Course designed to equip individuals with relevant skills and knowledge in tools like Excel, SQL & Power BI

Download the Syllabus

DOWNLOAD SYLLABUS - ONLINE

We are delighted to give you a peep into our packages. Kindly provide your details below after which you’ll be able to download our syllabus.

Applications are currently Open!

Duration

8 Weeks

Start Date

16th November, 2024

Level

Beginner

Training Structure

8 weeks of Learning

Projects

1 Project

Cost

₦200,000 ₦150,000

Welcome to our 8-week Data Analytics online course!

Are you ready to unlock the power of data and embark on an exciting journey of insights and discoveries? Whether you’re a beginner or looking to enhance your existing skills, this course is designed to equip you with the essential tools and knowledge to become a proficient Data Analyst.

Throughout this comprehensive program, we will cover a wide range of topics that are essential for a successful career in data analytics. From mastering Microsoft Excel to working with Structured Query Language (SQL) and delving into data visualization with Power BI, this course will provide you with a solid foundation in data analytics.

In this bootcamp, you will learn the following:

  • Microsoft excel
  • Working with structured Query Language
  • Cleaning and Analyzing Data – Excel, Data analysis, Cleaning
  • Learn the fundamentals of data visualization, know how to import and transform different data sources into Power BI.
  • Understanding of basic computer functionalities.
  • Laptop (Specifications: 8gb -16gb RAM, 256SSD or 500gb)
  • Dedication to learning and building a career in Data Analytics
  • Reliable Internet connection

WEEK 1

Module 1: Introduction to Microsoft Excel

  • Rows Vs Columns and Cells
  • Shortcuts in Excel
  • Inserting and Deleting Rows and Columns
  • Hiding/Unhiding Rows and Columns
  • Moving and copying in Excel
  • Find and Replace
  • Freezing Panes
  • Entering Data with Autofill
  • Flash Fill
  • Adding Comments
  • Splitting Screens Horizontally and Vertically
  • Protecting your workbook and worksheet
  • Proper upper and lower function
    Assignment/Quiz

Module 2: Functions and Operators

  • Conditional & Logical Operators
  • Basic Statistics Functions
  • LookUp and Reference Functions
  • Text and Date Functions
    Assignment/Quiz

WEEK 2

Module 3: Introduction to Database & SQL Module

  • SQL Intro and setup
  • Database fundamentals
  • Management System
  • Data and Metadata
  • Flavours of Database
  • Database Objects
  • Database terminologies
    Assignment/Quiz

Module 4: Structured Query Language

  • Building tables with CREATE TABLE
  • Adding table rows with INSERT
  • Changing row content with UPDATE
  • Retrieving data with SELECT
  • Finding the highest/lowest values with MAX and MIN
  • Applying filter conditions with WHERE
  • Removing tables with DROP TABLE
  • Sorting the result with ORDER BY
    Assignment/Quiz

WEEK 3

Module 5: Pivot Table

  • Structuring source data, navigating the Field List, creating & manipulating tables, etc
  • PivotTable Formatting: Conditional formatting values, applying default & custom styles, adjusting table layouts
  • Sorting, Filtering & Grouping: Sorting data, applying label & value filters, adding wildcards, grouping values
  • Calculated Fields & Values
    Assignment/Quiz

Module 6: Pivot Charts

  • Building PivotCharts
  • Adding slicers & timelines, creating dynamic dashboards etc

Module 7: Dashboard and Reporting in Excel

  • Data Organization
  • Pivot tables design and layouts, Interactive data exploration
  • Conditional formatting
  • Interactie controls
  • Charts and graphs
    Capstone Project

WEEK 4

Module 8: Introduction to Power BI and Preparation

  • Introduction to Power BI interface

Module 9: Data Cleaning

  • Cleaning, Transforming and loading Data
  • Understanding Rules For Clean Data
  • Mastering the thought for data Processing
  • Carrying out basic Data Transformation in power Query
    Capstone Project

Module 10: Cleaning Bad data with POWER BI TRACKS Power Query

  • Carrying out major Data Transformation in power Query
  • Tracing Query Errors
  • Connecting to Data Sources
  • Query Parameters
  • Query Dependencies

WEEK 5

Module 11: Data Modelling

  • Mastering Data and Model Build
  • Understanding the Concepts of FACT & DIMENSION Tables
  • Understanding Relationship Types in Power BI
  • Common errors and Resolutions in Data Models
  • Data normalisation
  • Understanding Relationships in Data Models
  • Common errors and relations in Data Models
    Capstone Project

Module 12: DAX Formula language

  • Mastering The golden Rules of DAX
  • Understanding how the DAX Engine works
  • Understanding how the DAX Engine Works
  • Understanding the DAX Evolution Context
  • Writing Simple DAX Measures
  • Introduction to the CALCULATE Function
  • Writing Time Intelligence Formulas
  • Writing Variance Formulas
    Capstone Project

WEEK 6

Module 13: Reporting and Data Visualization in Power BI

  • Create Reports
  • Create Dashboards
  • Perform Advanced Analytics
  • Create and Manage Workspaces
  • Manage Datasets in Power BI
  • Row-level Security
  • Building Reports & Visualisations
  • Understanding the Power BI Desktop Interface & Controls
    Capstone Project

Module 14: Data Visualisation

  • Sharing reports with other users
  • Setting up Auto Refresh & Data Gateways
  • Creating Power BI Dashboards
  • Designing Reports & Dashboards for Mobile view
  • Analysing Power BI Reports in Excel
    Capstone Project

WEEK 7

Module 15: Power BI Service

  • Creating developer microsoft account
  • Publishing reports to the Power BI Online Service
  • Understanding Workspaces
  • Understanding Self Service BI
  • The power BI EcoSystem
  • The 4 Skills needed to Master Power BI Getting Data with Power BI
    Capstone Project

Module 16: Power BI Service

  • Creating developer microsoft account
  • Publishing reports to the Power BI Online Service
  • Understanding Workspaces
  • Understanding Self Service BI
  • The power BI EcoSystem
  • The 4 Skills needed to Master Power BI Getting Data with Power BI
    Capstone Project

WEEK 8

Capstone Project Review and feedback
Capstone Project Presentation and Career Development

Kehinde Adegbola

Job build Technician
Severn Trent

Speak To a Learning Advisor
Speak To a Learning Advisor Form - Online

Come with expectations

100% Live Online Classes

You’ll be taught and mentored by some of the best teachers in the industry.

100% Instructor-Led classes

You will be taught & mentored by Industry expert.

Certificate

Get your very own physical certificate to prove your participation

Support System

Become part of an ever-growing, supportive community of like minds

Hands on Assignment

Grow with individual assignment feedback from your instructor.

Community Discussion

In app forum to collaborate with your peers.

Project Based Training

An hands-on approach to horn the skill you have learnt.

Success Stories

FAQs

Our program is 100% online, Live training program within the comfort of your home. However, if you are interested in our physical program click here.

A typical program at Univelcity runs for 3 Months, while our Fullstack program runs for 6 Months.

We are at No. 42 Montgomery Road, Yaba, Lagos (Adepate House).

Yes, we have evening classes. This class is structured best to suit individuals who have busy weekends.

The online classes are held every Saturday of the week 10 AM – 1 PM and Sunday 2PM – 5PM or 5PM – 8PM. We recommend this program if you are unavailable during the weekdays but would love to still learn an IT skill

Yes, you can. To join the waiting list, kindly apply for your desired course and get to let us know which cohort you intend to enroll for. We will get in touch with you.

You will see the dates for our next cohorts on your desired course of interest page. Feel free to reach out to us should you require clarifications. We will be happy to answer any questions and get in touch with you as soon as applications are open for another cohort.

Yes, you will be requiring a laptop. All our classes are hands-on and very practical.

Visit our FAQ Page for more help

Data Analytics Bootcamp

The Data Analytics Bootcamp is a Beginners’ Course designed to equip individuals with relevant skills and knowledge in tools like Excel, SQL & Power BI

Download the Syllabus

DOWNLOAD SYLLABUS - ONLINE

We are delighted to give you a peep into our packages. Kindly provide your details below after which you’ll be able to download our syllabus.