Exsion Reporting
Boost your reporting speed!
Exsion Reporting is an Excel based software that empowers controllers to produce reports based on data in Microsoft Dynamics 365 Business Central in the cloud (formerly Dynamics NAV).
This tool is equally useful for logistics and commercial departments.
Why we stand out
Easily create Reports in Excel
Exsion Reporting allows any controller to create reports based on data present within Microsoft Dynamics 365 Business Central (previously known as Dynamics NAV).
Combining all your data in Dynamics 365 Business Central
One of the functionalities we take pride in, is the possibility to transfer all data present within your database to Excel.
Reports can be Refreshed instantly
Once you have created your data selection (what we call a download definition), you can refresh it time and again, thus ensuring your report will contain the latest data.
See below how Exsion Reporting solves daily challenges faced by Business central users
Why Choose Exsion Reporting Over Other BI Tools?
Implementing traditional BI tools can be expensive and time-consuming due to the extensive setup, training, and consultancy required. Modifying reports in these tools is often difficult because it requires in-depth knowledge of Business Central’s complex database and familiarity with the specific BI tool's functionality.
Exsion Reporting Offers a Cost-Efficient and User-Friendly Alternative:
- Ease of Use: Exsion Reporting is designed to be intuitive and easy to use, leveraging familiar logic from Business Central and Excel. This means users can quickly adapt without extensive training or consultancy.
- Cost Efficiency: Unlike traditional BI tools, Exsion Reporting minimizes costs associated with setup and training. Our nearly 1,000 clients have successfully learned to use Exsion after attending just a one-day training session.
- Simplicity in Modification: Modifying reports in Exsion is straightforward, as it eliminates the need for deep technical knowledge of BC’s database. Users can easily change data sets and visualizations using familiar Excel functions.
How can I download Exsion Reporting?
Installing Exsion Reporting is easy and fast.
To install the program on your computer, you need to ensure that you have administration rights.
Simply follow the 3-minute video below for a step-by-step guide:
If you need any further assistance, please contact our support team.
I have to copy+paste to build reports and it takes too much time.
Exporting data from Business Central to Excel typically requires repetitive cut-and-paste actions to get the desired data set. This process is not only time-consuming but also prone to errors. Additionally, storing each version separately makes comparing data over different time periods extremely complex.
Exsion Reporting Streamlines This Process:
-
No More Cut and Paste: Exsion Reporting eliminates the need for manual cut-and-paste actions. Once you create a download definition, you can generate a report ready for use, including all future updates. Simply click the Refresh button to update your report, ensuring accurate and up-to-date information.
-
Eliminate Separate Versions: With Exsion Reporting, data is directly retrieved from the database. This allows you to use Excel for calculations and your database for data storage, simplifying data management and ensuring consistency.
I cannot combine data from different Business central tables
Even though Business Central provides ample filtering functionality, combining data from different tables can involve downloading several lists and repeatedly exporting reports. Combining this data is even more challenging due to limitations of excel formulas and links that can "break".
Exsion Reporting solves this by using the same coding to the download tables as the set up in Business Central with a direct link, thus eliminating the need to use excel formulas.
Several tables can be combined in one download ensuring the completeness and accuracy of the data.
What do I need to learn and use Exsion Reporting?
To get started with Exsion Reporting, you need to have a good understanding of Excel and have experience working with Business Central.
Is Exsion Easy to Learn?
Yes, Exsion's basic functionality is straightforward, and a one-day training course is sufficient for creating most reports. With this training, you will learn to use slicers to add a time dimension to your reports, create pivot tables for beautiful overviews, and much more.
Can I automatically update my reports and share with my colleagues?
You can automate report forwarding using the Windows Task Scheduler or Exsion’s built-in scheduler. We also collaborate with RBE, a company specializing in task planners. Reports can be automatically sent to selected staff based on changes in the database, without requiring any human interaction.
Can I Expand My Exsion Skills?
Absolutely! We offer advanced training for users who want to create complex reports or optimize their existing ones. This training is very useful for those looking to expand their Exsion capabilities.
I Cannot Access Data Created by Extensions
Exsion Reporting can also access data generated by extensions and other installed API's.
How fast is Exsion Reporting?
Many tools on the market are slow due to their underlying technology, often delivering data through complex connections and services that take a long time to donwload.
Exsion Reporting Provides Quick Answers:
Exsion is built to be fast and our clients are consistently satisfied with its performance.
How Does Exsion Achieve Such Speed?
In hosting and on-premise scenarios where we can access the database directly, database queries are submitted directly rather than through a connection. This direct access is why Exsion operates at such high speed, ensuring efficient and quick data generation.