Data Analytics &

Business Intelligence

15 weeks full-time
23 weeks part-time
classroom course

✓ Course developed by experts from India

✓ Get scholarship up to 80% on all courses
✓ Get Job Oriented training and be ready for interviews
✓ Training driven by Artificial Intelligence
 Why should you take this course?

250,000 new openings in the Data Analytics field in 2023. Data analysts are in
Demand!

The data analyst job market is expected to grow at a rate of 18% by 2024

Go beyond Kenya & Africa and get paid in Dollars $$

Get remote/freelancing/ full-time jobs from international companies!

In Kenya and across many parts of Africa, Software & IT industry is still small and many
graduates are job less.

Don’t worry, there is a good news:

1. Post covid-19, many companies started hiring employees from any part of world and
allow them to work remotely.
2. Many companies across the world started hiring freelancers and on an average pay is
45$ per hour. 1.57 billion people across the world are doing freelancing, you should
be one among them.

Secure your dream job in top tech & freelancing companies with our job-
oriented training

These days companies are conducting:

1. Live coding tests, specially in data structures & programming
2. Take home assignments to understand your technical skills
3. Deep technical interviews to see how sound you are
We will offer you Job oriented training to ensure that you will clear all the interview
rounds and secure a Job in your dream company.
 Course Features

Course Duration : 15 weeks Full time, 23 weeks Part time

Full time : 5 days a week, 10 AM – 5 PM
Part time : Mon, Tue, Wed 5 PM – 8 PM, Sat 10 AM – 5 PM

• Class room sessions led by instructors

• Get a course completion certificate
• Content from experts in industry
• Job oriented training
• Networking with industry professionals and students
• Placement assistance
• 1:1 mock interviews with Artificial intelligence tools
• Co-pilot with chatgpt and github copilot
• Get guided by Machine learning and receive personal
recommendations
• Special training to crack interviews with international top
tech companies (FAANG) and in freelancing portals like
toptal, turing, upwork and many more which have millions
of Jobs for tech specialists
• Live coding interviews training
• Resume & profile preparation assistance
• Real world projects & excercises
• Course is designed for working professionals & freshers
• Peer networking and group learning
• Monthly hackathons
• Team building activities
 Who can apply for this course?

1. Individuals with a bachelors degree who are interested in

business analysis, data analysis & project management

2. Working professionals who want to advance their career and

looking for a career transition as data analysts, business
analysts, analytics project manager

3. Any one who is interested in getting a job in international

companies which offer either full time/ freelancing jobs

4. Students specially from Business & administration, Engineering,

ICT, Mathematics & statistics, Actuarial science will be a good fit

5. If you do not have a degree, you can still join the course, you
might have challenge in finding a job but you can still freelance
or start your own company

6. For Graduates/Final year students, full-time is recommended

7. For Working professionals, part-time is recommended

 What will you learn?

Use SQL, Python, Power BI, Statistics & Regression techniques to

discover insights, design business dashboards, communicate critical
insights, design stratagies and create data driven solutions

Modules you will learn!

Module Full-time Part-time
Schedule Schedule
• Foundations Week 1 Week 1

• Artificial Intelligence – Co pilot Week 1 Week 1

• Advanced SQL Week 2 Week 2 & 3

• Data Wrangling & Manipulation Week 3 Week 3 & 4

• Exploratory Data Analysis Week 4,5 Week 4, 5, 6

• Inferential statistics Week 6, 7 Week 7, 8

• Time series analysis Week 7 Week 9,10

• Linear & Tree models for predictive Week 8, 9 Week 10, 11, 12
analytics
• Segmentation using clustering algorithms Week 9 Week 13

• Business Intelligence with Power BI Week 10 Week 14, 15

• Business intelligence with Tableau Week 11 Week 16

• Job & Interviews preparation Week 12-15 Week 17-23

Tech stack you will master!
 Course curriculum

Module 1 : Foundations
Description : Foundations to become a Data Analyst
Topics Covered:
1. Setting up the environment with Jupyter, VSCode & Anaconda
2. Programming with python – Variables, Operators, Conditions, Functions
3. Data structures with python – Lists, Sets, Dictionaries, Arrays
4. GIT repository - Create, add, commit, push, pull, branch, merge, stash, tag, rebase
5. Introduction to data analytics - Market, job opportunity, roles & responsibilities
6. Productivity tools - Miro, Coda, Piazza, Trello

Module 2 : Artificial Intelligence - Co-pilot

Description : Learn how to use AI tools to accelerate development
Topics Covered:
1. Chat GPT
2. Github copilot
3. Open AI Codex
4. Amazon code whisperer
5. AI tools for programming

Module 3 : Advanced SQL

Description : Learn how to use SQL to transform data and create summary
Topics Covered:
1. Databases & SQL - Databases, Tables, CRUD operations
2. Data cleansing & manipulation - group, joins, order by, where, trim, pad, coleasce,
pivot, unpivot tables, regex
3. Analytical functions - Partition by, window frame, analytical functions, ranking
functions, distribution functions
4. Indexing, Creating Views, Correlated sub queries
5. Common table expressions (CTEs)
6. Recursive CTEs
7. Date-time manipulation
Project: Stocks market data analysis with SQL
 Course curriculum

Module 4 : Data Wrangling & Manipulation

Description Understand how to connect to different data sources, extract the data and
transform with Pandas
Topics Covered:
1. Introduction to Pandas
2. Creating, reading & writing data frames
3. Data frames indexing & selecting
4. Connecting to different data sources (MySQL, Oracle, Postgre SQL)
5. Merge, Join, Concatenate & compare
6. Reshaping & pivot tables
7. Working with text data
8. Working with dates
Project: Retail sales data wrangling

Module 5 : Exploratory Data Analysis

Description : Learn how to explore data and gather insights with Pandas, Matplotlib,
Seaborn, Plotly
Topics Covered:
1. Data Cleansing - Handling missing values, outliers, transforming data types,
removing corrupt data, removing duplicates
2. Descriptive analytics - Mean, Median, Mode, Standard Deviation, Quartiles, Inter
quartile range, Variance, Correlation, bin distributions, Covariance, univariate,
bivariate & multivariate analysis
3. Entity summary - Identify entity, group data & derive summary
4. Data Visualization - Histogram, bar plots, line plots, stacked charts, area charts,
column charts, combo charts, donut & pie charts, funnel charts, map charts, scatter
plots, bubble plots, 3D plots, animated charts
5. Gathering business insights - Deriving KPI’s for chosen entity like best performing,
worst performing, summary of entity over time, creating business power points.
Project : Retail sales data analysis
Project: Banking loan data analysis
 Course curriculum

Module 6 : Inferential statistics

Description : Using statistics, dig deeper into data, understand the distributions,
correlations and do hypothesis testing to draw conclusions with scipy, numpy
Topics Covered:
1. Introduction
2. Distributions - Discrete, Bernoulli, binomial, Poisson, continuous, normal,
confidence intervals, skewness, kurtosis, Percentiles, Z-Scores, Density curves,
Random variables
3. Confidence intervals - Introduction, sample, population
4. Sampling distributions - sample proportion, sample mean, central limit theorem
5. Significance tests & Inference - Hypothesis testing, Analysis of variance, t-test, z-
test, Anova, One way Anova, Two way Anova, Chi square test
6. Predictive power - Information value, weight of evidence
Project : Product marketing & sales hypothesis testing

Module 7 : Time series analysis

Description : Using time series analysis learn how to forecast based on past data events
using statmodels & advanced packages
Topics Covered:
1. Seasonal decomposition - trend, seasonality & random components
2. Stationary & non-stationary time series events
3. Moving average - Simple, Weighted & Exponential
4. Correlations - Auto & partial
5. Regressions models - ARIMA
6. Seasonal models - Holt, Holt winters, SARIMA
7. Advance packages in python - prophet, darts, pyflux, kats, autoTS
Project : Daily stock price forecasting
Project: Store sales forecasting
 Course curriculum

Module 8 : Linear & Tree models for predictive analytics

Description : Using regressions techniques, learn how to do predictions on numeric &
categorical data
Topics Covered:
1. Introduction - predictor & outcome variables, types of machine learning algos
2. Data preparation - training, testing & validation
3. Error metrics - MAE, MSE, RMSE, Confusion matrix, recall, precision..
4. Regression on numeric data - Linear regression
5. Regression on categorical data - Logistic regression
6. Other regression techniques - Ridge, Lasso, Polynomial
7. Tree based techniques - Decision trees
Project : Boston house price prediction
Project : Newyork city taxi trip duration prediction
Project: Credit card fraud detection

Module 9 : Segmentation using clustering algorithms

Description : Using clustering techniques to gather similar objects and create segments
Topics Covered:
1. K-Means clustering
2. Hierarchical clustering
Project : Credit card customer segmentation
 Course curriculum

Module 10 : Business Intelligence with Power BI

Description : Using power BI build business dashboards and enable organizations to
make data driven decisions
Topics Covered:
1. Introduction - Options, settings and navigation
2. Art of story telling
3. Connecting & shaping data
4. Creating table relationships & data models
5. DAX calculations
6. Data visualizations - bar plot, stacked bar plots, column charts, line charts, area
charts, combo charts, pie charts, donut charts, gauge charts, funnel charts, scatter
charts, bubble charts, waterfall charts, maps, slicer charts, matrix, table charts,
aster plot, bullet charts, working with filters
7. Building stories with Power BI
Project : Customer shopping dashboard

Module 11 : Business Intelligence with Tableau

Description : Using Tableau build business dashboards and enable organizations to
make data driven decisions
Topics Covered:
1. Introduction - Options, settings and navigation
2. Connecting & wrangling data, creating calculated fields, creating hierarchies,
changing data types
3. Data visualizations - bar plot, stacked bar plots, column charts, line charts, area
charts, combo charts, pie charts, donut charts, gauge charts, funnel charts, scatter
charts, bubble charts, waterfall charts, maps, slicer charts, matrix, table charts,
heat mas
4. Working with time series data
5. Creating dashboards & stories
Project : Amazon Products Sales dashboard
 Course curriculum

Module 12 : Job & Interviews preparation

Description : Intense preparation to crack job interviews with top tech companies and
freelancing giants
Topics Covered:
1. SQL live coding questions
2. Python data analysis live coding questions
3. Take home data analysis projects preparation
4. Take home power BI project preparation
5. Mock interviews with AI tools & peers
6. Building profile on Linkedin & other free lancing websites
 Projects you will work on

1. Stocks market data analysis with SQL

2. Retail sales data wrangling
3. Retail sales data analysis
4. Banking loan data analysis
5. Product marketing & sales hypothesis testing
6. Daily stock price forecasting
7. Store sales forecasting
8. Boston house price prediction
9. New york city taxi trip duration prediction
10.Credit card fraud detection
11.Credit card customer segmentation
12.Customer shopping dashboard
13.Amazon Products Sales dashboard
 How to apply, fee & scholarship

Course fee : 210,000 ksh / 2100$

Scholarship : Up to 80% (168,000 ksh)

Process for scholarship:

1. Any one can apply for scholarship and everyone will be considered
for scholarship if the students are from Africa.
2. Working employees, students and graduates can apply for
scholarship.
3. After applying, you will have to come to Ramana head office and
take an assessment followed by interview.
4. Based on education merit, assessment result, interview and
financial back ground, students will receive up to 80% scholarship

Payment options

1. Full payment
2. Two installments in first two months @1% interest
3. Three installments in first three months @ 2% interest
4. Four installments in first four months @3% interest
 Contact us

Phone number: 0799369972

Email : info@ramanatechschool.com

Address:
Ajit Chambers, Mbagathi Way, Nairobi