Data Foundation: Dashboards, Metrics and Analysis Paths
Every Data Foundation project comes with seventeen dashboards, a set of metrics and an analysis path for each subject. They all read the same report views, which every Load fills from the Common Finance Model, so a dashboard, a metric and an answer from Weave never disagree. This holds for a project made from any Data Foundation template, such as Cost to Serve or Operational Transfer Pricing. To check that the numbers behind them can be trusted, see Data Foundation: Can the Numbers Be Trusted?.
The Reports Page
Section titled “The Reports Page”Reports, under Data Foundation in the project home, lists the dashboards by persona: Accounting, Executive, Finance, Marketing, Operations and Sales. Click a dashboard’s name to open it in a new browser tab. It opens in standard Superset, and no filter is carried from the project. As the page says, you see them if you have access to the project.
A dashboard with no data yet is listed by name, dimmed, under a line such as “3 reports have no data yet”, with what would fill it: “Fills when a system with pipeline data finishes its load.” or, for a dashboard that reads no particular subject, “Fills when your systems finish their first load.”
The Board pack card at the bottom has Open the board pack once the pack’s dashboard is built, and Board pack settings, available with edit access to the project, which opens the settings described in Board Pack.
When the Dashboards Are Built
Section titled “When the Dashboards Are Built”Installing Data Foundation creates the report views, and its message says how many report views and dashboards it installed and what to do next. The dashboards themselves are built at the end of every Load and Apply changes, by its Make the dashboards step, from what that run wrote. A project installed with the sample data shows the sample once its first load ends.
Each later run rebuilds the dashboards in place, so their links stay the same and data that arrives later fills in. Data Foundation rebuilds a dashboard on every Load, edits included, so copy a dashboard in Superset to keep changes of your own. The context line at the top of each dashboard says the same.
Missing data is never an error:
- A chart or tile with no data is left out and its row closes up. A tile without data can give its place to another one, such as Owed by customers in place of Net debt when no account is marked as borrowings.
- A tab whose charts all have no data is left out. A dashboard whose Overview has nothing to show is not built, and Reports lists it as having no data yet.
- The run finishes with a warning that names the dashboard and the tab left out, such as “CFM-Sales - Pipeline: the Deals closing tab is left out, as its charts have no data yet.”
- If reporting is turned off for your workspace, no dashboards are made, and the warning says so.
- If a dashboard someone else made already has the address a Data Foundation dashboard needs, that dashboard is left as it is, and the warning names the address. Give the other dashboard another address in Superset.
Who Sees Them
Section titled “Who Sees Them”A dashboard takes the project’s default audience for new dashboards when it is first built. Later rebuilds keep whatever audience it has then.
The dashboards are built from every row of the project, never from the rows one person can see. Each person who opens a dashboard sees only the rows their row access allows. When someone whose row access narrows what they see starts a rebuild, the dashboards are left as the last Load built them, and the message says that the next Load rebuilds them.
The Seventeen Dashboards
Section titled “The Seventeen Dashboards”Every dashboard is titled CFM-persona - report. It opens on Overview and ends with Detail, which lists the rows behind the figures. The tabs in between answer the questions below.
| Dashboard | Tabs between Overview and Detail | For |
|---|---|---|
| CFM-Accounting - Assets | Roll-forward, Bought and sold | Accounting |
| CFM-Accounting - Close and assurance | What needs fixing, Is the month closed. See Data Foundation: Can the Numbers Be Trusted? | Accounting |
| CFM-Accounting - Intercompany | Which pairs do not agree, What has no partner | Accounting |
| CFM-Accounting - Journals | What was posted by hand, Journals to check | Accounting |
| CFM-Accounting - Receivables and payables | Who owes us, Who we pay | Accounting |
| CFM-Executive - Summary | Where the cash is, Sales and what is coming | Executive |
| CFM-Finance - Operating expense | Which costs, Which departments, Which entities | Finance |
| CFM-Finance - Performance against plan | What caused the gap, Who is over budget, Where the year lands | Finance |
| CFM-Finance - Statements | What we own and owe, Where the cash went, Each unit’s share. The board pack’s PDF prints this dashboard. | Finance |
| CFM-Finance - Working capital and cash | Where the cash is, What is tied up | Finance |
| CFM-Marketing - Marketing | Where the money went, What it brought back | Marketing |
| CFM-Operations - Inventory | Where it sits, What is old and written off | Operations |
| CFM-Operations - Purchasing | Who we buy from, What we pay, What is still to arrive | Operations |
| CFM-Operations - Sites and people | Where cost went over, Staffing against plan, What we made | Operations |
| CFM-Sales - Orders and contracts | What we booked, What ships late, Renewals and retention | Sales |
| CFM-Sales - Pipeline | What changed, Deals closing, How reps are doing. For the rates its amounts use, see Which Rate Applies. | Sales |
| CFM-Sales - Sales | Why margin moved, Who buys from us, How reps are doing | Sales |
The Overview tiles of CFM-Executive - Summary are Revenue, year to date, Gross margin %, year to date, EBITDA, year to date and Cash at month end.
Reading a Dashboard
Section titled “Reading a Dashboard”The context line. Each tab opens with a line that says what the figures cover. See On the Dashboards. On Overview it adds Right-click any chart to break it down or see its rows. Without a budget it says No budget loaded; comparing with last year, and the chart titles compare with last year instead of budget.
Filters. Period is always there. Region, Country, Division and Entity are added when the project has two or more of them, and each lists only the values within the ones chosen before it. Profit centre is added when the data carries two or more. A dashboard’s own filters follow. Filters that don’t fit the bar are under More filters. Period opens on the last month closed for every entity. CFM-Accounting - Close and assurance, CFM-Accounting - Intercompany and CFM-Sales - Pipeline open on the current month: the first month not yet closed. With no month closed, Period opens on the latest month.
Tiles. A tile shows the figure, its change and its trend over the twelve months to the month chosen, with two comparisons: against budget and against last year, or, where the figure has no budget, against last month and against last year. A figure with no month of its own shows its value without the trend. A tile that another tab explains ends with Why ›, which opens that tab. Every variance is shown so that a positive figure is good, whichever way the measure runs, and the tile’s arrow and color follow. A margin’s variance is in points.
See also. Every tab but Overview ends with a See also line that links the dashboards related to it.
Units. Chart titles name the unit. The Display unit project setting is Automatic, Whole units, Thousands or Millions. Automatic uses whole units for a single company with less than 10 million of revenue in its largest fiscal year; otherwise thousands, or millions from 1 billion of revenue. Amounts per unit, such as an average price, are never scaled. A changed setting shows when the dashboards are next built.
Your system’s words. A project with one QuickBooks Online system reads in its words: Class in place of Profit centre, Location in place of site and Category in place of product family.
Copies of a Project
Section titled “Copies of a Project”A project made with Clone has no dashboards of its own. It shares the original’s set, and those dashboards keep reading the original. Its Reports page says This project is a copy, with Open the reporting project and two choices:
- Make this the reporting project points the set’s dashboards at this project, so their charts, links, favorites and schedules carry on. Each dashboard takes this project’s default audience, unless an owner chose its audience or someone co-owns it. You need edit access to this project and to the one the dashboards read before. A chart whose data this project lacks shows nothing here, and the message names the dashboard and tabs. On a project that has never loaded, the message is “This project has no reporting database yet. Run Load first.”
- Give this copy its own dashboards asks you to confirm, “This copy gets its own set of dashboards, as a separate business would. Use this only when the copy has become one.” Click Give dashboards to go ahead.
Both need edit access to the project, and both rebuild the dashboards straight away.
Metrics
Section titled “Metrics”Every project gets the metrics its dashboards show. Each is a metric definition that Weave answers with, defined once for both, so Weave and the dashboards agree. A metric is named by its title, such as Revenue or Working capital, or, where two share a title, the title and its subject, as title - subject. Where two of the same subject share a title, it is title (metric name).
Metrics are made when Data Foundation is installed and at the end of every Load by its Make the metrics step. A metric is made once the report view it reads is built. A metric the project already has by that name is left as it is, so your edits to it stay. A metric that can’t be made is named in the run’s warnings, with why; the dashboards still show it.
Analysis Paths
Section titled “Analysis Paths”Installing Data Foundation makes one analysis path per subject, named after the project: project name - subject. The subjects are Finance, Journals, Trial balance, Drivers, Sales, Pipeline, Orders, Contracts, Purchasing, Receivables and payables, Intercompany, Inventory, Assets, Cash and Close and assurance. When another analysis path already uses the project’s name, the paths take the name with a number, such as Northwind (2) - Finance.
Each path reads the subject’s report view and describes every report view of the subject, so Weave knows what each holds. Your business names are written into the description of the project’s own analysis path. A path of the same name that belongs to another project is left as it is, with a warning.
Report Views
Section titled “Report Views”The report views are tables and views named cfm_rv_... at the top of the project, such as cfm_rv_finance_month and cfm_rv_sales_window. The project’s Reports workflow fills them in every Load, after Consolidate. Every dashboard, metric and analysis path reads them, and you can query them like any other table in the project. A view whose data isn’t there yet is created empty and fills once its data arrives.