Microsoft Power BI Integration
View Supplier Portal data automatically in Power BI
Never download a vendor report again. Crisp’s secure integration automatically updates your Power BI reports with a live data feed.
All your data, fully automated
No more need for manual CSV downloads and data consolidation
Live data feed of continuously updated information from Crisp’s comprehensive, secure online data warehouse
Automatically updates your Power BI reports and dashboard visualizations
Free Power BI application template for Crisp data available in the Microsoft Office 365 app store
Crisp Tools and Features
Get more from your data with these handy dashboard features:
Automatic reports
Crisp automatically ingests new supplier portal reports when they’re available, saving you valuable time
Templates
Leverage templates with UNFI sales and supply reports
Consolidate all your data sources
Crisp also aggregates data from retailer and distributor portals such as:
How to setup a Power BI outbound connector with Crisp
Crisp’s Power BI integration is simple and secure
Add Connector
Once you’ve purchased Crisp, add the Power BI connector inside the Crisp platform
Generate OData feed
The Crisp platform will provide you with the OData URL to set up the connection in Power BI
Set up OData feed in Power BI
Configure the connection and select the list of reports you want to work with
Enjoy your data
Crisp will export historical data and automate future reports
Case Studies
-
The Honey Pot
By using Crisp’s platform and Promomash’s promotion planning features, The Honey Pot is able to accurately forecast demand and reveal sales opportunities.
-
Illy
Illy uses Crisp’s real-time dashboards to review stock on a day-to-day basis and ensure that there’s always plenty of product to meet their targets.
-
PANOS
Crisp’s real-time business dashboards give the PANOS team real-time answers in a matter of minutes.
-
Aura Bora
With Crisp’s Unified Distributor dashboard, sparkling water brand Aura Bora was able to save tens of thousands of dollars by avoiding stock-outs.
-
SunButter
With the help of Crisp’s void detection feature, SunButter can reduce out-of-stocks and continue to grow amidst supply chain challenges.
-
Mid-Day Squares
With Crisp, Mid-Day Squares’ success is anything but bite-sized. Mid-Day Squares uses Crisp’s customized dashboards to maximize every retail opportunity.