Who is this choice relevant to?

Local data analyst

You explore datasets using local queries, joins or transformations, and want to match RAM and SSD storage to the work you actually do. DuckDB points out that memory requirements also depend on the dataset and the queries.

Power BI user

You need to create or edit reports in Power BI Desktop, so the software you require determines your choice of operating system first. Microsoft describes Power BI Desktop as a Windows app.

Hot-desking analyst

You move between desks in a shared office and consider screen space, ports and portability, without losing sight of the analysis software you need.

What should you look for when choosing?

Start with the software you need, then match RAM and SSD storage to your queries. Finally, check the ports and included accessories for your shared workspace.

What to consider What should you look for? Who is this most important for?
Local processing capacity Match RAM and SSD capacity to your queries and tools; also check whether the exact configuration can be upgraded. If I run joins or transformations locally, I want enough RAM and SSD space for my analyses. Around 36% of consumers prioritise local processing capacity.
Software compatibility Check in advance which desktop programmes and plugins you need, and which operating systems they work on. When I need to use essential analysis software locally, I want to make sure it works with the operating system first. Around 29% of consumers put software compatibility first.
Changing workspaces Compare the screen and ports with the monitors, cables and peripherals at the office; decide whether you need a dock. At a hot desk, I want to be able to connect my laptop easily to the screens and equipment provided. This is the top priority for around 21% of consumers.
Configuration and service Compare the same RAM and SSD configuration, and check which accessories and service terms are included. When I buy a laptop for work, I want to compare the complete configuration and the applicable service terms. Around 14% of consumers prioritise these purchase conditions.

Common mistakes

  • Assuming a large file means you need a set amount of RAM

    The resources you need also depend on the type of query and whether an operation spills over to disk. File size alone doesn’t tell you how much RAM your analysis requires.

    Assess a representative analysis and compare both RAM and local SSD storage.

  • Choosing a Mac without checking your essential desktop software

    Microsoft describes Power BI Desktop as a Windows app. If you need to run it locally, macOS won’t meet that requirement.

    Before comparing laptops, make a list of the programmes you need and the operating systems they support.

  • Looking only at the laptop when you use a hot desk

    Ports vary by model, and the Dell Pro 14 configuration reviewed doesn’t list a charger as included. This means the laptop might not connect straight away to your existing workspace.

    Compare the ports and box contents with the screens and equipment you use.

Relevant brands to consider

Dell

The Dell Pro 14 PC14250 is a Windows work laptop worth comparing if Power BI Desktop and a 14-inch screen suit your work.

  • For the configuration reviewed, Dell lists 16 GB DDR5, a 512 GB SSD and a 14-inch screen with a resolution of 1920 × 1200.
  • Dell doesn’t list a charger as included with this configuration, and specifications can vary across the range. These are manufacturer specifications, not the results of an independent performance test.

Lenovo

The ThinkPad T14 Gen 6 (AMD) range is worth considering if memory upgrades and connectivity matter for local analysis work.

  • Lenovo specifies two DDR5-SODIMM slots and support for up to 64 GB across the range, as well as HDMI and Ethernet.
  • Configurations and regions vary. Check the exact model and keyboard layout before ordering.

HP

The EliteBook X Flip G1i B68T1EA#ABH is a useful comparison if a convertible touchscreen and multiple ports would come in handy.

  • HP lists 32 GB RAM, a 1 TB SSD, a 14-inch touchscreen, HDMI, USB-A and three USB-C ports for this configuration.
  • Check availability and the features of the specific offer; the specifications listed apply to this configuration.

Apple

The MacBook Air with M5 is a macOS option if you’ve confirmed that all the analysis software you need works on it.

  • For the 13-inch base model, Apple specifies 16 GB unified memory, a 512 GB SSD and two Thunderbolt 4 ports.
  • Microsoft describes Power BI Desktop as a Windows app. The Apple specifications listed don’t show that the app runs locally on macOS.

Joybuy laptops for exploring datasets

This selection includes Windows laptops for local analysis and software that runs on Windows, as well as a MacBook Air for analysis tools that work on macOS. Before buying, check that the programmes you need run on your chosen operating system.

HP OmniBook Ultra Next Gen AI 16-bk0004nd with 128 GB RAM and 2 TB SSD

HP OmniBook Ultra Next Gen AI 16-bk0004nd

This Windows 11 Pro laptop is worth comparing for local analysis where RAM and SSD storage matter.

128 GB RAM and a 2 TB SSD.

16-inch 3K OLED touchscreen with a 120 Hz refresh rate.

Check how much capacity your analysis requires; file size alone doesn’t determine this.

View at Joybuy
MSI Venture 16 AI A2HMG-068NL with 32 GB DDR5 and 512 GB SSD

MSI Venture 16 AI A2HMG-068NL

This Windows 11 Pro configuration could suit local analysis and workspaces where you connect an external screen or peripherals.

32 GB DDR5 and a 512 GB PCIe 4.0 NVMe SSD.

16-inch screen with a resolution of 1920 × 1200 and a 144 Hz refresh rate.

Ports: HDMI, USB-C with DisplayPort and Gigabit Ethernet. The product information doesn’t list a power adapter as included.

View at Joybuy
Apple MacBook Air 15-inch M5 with 16 GB memory and 512 GB SSD in Starlight

Apple MacBook Air 15-inch M5, 16 GB, 512 GB

This macOS laptop is for analysis tools that work on macOS. Don’t choose it if you need Power BI Desktop locally, as Microsoft describes the app as a Windows app.

15.3-inch screen, 16 GB memory and a 512 GB SSD.

Two Thunderbolt 4 ports. The power adapter isn’t included; according to the product information, a USB-C adapter rated at 35 W or higher is required.

Colour: Starlight. QWERTY keyboard.

View at Joybuy
Dell Latitude 7650 with Intel Core Ultra 7 155U, 16 GB RAM and 512 GB SSD

Dell Latitude 7650, Intel Core Ultra 7 155U

This Windows 11 Pro laptop is worth comparing if you use Windows software and connect peripherals at different desks.

16 GB LPDDR5x memory and a 512 GB SSD.

16-inch screen with a resolution of 1920 × 1200; listed weight is 1,835 kg.

Ports: HDMI and two Thunderbolt 4 ports. The power adapter must be purchased separately.

View at Joybuy
HP OmniBook X Flip NG AI PC 16-ar0070nd with 24 GB memory and 1 TB SSD

HP OmniBook X Flip NG AI PC 16-ar0070nd

This Windows 11 Home laptop could suit local analysis if the software you need works on Windows.

24 GB LPDDR5x memory and a 1 TB SSD.

16-inch OLED touchscreen with a 2-in-1 design.

View at Joybuy

Frequently asked questions

Should you choose a laptop based only on the size of a dataset file?

No. DuckDB notes that the queries you run also affect how much memory you need, and some operations may spill over to disk. So match your choice to your own analyses and the SSD storage available.

Can you use Power BI Desktop directly on a MacBook Air?

Microsoft describes Power BI Desktop as a Windows app. If you need to use this desktop application locally, don’t choose based only on the hardware specifications of a MacBook Air.

What should you look for in a laptop for a hot desk?

Check which cables, monitors and peripherals are used at your workspace. Then compare them with the ports on the exact laptop configuration, and decide whether you need a dock or adapter.

In the Netherlands, what happens if a laptop breaks too soon during normal use?

For a consumer purchase, ACM ConsuWijzer says statutory guarantee applies: the seller must resolve a problem with a faulty product free of charge, for example by repairing or replacing it, or sometimes by refunding you. If you’re buying on behalf of a business, check separately which contractual terms apply; don’t assume the consumer rules automatically apply.

Can you analyse personal data just because a dataset is publicly available?

No. Personal data that is publicly available can’t automatically be used for any purpose. The Dutch Data Protection Authority emphasises that public availability alone doesn’t give you free rein to use the data for any purpose; assess the purpose and content of the data before processing it.