You can use the Azure Cosmos DB ODBC driver to connect to Azure Cosmos DB by using BI analytics tools such as SQL Server Integration Services, Power BI Desktop, and Tableau. You can then analyze and create visualizations of your Azure Cosmos DB data in those solutions.
The driver offers rich features to help you renormalize data in Azure Cosmos DB. By using the driver, you can represent data in Azure Cosmos DB as tables and views. The driver enables you to perform SQL operations against the tables and views, including grouping by queries, inserts, updates, and deletions. To learn more, see the documentation page.