4 ms·
I suggest a shortcut: "SQL > Transform Data > Insights > Decision" I don't think you need Excel, you can do whatever you need in SQL: pivots, medians, average
by SQL2219 7y ago
I suggest a shortcut:
"SQL > Transform Data > Insights > Decision"
I don't think you need Excel, you can do whatever you need in SQL: pivots, medians, averages, aggregates and transformations of all kinds. In terms of speed and flexibility, you should be able to shame all those "Excel experts". After all, that Excel data probably came from a database to begin with.
- AnitaLather 7y agoThank you for replying. That's great to know. But I don't know SQL, as yet. Can you help me with steps to learn and master SQL to your suggestion.
- SQL2219 7y agoStart with where you work, find out what brand of database your company uses: PostgreSQL, Oracle, SQL Server, MySQL etc. If this is not your current situation, then you are on your own. There are more than enough free resources online to get you moving in the right direction, motivation not included.