There are many business intelligence tools available that can be used to analyze data from Business Central. Two of the most popular among our clients are Jet Reports and Power BI. Both products can be used for reporting and analytics, but each has strengths that make them appropriate for specific tasks. In this blog, we… Continue reading Jet Reports and Power BI: Which Reporting Tool Is Right for You?
Category: Reporting
Understanding the Differences Between Jet Reports and Jet Analytics
Created by the same company, Jet Reports and Jet Analytics both serve as powerful tools for data reporting and analysis—but they are built for entirely different purposes. If you’re trying to decide which is best for your needs (or whether you should use both), this blog provides a clear comparison to help you make an… Continue reading Understanding the Differences Between Jet Reports and Jet Analytics
Key Performance Indicators that Help You Assess Company Health
Key Performance Indicators (KPIs) are metrics used by managers and financial professionals to assess the health of a company. Think of KPIs as the vital signs to check on the health of a company. When a person goes for a medical checkup, the doctor will take his or her vital signs and, based on those… Continue reading Key Performance Indicators that Help You Assess Company Health
Combining Jet Reports/Analytics with Power BI to Supercharge Your Reporting and Business Intelligence
Many Microsoft Dynamics 365 Business Central or Dynamics NAV users might be confused when considering reporting and analytics options. Popular options include Jet Reports, Jet Analytics, and Power BI. Which is the best choice? Each tool was designed for a specific purpose; therefore, it depends on what you want to do that will help determine… Continue reading Combining Jet Reports/Analytics with Power BI to Supercharge Your Reporting and Business Intelligence
The Good, the Bad, and the Ugly of Losing Direct Access to SQL Server from Business Central in the Cloud
Many users of Microsoft Dynamics NAV or Business Central (BC) on-premises are used to being able to access SQL Server directly. That has been useful for several reasons, and one of the main reasons is that traditionally it has been much faster to run reports directly using SQL Server’s Report Builder than using Dynamics NAV… Continue reading The Good, the Bad, and the Ugly of Losing Direct Access to SQL Server from Business Central in the Cloud
Account Schedules Renamed to Financial Reporting in Business Central
This video examines the name change of Account Schedules to Financial Reporting in Microsoft Dynamics 365 Business Central and other changes now found in the Financial Reporting area. The change happened in the major update to Business Central in October 2022. Besides naming and navigation changes, functional updates are discussed in this video. Topics include… Continue reading Account Schedules Renamed to Financial Reporting in Business Central
Why It’s Important to Become an Innovative Retailer…and How to Start
What do you think when you hear the word, “innovative”? Typically, our thoughts go to making strides in technology—something really big like artificial intelligence, IoT, virtual reality, robots, and the like. While this is true, the real purpose of innovation is to improve what we already have, and it doesn’t have to be earth-shaking. In… Continue reading Why It’s Important to Become an Innovative Retailer…and How to Start
How to Use Data from Microsoft Dynamics 365 Business Central In Excel Using OData Feeds
Connecting to Excel with OData fields can be very powerful, not only for Power BI, but also for Microsoft Dynamics 365 Business Central. By simply connecting to a Business Central page as an OData feed, you can pull data into Excel to create pivot tables and more, opening the door to many benefits. In this… Continue reading How to Use Data from Microsoft Dynamics 365 Business Central In Excel Using OData Feeds
How to Make Measures Total Correctly in Power BI Tables
Microsoft Power BI is an excellent tool for creating and publishing dynamic and interactive reports, but it has a few tricky quirks. When creating a Power BI report with a table containing measures, sometimes the columns don’t total correctly. Those who experience this hurdle may be unfamiliar with how Power BI works or are new to data analysis expressions. Perhaps… Continue reading How to Make Measures Total Correctly in Power BI Tables
The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard
As a retailer with a top notch retail management system, you have access to a plethora of metrics. It’s easy to get overwhelmed with the amount of data at your fingertips, so this is where Key Performance Indicators (KPIs) help you determine which metrics can be used to keep your business moving in the right… Continue reading The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard