Hi.

This thread is to document my daily journey for the next 200 days, as I go from a novice to confident and job-ready in the field of data analytics.

Timeframe: 200 days

Start date: Friday, 21st April 2023

End date: Monday, 6th November 2023

No. Of hours per day: 3 hours

Estimated total number of hours: 600 hours

What I intend to learn:

1) Basic Statistics

2) Microsoft Excel

3) SQL

4) PowerBi

5) Python (optional)

6) R (optional)

7) Tableau (optional)

SPSS (optional)

9) Soft Skills (presentation skills etc)

How I Intend To Learn

1) Self-taught, via YouTube videos

2) Online courses

Schedule For The Next 10 Days

21st-30th April 2023

10*3hours= 30 hours


Basic Statistics= 20 Hours

Excel= 10 Hours

I may not strictly follow 3 hours per day. Some days, I am very busy. Some other days, I am relatively free.

The goal is that within 10 days (21st-30th April), I should have completed 30 hours

See you tomorrow (Day 1)

DataDoc:
Schedule For The Next 10 Days

21st-30th April 2023

10*3hours= 30 hours


Basic Statistics= 20 Hours

Excel= 10 Hours

See you tomorrow (Day 1)

Nice determination... I will be cheering you on!!!

dawnomike:
Nice determination... I will be cheering you on!!!

Thank you very much

All the best OP!

Plus10:
All the best OP!

Thank you very much Sir

Nice one

May God help

DataDoc:
Hi.

This thread is to document my daily journey for the next 200 days, as I go from a novice to confident and job-ready in the field of data analytics.

Timeframe: 200 days

Start date: Friday, 21st April 2023

End date: Monday, 6th November 2023

No. Of hours per day: 3 hours

Estimated total number of hours: 600 hours

Hello!!!
How is day one going?

Don't forget to update us on how it goes...

DataDoc:
Hi.

This thread is to document my daily journey for the next 200 days, as I go from a novice to confident and job-ready in the field of data analytics.

Timeframe: 200 days

Start date: Friday, 21st April 2023

End date: Monday, 6th November 2023

No. Of hours per day: 3 hours

Estimated total number of hours: 600 hours

Abi make I follow you on this short journey
Good luck OP

Day 1: Friday, 21st April 2023

Time spent: 4 hours

I watched 4 hours out of an 8hr 15 minutes video on Statistics. I just watched. I didn't jot. My aim is to watch the video again later on and then jot.

I will post the link to the video later on. I got it from YouTube.

I have some Epidemiology/Biostatistics background, so the video wasn't too difficult for me to follow. However, I still learnt some concepts better. The instructor was also very good.

Total Number of Hours Spent so far = 4 HOURS (out of 600 hours)

0.67% Complete
Lol
Still a long way to go

dawnomike:
Hello!!!
How is day one going?

Don't forget to update us on how it goes...

Update done...so far so good

Underdawgg:


Abi make I follow you on this short journey
Good luck OP

You can join me right away Sir. The more people the better.

OP ride on
More blessings

Day 2: Saturday, 22nd April 2023.

Time spent: 4 Hours

I had a very busy day and had to struggle to learn something.

I still continued with my Statistics video.

Video now remaining 15 minutes to the end.

I will have to complete the Statistics video and get into Excel.

I still have 12 more hours for my Statistics before 30th April. I would probably rewatch the video and look for some statistics problems to solve.

Why I posted yesterday's update today is that I was still up as at 11pm yesterday watching the Stats video.

Total number of hours spent so far: 8 HOURS (out of 600 hours)

1.33% Complete

A very good start, Doc.

Well done!

Well done OP. Im rooting for you as I'm on the same journey but less stringent. Best wishes to us

Wish you the best on your journey OP.

Please let me join you my bro

How do I contact you?

ymdo:
Please let me join you my bro

How do I contact you?

Okay.

SoftBread01:
A very good start, Doc.

Well done!

Thank you very much. One step at a time and I will reach my goal

farydah:
Well done OP. Im rooting for you as I'm on the same journey but less stringent. Best wishes to us

Thank you very much. I wish you the best.

Yohans:
Wish you the best on your journey OP.

Thank you very much

Nice. Stay consistent and you can achieve whatever you want.

Day 3: Sunday, 23rd April 2023

Time Spent: 5 Hours 30 minutes

I watched a 4-hour YouTube video by Ahmed Oyelowo. That's an introduction to Microsoft Excel.

I subsequently watched another video by freecodecamp, for 1 hour 30 minutes. I've forgotten the name of the instructor. He had a list of Excel projects and built them from scratch. This one was a bit fast-paced and I was lost at some point. I stopped 30 minutes to the end of the video. I will still complete it and probably rewatch to understand it better.

Total Number Of Hours Spent So Far: 13 Hours 30 Minutes (out of 600 Hours)

2.25% Complete

DataDoc:


Okay.

I didn't get any email even though nairalandbis notifying you sent a mail

ymdo:
I didn't get any email even though nairalandbis notifying you sent a mail

Reply the Nairaland mail. It will get to my email

DataDoc:
Hi.

This thread is to document my daily journey for the next 200 days, as I go from a novice to confident and job-ready in the field of data analytics.

Timeframe: 200 days

Start date: Friday, 21st April 2023

End date: Monday, 6th November 2023

No. Of hours per day: 3 hours

Estimated total number of hours: 600 hours

Nice one bro...I pray your achieve this.

Atyms it's not just the determination...but the distractions....I pray and hope your determination overcome the distractions

DataDoc:
Day 3: Sunday, 23rd April 2023

Time Spent: 5 Hours 30 minutes

I watched a 4-hour YouTube video by Ahmed Oyelowo. That's an introduction to Microsoft Excel.

I subsequently watched another video by freecodecamp, for 1 hour 30 minutes. I've forgotten the name of the instructor. He had a list of Excel projects and built them from scratch. This one was a bit fast-paced and I was lost at some point. I stopped 30 minutes to the end of the video. I will still complete it and probably rewatch to understand it better.

Total Number Of Hours Spent So Far: 13 Hours 30 Minutes (out of 600 Hours)

2.25% Complete

Kindly pose the link to the online videos you are watching

Pls I will like to join you on this challenge as I just started learning DA and needs accountability partner.

Hey, let me give you a tip that will go a long way to help you.

The best way to learn programming is to practice what you watch/learn on the video materials/recordings.... for example, you're currently learning Microsoft excel, as you watch the videos, practice hands-on as you watch. It doesn't matter how long it takes you to complete each video. What matters most is learning and retaining the knowledge. Practicing on your own as you watch helps you retain what you watched/learned. An 8-hour video might take you 24 hours to master, so far you are able to understand and recreate what you learned on your own. After each video recording, practice what you learnt hands-on without looking at the video.

When you get to the SQL aspect, download the SQL studio. That will help you get some hands-on. Same with PowerBI. Download the free version and do a lot of practice.... do some assignments and projects.... this will go a long way to help you during interviews.

Note, you have to dedicate enough time for this. SQL PowerBI, and Excel are the most important skill for a data analyst. SAS is also in high demand now. R and Python are extras... You can add python to make you dynamic. Data modeling is also important.

If necessary, whenever you feel you are ready, let me know. I can help with some assignments and projects, and also some interview tips..

DataDoc:
Day 3: Sunday, 23rd April 2023

Time Spent: 5 Hours 30 minutes

I watched a 4-hour YouTube video by Ahmed Oyelowo. That's an introduction to Microsoft Excel.

I subsequently watched another video by freecodecamp, for 1 hour 30 minutes. I've forgotten the name of the instructor. He had a list of Excel projects and built them from scratch. This one was a bit fast-paced and I was lost at some point. I stopped 30 minutes to the end of the video. I will still complete it and probably rewatch to understand it better.

Total Number Of Hours Spent So Far: 13 Hours 30 Minutes (out of 600 Hours)

2.25% Complete