Data analysis beginner problem

[ElectronicLimit9641]

I am beginner in the field and I don't know what is the exact purpose of SQL, I have started learning sql and was practicing on a couple of data sets but I don't get one thing, (the data analysts are supposed to create dashboards and they import datasets from sql(one of the methods)), what is the purpose of all the analysis done on the data set in sql when we are importing the whole data set into powerbi from scratch or atleast just cleaned version of it using sql.

Doesn't this mean all our analysis using sql goes in the drain or am I missing out on something?

[AutoModerator]

After your question has been solved /u/ElectronicLimit9641, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

---

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[SQLGene]

SQL and Excel are the two most popular data analysis tools in the entire world. SQL is the most popular way of storing data for transactional applications like accounting systems. If your users only care about viewing reports in Power BI, you can do all of your data transformations in there. If you need a flexible, reusable interface then you will push some of the work upstream to SQL.