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
While the same company created Jet Reports and Jet Analytics, they are two entirely different products (even though they both have “Jet” in their name). In this blog, we look at how each product is different and how they can be used together. Jet Reports is a reporting tool Jet Reports lets you query Microsoft… 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 Dynamics 365 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 Dynamics 365 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 a great tool for creating and publishing dynamic and interactive reports, but it has a few quirks that can be tricky to navigate. When creating a Power BI report with a table that contains Measures, sometimes the columns in the table don’t total correctly. When a Measure is used on rows… 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