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.
Start with your analysis methods: for local queries and joins, RAM and SSD storage matter, but the capacity you need also depends on the operations you run. File size alone doesn’t determine a fixed configuration (DuckDB). If you need Power BI Desktop locally, choose a Windows laptop: Microsoft describes Power BI Desktop as a Windows app. Then compare the screen and ports with your hot-desking setup, and check the exact configuration and included accessories.
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.
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.
You move between desks in a shared office and consider screen space, ports and portability, without losing sight of the analysis software you need.
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. |
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.
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.
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.
The Dell Pro 14 PC14250 is a Windows work laptop worth comparing if Power BI Desktop and a 14-inch screen suit your work.
The ThinkPad T14 Gen 6 (AMD) range is worth considering if memory upgrades and connectivity matter for local analysis work.
The EliteBook X Flip G1i B68T1EA#ABH is a useful comparison if a convertible touchscreen and multiple ports would come in handy.
The MacBook Air with M5 is a macOS option if you’ve confirmed that all the analysis software you need works on it.
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.
No image available
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.
No image available
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.
No image available
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.
No image available
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.
No image available
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.
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.
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.
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.
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.
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.