BIDA Romania

In this blog post we demonstrate how it is possible to create such a complex dashboard and the GL Account Beginning Of Time Balances from Business Central. This Dashboard uses the Microsoft Gateway product to allow the cloud Power BI Report to query a demo on premise Business Central Database to produce the dashboard. This proves that it is possible to make all data inside Business Central on premise available for query to Power BI in the cloud. We hope you like this demo.

In this blog post we show you a demonstration of how to create a report for Sales Lines for Business Central. We report Bill To, Sell To, Ship To sales lines with a global slicer to set parameters for the report.

In this blog post we announce and publish the availability of the rename script for Business Central 2023 Release Wave 2. What this rename script does is provide more user friendly names for tables and columns for all of the tables / columns in 2023 wave 2, also known as BC023. This script means there is no more need for brackets around tables or columns for queries written against BC. And all the symbols and spaces and special characters have been replaced. Basically the tables and columns are easier to read and therefore making it easier to write new SQL queries. These are free and available to all BC on premise users.

In this blog post we demonstrate is a video the details of how to make much better use of Power BI Cloud to query Business Central On Premise data. This blog posts opens the way for all On Premise customers to easily use Power BI Cloud to report on all data inside their BC System without having to have programmers write code for your "next query" or "next report". This is all free except the Power BI licenses if you do not already have them. We hope you like this blog post.

In this blog post we explain the details of how to make much better use of Power BI Cloud to query Business Central On Premise data. This blog posts opens the way for all On Premise customers to easily use Power BI Cloud to report on all data inside their BC System without having to have programmers write code for your "next query" or "next report". This is all free except the Power BI licenses if you do not already have them. We hope you like this blog post.

This is our first test post to the Business Central Forums

In this blog post we demonstrate how to query Business Central using a pseudo dimensional model and send the results into the Excel Power Query model. This is the future of direct query against operational systems.

In this blog post we demonstrate how to put pseudo dimensional models over the top of Business Central to solve the problems of sending ERP Data to AIs and querying ERPs to answer business questions.

In this blog post we demonstrate how it is possible to produce a report as complex as a balance sheet from Business Central using Meta5 and Excel.

In this blog post we present an updated demonstration of our Business Central Beginning of Time General Ledger Balance Excel demonstration.

In this video we demonstrate the Business Central Wave 23 data model dictionary we have implemented in Excel.

In this blog post we provide a detailed video demonstration of how to execute very complex SQL against Business Central to generate a valuable report that is very difficult (or impossible) to develop any other way.

In this blog post we show you the example of creating the Business Central Chart of Accounts Report using a Common Table Expression Query. This query is stored in a table and sent to Business Central via Meta5.

In this blog post we provide a detailed demonstration of how to use Meta5 desktops as a black box.

In this blog post we announce the availability of the Business Central Staging Area Evaluation Database.

In this blog post we announce the availability of the rename script for Business Central 2023 Release Wave 2

In this blog post we explain the features we have developed for the idea of Meta5 as a black box.

In this blog post we explain our offer to Finacle Version 7 installed accounts to receive a copy of our Finacle column renaming script.

In this How Do I blog post we show you how to add a new data disk pod.

In this How Do I Video we show you how to run a PowerShell command from inside a Meta 5 capsule.

In this blog post we show you how you can query Business Central 365 using Meta5 and the CData BC 365 ODBC Driver.

In this blog post we show you a detailed demonstration of how Meta5 can query your Navision 2018 system using SQL statements that are stored in files. This enables you to ask the most complicated of questions from Navision directly.

In this blog post we demonstrate how to query a multi-dimensional data model using Meta5.

In this blog post we reproduce a recent blog post by Bill Inmon, the father of data warehousing, on why you need a data model for a data warehouse.

In this blog post we demonstrate our Navision 2018 Dictionary Workbook. This dictionary makes it easier to query Navision 2018 from Meta5.

In this blog post we show you a detailed demonstration of how Meta5 can query your Navision 2018 system. We have created a dictionary to allow you to query all the tables in Navision 2018, including creating more than 5,000 joins in the model.

In this blog post we introduce two new features from Meta5 that allows you to retrieve data from even more sources with your Meta5 desktop and query tool.

In this blog post we briefly discuss the the upgrades we have made in our development methods for Excel Dashboards.

In this blog post we describe our new free Meta5 Evaluation Service for qualified companies.

In this blog post we will present the next database from the Ralph Kimball sample databases. The Warehouse Database. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will present the next database from the Ralph Kimball sample databases. The Voyage Database. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will present the next database from the Ralph Kimball sample databases. The Value Chain Database. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will present the next database from the Ralph Kimball sample databases. The Telephone Database. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will present the next database from the Ralph Kimball sample databases. The Supply Chain Database. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will present the next database from the Ralph Kimball sample databases. The Shipments Database. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will present the next database from the Ralph Kimball sample databases. The Insurance Database. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will present the next database from the Ralph Kimball sample databases. The Grocery Database. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will present the next database from the Ralph Kimball sample databases. The Factless Fact Tables Database. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will present the next database from the Ralph Kimball sample databases. The Credit Card Database. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will present the second database from the Ralph Kimball sample databases. The Cable TV Database. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will introduce you to the Ralph Kimball sample databases. We will demonstrate these databases through the Meta5 software from the company Ralph co-founded in 1982.

In this blog post we will take you through part 05 of re-recreating the example demographics dashboard we have released to the public.

In this blog post we will take you through part 04 of re-recreating the example demographics dashboard we have released to the public.

In this blog post we will take you through part 03 of re-recreating the example demographics dashboard we have released to the public.

In this blog post we will take you through part 02 of re-recreating the example demographics dashboard we have released to the public.

In this blog post we will take you through part 01 of re-recreating the example demographics dashboard we have released to the public.

In this blog post we will take you through part 03 of re-recreating the example Adventure Works dashboard we have released to the public.

In this blog post we will take you through part 02 of re-recreating the example Adventure Works dashboard we have released to the public.

In this blog post we will take you through part 01 of re-recreating the example Adventure Works dashboard we have released to the public.

In this blog post we teach you how to create a new file drawer on a users desktop in Meta5.

In this video we show you how to create power pivot tables in Excel from data retrieved by the Meta5 query tool.

In this video we show you how to create Excel Headers based on the column names returned by the meta5 query icon.

In this blog post we will show you how to simply and easily set the length of character fields in the WTDD to the maximum length of actual data in the character field.

In this blog post we show you how do I set up O365 email for meta5.

In this blog post we should you how do I set up SMTP email for meta5.

In this blog post we demonstrate how to copy objects between windows and Meta5.

In this blog post we will introduce you to the Meta5 Desktop. We will also introduce you to the suite of icons you can use to perform your data wrangling and data analysis.

In this blog post we share with you some of the rich history of Meta5. We explain to you why it is still the best tool for the power data analyst.

In this blog post we will answer your question how do I know what data is available to me in Meta5?

In this video we will demonstration how to install the Microsoft Meta5 demonstrations.

In this blog post we teach you how to create an ODBC connection for Meta5.

In this blog post we welcome you to our new "How Do I..." video series.

In this post we provide a detailed demonstration of how we build Excel dashboards for our Microsoft Navision BI Solution using Meta5. You can do the same for your Navision ERP even without a data warehouse.

In this post we provide an overview demonstration of how we build Excel dashboards for our Microsoft Navision BI Solution using Meta5. You can do the same for your Navision ERP even without a data warehouse.

In this blog post we provide a case study of how we provided significant ETL performance improvements for one of our customers here in Bucharest.

In this post we make available a detailed white paper on how we have built our first Microsoft Navision BI Solution Dashboard. You can request a copy on this page.

In this blog post we provide a detailed demonstration of what the proposed dashboards will look like for our Microsoft Navision BI Solution.

In this blog post we announce updates to the BIDA Navision BI Data Models for our BI Solution. You can request the updates from this page.

In this post we talk about our first successful project implemented in the USA as BIDA. This is a big step forward for our new company!

In this blog post we have released details of our BIDA Navision BI Party Profiles data models. You can request them from this page.

In this blot post we release the details for our Microsoft Navision BI Solution Sales Category Models. You can download them from this page.

In this blog post we describe how it is possible to access a Navision BI Staging area using the Meta5 software. This can be done to perform data analysis that on data that is not yet in the data warehouse.

In this blog post we describe how it is possible to build a staging area for a Navision BI solution in just a few days.

In this post we wish to provide a short explanation of our MicroSoft Navision BI Solution which is under development.

In this post we talk about how we can help you improve your business performance using the Meta5 software for more sophisticated business analysis.

In this post we explain what we can offer for ETL support or possible migration of your ETL system to our BIDA ETL software.

In this post we talk about how data warehouse data models can be improved for better performance and functionality.

In this post we describe some of the common performance and reliability issues that we have seen with ETL subsystems and how to solve them.

In this post we describe, in detail, the benefits and processes of manual partitioning using SQL Server.