A temporary table with a hash (#) or double hash (##) is a temporary table stored in the system database tempdb. This table exists only for the duration of the user session ID that created it. There are two types of temporary tables: Local Temporary Table A local temporary table is accessible only within the… Read More »
In some situations, we need to get an overview of the data present in a table. Or perhaps we want to check if there are any duplicate values in the table that we do not want. How can we retrieve a list of such duplicate records using SQL script? How to Identify Duplicate Rows in… Read More »
With the term “Finance covenants” we often encounter it in contractual documentation in the field of finance. It frequently appears in loan agreements (bank vs. company), prospectuses for bond issuer programs, or other financial agreements between two or more parties. What is a Financial Covenant – Definition A financial covenant can be defined as an… Read More »
A data warehouse is a centralized repository where company-wide data is consolidated and stored in a format that enables clear, accurate, and user-friendly reporting in tools such as Excel, Power BI, or other analytical platforms. At some point in every company’s lifecycle, you inevitably realize that you are operating too many business systems and facing… Read More »
The aim of this article is not to extensively describe the consolidation of financial statements from a theoretical perspective but to demonstrate how to automate the preparation of consolidated statements as much as possible, perhaps using Excel. It is assumed that if you are reading this article, you have an idea of what it’s about.… Read More »
Power BI report examples are popular, so I’ve decided to create another example that you probably won’t find elsewhere – a Financial report in Power BI. Typically, financial reports are done in Excel. My intention was to thoroughly explore Power BI and test it in the creation of a complex report, such as financial statements… Read More »
Resource Governor is one of the SQL Server enterprise features that are not available in any other edition. If you are interested in various limitations across editions, I have summarized them in the article SQL Server Installation – Planning, HW and SW Requirements. If you are experiencing performance problems and have tried various optimization and… Read More »
Whenever we set connector to our data in Power BI, we have an option to select connection to a certain object (e.g. a table) or there is a second option. That is connection using direct query which secures live connection to data source. We will prepare simple Sales report by few clicks. (as in video).… Read More »
Logical functions serve us to test conditions not only in Excel. They can be used in situation when we need to compare 2 or more values and find out if a certain condition is met. Often used function IF belongs to logical functions, except for this function, you will most often use functions AND and… Read More »
SUBTOTAL is a little strange function. There are 11 mathematical functions hiding inside it. We can calculate sum, arithmetic mean, spread, minimum/maximum and another statistic values using SUBTOTAL function. What’s more, we can limit whether we want to calculate even with hidden values which were hidden manually. All under roof of one function. SUBTOTAL –… Read More »