Raalsalghul:


Start with spreadsheets.

Do you have access to Internet?

I would subscribe

SimplePlan34:


I would subscribe

https://www.youtube.com/user/ExcelIsFun

https://www.youtube.com/c/AlexTheAnalyst

https://www.youtube.com/c/Excelcampus1

https://www.youtube.com/channel/UCRhUp6SYaJ7zme4Bjwt28DQ

Start following those channels ASAP!

I could also give you my Udemy login if you are interested.

Raalsalghul:


https://www.youtube.com/user/ExcelIsFun

https://www.youtube.com/c/AlexTheAnalyst

https://www.youtube.com/c/Excelcampus1

https://www.youtube.com/channel/UCRhUp6SYaJ7zme4Bjwt28DQ

Start following those channels ASAP!

I could also give you my Udemy login if you are interested.

I am interested for the Udemy login

SimplePlan34:


I am interested for the Udemy login

Send me a P.M, I'll reply your mail with the username and password.

Raalsalghul:


Send me a P.M, I'll reply your mail with the username and password.

Bro I don't think I remember the email I use for my Nairaland account pls greatgabriel18@gmail.com

SimplePlan34:


Bro I don't think I remember the email I use for my Nairaland account pls greatgabriel18@gmail.com

I just replied your PM now.

I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

am interested.
.
.
whatsapp-08111145151

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

Kindly Book me In, am interested.

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

Interested, what's the mode of participation?

Raalsalghul:


https://www.youtube.com/user/ExcelIsFun

https://www.youtube.com/c/AlexTheAnalyst

https://www.youtube.com/c/Excelcampus1

https://www.youtube.com/channel/UCRhUp6SYaJ7zme4Bjwt28DQ

Start following those channels ASAP!

I could also give you my Udemy login if you are interested.

good day my brother,i would also need the udemy login.
.
.
.
thanks.

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

I'm interested. Thanks.

Really nice of you. There are people like me who learn it up to window functions but never use it in daily tasks so we keep learning it over and over again after a few months.

I really hope to address this.

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

Hinokami:
Really nice of you. There are people like me who learn it up to window functions but never use it in daily tasks so we keep learning it over and over again after a few months.

I really hope to address this.

Some of those advanced SQL stuff like stored procedures, functions, views are mostly automated on company's databases so you might find yourself not using them: speaking from experience here.


I wouldn't stress myself if I were you. As long as you don't use it day to day, you are bound to forget though I understand knowledge of it helps in improving expertise.

Raalsalghul:


Some of those advanced SQL stuff like stored procedures, functions, views are mostly automated on company's databases so you might find yourself not using them: speaking from experience here.


I wouldn't stress myself if I were you. As long as you don't use it day to day, you are bound to forget though I understand knowledge of it helps in improving expertise.

Worthy of note. You're right. Knowledge about it should be enough for now.

Thanks

I'm interested

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

Interested .

0.803.062.2583 - Whatsapp.

SparkleSix:
Greetings bosses,

I am currently looking for a good project topic to use as my final year project topic and my project supervisor mentioned that he would love me to choose a top in the AI niche.

Now the problem is that I am not all that into AI and Machine Learning, I am more of a web/Blockchain developer guy. But I have played around with a few beginner lessons in the past.

So after some weeks of research, I finally settled for the topic "A web based Breast cancer prediction system"

But then, I need some insights if it's possible to hook up a breast cancer prediction model to a web based framework (I work with Reactjs)?

How feasible is it?

I also observed that during the training of a prediction model using something like Naive Bayes the data set is divided into training and test set at a ratio of say 80:20 for the training and test data set respectively.

What if I want to make a prediction of just one row of data, will it turn out good?

I want the web based version to have individual input fields where one can enter their data and then this calls the prediction model and pass in the values and in turn gives a response of the prediction value. E.g "Has cancer" or "You don't have Cancer"

I need some insights on this because I want to start the development of the project web app first before brushing up some machine learning crash course to hook it up.

Cc: KlausMichaelson, Ejiod, all the gurus and OGs of the thread.

Arigato.

Hello Brother,


I am so sorry this is coming late.



This project of yours is very interesting to start with.

Things you need to note about ML is the fact that any model you are building needs a lot of data in order to give you a prediction of high accuracy. Working with just few data will likely make a model not intelligent enough and also make it confused as well. It is therefore necessary to get a huge amount of data on breast cancer in order to get the best from your model.


Do note, that data being used should be thoroughly cleaned. Poor quality of data doesn't help a model in anyway. It is therefore necessary for you to know how to clean, manipulate, normalize and obtaining important Features that will help your model learn very well about your data.


Also, you mentioned training and testing data: yes, they are needed by your Model for training it as well as testing it. It helps process your model in order to understand your data perfectly well. A high amount of your data should be used for training your Model (80% i.e train_size=0. change that emoji to eight(Nairaland wahala), while the rest (20% i.e test_size=0.2) should be used for testing.


Find the best model among the many models you're using. A higher accuracy score or a high mean_absolute_error value can help you determine the best models.


Learn to save your model using Pickle.

For the Web based version, streamlit is specifically meant for this. Learn about it's various functions and your work is 100%.


All the best.

Greetings my ogas. Pls what area can one with a knowledge of advanced excel skills work in, as a freelancer or remote worker?

avalon7:


You're speaking facts bro. Most data related jobs require an MSC or better to get. I've seen people start learning web development or software development and land a great job within 6 months but data professional jobs require a whole lot more.

I feel like I'm in too deep to quit lol but if I'm to start all over again i probably would go the web development or software development route.

The only upside for data professionals is that once you get a foot in you can relax and keep doing what you know, web devs and software devs would need to keep learning the latest and greatest tools plus the bar to get in is low so the competition is very high.

I go like join this your circle oh lol. I'm think of creating a network of ambitious Machine learning, Data engineering and data science enthusiasts.

I'm currently enrolled in a data science course on datacamp. Abeg I need study buddy. Lemme know if it's something you'd like

Kaycee54321:


Lol. This "circle" is nothing special oh. It'll be fine if we connect though. My mailbox is open. I'm hoping yours is too...

Can I?

Data science in view here

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

Pls I am very much interested

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

Good day sir, I'm interested.

Hello everyone. I have some thoughts that have been bothering me.

This thread was the starting point for my Data Analysis journey and I've tried to follow the recommendations listed here. I've been learning Excel, Power BI, SQL, and Python. To be honest, I haven't been paying attention to creating dashboards. My main focus have learning how to manipulate formulas (especially DAX) and other technicalities involved. But recently, I joined some tech communities on Twitter and I see a lot of people creating beautiful dashboards. I hardly see anyone talk about about their SQL or Python projects.

I'm quite confused. Is there something I'm missing? (Note: I'm yet to successfully land a job)

AnthCunny:
Hello everyone. I have some thoughts that have been bothering me.

This thread was the starting point for my Data Analysis journey and I've tried to follow the recommendations listed here. I've been learning Excel, Power BI, SQL, and Python. To be honest, I haven't been paying attention to creating dashboards. My main focus have learning how to manipulate formulas (especially DAX) and other technicalities involved. But recently, I joined some tech communities on Twitter and I see a lot of people creating beautiful dashboards. I hardly see anyone talk about about their SQL or Python projects.

I'm quite confused. Is there something I'm missing? (Note: I'm yet to successfully land a job)

Think of it like making Jollof

The data cleaning is like identifying the ingredients needed to make jollof

The SQL is to get the exact ingredients needed for the Jollof in the right quantity

The python programming, Excel manipulation, DAX in BI...are all the different methods used in prepping the Jollof to taste based on specific requirements


The dashboard is the final plate of Jollof with Chicken and Juice that is served on the table.

So, yeah, more emphasis is placed on the already prepared Jollof... but that doesn't sidestep the processes involved in turning raw foodstuff to edible Jollof.

Kaycee54321:


Think of it like making Jollof

The data cleaning is like identifying the ingredients needed to make jollof

The SQL is to get the exact ingredients needed for the Jollof in the right quantity

The python programming, Excel manipulation, DAX in BI...are all the different methods used in prepping the Jollof to taste based on specific requirements


The dashboard is the final plate of Jollof with Chicken and Juice that is served on the table.

So, yeah, more emphasis is placed on the already prepared Jollof... but that doesn't sidestep the processes involved in turning raw foodstuff to edible Jollof.

I was almost salivating reading this

Thanks alot for the insight.

Raalsalghul:


https://www.youtube.com/user/ExcelIsFun

https://www.youtube.com/c/AlexTheAnalyst

https://www.youtube.com/c/Excelcampus1

https://www.youtube.com/channel/UCRhUp6SYaJ7zme4Bjwt28DQ

Start following those channels ASAP!

I could also give you my Udemy login if you are interested.

I sent you a PM boss

AnthCunny:
Hello everyone. I have some thoughts that have been bothering me.

This thread was the starting point for my Data Analysis journey and I've tried to follow the recommendations listed here. I've been learning Excel, Power BI, SQL, and Python. To be honest, I haven't been paying attention to creating dashboards. My main focus have learning how to manipulate formulas (especially DAX) and other technicalities involved. But recently, I joined some tech communities on Twitter and I see a lot of people creating beautiful dashboards. I hardly see anyone talk about about their SQL or Python projects.

I'm quite confused. Is there something I'm missing? (Note: I'm yet to successfully land a job)

What I have noticed about Nigerian data analysts (mainly the show-offs) is that they all think data analysis is all about creating dashboards(visuals) as though they are graphic designers. And I can bet it that they didn't really do much of any cleaning and wrangling of data, otherwise they will show that part as well: trust Nigerians.

I don't see Whites post things like dashboards. To them, it's just a normal thing. The 70-80% of an analyst job is spent more on cleaning and preparing the data. This is where the knowledgeable of SQL, DAX, Pandas, Excel Functions comes in.


Simply put, Nigerian Data analysts are more of graphic designers while the white counterpart are much more than that: they are just like the scientists of the data itself. Your dashboards doesn't really tickle their fancy.


Follow them, you will understand that Data analysis has a long way to go in Nigeria.

Ps: I may be wrong, but that's my opinion.

KlausMichaelson:



What I have noticed about Nigerian data analysts (mainly the show-offs) is that they all think data analysis is all about creating dashboards(visuals) as though they are graphic designers. And I can bet it that they didn't really do much of any cleaning and wrangling of data, otherwise they will show that part as well: trust Nigerians.

I don't see Whites post things like dashboards. To them, it's just a normal thing. The 70-80% of an analyst job is spent more on cleaning and preparing the data. This is where the knowledgeable of SQL, DAX, Pandas, Excel Functions comes in.


Simply put, Nigerian Data analysts are more of graphic designers while the white counterpart are much more than that: they are just like the scientists of the data itself. Your dashboards doesn't really tickle their fancy.


Follow them, you will understand that Data analysis has a long way to go in Nigeria.

Ps: I may be wrong, but that's my opinion.

Thanks for sharing.

KlausMichaelson:


I don't see Whites post things like dashboards. To them, it's just a normal thing. The 70-80% of an analyst job is spent more on cleaning and preparing the data. This is where the knowledgeable of SQL, DAX, Pandas, Excel Functions comes in.


Simply put, Nigerian Data analysts are more of graphic designers while the white counterpart are much more than that: they are just like the scientists of the data itself. Your dashboards doesn't really tickle their fancy.


Follow them, you will understand that Data analysis has a long way to go in Nigeria.

Ps: I may be wrong, but that's my opinion.

Very true too.

I also feel that it's because of how the Nigerian employers try their possible best to not give a F*CK about the programming mumbo jumbo.

I remember vividly, my very first job, I prepped a long ass Word Doc on my processes, talked about how we should integrate Jupyter so we can work on code and bla bla bla

The CEO met me on Monday morning and told me that all he's interested in is, whether he's winning or losing.

If he's winning, why?
If he's losing, why?

I jeje began to use Excel pivots and sweet BI dashboards and everybody was happy.

Kaycee54321:


Very true too.

I also feel that it's because of how the Nigerian employers try their possible best to not give a F*CK about the programming mumbo jumbo.

I remember vividly, my very first job, I prepped a long ass Word Doc on my processes, talked about how we should integrate Jupyter so we can work on code and bla bla bla

The CEO met me on Monday morning and told me that all he's interested in is, whether he's winning or losing.

If he's winning, why?
If he's losing, why?

I jeje began to use Excel pivots and sweet BI dashboards and everybody was happy.

Lols. That last part is very relatable.

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

I am interested, hope its not late.