cochtrane:
Glad to see this thread still making progress. If you are interested in data science tutorials and/or lectures at beginner to intermediate level, watch out for this space . I'll be offering a series of lectures in the coming months for those interested who want to transition or stay motivated. Lectures may be paid though, cos my observation from giving free lectures is that they hardly make any significant impact.

mosix4real:
I just sat for the PL-300: Microsoft Power BI Data Analyst Exam. I passed. I scored 725. Next up - SQL

wisdomremz:
already started my journey into data science, prior before now I had a mentor(my cousin) who is a data scientist in Australia who talked extensively on data science and gave various tools necessary. So I brushed through excel by taking some course like analysing data using excel and other courses on Edx(videos) then currently learning sql using sql server express learnt basics using w3schools and sqlzoo which am done, practicing using ssms and sample database like(adventureworks and northwind) so refreshing. Also I have some PDFs book having questions and problem from beginner to advance on the sample database listed, once am done I will also take some courses on edX. Afterwards would move into python and other tools.


just wanted to share my journey for the past one month. thanks Ejiod and other contributors.

if you are also on this journey into the world of data science quote me, let's relate �

Teophilus96:
Hi everyone,

So I actually have an interview on Monday. I am applying for the role of a Data analyst/Scientist. Please can anyone who is experienced in that field or an HR here tell me the kind of questions to expect. I will really be grateful. Thank you.

Teophilus96:
Hi everyone,

So I actually have an interview on Monday. I am applying for the role of a Data analyst/Scientist. Please can anyone who is experienced in that field or an HR here tell me the kind of questions to expect. I will really be grateful. Thank you.

Teophilus96:



Hi for the update, I got the job offer. During the interview I felt quite uneasy and nervous at the start. I was given the company data to work on and provide certain insights. I tried using MySQL to query the data and obtain certain pattern since the data was not clean at all. MYSQL failed me lols, so I ended up using POWERBI to do whole stuff. I have been waiting to share this news untill they get back to me. Thanks you all, I wish us all the very best!

mosix4real:
I just sat for the PL-300: Microsoft Power BI Data Analyst Exam. I passed. I scored 725. Next up - SQL

Teophilus96:



Hi for the update, I got the job offer. During the interview I felt quite uneasy and nervous at the start. I was given the company data to work on and provide certain insights. I tried using MySQL to query the data and obtain certain pattern since the data was not clean at all. MYSQL failed me lols, so I ended up using POWERBI to do whole stuff. I have been waiting to share this news untill they get back to me. Thanks you all, I wish us all the very best!

maticar:

congratulations bro

i'm happy

Ejiod:

Very big Congrats...
Don't forget to share your progress both ups and down

Teophilus96:



Hi for the update, I got the job offer. During the interview I felt quite uneasy and nervous at the start. I was given the company data to work on and provide certain insights. I tried using MySQL to query the data and obtain certain pattern since the data was not clean at all. MYSQL failed me lols, so I ended up using POWERBI to do whole stuff. I have been waiting to share this news untill they get back to me. Thanks you all, I wish us all the very best!

Gentleman001:


Congratulations man..

jolak5:
Hello guys, I'm learning python and I have an aptitude test with a school today.


Can anyone help me with the solution to this question?

Teophilus96:


# import the NumPy module
import numpy as np

# create an array
a = np.array([5, -10, 50, -945, 12, 0])

# Call the len() function
print("You have entered", len(a) - 1, "numbers"

Please change the emoji to )

jolak5:


Thanks boss. I don fail the test already. I couldn’t solve a question

Teophilus96:


Pick your lessons and learn from them. All the best next time.

Tenshades:
My IFS function isn't coming up in my Excel 2016...help

Ejiod help

jolak5:
Hello guys, I'm learning python and I have an aptitude test with a school today.


Can anyone help me with the solution to this question?

a = []
x= input()
while ''.join(x.split('0'))!='': 
  try:
    d = int(x)
    a.append(d)
  except:
    print( "Not a number" )
    break
  x = input()
print(a)

Teophilus96:


# import the NumPy module
import numpy as np

# create an array
a = np.array([5, -10, 50, -945, 12, 0])

# Call the len() function
print("You have entered", len(a) - 1, "numbers"

Please change the emoji to )

Omotaday:
Get a recent version of Excel.

Guontey:

That's not a good way to write the function

Omotaday:
Through this thread, I was motivated to start learning excel and Sql (through youtube and web materials), I can say I can comfortable use both to some extent. Hoping to be good in those before moving to Tableau and then Python. However, I am having issue on how I can start to put what I've learnt into use.

For Instance, I've got Data files on Airline performance from 1987 to 2008, I am to analyze and treat this data, they are about for 22 files with each having over 1 million rows of record. I'm not sure if I should import these files through Excel -Data- Query, merge them(this may be too large for excel) and try to make sense out of it, or I need to find a way to get the files into PostgreSQL. I will appreciate comments on the process to treat a data like this or how to start with it.

Lastly, I am looking for a mentor or coach, someone who is already in the field, I don't mind discussing terms. Things are easier for me when I have access to someone I can ask this questions whenever I'm stuck.

Thanks

Guontey:

That's not a good way to write the function

avalon7:


Nice one! Did you have to pay to take the exam or do you have to pay for the certification?

Drsmartphilips:
i need some assistance with a task, can i get some assistance