Search Icon
    Power BI integration

    Vemcount and Power BI: footfall where your team already works

    Your headquarters already runs on Power BI. Vemcount data can be read into Power BI through the Vemcount REST API, so visitor counts, conversion rate and occupancy sit beside sales, margin and staffing in the reports your management reads every week. Vemco has set this up for many customers.

    powerbi_cutout_800px

    Power BI for reporting, Vemcount for the floor

    What you see in Power BI

    Visitors per store, day and hour. Conversion rate where sales data is connected. Occupancy and dwell measures where they are installed. Every store and country with the same definitions, ready to join with your own finance, staffing and campaign data.

    What stays in Vemcount

    Live counts on the dashboard within about two seconds. Alarms when a sensor is offline or a count looks wrong. Daily reports for store and regional managers. The checks behind the numbers: accuracy typically 98 to 99 percent, with a contractual minimum of 96 percent.

    Who looks where

    Headquarters and analysts: Power BI, weekly and monthly, across the whole business. Regional managers: Vemcount, to compare their stores every morning. Store managers: Vemcount, live, to act during the day. One source of numbers, so the three never argue about whose figure is right.

    How it connects

    Through the Vemcount REST API. Your BI team schedules the refresh in Power BI. Our team helps with the first setup and the data model, so the first report uses the same definitions as the Vemcount dashboard.

    Vemcount visitors and turnover view, the data Power BI reports read through the REST API

    Footfall and conversion next to the numbers you already report

    55,000+ installations in 98+ countries; 60+ million people counted every day; 20+ years.

    Your headquarters already runs on Power BI. Vemcount data can be read into Power BI through the Vemcount REST API, so visitor counts, conversion rate and occupancy sit beside sales, margin and staffing in the reports your management reads every week. Vemco has set this up for many customers.

    In Power BI you see visitors per store, day and hour, conversion rate where sales data is connected, and occupancy and dwell measures where they are installed, for every store and country with the same definitions and ready to join with your own finance, staffing and campaign data. The people counting software keeps the live side: counts on the dashboard within about two seconds, alarms when a sensor is offline or a count looks wrong, daily reports for store and regional managers, and the checks behind the numbers, with accuracy typically 98 to 99 percent and a contractual minimum of 96 percent.

    Headquarters and analysts work in Power BI, weekly and monthly, across the whole business. Regional managers compare their stores in Vemcount every morning. Store managers use Vemcount live to act during the day. One source of numbers, so the three never argue about whose figure is right.

    It connects through the Vemcount REST API. Your BI team schedules the refresh in Power BI, and our team helps with the first setup and the data model. Conversion rate comes from sales analytics in Vemcount when your POS sends sales data, and you can see all integrations that feed the platform, including the Shopify footfall integration. Groups running stores in several countries use the same setup on the enterprise platform.

    Power BI is a trademark of Microsoft Corporation. Vemco is not affiliated with Microsoft unless stated.

    Fits your systems and your rollout

    Data through the Vemcount REST API
    Data through the Vemcount REST API
    Scheduled refresh set by your BI team in Power BI
    Scheduled refresh set by your BI team in Power BI
    Same definitions in every country
    Same definitions in every country
    Sales data from your POS through the REST API v4 or an existing integration
    Sales data from your POS through the REST API v4 or an existing integration
    One login for store teams in Vemcount
    One login for store teams in Vemcount
    Local offices and partners for support
    Local offices and partners for support

    The Vemcount data your Power BI reports can use

    people-counting

    VemCount

    People counting and footfall for every store and site.

    heatmaps-and-tracking

    VemTrack

    Heatmaps and tracking of how people move through a space.

    facility-management

    VemSpace

    Occupancy, desk and room use and indoor climate.

    tenant-management

    VemTenant

    Tenant sales reporting for malls.

    vemfusion

    VemFusion

    Integrate your POS, BI, and ERP systems with our software.

    A Solution to Every Problem

    Luksusbaby A/S
    Problem

    Luksusbaby wanted to view real-time, accurate KPIs regarding their physical stores, such as hit and conversion rates, for improved decision-making. 

    Solution

    Our solution helped Luksusbaby take action based on facts rather than intuition while discovering the age of their incoming visitors for accurate conversion rate data.

    luksusbaby
    Daells Bolighus
    Problem

    Daells Bolighus struggled to keep up with the changing market and had been in an economic deficit for 16 years. The main problems were old-fashioned marketing strategy and a lack of insight into customer data.

    Solution

    Vemco Group installed people counters in both Daells Bolighus stores and integrated sales and visitor data from the physical stores with online data from their website, allowing them to view and compare data across locations.

    reduced Daells Bolighus Vemco Group
    Magasin
    Problem

    Magasin had an outdated, unreliable people counting solution and wanted a hosted solution, exporting data into a central BI system to give them insight into customer behavior in all their department stores.

    Solution

    We delivered an accurate, up-to-date people counting solution to Magasin, which allowed them to reduce operational costs by outsourcing their customer data to us.

    magasin
    Odense Municipality
    Problem

    Odense Municipality wanted to access insight into how the citizens and visitors of Odense use the city and act on these insights based on factual decision-making rather than intuition.

    Solution

    To measure how the citizens and visitors of Odense use the shopping street, we cover all relevant entrances and exits with weather-resistant sensors that cover heights up to 20 meters.

    Odense v2

    Frequently Asked Questions

    Can we use our existing Power BI licences?

    Yes. Power BI reads the data through the Vemcount REST API, using the Power BI licences and workspaces you already have. There is no extra Vemco software to install on the Power BI side. Your BI team connects to the API, builds the data model and designs the reports, and our team helps with the first setup so visitor counts and conversion rate land in the right tables from the start.

    Which measures are available through the API?

    Visitor counts in and out per location and zone by interval, conversion rate where sales data is connected, and occupancy and dwell measures where those modules are installed. The exact list depends on the modules you run in Vemcount. Before the first setup our team walks the available measures through with you and your BI team, so the data model in Power BI uses the same definitions as the Vemcount dashboard.

    How often can the data refresh?

    The refresh is scheduled by your BI team in Power BI, so the reporting cadence follows your management rhythm, whether that is daily, weekly or monthly. Vemcount itself shows live counts on the dashboard within about two seconds, which is where store teams look during the day. Power BI is for the numbers management reads afterwards, next to sales, margin and staffing.

    Can we combine it with POS data that is already in Power BI?

    Yes. Join the Vemcount data with your sales data on store and time, and conversion rate is calculated in your Power BI model. The other route is to send sales data to Vemcount through the REST API v4 or one of the 19 POS integrations, so conversion rate is calculated in Vemcount as well and store managers see it live on the dashboard. Many customers use both.

    Who helps us set it up?

    Our team. Vemco has set up Power BI reporting on Vemcount data for many customers, so the first setup and the data model follow a path we know well. Your BI team keeps ownership of the Power BI workspace and the reports. Support comes from our local offices, in the countries where your stores are.

    You Are Only as Good as Your Customers Say

    Katrine Velter Avatar

    Katrine Velter

    Senior Analyst

    Danske Shoppingcentre

    We own 17 shopping malls in Denmark, and Vemtenant handles our revenue reports from more than 1,000 stores. The system keeps track of missing reports, automatic reminders and reports, and user management. Credibility and transparency between our malls and the tenants were the most challenging issue, which is now solved.

    Ivalu Jensen Skovgaard Avatar

    Ivalu Jensen Skovgaard

    Business Developer

    Skechers

    Comfort is key, and Vemco's footfall analytics help us understand customer behavior, so we are able to give our customers the best and most comfortable experience.

    Jacob Høffer Larsen Avatar

    Jacob Høffer Larsen

    Project Manager

    Smart City Odense

    We have been satisfied with our collaboration with Vemco Group, which has shown us that it is possible to reliably and professionally monitor pedestrians on our shopping street. We see a great potential in developing and running our city better based on the insights that Vemco Group has given us.

    Janni Baslund Dam Avatar

    Janni Baslund Dam

    Mall Manager

    BROEN Shopping

    We use Vemcount to measure the traffic at our entrances, so we get an idea of where the customers come from and when the number of visitors peaks during a day, week, month or year. This gives us, among other things, a tool for planning our marketing and activity calendar wh subsequently evaluating these activities.

    Henrik Wieben Avatar

    Henrik Wieben

    Country Manager

    HiFi Klubben Denmark

    Over the years, we have tested a handful of different people counting solutions, which unfortunately have disappointed us at every turn. Finally, with help from Vemco Group, we have found the right solution. A valid and good quality solution ensuring that we can optimize our business and measure the performance of our stores.

    Lasse L. Mohrsen Avatar

    Lasse L. Mohrsen

    Loss Prevention Manager

    Magasin du Nord

    We wanted a central solution that could cover all of our department stores in Denmark. We wanted the same system and a hosted solution but managed from one place. It was also a requirement from the beginning that the solution was able to count very accurately. And Vemcount has worked perfectly.

    Ditte Nedergaard Pedersen

    Ditte Nedergaard Pedersen

    Regional Manager

    Luksusbaby A/S

    We wanted people counters in our physical stores so that we could access data and KPIs, such as conversion rates, to help us make action plans that improve the sales process. And Vemco came as a natural solution to this. We have received amazing support and have nothing but praise on our end.

    Bjarke Bendix Cloos Avatar

    Bjarke Bendix Cloos

    Director

    Jorcks Ejendomsselskab

    The most important features for us have been the ability to accurately count how many people pass through both entrances of Jorck’s Passage during the day, as well as the system's operational stability so that we do not have to spend time on downtime. I asked my acquaintances in the mall industry, and they said that Vemco is the provider to use. That's why we chose Vemco.

    Nedim Jukic

    Nedim Jukic

    Retail Executive Assistant

    Planika

    By implementing Vemco Group's people counting solution, we aim to optimize our staffing, improve conversion rates, enhance store layout, and evaluate the effectiveness of our marketing efforts. This positions Planika for success in delivering exceptional customer experiences and driving business growth.

    Jacob Falkenby Fredericia Idrætscenter

    Jacob Falkenby

    CEO

    Fredericia Sports Centre

    While browsing through the different kinds of people counters on the market, it became clear that the Vemco solution was the one, which suited us best. Partly, because of the sensor technology they offer, but also since they were able to deliver vast amounts of data, including accurate live data.

    Brian Seemann Broe

    Brian Seemann Broe

    CEO

    Daells Bolighus

    I was a bit cheeky to ask Vemco if it was possible to merge sales data from our online shop with data from our physical stores, and they provided a unique solution. Today, we have an absolutely fantastic tool - I can see how many visitors we have, I can see our turnover per hour, and this way, I can measure the impact of every single penny we invest in our marketing.

    Keith Mafi

    Keith Mafi

    Senior Digital Portfolio Manager

    Swedish Match (North Europe AB)

    Working with Vemco Group has been an excellent experience. Their people counting solution provides us with accurate in-and-out data, which is essential for our direct retail operations. Precision and quality are critical to us, and Vemco Group consistently delivers both. Their team is not only professional but also incredibly supportive, always ready to assist us whenever we need it. We couldn't be more satisfied with our solution, which is tailored to fit our needs. 

    Alice Jansson

    Alice Jansson

    Store Manager

    SmartaSaker

    We contacted Vemco Group because we felt that it looked simple, it seemed to fit our needs, and it simply felt like a reliable solution. Our biggest challenge was that we had no idea what our conversion rate looked like. We used to rely on our gut feeling, and that's not a very data-driven approach. Additionally, we couldn’t figure out why certain things stood out in sales, why we had fewer visitors at certain times, and so on. Now we can see it very easily.

    Saad Elkoli

    Saad Elkoli

    IT Strategist & Object Manager

    Haninge Municipality

    Vemco Group's solution has given us insight into the usage of our facilities and provided us with better, more accurate data, enabling us to make data-driven decisions and simplify the overview of available data. The simplicity of being able to access precise data, which our operations and management team need to properly resource plan and schedule resources, is key.

    Let's Connect

    main-page-
    connect-icon3
    globe
    coment-box