Skip to Content

Does your sales team meet its visits? How to create professional dashboards in Odoo without Power BI

Discover how to turn field visit data into visual dashboards that drive productivity, using only Odoo's native tools and no external dependencies.
April 21, 2026 by
Does your sales team meet its visits? How to create professional dashboards in Odoo without Power BI
Wilfredo Fernando Pastor Avila
| No comments yet

The problem of the manager who can't see what's happening in the field

María manages a team of 15 salespeople who visit clients across the region. Every Monday, her manager asks her: "How are we doing with the planned visits?" María opens multiple screens in Odoo, exports data to Excel, creates charts manually and two hours later delivers a report that is already out of date. Her salespeople, meanwhile, have no visibility into their own performance. This situation repeats every week, consuming valuable time that could be spent on sales strategy. Does this sound familiar? The problem isn't a lack of data, but the inability to turn it into actionable information quickly and visually.

Identify your data sources: the crucial first step

Before creating any dashboard, you need to know where the information you need is. In Odoo, your data sources can be individual records, lists or, most commonly, pivot tables. These pivot tables are the foundation on which you'll build your visualizations.

Applied example: At Ganemo, we worked with a pharmaceutical distributor that needed to monitor medical visits. We identified that the "Visit Compliance" pivot table contained exactly the data they needed: salesperson, planned, completed and non-completed visits per month. This data source, already structured in Odoo, became the foundation of their control dashboard. When implementing with Ganemo, we make sure each client correctly identifies its critical data sources before starting any reporting project.

Shape your data: more than just inserting information

It's not enough to take the pivot table exactly as it appears. You need to shape it to the specific requirements of your analysis. This means selecting the right measures (such as "planned", "executed"), grouping by the relevant dimensions (salesperson, month) and applying initial filters if necessary.

Real use case: A field technical services client needed to see not only completed visits, but also the average resolution time. Instead of using the standard pivot table, with Ganemo we set up a custom view that included calculated measures such as "average service time" and "urgent vs. scheduled visits". This customization, done directly in Odoo, spared the client from having to resort to complex external tools. The advantage of working with Ganemo is that we understand how to optimize these data structures so they are both powerful and easy to maintain.

Dynamic vs. fixed pivots: the secret to easy maintenance

Odoo offers two types of pivots when inserting data into spreadsheets: fixed and dynamic. Fixed pivots keep their structure even if you add new salespeople or products. Dynamic ones, created using formulas, update automatically in both structure and content. For dashboards that require constant updating, dynamic pivots are essential.

Illustrative story: A B2B sales company with high staff turnover had a problem: every time it hired a new salesperson, its dashboard stopped including them. The IT team had to update the spreadsheet manually every month. After migrating to dynamic pivots with the formula =PIVOT(1,5,1,0,5,1) (where 1 is the data source ID), the dashboard began updating automatically. Ganemo specializes in implementing these dynamic solutions that grow with your business, eliminating repetitive manual tasks.

Create custom measures directly in your dashboard

Do you need to calculate specific metrics such as "missing visits" or "compliance percentage"? Instead of doing it in external Excel, you can create calculated measures directly in the Odoo pivot. These measures integrate perfectly with your data structure and update in real time.

Business example: A sales manager wanted a column showing the "average days between visit and sale close". Instead of developing a complex integration with Power BI, with Ganemo we added a calculated measure in the pivot's properties using the formula: (close_date - visit_date). This measure appeared immediately in the dashboard, giving the team valuable information about the effectiveness of their visits. Ganemo's ability to implement these native customizations in Odoo saves months of development in external tools.

From table to visual dashboard: charts and professional design

Once you have your data structured, it's time to turn it into impactful visualizations. Odoo lets you insert bar, line, pie and other charts, directly linked to your dynamic pivots. You can customize colors, add data labels and organize multiple charts on a single board.

Practical situation: A sales director needed a dashboard showing simultaneously: 1) Compliance percentage per salesperson (bar chart), 2) Monthly trend of completed visits (line chart), and 3) Distribution by client type (pie chart). Using Odoo's native tools, we organized these three charts into a single view, applying styles consistent with the company's brand. Each chart updates automatically when salespeople record new visits. Ganemo helps companies design dashboards that are not only functional but also visually professional, clearly communicating team performance.

Global filters: control what you see in one click

The most useful dashboards let users filter information according to their needs. Odoo includes global filters that affect all linked data sources. You can set up filters by date (current month, quarter, year), by salesperson, by region or by any other relevant field.

Implementation case: A company with operations in three countries needed each regional manager to see only data for their territory, while the general director saw the consolidated view. We set up hierarchical filters where users, according to their permissions in Odoo, automatically saw the information relevant to them. A salesperson in Bogotá only sees their visits; the Colombia manager sees their whole team; the director sees all three regions. This integrated security setup, which Ganemo masters, is a key advantage over external solutions where permissions must be reconfigured separately.

When do you really need Power BI? (and when you don't)

For 80% of business cases, Odoo's native reporting tools are more than sufficient. They are faster to implement, easier to maintain and integrate seamlessly with your existing processes. Consider external tools like Power BI only when you need: 1) To combine data from multiple completely different systems, 2) Advanced statistical analysis with machine learning, or 3) Complex 3D or geospatial visualizations.

Real business decision: A manufacturing client was considering investing $15,000 a year in Power BI licenses plus integration consulting. After evaluating its real needs, with Ganemo we implemented dashboards in Odoo that covered 95% of its requirements. The $15,000 was reinvested in improving its production processes. For the remaining 5% (demand predictive analysis), we set up a direct connection from Power BI to its Odoo database, but only for that specific case. Ganemo helps you make these strategic decisions: implement as much as possible in Odoo and integrate external tools only where they truly add unique value.

Your next step: from viewer to dashboard creator

The real power isn't in having dashboards, but in being able to create and modify them as your business needs evolve. With the techniques you've learned, you can start today: identify a critical metric for your business, find its data source in Odoo, create a dynamic pivot and add a simple chart. In one afternoon, you'll have your first functional dashboard.

Complete transformation: I remember a client who started with a simple dashboard of completed visits. Six months later, their team had created 12 different dashboards: real-time inventory control, margin analysis by product, tracking of service orders, and more. Most valuable of all: they did it themselves, without depending on external consultants for every change. This autonomy is what Ganemo promotes in every implementation: empowering you with the tools to grow with your system, not in spite of it.

The question is no longer whether you can have professional dashboards in Odoo, but what you are going to do with all the valuable information you can now see clearly for the first time.

Related video

Does your sales team meet its visits? How to create professional dashboards in Odoo without Power BI
Wilfredo Fernando Pastor Avila April 21, 2026
Share this post
Tags
Archive
Sign in to leave a comment
When AI Agents Maintain Your Documentation: Karpathy's Pattern Wins and Its Limits in Practice
A tribute to Karpathy's gist on LLM Wiki — and the 4 nuances to consider when you move from personal use to team use.