The cost of building a data warehouse, maintaining it, and building dashboards that are accessible and available to everyone in an organization can vary greatly depending on a number of factors, such as:

Size of data warehouse: The larger the data warehouse, the higher the cost of building, storing and maintaining the data.

Tools and technologies used: The cost will depend on the tools and technologies used for building and maintaining the data warehouse, such as the database management system, data visualisation tool, cloud service provider, etc.

Expertise required: The cost will also depend on the level of expertise required for building and maintaining the data warehouse, such as data engineers, data scientists, and IT professionals.

Maintenance and upgrades: The cost of maintaining and upgrading the data warehouse and dashboards over time must also be considered.

Let's do this estimate based on Microsoft stack of solutions

Estimating the total cost of ownership (TCO) for a data warehouse solution with millions of records using Azure and Microsoft BI is complex, as it depends on several factors such as data volume, complexity of data, number of users, storage and processing needs, etc. However, here is a rough estimate based on some assumptions:

Cost of building the data warehouse: $100,000 - $500,000

This estimate takes into account the cost of setting up the data ingestion pipelines, data processing and transformation, and setting up the data warehouse.

Cost of operating the data warehouse: $50,000 - $200,000 per year

This estimate includes the cost of storage, processing, virtual machines, and data transfer.

Cost of using Microsoft Power BI: $10 - $30 per user per month

This estimate depends on the number of users, the type of license, and the features used.

Note that this is just a rough estimate and the actual cost can vary greatly based on the specific requirements and use case

Here is a rough estimate of the cost of people required to maintain and build a data warehouse solution with millions of records using Azure and Microsoft BI:

Data Engineers: $100,000 - $200,000 per year

This estimate is based on the cost of hiring data engineers with experience in setting up data ingestion pipelines, data processing and transformation, and data warehousing.

Data Scientists: $120,000 - $250,000 per year

This estimate is based on the cost of hiring data scientists with experience in data analysis, modeling, and visualization.

IT professionals: $80,000 - $150,000 per year

This estimate is based on the cost of hiring IT professionals with experience in managing and maintaining the data warehouse, virtual machines, and cloud infrastructure.