# Oplema > Oplema is a browser-based data analytics platform, built in Denmark. Strata prepares data: clean, join and reshape files and databases in a visual flow of blocks, in the same space as Alteryx, KNIME or Power Query. Vista turns the result into interactive dashboards you publish by link, in the same space as Power BI, Tableau or Looker Studio. Elara is an AI assistant that builds and edits both. Local work in Strata and Vista needs no install, account or card. Last updated 2026-11-08. For how to use Oplema, with every block, setting, visual and how-to guide, read https://oplema.com/docs/llms.txt. Every page is also available as Markdown: add .md to its URL (/index.md for the homepage) or request the page with the Accept: text/markdown header. The links below point to the Markdown versions. **What Oplema is for** - Preparing data without code: filter, join, reshape, aggregate and clean CSV, Excel, JSON and Parquet files, or data from connectors for databases, cloud storage, business apps and finance tools. Each step is a block with a preview of its result. - Repeatable reports: run the same Strata flow again when the data changes, or schedule it in Cloud. Schedules run as hosted runs in your region, even when your browser is closed, as often as every minute. - Dashboards: build charts, tables, KPIs and filter controls in Vista on top of a Strata flow, arrange them across pages and publish a link. People with the link don't need an account. - Python export: export a Strata flow as a Python script that runs on local files. - Version history: Echo saves versions of flows and dashboards for free, with branches, comparisons and a way back to any earlier version. - AI help: Elara builds and fixes flows and dashboards with the same blocks you use, so everything it adds can be inspected and edited. - Teams: share projects, set roles and member spending limits in Console. There are no per-seat fees. **Limits, and when another tool fits better** - Editing needs a desktop browser. - Dashboards can't be exported as HTML, PNG or PDF. They are shared as a published link. - Anyone who can open a published dashboard can reach the published project and its input data. Filters don't limit that, so publish only what viewers may see. - Every hosted run, scheduled or not, stops after 5 minutes on 2 vCPU and 4 GiB, so long-running jobs belong in a data warehouse or ETL tool. - Previews show 100 rows by default, and you can switch a preview to all rows. Runs and published dashboards always use all rows. - The exported Python script reads and writes local files only. - Database and app connections always go through Oplema's servers, even when the flow runs in your browser. - Oplema has no SOC 2 report. **Free use and accounts** - Strata and Vista run free in the browser with no account or card. Connector reads and writes over the first 50 MB of each transfer are paid from usage, even when the flow runs locally. - Without an account, Cloud keeps 25 MB of files and projects and deletes them about 30 days after the guest session started. - A free account stores 25 MB for free, pays $0.01 per GB per day from usage for anything above that, and gets a one-time $10 usage credit after email verification, valid for 3 months. - Publishing and viewing a dashboard have no fee. Connector downloads over the free allowance spend the publisher's or team's usage. - An account is needed to publish dashboards, schedule runs, share projects, use partner connectors and use Elara with any model. - There are no per-seat fees. Teammates and dashboard viewers add no cost; usage pays for hosted runs, connector transfers and Elara on hosted models. - Account and Cloud data are stored in the region chosen at sign-up: United States (US West), United States (US East), European Union (Germany) or Asia (Singapore). People you share with need an account in the same region. **Pricing** - Cloud subscriptions are in USD. Usage is released monthly, including on annual billing. Annual amounts are the full upfront payment. - Oplema Starter: $20/month or $192/year, with $20 of usage every month. - Oplema Regular: $60/month or $576/year, with $80 of usage every month. - Oplema Scale: $200/month or $1,920/year, with $320 of usage every month. - Annual billing saves 20% compared with paying monthly. Monthly usage expires at the next monthly reset. Top-ups expire after 12 months per purchase; there's no cap on total usage. - Hosted runs cost $0.0024 per minute on 2 vCPU and 4 GiB. Data transfer over the first 50 MB of each transfer costs $0.01 per GB. Per million tokens, depending on your account's region, Elara's own models cost $0.4234–$1.3926 input / $1.2701–$5.5704 output for Elara Spark 1.0 and $8.64–$9.504 input / $43.20–$47.52 output for Elara Flame 1.0 ($17.28–$19.008 input / $64.80–$71.28 output above 272,000 prompt tokens), and other hosted models start at $0.3456 input / $2.16 output. Cloud storage is free within the limits above. **Elara and your data** - Elara can use Oplema's hosted models, paid from usage: Elara Spark and Elara Flame, plus models from OpenAI, Anthropic, DeepSeek, Z.ai / GLM, xAI / Grok, Mistral, Google Gemini and MiniMax. - Elara can also use your own key with any OpenAI-compatible HTTPS endpoint, sent through Oplema's proxy, or a model server on your own machine, such as Ollama. - Every option needs an account. Elara sends the conversation and run information to Oplema, even with a local model, and its tool results can include up to 100 rows per variable each time it inspects data. - Elara conversations are used to improve Elara unless you opt out in profile settings. Oplema doesn't use your content to train third-party foundation models. ## Products - [Strata](https://oplema.com/strata.md): Clean, combine and reshape data in your browser with blocks or a script. Inspect every step, then run the flow again when your data changes. - [Vista](https://oplema.com/vista.md): Build interactive dashboards on your Strata flows, right in your browser. Arrange charts and tables across pages and publish a link for others to explore. - [Elara](https://oplema.com/elara.md): Ask Elara to build Strata flows and Vista dashboards, check a result or fix a step that failed. You choose the model and can edit everything it adds. - [Echo](https://oplema.com/echo.md): Save versions of your Strata flows and Vista dashboards for free. Branch to try another approach, compare versions to see what changed or go back. - [Cloud](https://oplema.com/cloud.md): Keep your projects and data files in one place, share access, publish dashboards at their own link and schedule hosted runs. Free accounts include storage. - [Console](https://oplema.com/console.md): Manage your team's cloud usage in one place. Assign usage to each team, set roles and member spending limits and track storage, with no seat fees. - [Connectors](https://oplema.com/connectors.md): Find the connector for your data, from local files and cloud storage to databases, business apps and finance tools, and bring it into a Strata flow. ## Alternatives and comparisons - [All comparisons](https://oplema.com/comparisons.md): Compare Strata, Vista and Elara with 15 data tools. See how each works, when it fits better and estimate what your current tools cost a year. - [Alteryx alternative (Strata)](https://oplema.com/comparisons/alteryx-alternative.md): See how Strata compares with Alteryx on per-user licenses, browser flows and Python export, and when Alteryx's connectors and automation fit better. - [Count alternative (Oplema)](https://oplema.com/comparisons/count-alternative.md): Compare Strata and Vista with Count's shared canvas on editor pricing and where work runs, and see when real-time canvas collaboration fits better. - [Deepnote alternative (Oplema)](https://oplema.com/comparisons/deepnote-alternative.md): See how visual Strata flows compare with Deepnote notebooks on editor pricing and local runs, and when Jupyter workflows and managed compute fit better. - [FME alternative (Strata)](https://oplema.com/comparisons/fme-alternative.md): Compare Strata with FME Form for tabular data prep, from license cost to Python export, and see when FME's spatial and CAD tools are the better fit. - [Hex alternative (Oplema)](https://oplema.com/comparisons/hex-alternative.md): See how Strata and Vista compare with Hex notebooks on editor pricing and local runs, and when Hex's published data apps and managed compute fit better. - [Julius AI alternative (Elara)](https://oplema.com/comparisons/julius-ai-alternative.md): Compare Elara with Julius AI on editable flows and dashboards, model choice and pricing, and see when chat-first analysis and reports fit better. - [KNIME alternative (Strata)](https://oplema.com/comparisons/knime-alternative.md): See how Strata's browser flows compare with KNIME's desktop app and Hub pricing, and when KNIME's specialist nodes and extensions fit better. - [Looker alternative (Vista)](https://oplema.com/comparisons/looker-alternative.md): Compare Vista with Looker on platform and viewer licenses and LookML modeling, and see when Looker's governed metrics are the better fit. - [Metabase alternative (Vista)](https://oplema.com/comparisons/metabase-alternative.md): See how Vista compares with Metabase on Cloud and self-hosted costs and where dashboards get data, and when Metabase's SQL and query builder fit better. - [Power BI alternative (Vista)](https://oplema.com/comparisons/power-bi-alternative.md): Compare Vista with Power BI on Pro and viewer licenses and browser authoring, and see when DAX models and Microsoft 365 make Power BI the better fit. - [Prophecy alternative (Strata)](https://oplema.com/comparisons/prophecy-alternative.md): See how Strata's local browser flows compare with Prophecy's cloud pipelines and per-user pricing, and when Spark, warehouse and Git workflows fit better. - [Qlik alternative (Vista)](https://oplema.com/comparisons/qlik-alternative.md): Compare Vista with Qlik Cloud Analytics on capacity pricing and local work, and see when associative exploration and managed spaces fit better. - [Sigma alternative (Vista)](https://oplema.com/comparisons/sigma-alternative.md): See how Vista compares with Sigma on license costs and working without a data warehouse, and when Sigma's spreadsheet-style analysis fits better. - [Tableau alternative (Vista)](https://oplema.com/comparisons/tableau-alternative.md): Compare Vista with Tableau on Creator and Viewer pricing and browser authoring, and see when Tableau's charts and enterprise governance fit better. - [Talend alternative (Strata)](https://oplema.com/comparisons/talend-alternative.md): See how Strata's free local flows compare with Qlik Talend Cloud's capacity pricing since Open Studio retired, and when enterprise integration fits better. ## Use cases - [Use cases](https://oplema.com/use-cases.md): Work through six data analysis examples, from AR aging and budget vs actual to churn and CAC, each with a flow and a dashboard, on fictional data. - [Month-end reporting for a small business](https://oplema.com/use-cases/month-end-reporting.md): Turn a small business's month-end books into a collections call list and a product decision on one dashboard, then publish and schedule it for next month. - [AR aging report with a collections call list](https://oplema.com/use-cases/ar-aging.md): Build an AR aging report that ranks who to call first by days late and payment history, in an interactive example with fictional invoices and payments. - [Budget vs actual variance by department](https://oplema.com/use-cases/budget-vs-actual.md): Compare budget with actual spend by department and see how a total under plan hid a growing overspend, in an interactive example with fictional data. - [Contribution margin by product](https://oplema.com/use-cases/contribution-margin.md): Calculate contribution margin by product from order lines, fees and unit costs, and see why the best seller doesn't earn the most, using fictional data. - [CAC by channel and cost per retained customer](https://oplema.com/use-cases/cac-by-channel.md): Calculate CAC by channel, then the cost per customer still subscribed after 90 days, and see why the cheapest channel changes, using fictional data. - [Customer churn analysis by onboarding and segment](https://oplema.com/use-cases/customer-churn.md): Compare who canceled with who stayed by onboarding, plan, company size and industry at 90 days, in an interactive example on fictional data. ## Getting started and documentation - [Getting started](https://oplema.com/docs/getting-started.md): Join two sample tables, chart revenue by country, save a version and open it again in a 15-minute tutorial that needs no account. - [How-to guides by task](https://oplema.com/docs/how-do-i.md): Find the guide for your task: build flows and dashboards, connect data, schedule runs, publish, share, manage teams and pay for usage. - [Documentation](https://oplema.com/docs.md): Learn to prepare data in Strata and build dashboards in Vista, with a 15-minute first tutorial, task guides and a reference for every block and visual. - [Oplema documentation](https://oplema.com/docs/llms.txt): Documentation for Oplema, a browser-based data analytics platform: Strata prepares data in flows of blocks, Vista builds interactive dashboards, Elara is the AI assistant, Echo keeps version history, Cloud stores, shares, publishes and schedules work, and Console manages teams and usage. ## Pricing details and FAQ - [Pricing](https://oplema.com/pricing.md): Build locally for free, then compare cloud plans, top-ups and what hosted runs, Elara and data transfer cost. Estimate your monthly bill by plan. - [FAQ](https://oplema.com/faq.md): Get answers on accounts, saving and sharing projects, what's free and what costs money, how Elara works and where your data goes in Oplema. ## Company and contact - [About us](https://oplema.com/about-us.md): Meet the founders building Oplema in Denmark and see why data prep, dashboards, AI and version history share one project, with no seat fees. - [Contact](https://oplema.com/contact.md): Get support, share feedback, plan a team or classroom rollout or report a security issue. A founder usually replies within one business day. ## Legal and data handling - [Privacy policy](https://oplema.com/privacy-policy.md): See what personal data Oplema collects, what stays on your machine, who else sees it, how long it's kept and how to use your privacy rights. - [Terms of service](https://oplema.com/terms-of-service.md): Read the terms for using Oplema: free local use, paid cloud subscriptions and top-ups, renewal and cancellation, refunds and acceptable use. - [Data processing agreement](https://oplema.com/data-processing-agreement.md): See when Oplema processes personal data in its cloud on your behalf, with the terms for subprocessors, security, transfers, breaches and deletion. - [Model providers](https://oplema.com/model-providers.md): See which models Oplema provides for Elara in your region, where your chats are processed and which companies host each model. ## Optional - [Learn](https://oplema.com/learn.md): Learn data preparation and business intelligence in five free courses that run in your browser, from a first CSV in Strata to a published dashboard. - [Build a report from a CSV export](https://oplema.com/learn/export-to-report.md): Learn Strata in a free hands-on course: build a data flow on a blank canvas, load and clean a CSV, account for every row and chart the result in Vista. - [Build your first data flow from a CSV](https://oplema.com/learn/export-to-report/first-data-flow.md): Learn to build a first data flow, free in your browser: place two Strata blocks on a blank canvas, load a CSV by URL and see what a 100-row preview hides. - [Load a CSV file into a data flow](https://oplema.com/learn/export-to-report/load-a-csv-file.md): Learn to load a CSV from your computer into Strata as a guest with Input, check the row count and see which columns arrived as numbers and which as text. - [Choose columns and set data types in a flow](https://oplema.com/learn/export-to-report/choose-columns-and-types.md): Learn to drop the columns a report doesn't need with Select in Strata, read each column's data type and see why a cast can't turn 24,50 into a number. - [Clean up inconsistent text in a CSV](https://oplema.com/learn/export-to-report/clean-up-text.md): Learn to trim stray spaces and fix case with Cleanse in Strata so each status and bike code has one spelling, then count the spellings before and after. - [Convert text to numbers and dates, European format](https://oplema.com/learn/export-to-report/convert-numbers-and-dates.md): Learn to convert amounts like 24,50 and day-first dates like 14/09/2026 with Number and DateTime in Strata, and count what each format leaves empty. - [Filter rows by date and account for what's left out](https://oplema.com/learn/export-to-report/filter-rows-by-date.md): Learn to filter a CSV to one week of finished hires in Strata, then give each rejected row a reason: other weeks, cancellations, no-shows or no date. - [Add a calculated column to a table](https://oplema.com/learn/export-to-report/add-a-calculated-column.md): Learn to add a calculated column with Formula in Strata: take VAT off a week of bike hires, check the net total against gross × 0.8 and handle free hires. - [Total rows by group and prove the total is right](https://oplema.com/learn/export-to-report/total-and-prove.md): Learn to total a week of hires by bike code with Summarize in Strata, then prove the row count with Count Dataset so no hire is lost or counted twice. - [Export results to CSV and make a first chart](https://oplema.com/learn/export-to-report/export-and-chart.md): Learn to export a weekly summary to CSV with Output in Strata, publish the same table to Vista with Vista Source and check the chart against the file. - [Fix a data flow when next week's file changes](https://oplema.com/learn/export-to-report/fix-a-broken-flow.md): Learn to repair a Strata flow after the export renames a column and a status, find the hires it dropped without a warning and add a check of your own. - [Combine and reconcile data files](https://oplema.com/learn/many-sources.md): Learn to combine and reconcile messy files in a free hands-on Strata course: stack files, remove repeats, explain unmatched joins and unpack JSON. - [Combine CSV files when a column has been renamed](https://oplema.com/learn/many-sources/combine-files-with-renamed-columns.md): Learn to stack CSV files with Union in Strata, find the column a till update renamed, fix it with Select and make the next rename stop the flow. - [Remove rows that appear in two files](https://oplema.com/learn/many-sources/remove-rows-in-two-files.md): Learn to find bookings that appear in two files, remove them with Unique in Strata on the right key and check every removed row in the Duplicate output. - [Find out why rows don't match in a join](https://oplema.com/learn/many-sources/find-unmatched-join-rows.md): Learn to read a join's Left and Right outputs in Strata, fix keys that differ only in case and explain every booking that didn't match the register. - [Label rows from a small lookup table](https://oplema.com/learn/many-sources/label-rows-from-a-lookup-table.md): Learn to label rows from a small mapping table with Manual Input and Lookup in Strata, and make an unlisted code show up instead of staying blank. - [Match misspelled names between two tables](https://oplema.com/learn/many-sources/match-misspelled-names.md): Learn to match hand-typed supplier names to an approved list with Fuzzy Match in Strata, read every match score and reject the near misses. - [Split packed cells into columns or rows](https://oplema.com/learn/many-sources/split-packed-cells.md): Learn to split a packed cell into columns, explode a list into rows with Split to rows in Strata and total revenue before the split so it isn't doubled. - [Extract fields from JSON and reconcile payments](https://oplema.com/learn/many-sources/extract-json-and-reconcile.md): Learn to unpack JSON payment records in Strata, pull booking numbers out of free text with RegEx, join them to the till and explain the gap to the cent. - [Compare a wide budget sheet to actuals](https://oplema.com/learn/many-sources/compare-budget-to-actuals.md): Learn to unpivot a wide budget sheet with Transpose in Strata, leave out its Total column and pivot it back with Cross Tab to compare with actuals. - [Debug a flow that runs but gives the wrong total](https://oplema.com/learn/many-sources/debug-a-wrong-total.md): Learn to find two faults in a Strata flow that runs without errors by checking row counts against figures you trust, then build the month-end table. - [Build and publish a dashboard](https://oplema.com/learn/table-to-dashboard.md): Learn Strata and Vista in a free hands-on course: filter a dashboard, add a what-if parameter, fill missing days, publish it and build a project alone. - [Add a shop filter to a dashboard](https://oplema.com/learn/table-to-dashboard/add-a-dashboard-filter.md): Learn to add a shop filter in Vista that reaches every visual on the page, built on a daily table from Strata, so each manager sees only their shop. - [Add a what-if parameter to a dashboard](https://oplema.com/learn/table-to-dashboard/add-a-dashboard-parameter.md): Learn to let readers set a threshold with Vista Parameter, bring it into a Strata flow with Lookup and count short days per shop at each value they pick. - [Rolling date filter: last 7 days from today](https://oplema.com/learn/table-to-dashboard/filter-last-7-days.md): Learn to write a last-7-days filter in Strata, test its edge on a date you choose, then use Date/Time Now and see why the view needs a fresh file. - [Fill missing dates and calculate a 7-day average](https://oplema.com/learn/table-to-dashboard/fill-missing-dates.md): Learn to build a date spine with Sequence in Strata so closed days count as zero, then use Rolling Calc for a true 7-day average instead of a 7-row one. - [Move a flow's files to Cloud and rerun it](https://oplema.com/learn/table-to-dashboard/move-files-to-cloud.md): Learn to upload CSV exports to Cloud, rebuild a Strata flow that reads and writes Cloud files, run it with Run local and save a version others can open. - [Publish a dashboard and hand over the rerun](https://oplema.com/learn/table-to-dashboard/publish-a-dashboard.md): Learn to build a Vista dashboard on a Strata flow fed from Cloud, publish it as a link, rehearse next month's rerun and write a handover note. - [Practice data project: raw files to a report](https://oplema.com/learn/table-to-dashboard/practice-project.md): Practice data prep end to end: build a Strata flow from a brief and a blank canvas for a new business, publish the answers, then rerun it on a new month. - [More data tools: when you'd use each one](https://oplema.com/learn/table-to-dashboard/more-data-tools.md): Learn when to use twelve Strata tools the courses didn't need, from Sample and Bin to Impute and Join Multiple, each with a small working example. - [Data preparation](https://oplema.com/learn/data-preparation.md): Learn to clean, combine and reshape messy data in a free course with nothing to install: reconcile two reports, parse dates and remove duplicates. - [What is data preparation?](https://oplema.com/learn/data-preparation/what-is-data-prep.md): Learn what data preparation is and the usual steps that turn raw files into a table you can analyze, with a worked example in Excel and SQL. - [What is data grain? How each step changes a table](https://oplema.com/learn/data-preparation/how-tables-change.md): Learn what grain means, how each step changes a table's values, rows, columns or grain, why grouping can't be undone and why to count rows at each step. - [Append vs join: stacking rows from two tables](https://oplema.com/learn/data-preparation/append.md): Learn to append one table under another with UNION ALL or Power Query's Append, how appending differs from a join and what to check before you stack. - [Data types and casting: CAST vs parsing](https://oplema.com/learn/data-preparation/types-and-casts.md): Learn the common data types, implicit vs explicit conversion, CAST in SQL, how to keep leading zeros and when to parse a value instead of casting it. - [Parsing dates from text: day first or month first](https://oplema.com/learn/data-preparation/parse-text-and-dates.md): Learn to parse dates from text by stating the format, why 03/08/2026 is ambiguous, how a day above 12 tells you and how to do it in Excel and SQL. - [Null vs blank vs zero: cleaning missing values](https://oplema.com/learn/data-preparation/cleanse-and-nulls.md): Learn to clean stray spaces and case, tell null from blank from zero and decide when to keep, fill or exclude missing values, with COALESCE in SQL. - [Sorting data by one or more columns](https://oplema.com/learn/data-preparation/sort.md): Learn to sort rows by several columns, break ties, see why row order affects later steps and write ORDER BY in SQL and Sort in Excel. - [Finding and removing duplicate rows](https://oplema.com/learn/data-preparation/unique-and-duplicates.md): Learn to find duplicates with COUNTIF or GROUP BY HAVING, remove them with ROW\_NUMBER or Remove Duplicates and choose which copy of a record to keep. - [Filtering rows: WHERE, conditions and nulls](https://oplema.com/learn/data-preparation/filter-rows.md): Learn to filter rows with WHERE in SQL and FILTER in Excel, why nulls fail every comparison and how to reconcile the rows you keep with those you reject. - [Inner vs left: joining tables by key](https://oplema.com/learn/data-preparation/joins.md): Learn what inner, left, right and full joins keep, how repeated keys multiply rows and how to write each join in SQL and Excel, then audit the result. - [Calculated columns vs aggregates explained](https://oplema.com/learn/data-preparation/formulas.md): Learn the difference between a calculated column and an aggregate like SUM, how nulls behave in arithmetic and how to write both in SQL and Excel. - [GROUP BY: grouping and summarizing rows](https://oplema.com/learn/data-preparation/summarize.md): Learn how GROUP BY and PivotTables collapse rows into totals and counts, why COUNT(\*) and COUNT(column) differ and how to check the grouped result. - [Wide vs long data: pivot and unpivot](https://oplema.com/learn/data-preparation/transpose-and-crosstab.md): Learn the difference between wide and long data, when to use each shape and how to pivot and unpivot between them, with SQL and Excel equivalents. - [Running totals and rolling averages](https://oplema.com/learn/data-preparation/rolling-windows.md): Learn to calculate a running total and a rolling (moving) average, handle partial windows and choose between row and calendar windows, in SQL and Excel. - [How to reconcile two reports that disagree](https://oplema.com/learn/data-preparation/messy-file-to-table.md): Learn to reconcile two reports that disagree: account for every row and euro with a bridge, test a rule and hand over the table with its known limits. - [Business intelligence](https://oplema.com/learn/business-intelligence.md): Learn to define KPIs, test reports, choose charts, design a dashboard and write a decision memo in a free course with nothing to install. - [What is business intelligence?](https://oplema.com/learn/business-intelligence/what-is-bi.md): Learn what business intelligence (BI) is, how it differs from analytics and how it links a question, a defined measure, checked data and a view. - [KPI vs metric: how to define what you measure](https://oplema.com/learn/business-intelligence/kpis-metrics.md): Learn the difference between a KPI and a metric, leading vs lagging indicators and how to write a metric definition where each clause moves the number. - [Where business data lives: systems and exports](https://oplema.com/learn/business-intelligence/where-data-lives.md): Learn where business data lives, from CRM to accounting systems, why reports usually get an export and how to record each source's owner, grain and date. - [Data quality dimensions and how they move a metric](https://oplema.com/learn/business-intelligence/data-quality.md): Learn the six data quality dimensions, from accuracy to validity, how to judge quality against the metric it feeds and how to tie each fault to an owner. - [Join fan-out: how joins inflate metrics](https://oplema.com/learn/business-intelligence/joins-integration.md): Learn why a repeated key in a lookup table multiplies rows and inflates totals, how to keep joins many-to-one and how to reconcile by group to catch it. - [Mean, median and weighted average in reporting](https://oplema.com/learn/business-intelligence/aggregation.md): Learn when the median beats the mean, how a weighted average works, how nulls change the answer and why every average depends on the rows it covers. - [ETL vs ELT: what's the difference?](https://oplema.com/learn/business-intelligence/what-is-etl.md): Learn what ETL and ELT are, how they differ, when to use each and how snapshot and append loads work, so a repeat run gives the same answer. - [What is a star schema? Facts and dimensions](https://oplema.com/learn/business-intelligence/star-schemas.md): Learn how a star schema splits fact and dimension tables, when a flat table will do and how date dimensions, snowflakes and SCD Type 1 and 2 work. - [How to choose the right chart for your question](https://oplema.com/learn/business-intelligence/chart-choice.md): Learn to pick a bar chart, line chart, single number or table for the question you're asking, and avoid truncated axes and missing periods. - [Dashboard design best practices and a checklist](https://oplema.com/learn/business-intelligence/dashboard-design.md): Learn to design a dashboard that puts the summary first, then the views that explain it, and states the measure, period and exclusions, with a checklist. - [Dashboard filters: scope, selections and limits](https://oplema.com/learn/business-intelligence/filters.md): Learn how a dashboard filter changes the rows a view includes, how its scope works across visuals, how it differs from a rule and how to test a conclusion. - [What is self-service BI, and what does it need?](https://oplema.com/learn/business-intelligence/self-service.md): Learn what self-service BI is and what it needs to work: agreed definitions, access rules and a clear route for the questions shared data can't answer. - [How to check a dashboard after a data refresh](https://oplema.com/learn/business-intelligence/refresh-schedule-share.md): Learn to check a dashboard's numbers after each data refresh, label the date the data runs through and see what scheduling and publishing do in Oplema. - [What is data governance? Owners and change notes](https://oplema.com/learn/business-intelligence/governance.md): Learn what data governance means in a small team: who owns each definition, who may change it and how to record each change in a short change note. - [How to write a decision memo from a dashboard](https://oplema.com/learn/business-intelligence/messy-export-to-dashboard.md): Learn to write a one-page decision memo from a dashboard: test the conclusion in both directions, state what the data doesn't show and use the template. - [News & insights](https://oplema.com/news-and-insights.md): Read Oplema's launch posts, engineering write-ups and founder essays, newest first, with links to the full changelog and the docs for every tool. - [Oplema is live](https://oplema.com/news-and-insights/oplema-is-live.md): Oplema launched November 8, 2026. See what each tool does, how to start free in your browser without signing up and which cloud services cost money. - [Running a million-row flow in a browser tab](https://oplema.com/news-and-insights/million-rows-in-a-tab.md): See how a one-million-order Strata flow ran 130 times in a browser tab, with median times of 1.9 seconds fresh and 1.4 warm, and every result checked. - [Why we're building Oplema](https://oplema.com/news-and-insights/why-we-are-building-oplema.md): Read why we put data prep, dashboards, AI and version history in one project, kept local work free, dropped seat fees and built a European alternative. - [Changelog](https://oplema.com/changelog.md): See every Oplema release with its date: updates to Strata flows, Vista dashboards, Elara, Echo version history, Cloud, Console and connectors.