(This question was asked a couple years back; I'm curious about what newcomers may be gaining traction and are worth considering)
Within my area, data sourced from just about everywhere, Oracle, Maria, SAP, SharePoint, flat files, etc. Alteryx and Informatica used to structure data, with some Python at the more advanced level.
On the visualization side most everything is Tableau or Qlik, with the former having the larger footprint (maybe 3x as large). Tableau is oriented more for less technical business teams, Qlik Sense for more technically included teams (more powerful, at the expense of being more difficult), and QlikView for a lot of legacy dashboards -- currently reviewing whether to close it off to new development.
On the reporting side, primarily Cognos.
We rely heavily on vendor applications since we can typically insure support is available.
Only new tool we've evaluated and picked up recently (last couple of years) has been Looker, which was licensed for a small use case and hasn't worked as expected. Interest has been primarily in the scripting/ETL component, less so on the visualization side, but the license model makes it very expensive for what we use it for.
For enterprise, company-wide aggregation, we were supposed to be feeding an enterprise measures system with long term storage in Amazon Redshift and standardized dashboards built in PowerBI that utilized standard metrics definitions everyone was supposed to converge on. But that product was two years behind schedule and eventually cancelled when the company merged with an airline manufacturer and Covid hit a month later and suddenly capital funds totally dried up. So luckily our on-premises solution was entirely free and allowed user to define whatever collection strategies and metrics they wanted.
I hope someone is still actually using this. It was just me and two other guys who made all this tooling and automation and deployed it to seven pilot product teams middle of last year. Not sure how they're doing without me since I wrote all of the core libraries myself with no external input or review because we were in such a hurry to demonstrate value.
About 5 years ago when I was a BI lead we were using Jasper reports, which was acquired by Tibco. I also trialled stuff like Qlikview and Tableau which seemed great for their particular use-cases.
Before that we used Oracle Discoverer, Oracle Apex and Business Objects.
Home grown ETL processes in Python, Spark and Airflow with Rendeck and Jenkins.
Tableau for dashboards.
Python + Dash for more complicated dashboards.
Looker for reporting.
Airflow for scheduling.
Sagemaker for ML
Redshift for storage
dbt to transform the raw data into something warehousey
Metabase for viz