binse: Data Analytics · iPad

From raw data to an interactive dashboard & presentation, on an iPad.

Bring a file in from Files. Tidy it, step by step, with the table in front of you. Build a dashboard that filters when you touch it. Then stand up and present it, with your notes on the iPad and the page on the screen behind you. All of it runs on the iPad, offline.

Coming soon Built, and being finished for the App Store. Ask to be told the day it ships.

01 · Bring it in A file from Files, iCloud Drive or OneDrive becomes a table.
02 · Tidy it Steps you can see, each with a preview of what it did.
03 · Chart it Tap a bar, and the whole page follows it.
04 · Present it A point at a time, on the screen behind you.

44

Prep steps for tidying a table, from keeping rows to joining, pivoting and matching similar text

363

visuals in the gallery, the same set as Binse on a computer

13

looks for presentation text, over 20 typefaces and 9 entrances

14

templates for text pages, some with words alone and some beside your charts

01 · Bring it in

Your files, from wherever they are kept.

A spreadsheet, an export from another system, a file someone sent. Open it in the app and it becomes a table under Data, ready to tidy, chart or both.

Open a file, and it is a table

The app reads the file where it is and keeps its own copy in the Binse folder in Files, so it works without a connection.

CSV, Excel, Parquet and JSON, from Files, iCloud Drive, OneDrive or anywhere else the Files app reaches.
Open in, from other apps. A file shared to the app from Mail or a browser arrives in Data by itself.
Every column has a type, shown on its badge: text, number, date or yes and no.
Look inside any table before doing anything with it: its first rows and every column.
Show it in every visual. One tap draws the table in every kind of chart, to see what it could become.

The Data tab in landscape: the coffee sales and shops tables and the two tables that Prep flows make, each a card with its rows, its columns and the first of its column names. — **A file in, and a look inside it.** The badges say what each column holds.

A library you can scan, or read

Dashboards, tables and Prep flows each have a tab. Each tab can be cards or a list, and remembers which.

Cards with a small picture of each dashboard's first page, or the columns of each table.
A list with the details: rows, columns, file size, which dashboards and flows use a table, and when each thing last changed, to the minute.
Sort by any column with a tap on its heading, and again to reverse it.
The next thing to make sits beside the tabs: a new dashboard, a new table or a new flow, depending on where you are.

The Data tab as a list: each table with its type, name and file, rows, columns, size, what uses it, and when it was last read, sorted by name. — **The list view.** Everything a card has no room for, sortable.

02 · Tidy it in Prep

Tidy the data one step at a time, and see each step work.

A Prep flow is a list of steps. Each says what it does and how many rows come out of it, and the table after the step you choose fills the rest of the screen. There is no Run button: every change runs at once and saves itself.

44 steps, found by typing

Grouped as rows, columns, combining, reshaping, profiling and analysing, with a search that knows what people call them: pivot, lookup, dedupe.

Rows: keep the rows you want, by value or by position, remove duplicates, sort, take a sample, or the top or bottom rows.
Columns: change a type, fill in blanks, find and replace, clean up text, rename, number the rows, put numbers into bands, running totals, and new columns from a formula.
Combine: join a table, add rows from another, keep the rows found in a list, replace from a list, and match similar text.
Reshape: group and summarise, values into columns and back again, and fill in missing dates.
Profile and analyse: profile the columns, count values, find groups, correlation, forecast and predict a number.
Every step can be turned off, moved up or down, or removed, and the flow runs again as you do it.

Steps, and what they did. The count on each step changes as it runs.

Look at a table before you join it

Other tables opens a window with every table down the left and the one you tap on the right, its first rows and every column, without leaving the flow.

Shared columns are marked, and the tables that share the most with yours come first.
Choosing a table for a join fills in the matching column for you.
Keep one beside the steps while you work, and go back to your own table with a tap.

The Other tables window: the tables listed on the left with their rows, columns and the columns each shares, and on the right the Coffee shops table with all eight shops, their cities and opening dates. — **Other tables.** Names on the left, the rows on the right.

What comes out is a table

The result appears in Data under the flow's name, and dashboards read it like any file.
Change the flow and every dashboard built on it follows.
Make a dashboard from it with one tap, or share the result as a CSV file.

03 · Chart it

Dashboards you use with your fingers.

The dashboard canvas from Binse, full screen. Tap a bar, a slice or a row and every other figure, chart, map and table on the page filters to it. Tap it again to let go.

Tap to filter

Cross-filtering as on a computer: one mark chosen, the whole page answers.
Filters and bookmarks in a bar that comes down when you want it.
Drill down into a chart, or through to another page that opens filtered to what you tapped.
Swipe between pages, with the page names along the top.
Share a page as a picture through the share sheet.

One tap. The key figure and every chart follow the shop you chose.

Build it on the iPad

Edit brings the visuals in from the left and the settings in from the right. Done puts them away again.

363 visuals in a gallery by family, from key figures and bars to maps, gauges and tables.
A new visual starts on sensible columns from its table, rather than empty.
Made for a finger: press and hold for menus, a mode to select several at once, and panels that fit a portrait screen.
Copy and paste visuals between pages and dashboards, and undo anything.
A keyboard works as on a computer: undo, redo, copy, paste and delete.
Themes for colour, corners and density, and it saves itself as you go.

The dashboard builder in landscape: on the left the visuals, the coffee sales table's measures and fields; in the middle the Overview page with its key figures and charts, the Revenue by shop bar chart selected; on the right that chart's settings, its dimension, measure, orientation, sort and top ten. — **The builder, in landscape.** Visuals and fields on the left, the page in the middle, the chosen chart's settings on the right.

04 · Present it

Stand up and present it, live.

Present turns a dashboard into a talk. Each page fills the screen and stays live, so a question from the room is a tap away from its answer, on the page everyone is looking at.

Your notes on the iPad, the page on the screen

Connect a screen or projector by cable or AirPlay and the room sees the page, nothing else. The iPad becomes the presenter's view.

Notes for each page, written in the page's menu and shown large beside the page.
What comes next, the time since you started, and the time of day.
A laser pointer: a finger on the iPad becomes a red dot on both screens.
A clicker or a keyboard moves the talk on: arrows, page up and down, and the space bar.
Pages can be left out of the talk and still be there to view and edit, and the screen stays on while you present.
A headline for a page, shown only while presenting, titles a chart for the room without changing the dashboard.

The presenter view on the iPad: the Takeaway page live on the left, a bar chart of revenue by shop beside a slide of text, and on the right the timer, the page notes in large type, one point still to come, and the Next point, pointer and End buttons. — **The presenter's view.** The page, your notes, what comes next and the time.

Presentation text, made for a room

Slide text is a visual for words: titles, kickers, points, quotes and columns, with numbers in the sentences that stay live and follow the filters.

13 looks, from stage black and paper white to editorial, neon and chalkboard, and every setting can be changed on top.
20 typefaces, chosen separately for headings and body, with weights, capitals, spacing and 10 kinds of bullet.
It fits the box, growing as well as shrinking, on the iPad and on a large screen alike.
Live numbers in a sentence, with an arrow and a colour for up or down, and an agenda written from the page names.
Gradient headings, a glow, frosted glass, accent bars, borders and shadows.
9 entrances, and points that build one at a time with each press of the clicker.

A point at a time. Each press brings in the next one, then the next page.

Start from a template

14 templates for a new page, in the look you choose: a title, an agenda, a section divider, points, two columns, a big number, a quote, a statement, next steps and a closing slide, and four that put words beside charts already on the dashboard.

The New text page window over the dashboard in Edit: the looks along the top with Neon chosen, then the templates for text alone and for text beside a chart, each drawn in the Neon colours. — **New text page.** Choose a look, then a template.

05 · The first lesson

A first lesson that has you doing it for real.

The first time it opens, the app offers a short lesson with practice data from an invented chain of 8 coffee shops, or with a file of your own. It covers the whole journey, in the app itself.

It points at the real button, says in a sentence what to do, and moves on when it sees you have done it.
Messy on purpose. The practice files need tidying, so every Prep step fixes something you can see.
Never in the way. Every step can be skipped, the lesson paused and carried on later, or started again.
Tidy at the end. It offers to remove what it made, and never removes a file of your own.

The first lesson in the app: a flow has just been started from Coffee sales, a light is around the Add a step button, and a card beside it says Part 2 of 4, Tidy it in Prep: tap Add a step, then Change type. — **The lesson.** A light on the button, and a sentence about it.

06 · Made for iPad

An iPad app, not a website in a frame.

Offline

The data, the flows and the dashboards live on the iPad. A train, a plane or a basement meeting room makes no difference.

Ordinary files

Everything sits in the Binse folder in Files, where it can be backed up, shared and opened on a computer.

A finger first

Controls sized for a finger, press and hold for menus, swipes between pages, and a little haptic tap when something snaps into place.

Portrait and landscape

Panels sit beside the page in landscape and come in over it in portrait, so the page is what you see first either way.

A keyboard when you want one

With a keyboard attached, the shortcuts from a computer work, and a presentation clicker moves a talk on.

The share sheet

A page as a picture, a table as CSV, straight to Mail, Messages, AirDrop or Files.

07 · Buying

Bought on the App Store.

binse: Data Analytics is a yearly App Store subscription, bought and managed with your Apple Account. It is separate from a Binse licence for Windows or Mac, and not included with one. The price page has every price side by side.

Runs on: iPad; iPadOS 18 or later.
What it costs: €49.99 a year; An App Store subscription, bought and managed with your Apple Account.
When: Coming soon; Built, and being finished for the App Store.
On a computer: Binse for Windows and Mac; The full product, with its own licence. Dashboards on a computer.

Ask to be told the day it ships Both iPad apps