I'm just thinking some of you that need to add a professional certifications to your resume, you can try the DA 100 by Microsoft which gives you certification in Data Analyst.

Anybody has any recommendation for an internationally recognised certified course for SQL?

If you are very good at excel and could manage in an admin office of an indian colgomorate,

Please send a CV to wallacetechnoid@gmail.com


Note: I am not promising anything. Just trying to help here.

Sirwallace:
If you are very good at excel and could manage in an admin office of an indian colgomorate,

Please send a CV to wallacetechnoid@gmail.com


Note: I am not promising anything. Just trying to help here.

Please where is the location

rodhy:
Can anyone recommend a very good course on statistics for data analysts(Microsoft excel)

I have udemy videos on this

I want to follow this Thread

I've started this journey since September last year

Done with...
Excel approach to data science
Stastitical approach to data science
Tableau Visualization

Now on python intermediate, trying in mastering xgboost, SKlearn, clustering, Kmeans, Tree regression python visualization etc as well building knowledge in this follow area, multicollinearity, No auto correlation, heteroscedacity, homoscedasticity..and how to interpret PCA and VIF and other useable models

I know I've been slow in moving to SQL..due I'm still student at the University, Studying Mathematics..

Kaggle's 30 Days of ML
You're invited to our super fun, beginner-friendly learning challenge, #30daysofML.
* First 2 weeks: rapidly cover essential machine learning skills.
* Last 2 weeks: join others in an invite-only, low pressure Kaggle competition.
Sign up now, starts Aug 2!
https://www.kaggle.com/thirty-days-of-ml?utm_medium=social&utm_campaign=thirty-days-of-ml

Ejiod:
I'm just thinking some of you that need to add a professional certifications to your resume, you can try the DA 100 by Microsoft which gives you certification in Data Analyst.

Please I'm having issues installing both MySQL and Tableau on my system.

Below is what's showing on the screen.

Please help!

ItsTime4me:
Hello guys, Please I need help on how to install SQL workbench. I have been trying to install it but it is not working. Please are there requirements for the installation?

Did all the library lnstalled when installing it
. I can help u if u stay around igando

munstaqq:


Please I'm having issues installing both MySQL and Tableau on my system.

Below is what's showing on the screen.

Please help!

Look for videos on youtube on how to install the workbench through the Msql Installer and follow the steps.

Please I need a sample of how a report can be written in excel and tableau. Thanks

Heyf:
Hello everyone,
I think I've learnt EXCEL to an extent, please where I can I get materials to practice with??
I want to master Excel very well before moving to something else

Check kaggle.com

trojan84:


Check kaggle.com

Thank you very much

https://www.youtube.com/watch?v=xHeNOCeoD4Q

munstaqq:


Please I'm having issues installing both MySQL and Tableau on my system.

Below is what's showing on the screen.

Please help!

Not this…
Download MySQL workbench

Ejiod:

Not this…
Download MySQL workbench

I downloaded it. The same problem still. Seems my system doesn't support MySQL or something is wrong with the setup.

Please which other SQL application can I use? I don't want to put my learning on hold because of this little challenge.

belovez:


Look for videos on youtube on how to install the workbench through the Msql Installer and follow the steps.

Okay. Thank you

Hello guys,

I got a DM from recruitment consultant from LinkedIn for these two roles:


Database administrator
Data engineer.

I could not take it cus I am engaged with an employer but I can refer people as she asked.


If you are good with track record to show your are really good at these two roles:

Please quote this tweet and reach out to me.

Data Analyst Project Example for Portfolio

This is to provide ideas, guidance and inspiration on those hoping to embark on personal project for their Data analyst portfolio

Nairaland Politics project
Background of the project:
Nairaland is a Discussion forum where people come and share their thoughts on different topics.
The site is divided into categories and sections to guide the users.

Scope of the project:
This project shall focus on the first 300 pages of the politics section of nairaland.com

Project Questions:
1 What is the topic with the highest number of views
2 What is the topic and original Poster of the topic with the highest number view
3 What is the topic and original Poster of the topic with the highest number of comments or updates
4 Which post was last updated and when in the 300 pages scraped or oldest in terms of update
5 Who are the most active users in the politics section of Nairaland and how many topics did they create
6 Which month had the highest number of Headings
7 Any other question that can help us understand the data very accurately

Project Task:
task 1 : Write a python script to scrape 300 pages from politics category of nairaland.com
task 2 : using necessary libraries clean and analyze the data
task 3 : present your result using suitable visualization

Skills demonstrated in the Project :
1 Web scraping
2 Regular expression usage
3 Writing to a file
4 Data manipulation
5 Data cleaning
6 Data visualization
7 Research
8 Documentation

Column name definitions for the project :
1 Heading : The title of the thread
2 Poster : The person that created the thread
3 Updated : How many times contributions have been added to the thread
4 Viewed : How many people opened the thread to read the content without contribution
5 Time : The time and date the last contribution was made on the thread
6 Last_Updated : The lasted person to make contribution to the thread

https://github.com/brightonu/portfolio_projects/blob/main/politics_project_Final.ipynb

lovelybobo:
Data Analyst Project Example for Portfolio

This is to provide ideas, guidance and inspiration on those hoping to embark on personal project for their Data analyst portfolio

Nairaland Politics project
Background of the project:
Nairaland is a Discussion forum where people come and share their thoughts on different topics.
The site is divided into categories and sections to guide the users.

Scope of the project:
This project shall focus on the first 300 pages of the politics section of nairaland.com

Project Questions:
1 What is the topic with the highest number of views
2 What is the topic and original Poster of the topic with the highest number view
3 What is the topic and original Poster of the topic with the highest number of comments or updates
4 Which post was last updated and when in the 300 pages scraped or oldest in terms of update
5 Who are the most active users in the politics section of Nairaland and how many topics did they create
6 Which month had the highest number of Headings
7 Any other question that can help us understand the data very accurately

Project Task:
task 1 : Write a python script to scrape 300 pages from politics category of nairaland.com
task 2 : using necessary libraries clean and analyze the data
task 3 : present your result using suitable visualization

Skills demonstrated in the Project :
1 Web scraping
2 Regular expression usage
3 Writing to a file
4 Data manipulation
5 Data cleaning
6 Data visualization
7 Research
8 Documentation

Column name definitions for the project :
1 Heading : The title of the thread
2 Poster : The person that created the thread
3 Updated : How many times contributions have been added to the thread
4 Viewed : How many people opened the thread to read the content without contribution
5 Time : The time and date the last contribution was made on the thread
6 Last_Updated : The lasted person to make contribution to the thread

https://github.com/brightonu/portfolio_projects/blob/main/politics_project_Final.ipynb

Very impressive �

WorldQuant offers a free online data science top-notch certification programme for any one really interested in the field. Also, if you are a graduate especially in the science, engineering or finance field and passionate about applying for the free 2 years Masters degree programme in financial engineering. Anyone really serious who needs assistance in successfully passing the quantitative test to be enrolled can message me.

Tonyblessed:
WorldQuant offers a free online data science top-notch certification programme for any one really interested in the field. Also, if you are a graduate especially in the science, engineering or finance field and passionate about applying for the free 2 years Masters degree programme in financial engineering. Anyone really serious who needs assistance in successfully passing the quantitative test to be enrolled can message me.

I hold a degree in Economics can I apply for the Financial Engineering or is only meant for science folks

Sirwallace:
Hello guys,

I got a DM from recruitment consultant from LinkedIn for these two roles:


Database administrator
Data engineer.

I could not take it cus I am engaged with an employer but I can refer people as she asked.


If you are good with track record to show your are really good at these two roles:

Please quote this tweet and reach out to me.

Thanks for remembering this platform big boss and the opportunities. This is what this place is meant for to help others, inspire and encourage.

Thanks once again

lovelybobo:
Data Analyst Project Example for Portfolio

This is to provide ideas, guidance and inspiration on those hoping to embark on personal project for their Data analyst portfolio

Nairaland Politics project
Background of the project:
Nairaland is a Discussion forum where people come and share their thoughts on different topics.
The site is divided into categories and sections to guide the users.

Scope of the project:
This project shall focus on the first 300 pages of the politics section of nairaland.com

Project Questions:
1 What is the topic with the highest number of views
2 What is the topic and original Poster of the topic with the highest number view
3 What is the topic and original Poster of the topic with the highest number of comments or updates
4 Which post was last updated and when in the 300 pages scraped or oldest in terms of update
5 Who are the most active users in the politics section of Nairaland and how many topics did they create
6 Which month had the highest number of Headings
7 Any other question that can help us understand the data very accurately

Project Task:
task 1 : Write a python script to scrape 300 pages from politics category of nairaland.com
task 2 : using necessary libraries clean and analyze the data
task 3 : present your result using suitable visualization

Skills demonstrated in the Project :
1 Web scraping
2 Regular expression usage
3 Writing to a file
4 Data manipulation
5 Data cleaning
6 Data visualization
7 Research
8 Documentation

Column name definitions for the project :
1 Heading : The title of the thread
2 Poster : The person that created the thread
3 Updated : How many times contributions have been added to the thread
4 Viewed : How many people opened the thread to read the content without contribution
5 Time : The time and date the last contribution was made on the thread
6 Last_Updated : The lasted person to make contribution to the thread

https://github.com/brightonu/portfolio_projects/blob/main/politics_project_Final.ipynb

Thanks for this guideline, now it's clearer to me how Cochtrane used nairaland as a project.

https://www.nairaland.com/5485400/chronicle-data-scientist-analyst/46#90515671


Thanks for sharing.

belovez:


I hold a degree in Economics can I apply for the Financial Engineering or is only meant for science folks

Yeah. Economics graduates are also encouraged. Anyone can apply for the programme. But they encourage you be proficient in maths, statistics, algebra, calculus and programming which is a necessary skill encountered in all financial engineering programme as you delve deeper to make the most of the programme and in writing the quantitative test. And those who usually graduate from these technical fields like engineering, computer science, physics etc are usually good in problem solving. And of course, it depends on how passionate and dedicated you are.

Sellout:
The community is moving! If you have interest and what to start your career in data analysis. Well my udemy paid courses are still in my dashboard and I'm pretty sure it is everything and more to get started. From Excel to Power BI to SQL. If you are interested and want to download the tutorials using udeler you can reach out to me via whatsapp 08108176six73. Completely free. Only thing you would be required to have would be data. Cheers.

Hello!!
Bro is the offer still available, please I need it .

Heyf:
Hello everyone,
I think I've learnt EXCEL to an extent, please where I can I get materials to practice with??
I want to master Excel very well before moving to something else

bro, what materials did you use?

lymelyte:
bro, what materials did you use?

Sis*

"Excel is fun" on YouTube.
Basics and advanced

Heyf:


Sis*

"Excel is fun" on YouTube.
Basics and advanced

thanks. But can you advice on how to learn effectively? Because I went to the channel on YouTube but the knowledge isn't in order... I am having challenges on that. If you can help.

lymelyte:
thanks. But can you advice on how to learn effectively? Because I went to the channel on YouTube but the knowledge isn't in order... I am having challenges on that. If you can help.

Follow the library, check for Excel basics..it has like 24 videos or so... numbered from 1..

The Excel advanced library also has like 30 videos or so

Just check for the video playlist..it's there