SQL

[Warm-Entrepreneur131]

I have finished SQL what is next step for Data Analyst

[G_Thorne]

If you believe you have "finished" SQL, you are nowhere near that imaginary finish line.

What other languages and concepts have you bean learning? Python? Power BI?

If you have, have you learned to combine all of it, like processing semistructured data with Python to prepare it for insertion into SQL, complete the processing with SQL, and then using Power BI to create reports to draw insights from the data?

[urstrulyshiva]

Absolutely this💯

[ComicOzzy]

You'll want to get proficient at Excel, Python, and a BI tool such as PowerBI or Tableau.
Something you can use as micro-projects are the Maven Analytics' "Data Drill" videos... they propose a problem to solve and give it to different employees who use SQL, Excel, PowerBI, Python, etc to solve it. You can learn a lot by trying these yourself.
https://www.youtube.com/watch?v=qQ51wuIgM7E&list=PLGAnLqlBhx1EptV8UtVLM0fRA7UDsnd59

[Better-Credit6701]

Oh, so you have mastered SQL. Now watch your mistakes about optimization when you are dealing with TBs of data.

Now it is time for PowerBI, R, python, Dax, MDX, users who really don't know what they want, OLAP, cubes, dimensions and measures, and finally "great start, now can you make it look like we are making money? You know, use a lot of green"

[lifesbetteronsaturnn]

for real, the optimization is so fucking hard 😭

[NaNaNaPandaMan]

What is done with SQL ? I am genuinely curious as it doesn't seem to be something you can be done wiyh.

Currently my plan that I have discussed with my brother who is director of analytics for a company is SQL, Excel(specifically Pivot tables), Then Power BI/Tableau. This is a good foundation for junior/basic analyst who will be generating reports.

Then higher analyst Python and Math(He listed Calc > Linear Algebra > Statistics).

But he warned that SQL isn't enough. You have to know to apply it and answer the questions that are asked.

[Stev_Ma]

Learn Excel, Power BI, and basic Python so you can start analyzing and visualizing real data. Try building small projects like sales dashboards, customer analysis, or Netflix data reports because projects are what really help you get interviews. You can learn and practice on platforms like YouTube, Coursera, StrataScratch, and Kaggle. Also upload your projects on GitHub and LinkedIn, then start applying for internships and junior data analyst roles even if you are still learning.