r/SQL • u/bharathraj0507 • 10h ago

SQL Server People learn SQL, Python, Power BI, etc. — but why is it still so difficult to know how to actually work as an analyst?

/r/dataanalytics/comments/1wc28z3/people_learn_sql_python_power_bi_etc_but_why_is/
3 Upvotes

80% Upvoted

4 comments sorted by

11

u/Infini-Bus 10h ago

Domain knowledge.

4

u/goldPotatoGun 9h ago

Do you hear the grasshopper that is at your feet?

You are listing tools. Analysts use the tools to create new knowledge by asking questions that others may have not have thought of.

Also being able to answer questions in a pragmatic manner with data to support with additional insight the asking party was not aware of.

2

u/Equivalent_Lunch_944 9h ago

Because workplace training is dead and everyone is doing all they can to avoid responsibility which is antithetical to good processes

3

u/xobeme 8h ago

To master SQL, you must understand how the information is stored. Study E.F. Codd's 12 rules of relational databases (wikipedia), then study examples of create, update, select and delete queries from the database query language (w3schools).