Azure Data Application

Question

Hello all,

I am a teacher with student who is trying to develop and application for a company for a senior project using azure. The requirements are to get data from a database within azure and display metrics to be used by the company. We don't know exactly where to start as there are so many options. Any help for what applications to use for both the data visualization and the database would be helpful. If I left off any important details please ask those as well. Thanks in advance!

Answer 1

Hi @Dan Ballard,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

As i understand that you are trying get data from a database within azure and display metrics.

Any help for what applications to use for both the data visualization and the database would be helpful?

Database options:

• Azure SQL Database: A fully managed relational database service that supports SQL Server. It’s great for structured data and offers high availability, scalability, and security.For more information, please refer the document: SQL Database.
• Azure Cosmos DB: A fully managed NoSQL database service for modern app development. It supports multiple data models like document, key-value, graph, and column-family.For more information, please refer the document: Cosmos DB.
• Azure Data Lake Storage: Ideal for big data analytics, it allows you to store data of any size, shape, and speed.

Data Visualization Options

• Power BI: A powerful business analytics tool that can connect to various data sources, including Azure SQL Database and Azure Cosmos DB. It allows you to create interactive reports and dashboards.

For more information, please refer the document: Power BI.

• Azure Data Explorer Dashboards: This tool integrates with Azure Data Explorer and allows you to run queries and build dashboards directly in the web application.

For more information, please refer the document: Azure Data Explorer dashboards.

• Grafana: An open-source platform for monitoring and observability. Azure Managed Grafana is recommended for cloud-native scenarios.

For more information, please refer the document: Grafana.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.