← All guides

Do You Need a Data Warehouse? The Data Setup for a Small Company

Most small companies do not need a data warehouse. The setup that fits depends on how many systems hold your numbers, how fresh the numbers must be, how many people read them, and who can look after it. The right move is usually one stage up from where you are. A warehouse is rarely the next step.

What companies your size actually use

Power BI is Microsoft’s reporting service. SQL is the language most business databases use.

In 219 finance and office job adverts we collected from small US companies, posted from 11 to 16 September 2026, Excel appeared in 47% and QuickBooks in 25%. None named Power BI or SQL.

We also collected 276 data and analyst adverts from US companies of the same size, posted from 28 October to 9 November 2026. Excel appeared in 41%, SQL in 38%, and Power BI in 24%. Snowflake, Databricks, dbt, BigQuery, and Redshift are tools used by specialist data teams. Together, they appeared in about 5% of these adverts.

Most companies this size run on Excel and an accounting system. Those that hire for data mostly use Excel, SQL, and Power BI.

The four stages at a glance

Stage Fits when Cost per month Who looks after it What breaks first
1. Excel and accounting reports One or two systems, monthly or weekly reporting, and one person builds the pack $0 extra Finance lead or bookkeeper The builder leaves
2. Shared Power BI reports Several people need the same refreshed reports from a few systems $70, or $280 if all 20 view reports Report builder, with outside help for fixes Refresh stops or the gateway sits on a laptop
3. One SQL reporting database Report logic is repeated, history is missing, or Power BI Pro limits are reached About $85 plus Azure Data Factory usage, or $70 with an existing SQL Server. About $295 or $280 if all 20 view Part-time SQL help, with finance owning definitions A load fails silently or an old server reaches end of support
4. Microsoft Fabric A data specialist manages larger volumes, pipelines, and several types of data storage About $226 reserved or $333 pay-as-you-go. About $436 to $543 if all 20 view Data engineer or data warehouse developer The trial ends or viewers lack the required licenses

Costs are for a 20-person company where five people read reports, at Microsoft’s US list prices read on 18 November 2026. The totals are our arithmetic. Five readers is an illustration, and the all-20 figure appears in each stage below.

Stage 1. Excel and your accounting reports

This stage keeps reporting inside spreadsheets and the reports already provided by your accounting system.

It fits when:

  • One or two systems hold the numbers.
  • One person builds the monthly pack.
  • Other people receive a file or PDF.
  • Weekly or monthly numbers are fresh enough.
  • No sheet comes near Excel’s limit of 1,048,576 rows.

The extra monthly cost is $0 for five readers and $0 for all 20 because the reports are shared as files or PDFs. This assumes you already have the spreadsheet and accounting software you use today.

Power BI Desktop is Microsoft’s free Windows application for exploring data and building a report. Microsoft offers a free Power BI account, but sharing reports through the Power BI service requires an upgrade.

Your finance lead or bookkeeper can look after this stage. The first break is usually human. The workbook, file paths, and month-end steps live in one person’s memory. Use The person who ran your data left to record the process before that person goes.

Stage 2. Shared reports on top of your systems

This stage adds online reports directly over the systems and files you already use. It is often the right answer when you are choosing Excel vs Power BI and several people need the same current numbers.

It fits when:

  • Three or more sources are combined by hand each period.
  • Three or more people need the same weekly or daily numbers.
  • People need to read reports on a phone or in Teams.
  • The report remains within the Power BI Pro limits below.

Microsoft lists Power BI Pro at “$14.00 user/month, paid yearly” and Power BI Premium Per User at “$24.00 user/month, paid yearly.” Premium Per User is an option when a small group needs larger models or more frequent refreshes. Every person accessing content in its workspace needs Premium Per User.

For ordinary Pro sharing below Fabric F64, every viewer needs Pro. Five Pro users cost $70 a month. All 20 cost $280 a month. Premium Per User would cost $120 for five people or $480 for all 20.

A Pro semantic model has a 1 GB model limit and up to eight scheduled refreshes a day. A refresh on shared capacity must finish within two hours. Reaching any of those limits points toward stage 3 or a different Power BI license.

The on-premises data gateway is Microsoft’s bridge between the Power BI service and data stored on a local server or PC. It has no license charge and is only needed for local data because cloud services can generally connect without a gateway.

The report builder usually looks after this stage, with outside help for fixes. The first common break is a failed refresh. Power BI can turn off the schedule after four consecutive failures, so use Power BI scheduled refresh not working to check it.

The second break is a gateway installed on a laptop or desk PC. Microsoft advises against installing it on a computer that may be turned off, asleep, or disconnected. Use On-premises data gateway offline when the reports lose their connection.

Stage 3. One SQL database between your systems and reports

At this size, this is what a data warehouse usually means. One reporting database receives data from your business systems, keeps useful history, and gives every report the same cleaned numbers.

It fits when:

  • A model is near 1 GB or a refresh is near two hours.
  • You need more than eight scheduled refreshes a day.
  • The same clean-up appears in several reports and gives different answers.
  • You need history the source systems do not keep, such as month-end snapshots.
  • Four or more sources feed your reporting.
  • You already have SQL Server in the building.

Azure SQL Database is Microsoft’s managed SQL database in Azure. Standard S0 costs about $14.72 a month based on the East US Azure price list and our arithmetic. Microsoft describes Basic as providing less than one vCore, while Standard uses HDD-based storage suited to development, testing, and other infrequently accessed work. Basic allows 2 GB and S0 allows up to 250 GB.

The Azure SQL Database free tier provides a monthly allowance for trying a database. Microsoft positions it for development and proof-of-concept work and gives it no service-level agreement.

Azure Data Factory is Microsoft’s cloud service for scheduling and moving data. Its East US prices are usage-based, including $1 per 1,000 cloud activity runs and separate charges for data movement. The monthly amount depends on what runs, so no estimate is included here.

On site, you can use SQL Server the company already licenses. SQL Server Agent is its job scheduler for nightly loads. SQL Server Express is the free entry-level edition, but Microsoft’s edition table shows that Express has no SQL Server Agent. Express therefore needs another scheduler.

With five Pro readers and Azure SQL Database S0, the monthly total is about $85 plus Data Factory usage. All 20 viewing costs about $295 plus usage. If you already license SQL Server, the total remains $70 for five Pro readers or $280 for all 20, with no new database cost.

Someone who writes SQL and can read a failed job looks after this stage. That is usually part-time help. Your finance lead still owns the meaning of revenue, margin, and open orders.

The first break is often a nightly load that fails without a working alert. SQL Server Database Mail and Office 365 covers those alert emails. The next risk is an old server that has passed its support date. See SQL Server 2016 end of support. The process also becomes fragile when the person who built the loads leaves without documenting them.

Stage 4. Microsoft Fabric

Microsoft Fabric is Microsoft’s cloud service for data storage, data movement, analysis, and reporting within one purchased capacity. It fits when you have a person whose job is data, volumes beyond one SQL reporting database, or a clear need for lakehouses, notebooks, and Fabric pipelines.

Microsoft’s Fabric pricing page shows the purchasing options but does not display numeric prices in its rendered table. The Azure price list for East US lists $0.18 per capacity unit per hour for pay-as-you-go use and $938 per capacity unit per year when reserved.

An F2 capacity has two capacity units. Our arithmetic puts it at about $263 a month pay-as-you-go or $156 a month reserved for one year. Adding five Pro licenses gives a total of about $333 or $226. With all 20 viewing, the total is about $543 or $436.

Below F64, each Power BI viewer still needs Pro, Premium Per User, or an individual trial. F64 is the first size where free users with the viewer role can read Power BI content. It costs about $5,003 a month reserved, which equals about 357 Pro licenses. A company of 20 never reaches that saving.

Microsoft’s own warehouse and lakehouse role list names data engineers and data warehouse developers. That is who looks after this stage. Snowflake, Databricks, and dbt occupy a similar place outside Microsoft and are built for companies with a data team.

Fabric has a 60-day trial for evaluation and testing. When it ends, the Fabric items stop working. Content remains in OneLake, Fabric’s storage layer, for seven days and may then be deleted unless you purchase capacity.

How to tell which stage you are at

Answer these five questions:

  1. Do the numbers you report come from only one or two systems?
  2. Are weekly or monthly numbers fresh enough?
  3. Do five or fewer people need to read shared reports?
  4. Does someone combine files by hand every week or month?
  5. Is there a named person who would fix the setup if it broke tonight?

Mostly yes to the first three, with little manual combining, points to stage 1. Regular file combining or several report readers points to stage 2. Four or more sources, missing history, repeated clean-up, or Pro limits point to stage 3. A named data specialist and a clear need for Fabric-only tools point to stage 4. If nobody would fix a break tonight, ownership is the issue before technology is.

When to hand it over

Hand the setup over when reports matter to weekly decisions but nobody owns refreshes, gateways, database jobs, licenses, and documentation. Our Take over and run it service keeps the setup you have running, fixes breaks before your users notice, and tells you when the next stage is worth it.

Frequently asked questions

Do I need a data warehouse for Power BI?

No. Power BI can report directly from spreadsheets, accounting systems, cloud services, and SQL databases. A warehouse becomes useful when several reports repeat the same clean-up, when you need history the source systems do not retain, or when refresh and model limits start to bite.

How much does Power BI cost for a small business?

Power BI Pro costs $14 per user per month, paid yearly. Five report builders and viewers cost $70 a month, while 20 cost $280. A local data source may also need a gateway, but the gateway itself has no license charge.

Is Power BI free?

Power BI Desktop is free for one person to explore data and build reports. Sharing and collaboration through the Power BI service normally require Pro or Premium Per User for each viewer unless the content is on F64 or larger capacity.

Can a small company use SQL Server Express?

Yes. SQL Server Express can suit a small reporting database and has a 50 GB maximum relational database size. It is limited to the lesser of one socket or four cores, has a 1,410 MB buffer pool, and does not include SQL Server Agent or Database Mail, so scheduled loads and alerts need another arrangement.

When does a small company need Microsoft Fabric?

A small company needs Fabric when it has a data specialist and a clear requirement for Fabric’s lakehouse, warehouse, notebooks, or pipelines. It is rarely justified only to avoid buying Pro licenses because free viewers require F64, which costs about $5,000 a month when reserved.

How we checked this: every price and limit on this page was read on Microsoft’s own price pages, the Azure price list and Microsoft Learn on 18 November 2026. The job advert counts come from adverts we collected from small US companies between September and November 2026.

When the person who ran it has leftTake over and run itPipelines, models and reports stay working. Breaks are fixed, the stack is watched, and one agreed change is made each month.See the offer