Who is this guide for?

People with two existing screens

You want to review responses on one screen and keep a data file or set of instructions open on the other. First, check that the connections on the exact mini PC model match both screens. Microsoft Support explains how to use multiple screens in Windows.

People working with larger data files

You regularly sort, merge or transform data, and want to match the memory and software to your own files. Microsoft Support notes that Power Query limits depend in part on available virtual memory and the software architecture.

People with an established software workflow

You have existing Excel queries or other analysis tools, and want to check that the required features, versions and data sources work on your chosen operating system before switching. Microsoft Support sets out version requirements and supported data sources for Power Query in Excel for Mac.

What should you look for?

Pre-configured Windows mini PC

A good fit if: you use Windows software and want a PC with the operating system already installed. Lenovo lists Windows 11 Pro, 16 GB RAM and a 512 GB SSD for the ThinkCentre M70q Gen 6 model 13A4007KEZ.

Bear in mind: check the connections on the exact model. Lenovo’s family specifications list HDMI and DisplayPort, but optional ports are not available on every model.

Configurable mini PC

A good fit if: you want to choose the memory, storage and operating system yourself. ASUS specifies two HDMI 2.1 outputs for the ExpertCenter PN64.

Bear in mind: ASUS also lists models without a pre-installed operating system, so check what’s included with the exact configuration.

Mac mini with macOS

A good fit if: your data-cleaning software and data sources work on macOS. Apple specifies support for multiple external screens for the Mac mini with M6 chip.

Bear in mind: Microsoft lists version requirements for Power Query in Excel for Mac. Don’t assume that features and connections are identical on Windows and macOS.

What to consider What should you check? Who is this important for?
Two screens For each screen, compare its connection and desired resolution with the outputs on the exact PC model. Check the cables too, and choose extend mode if you want to show different things on each screen. If I want to view responses and cleaned data at the same time, both screens need to work independently. That’s why around 36% of consumers make a dual-screen set-up their top priority.
Memory and data processing Consider the size of your files, your version of Excel and the tasks you carry out. Then compare the memory and SSD in the exact configuration. When working with large files and recurring transformations, I want to match the configuration to the way I work, not just make sure the PC starts up. Around 29% of consumers prioritise data processing.
Software and data sources Check your programmes, existing queries, versions and connections for the operating system you plan to use. If I want to keep using existing queries and data sources, the features I need must be available on my chosen system and software version. Around 21% of consumers base their choice mainly on software compatibility.
Purchase and set-up Compare the exact model, including the operating system, memory, SSD and any screen cables you need. When I’m considering a configurable PC, I want to know in advance what I’ll still need to install or buy. Around 14% of consumers make the configuration contents and set-up requirements their top priority.

Buying pitfalls

  • Assuming two ports automatically mean two usable screens

    The outputs on the exact PC model need to match the inputs and desired resolutions of both screens. A family specification doesn’t guarantee that every optional port is available on every model.

    Check each screen and the PC model separately, including the connection, cable and desired resolution.

    You may need different cables or adapters.

  • Comparing a configurable PC as if everything is included

    A model may be sold without a pre-installed operating system, so check what’s included before comparing configurations.

    Check the operating system, memory, storage and included accessories for each model.

    A missing operating system or other essential components may mean extra purchases and set-up work.

  • Assuming software works the same on Windows and macOS

    Microsoft lists version requirements and information about supported data sources for Power Query on Mac. That doesn’t mean every existing query or connection will work identically on both systems.

    Before buying, check your key files, queries and connections with the software version you plan to use.

    Adapting queries or connections can take time.

  • Taking a security claim as proof that survey data is fully protected

    If you process data that can be traced back to individuals, the Dutch Data Protection Authority says that appropriate security depends on the processing involved and the risks.

    Assess whether the data can be traced back to individuals and, where necessary, put appropriate measures in place, such as access controls, updates and recovery options.

Brands to consider

Lenovo

The ThinkCentre M70q Gen 6 is a business Windows mini PC range. Check the ports on your chosen model before using it with two screens.

  • Lenovo lists Windows 11 Pro, 16 GB RAM and a 512 GB SSD for model 13A4007KEZ. Lenovo PSREF lists HDMI and DisplayPort for the product family.
  • Optional screen ports vary by model, so check the exact configuration and your screens.

ASUS

The ExpertCenter PN64 is a configurable option to consider if your screens use HDMI and you want to choose the specification yourself.

  • ASUS specifies two HDMI 2.1 outputs and upgradeable DDR5 memory for the PN64.
  • ASUS also lists a model without a pre-installed operating system. Check the operating system, memory and storage for each model.

Apple

The Mac mini with M6 chip is a compact macOS option if your specific data-cleaning software and data sources work with macOS.

  • Apple specifies support for multiple external screens. Microsoft documents Power Query for Excel on Mac.
  • Check your version of Excel, data sources and existing tasks. Windows and macOS workflows aren’t automatically identical.

HP

The Pro Mini 400 G9 is a business Windows mini PC range. Assess the exact configuration before choosing it for two screens.

  • HP lists Windows 11 Pro, 16 GB RAM and a 512 GB SSD for model 9H6Z2ET#ABH.
  • Check which screen outputs are available on your chosen model and whether they match your screens.

Mini PCs on Joybuy

These Joybuy products are mini PCs worth comparing for local data work. For each model, check the screen outputs and software requirements for your own set-up.

SOYO Y5Pro mini PC

SOYO Y5Pro mini PC

Check the software requirements and connections for your two screens before choosing this configuration.

The product name lists an Intel Core i5 8250U/8350U, 8 GB DDR4 and a 256 GB SATA SSD.

View at Joybuy
Apple Mac mini with M6 chip, 16 GB and 256 GB SSD

Apple Mac mini M6, 16 GB, 256 GB SSD

Check that your data-cleaning software, queries and data sources work with your version of macOS and your software.

12-core CPU, 12-core GPU, 16 GB memory and 256 GB SSD.

View at Joybuy
Apple Mac mini with M6 chip, 16 GB and 512 GB SSD

Apple Mac mini M6, 16 GB, 512 GB SSD

Check that your data-cleaning software, queries and data sources work with your version of macOS and your software.

12-core CPU, 12-core GPU, 16 GB memory and 512 GB SSD.

View at Joybuy
Apple Mac mini with M6 chip, 24 GB and 512 GB SSD

Apple Mac mini M6, 24 GB, 512 GB SSD

Check that your data-cleaning software, queries and data sources work with your version of macOS and your software.

12-core CPU, 12-core GPU, 24 GB memory and 512 GB SSD.

View at Joybuy
ASUS Ascent GX10 GB10 mini PC with 128 GB LPDDR5x and 1 TB SSD

ASUS Ascent GX10 GB10, 128 GB LPDDR5x, 1 TB SSD

Check the exact screen connections and software requirements for your intended set-up.

The product name lists 128 GB LPDDR5x memory and a 1 TB SSD.

View at Joybuy

Frequently asked questions

How do I set up two screens without duplicating the same image?

Connect both screens using suitable connections, then in Windows go to Settings, System and Display and choose Extend these displays. You can also identify and arrange the screens there. Beforehand, check that your chosen PC supports both screens independently.

Is 16 GB RAM always enough for my survey files?

No, 16 GB isn’t a universal benchmark for this task. Microsoft Support says that the amount of data Power Query can process depends in part on the available virtual memory, the software architecture and the operation being performed. Check your own files and software before choosing a configuration.

Can I run existing Power Query tasks on a Mac mini?

Excel for Mac includes Power Query, but Microsoft Support lists version requirements and explains which data sources are supported. Check the version, connectors and specific queries in your existing workflow before buying.

Is a mini PC on its own enough to process survey data in line with the GDPR?

No. The GDPR applies if data can be linked directly or indirectly to individuals and an organisation processes it. The Dutch Data Protection Authority says that appropriate security depends on the specific processing and risks; a particular PC or built-in feature is not, by itself, proof of compliance.

What should I check during set-up and maintenance?

First, check the cables and make sure both screens are recognised. Microsoft Support also recommends checking for Windows updates if you have display problems. If your organisation processes personal data, the Dutch Data Protection Authority lists up-to-date software, backups and encryption among possible security measures. The measures that are appropriate depend on the processing and the risks.