CONTACT:
Ghana: William KyeiBaffour: +233 24 561 8148
Nigeria / Others: +2347026283139
Download Outline Here!
K-Analytics 3 in 1 Program Outline
Brief.
OUR
FUNCTION POOL LISTING:
WARNING:
It is a must for all participants to watch
the pre-training video before training date
Download from Blog:
https://k-analytics.blogspot.com/p/k-analytics-3-in-1-program-data.html
Week 1 (JANUARY 28, 29 and Weeknight 40min if necessary):
A.
Quick Touch:
· Your Excel Version and Keyboard
· Formula and functions: Aggregate function, Text
Functions and SUMPRODUCT
· Named
ranges
· First
level Visualization
· Number
Formatting [pre-installed]
· Conditional
Formatting [MOM/YOY/QTQ Change vs. Trend]
B.
· Excel
Table and Range
· Logical
functions (IF, IFS, NESTEDIF etc.) Conditionals
· Cell
Referencing key concept
C.
Data Analysis (Single and Multiple criteria):
Functions (and with named range),
Creating Unique LIST/ Data Validation / (Dynamic
reporting)
D. R programming – Base R
Introduction to Programming. Introduction to R (Base
R and R Studio). Installation of Packages, creating Variable and Variable
types, performing calculation and doing simple plots, Data frame –creation and
manipulation. Data exploration using R
E. Having a Glimpse of Power BI
Week 2 (FEBRUARY 4 , 5 and Weeknight 40min if necessary):
A.
·
Data Analysis 2 (Multiple Criterion):
Functions (with named range) – if
not covered in previous week.
· PIVOT
TABLE
B.
LOOKUP Functions (V,H-LOOKUPS, INDEX
& MATCH, XLOOKUP)
C.
Introduction to Power BI, Power Query
and first level visualization
D.
R programming – Using R packages
Data
frame –creation and manipulation, Creating
a project, importing, and manipulating data, Data analysis with R
Week 3 (FEBRUARY 11 , 12 and Weeknight 40min if necessary):
A.
Date Calculations [Dealing with
Dates]
B.
Data Analysis with Power BI and
Introduction to DAX
C.
Dealing with Number Text
D.
More on R
Week 4 (FEBRUARY 18 , 19 and Weeknight 40min if necessary):
A. Bringing
everything together in Cases and Scenarios (Projects)
B. Data
Analysis with Power BI
What’s New in K-Analytics: Introducing
K-Analytics Excel workstream
Type: Excel Workbook
Aim: To help
participants work their analytic skill to remembrance by giving them a wide
range of data problem covering the key concepts learnt in the course. Solving
this workstream every now and then keeps your analytic mind sharp; even if you
are not an active data analyst. The idea is ------ always go back and solve
from scratch again and again. Analytics is a skill and a skill is in action not
in words. You leave it, it leaves you.
Download Outline Here!
OUR PROGRAM GOAL
To train participants in Data Analysis for Business Decision from 3 perspective. Our goal is to give participants the bird's eye view of Analytic tools at their disposal and guide their career choice in data analytics by helping them discover the tool that fits their personality.
The 3 Perspective:
1. Spread Sheet:
Participants are taught the world's No.1 spreadsheet software; Microsoft Excel to advance proficiency.
Over 45+ strategic Microsoft Excel functions (V-LOOKUP, H-LOOKUP, INDEX & MATCH, SUMPRODUCT, IFERROR, IFNA, VALUE(), TEXT(), DATE(), IF, SUMIFS, AVERAGEIFS, MAX, MIN, COUNTA, Aggregate / Array functions etc.) would be mastered from scratch plus techniques, pivot tables etc.
2. Business Intelligence tool (Power BI):
Participants would learn how to create insightful visualization with Power BI; one of the leading business intelligence tool for visual analytics / visualization and for creating management solutions.
3. Programming Language (R programming)
Here we show how simple programming or coding is. Participants learn how to analyze data using programming language and appreciate how much faster data analysis with programming compared to spreadsheets. In the session we learn the language of Data Science, R programming language.
PROGRAM / PLAN:
PRE-TRAINING (to be completed before training date)
ALL participants are expected to watch the pre-training video before the training. The goal of this video is to take out the rudiment as we have a lot to learn in the program. The Video covers Introduction to Business Analytics and teaches Microsoft Excel from scratch covering our first nine (9) functions (very great for participants who have never used Excel before or are not proficient with it). The videos are snippets from our ExcelQuickStart program.
Download Pre-Training Video here!
LIFE TRAINING ( ZOOM CLASS)
Pre Training Date:
A one hour life session that reviews the pre-training video with participants. Knowledge of key concepts, application and solution to scenarios / exercises.
Saturday Jan. 21, 2023
Time: 10am - 11am ---- Nigerian Time
Topic: K-Analytics Data Analytics for Business Decision
(Pre-engagement)
Time: Jan 21, 2023 10:00 AM Nigerian Time
Join Zoom Meeting
https://us02web.zoom.us/j/88194808301?pwd=aUJQTzd5MTlzVVR1U2ZGNHFxMUxGZz09
Meeting ID: 881 9480 8301
Passcode: KATA
=================================================
MAIN Training Date:
Jan. 28 – Feb. 19, 2023
Training Days:
Saturdays: 10am Nigerian Time, Sunday & Weekdays (will be discussed and agreed)
PROGRAM REQUIREMENT:
1. Computer with Microsoft Excel. 2016 and above is perfect. Lower versions can work too but version listed here is best for the program
2. Power BI & R software will be provided
3. No knowledge is required. You can join the program from ground zero. It is important participants watched the pre-training videos.
3
PROGRAM FEE:
- N60,000 , USD140 , GHS 1,500
Download Pre-Training here. Must Watch before the Training
For more inquiry, send mail to career.initiative7@gmail.com
or
Click WhatsApp Icon to send a WhatsApp message now!
No comments:
Post a Comment