Data-driven decision making is commonly understood by our customers as the process of extracting valuable data insights from business operations. In doing so, data has to be identified, pre-processed, ingested into appropriate databases and finally presented in a condensed and filtered manner to the end-user. Our primary tool for this is the development of data-driven …
Spreadsheets have been around since the early 1980s and the basic concept has remained the same with rows and columns that can contain data and calculations. It is a very powerful concept that allows for advanced calculations and analysis. But with collaboration around data and analysis becoming increasingly important, and the dramatic increase in the …
Microsoft Azure is a cloud computing platform and infrastructure that provides a range of services for building, deploying, and managing applications and services through a global network of data centers. Azure has a wide range of services, including computing, analytics, machine learning, storage, and networking. These services can be combined and configured to meet an …
In previous articles, we have outlined drivers that make data an ever more important factor for business success, the associated need to audit data (including the processes involved to collect, store and analyze data) and how financial auditing methods can be translated to fit this purpose. Company accounts are crucial for the allocation of assets …
DAX, or Data Analysis Expressions, is a formula language used to define calculations and measures (terminology to define row calculations) used to analyze and transform data in Power BI. It is a powerful and flexible script/programming language that allows users to create complex calculations and perform advanced data analysis tasks. The power of DAX becomes …
One week ago, on November 30th, OpenAI released it’s latest large language model chat bot, called ChatGPT. As a general chat-bot, this system allows users to enter prompts to which the system replies. While it is not always correct, ChatGPT is in many instances able to provide very detailed answers to a wide range of …
The rise of large language models & coming business applications Read More »
Excel is by far the most utilized spreadsheet and data tool in the world with over 1 billion instances in use. It can be argued that Excel is one of, if not the most user-friendly spreadsheet tools in the world. Most business professionals are familiar with Excel and Excel has served as a traditional data …
Imagine such a scenario: you have a production line that has thousands of milling machines, and you notice that you are losing money every time a machine breaks down and lower the production rate. What can you do to solve the problem? You asked your engineers to regularly check every machine and either repair or …
In previous articles, we have outlined drivers that make data an ever more important factor for business success, the associated need to audit data (including the processes involved to collect, store and analyze data) and how financial auditing methods can be translated to fit this purpose. Company accounts are crucial for the allocation of assets in …
There are dozens of important metrics a company needs to track and understand to build a successful business. From acquisition cost, sales revenue to the churn rate and many more, these metrics help companies stay on track as the business grows. If you are not tracking your metrics, surprises can happen that will harm your …