How does SQL + KPI reporting actually work in a real data analyst job?

I'm learning data analytics and have no real industry experience. Can someone explain the end-to-end workflow in a company? Where are KPIs usually stored or defined? Where does the data come from (ERP, CRM, databases, etc.)? Where do analysts write SQL queries? After getting the results, how are they shared with stakeholders (Excel, Power BI, dashboards, email)? submitted by /u/Pretend_Muffin_3289 [link] [comments]