I think you need to go a step further and define a few more terms like what you mean when you say "Analytics" and "business intelligence" For example >PowerBI

I think you need to go a step further and define a few more terms like what you mean when you say "Analytics" and "business intelligence" For example >PowerBI - microsoft business analytics I don't think I would classify Power BI as an analytics tool - In my limited experience with using it I have found that it has some nice ways to build reports and visualize data graphically but only very rudimentary statistical functions and is not really suited for performing data analysis. My organization is travelling along the "modern data" pipeline so I'm grappling with some of the same confusion myself about what everything is in the new world... In the "old data" world I'm familiar with - I would use stuff like SAS or R to perform ad-hoc analytics i.e. analyze data using statistics, perform regressions, Timeseries forecasting, distribution analysis etc. For reporting and visualizing data: that would fall to things like excel, Cognos, ggplot2, Proc report and Some javascript plotting packages like d3js etc. To Extract data would involve running SQL query against databases (Oracle, DB2 or Microsoft SQL Server etc directly) directly then using sas or R to transform the data as needed. Modern approach seems to be Databricks to ingest data into datalake, Python via Juypter notebooks to perform analytics hosted on Azure ML studio running in cloud on a "compute instance" for another level of Indirection...Then Power BI to visualize and build reports.