Questions?

Do you use SQL Server for your Data Warehouse?

Is your ETL too slow?

Does your data arrive after 9am?

Are there days your ETL fails and your data does not arrive at all?

Do you want your ETL to run faster?

Do you want your ETL to be more reliable?

Does adding new data take too long and cost too much?

Do your queries run too slowly?

Would you like your queries to run MUCH faster?

Answers!

If you answered yes to two or more of these questions?

We would like to talk with you.

We are world class experts on SQL Server.

No matter how you implemented your ETL?

We can make your ETL run faster and be more reliable.

No matter how you implemented your data models?

We can make your queries run MUCH faster.

All with no more investment in hardware or software.

ETL Case Study

BIDA0057 – Business Central Beginning of Time GL Balances in PowerBI

0
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.

BIDA0056 – Business Central Dimensional Queries Sending Results To Excel

0
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.

BIDA0055 – Business Central Tables And Columns Rename Script

0
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.

BIDA0054 – BC Direct Query Using PowerBI Cloud Demo

0
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.

BIDA0053 – BC Direct Query Using PowerBI Cloud

0
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.

BIDA0052 – First Post To Business Central Forums

0
This is our first test post to the Business Central Forums

BIDA0051 – Business Central Dimensional Queries Sending Results To Excel

0
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.

BIDA0050 – Dimensional Models Over Business Central

0
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.

BIDA0049 – Business Central Balance Sheet in Excel

0
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.

BIDA0048 – Business Central Beginning of Time GL Balances in Excel

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

BIDA0047 – BC 2023 Excel Dictionary Demo

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

BIDA0046 – Business Central Beginning of Time GL Balances in Excel

0
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.

BIDA0045 – Meta5 And Complex CTE Queries

0
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.

BIDA0044 – Meta5 As A Black Box Demo

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

BIDA0043 – Business Central Staging Area Evaluation Database Available

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

BIDA0042 – Business Central Tables And Columns Rename Script

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

BIDA0041 – Meta5 As A Black Box

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

BIDA0040 – InfoSys Finacle Version 7 Column Table Renames Available

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

HD0015 – How Do I Add A New Data Disk Pod

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

HD0014 – How Do I Run PowerShell Commands In Meta5

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