movado19:


You are very right.
Knowing the data types and analysis types is very important...that should actually be the first goal and this can be learned in a day or two, I believe. It's not something that would or should delay one from still starting in Excel, because in there, one gets to see the various data types at play.
The analysis types become more understandable when/if anyone takes Statistics (at least begin by understanding the philosophy).

If you have data, go to Coursera and enroll for Google data analysis professional certification. If you are as rich as I am, apply for financial aid.



Yes, yes, yes! No one should let finances stop them from learning and they do help out a lot with financial aid.
I also believe that course/certification would be very nice for anyone who looks into it. Google has done a lot of work to simplify virtually the whole data analysis process. They have put together a fine blend of soft and hard skills that are in demand.

Hinokami:
Guys what do you think about dbt(data build tool) and looker?

AnalysisGuru:

Dbt is a great ETL tool. One of the best for the pricing it offers.
Looker on the other hand is also a great tool but it doesnt fascinate me personally.
Dbt is also gaining popularity and so many coys are using it as we speak.

Hinokami:



Thanks. I guess it ain't bad to start learning dbt ASAP

Hinokami:



Thanks. I guess it ain't bad to start learning dbt ASAP

Marveaux:

These tools you just mentioned, are they data analysis tools or data engineering tools?

AnalysisGuru:


Yes please...
Learn dbt but also learn Airflow or Prefect..
Those are great ETL tools too

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.

Blesschemical:
Abia state

movado19:



To butress your point, @ Gidicars,
@Kaymax222 can go through the thread and see that excel, PBI, SQL, Tableau, Python are the most frequent tools & languages to learn.

If s/he is brand new to any of these, then I would personally suggest the following route:
Excel - SQL - PBI - Tableau - Python.

Hi bro, I sent you a message. Kindly respond. Thanks

My reason for this is that excel is the "mothership" of all, if not most of these data viz/spreadsheet tools (including google spreadsheet).
Having a good grasp of excel will ensure smooth sailing in PBI and Tableau.
SQL should be next or in tandem with excel because then one can see the similarities and differences with respect to how both of them deal with data cleaning through their functions.

Python should be after one is proficient to a certain degree in the 4 prior tools (in my opinion).

@Kaymax222 can go to the following link to download the workbook tutorial which takes one through some very important excel formulas.

https://templates.office.com/en-us/Formula-tutorial-TM16400656

https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?wt.mc_id=otc_home

I hope this helps.

Raalsalghul:


Unfortunately too far.

Otitodilijesu:


Baba na Lagos me I dey oo... Make we make arrangements, abeg.

Raalsalghul:


Send a private message.

Otitodilijesu:


Thanks. I'd do that Asap

Raalsalghul:


Couldn't see your message: send a mail to donjoelmc@yahoo.com.

Otitodilijesu:


Thanks. I just shot you a mail

Kaymax2222:
good evening boss I appreciate your response back to me. I am a newbie.. I don't have any first hand knowledge I the feed and I prefer video also I have a phone and a laptop too. Pls help.

GidiCars:


Yea, like movado19 said, excel isn't a bad place to start. But don't dwell on it much. If you have enough data & you use telegram, search up udemy free courses . on telegram. The channel has about 100K users. I have more 50 premium courses on udemy. I have more than 3 premium Power bI courses alone.

We had a computer in the house growing up, so using Microsoft office suite wasn't a big deal for me. During my siwes, the company I worked for used excel heavily for most of their works. I had no pproblem working cause I already knew the basics. I believe tjings like that are part of those things the averega learned person is suppose to know. You don't really need to have in-depth knowledge about it, just know the basics.

Cc: movado19

waleyp:
How can someone learn data analysis from the scratch............

Raalsalghul:


Read from page 1.

waleyp:
I'm doing that

mcemmy0z:
If you reside around songo Ota I have these available
*Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
*Udemy - SQL - MySQL for Data Analytics and Business Intelligence
*Tableau 10 A-Z Hands-On Tableau Training For Data Science!
*Tableau Hands-on Learn Data Visualization with Tableau
*Udemy - Power BI A-Z Hands-On Power BI Training For Data Science
*Udemy - Machine Learning A-Z™ Hands-On Python & R In Data Science
*Udemy - Python for Financial Analysis and Algorithmic Trading

GidiCars:
I uploaded the file to the following link below. It contains 4 PDFs to help you get started. I also screenshot some other files you might be interested in. Just holla me if you need any of them. Do not forget to also join telegram if youprefer videos, they upload free tutorials from Udemy on some channels.

https://ufile.io/1p574oye


Cc.

Meritbaba
kennethfranc
nastynic
Wfsholla90
Shodman
Adegbem01
OladiTwo5

Scholar212:
I have been an active follower of this thread, after few starting to learn on and off, the Sidehustle internship with data Analytics track has made me focused and serious now. Moving gradually from Excel - PowerBI and hoping to move along to SQL and then python. This thread is a good motivation, thanks to the Op and others that have shared their story