Need for an automated process of fetching data for two different companies from Business Central ERP and LeafLink CRM with the following functionalities:
Need for individual dashboards for both companies that contains different type of financial reports with graphical and tabular visualization.
Need to create a consolidated dashboard containing data of both companies in single report for the customers of the company, so that the Business Owner will be able to view the overall business of the company.
Need for a functionality that shows live business central data at the Power BI dashboard and reports.
Solution Delivered
Cynoteck proposed implementation of Power BI Pro for creating reports and dashboards
We implemented the following approaches to fulfil the requirements of the system:
We created various web services in Business Central to supply the relevant data inputs for Power BI.
In power BI we performed the following activities -
Transformed the Business Central data
Created multiple custom columns and measures for creating the reports.
Created different workspaces for both company in the Power BI service and assigned individual managers to their respective workspace according to their company.
Published report in Power BI service workspace according to their company.
We have configured scheduled refresh so that the data will always be refreshed.
Business Value
Easy and automated tracking of the sales from all the units, order and samples, sales by salesperson, sales by items and regions etc.
Easy to automate tracking of customers, their last order, last activities, sales conversion, average order etc.
Better reporting for management via graphical and tabular reports.
Being created in Power BI it is easy to maintain scheduled refresh so that the users are always supplied with live data.
Easy way to filter all the reports using different type of slicer available in the report.
Easy way to share report to users via email and report link
Easy way to export the report in the form of PPT and PDF or can print the report.
Diligence in delivering releases on time and with utmost quality.
We deliver the Cost-effective solution within proposed turnaround
Low maintenance cost, reduced manual effort and time to create reports.
Project Details
Technology
Microsoft Power BI
Team Size
2
Duration
1.5 Month
Industry
Cannabis Distribution and Manufacturing
Client Testimonial
Spencer Graff
CEO, N-Fuzed
"The Cynoteck team is Very knowledgeable and provides prompt responses and great service. I highly recommend them for basic implementations and complex integrations."
Need for an automated process of fetching data for two different companies from Business Central ERP and LeafLink CRM with the following functionalities:
Need for individual dashboards for both companies that contains different type of financial reports with graphical and tabular visualization.
Need to create a consolidated dashboard containing data of both companies in single report for the customers of the company, so that the Business Owner will be able to view the overall business of the company.
Need for a functionality that shows live business central data at the Power BI dashboard and reports.
Solution Delivered
Cynoteck proposed implementation of Power BI Pro for creating reports and dashboards
We implemented the following approaches to fulfil the requirements of the system:
We created various web services in Business Central to supply the relevant data inputs for Power BI.
In power BI we performed the following activities –
Transformed the Business Central data
Created multiple custom columns and measures for creating the reports.
Created different workspaces for both company in the Power BI service and assigned individual managers to their respective workspace according to their company.
Published report in Power BI service workspace according to their company.
We have configured scheduled refresh so that the data will always be refreshed.
Business Value
Easy and automated tracking of the sales from all the units, order and samples, sales by salesperson, sales by items and regions etc.
Easy to automate tracking of customers, their last order, last activities, sales conversion, average order etc.
Better reporting for management via graphical and tabular reports.
Being created in Power BI it is easy to maintain scheduled refresh so that the users are always supplied with live data.
Easy way to filter all the reports using different type of slicer available in the report.
Easy way to share report to users via email and report link
Easy way to export the report in the form of PPT and PDF or can print the report.
Diligence in delivering releases on time and with utmost quality.
We deliver the Cost-effective solution within proposed turnaround
Low maintenance cost, reduced manual effort and time to create reports.
Project Details
Technology
Microsoft Power BI
Team Size
2
Duration
1.5 Month
Industry
Cannabis Distribution and Manufacturing
Client Testimonial
Spencer Graff
CEO, N-Fuzed
“The Cynoteck team is Very knowledgeable and provides prompt responses and great service. I highly recommend them for basic implementations and complex integrations.”
00vote
Article Rating
Subscribe
Connect with
I allow to create an account
When you login first time using a Social Login button, we collect your account public profile information shared by Social Login provider, based on your privacy settings. We also get your email address to automatically create an account for you in our website. Once your account is created, you'll be logged-in to this account.
DisagreeAgree
Connect with
I allow to create an account
When you login first time using a Social Login button, we collect your account public profile information shared by Social Login provider, based on your privacy settings. We also get your email address to automatically create an account for you in our website. Once your account is created, you'll be logged-in to this account.