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.
Book a demo
Tell us a little about your site and we will set up a live demo with you.
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.
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
The Vemcount data your Power BI reports can use
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.
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.
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.
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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