Select Distinct Logo Clear Background

Unlocking the Power of DAX LOOKUPVALUE in Power BI


DAX LOOKUPVALUE function is the subject of this blog. It is particularly useful for retrieving values from tables based on specific conditions. In this blog, we will explore the LOOKUPVALUE function, its syntax and use cases. We will also cover examples to help you leverage its full potential. This is similar to the Power BI […]

Mastering Excel LAMBDA Functions

Excel LAMBDA functions

Creating powerful, custom functions in Excel got easier with Excel LAMBDA functions. These functions offer a dynamic way to create reusable formulas. These can simplify complex calculations, tailor your data manipulation, and enhance the efficiency of your workflows. Here’s an in-depth look at how to use LAMBDA functions, including some practical examples. Excel LAMBDA functions […]

Exploring the Best Data Import Technologies

Best Data Import Technologies

The ability to efficiently and accurately import data is crucial for any business. The right tool is key, whether you’re integrating massive datasets, streaming real-time data, or moving data between applications. In this blog, we’ll compare some of the leading data import technologies from Microsoft, Amazon, Google, and Snowflake. SQL Server Integration Services (SSIS) Overview: […]

Harnessing the Power of Streaming Data

Streaming Data

Streaming data has emerged as a critical component of modern data strategies. Streaming data refers to data that is continuously generated by various sources, these typically send data records in small sizes (such as bytes or kilobytes). This blog explores what streaming data is, why it’s important, its applications, and the tools used to manage […]

The Medallion Architecture Unveiled

Medallion architecture

Medallion architecture, a term increasingly recognized within the realms of data management and software development. It presents a compelling framework for building scalable, flexible, and efficient data platforms. This blog post explores the core concepts of medallion architecture, its benefits, and real-world applications. It aims to shed light on why it has gained popularity among […]

A Guide to Extracting Data from Joblogic

extracting data from joblogic

Following on from the blog last week I thought I’d write a similar guide to extracting data from Joblogic. Joblogic is a popular Field Service Management (FSM) software that helps facility management companies run their operations. FSM software is particularly useful for companies that provide services at the customer’s location. These companies are generally involved […]

A Guide to Extracting Data from BambooHR

Extracting data from BambooHR

Having worked with a few customers on automating the data output from their HR system, namely BambooHR. I thought I’d summarise some some of the considerations on extracting data from BambooHR. BambooHR is a cloud-based Human Resources Information System (HRIS) designed to simplify HR processes for businesses. It’s known for its user-friendly interface, scalability, and […]

Explaining User-Defined Types in SQL Server?

User-Defined Types in SQL Server

Having recently stumbled on User-Defined Types (UDTs) in SQL Server. I thought I’d write a blog to explain what user-defined types are? Why you should you use them? This blog post delves into what UDTs are, why they are useful, and how to use them in SQL Server. What are User-Defined Types (UDTs)? In SQL […]

Azure Data Factory vs Logic Apps:

azure data factory vs logic apps

Key Differences and Cost Implications On a recent project I have been looking at whether to use Azure Logic Apps as an alternative to Azure Data Factory (ADF). This brought me to compare these 2 technologies. This blog aims to summarise key differences between Azure Data Factory vs Logic Apps. It also aims to discuss […]

Choosing the Right Paginated Reporting Tool

Pixel-Perfect Precision

Pixel-Perfect Precision: In the data realm, the importance of robust reporting tools cannot be overstated. Businesses rely on accurate, timely, and insightful reports to drive strategic decisions, identify trends, and measure performance. In the modern landscape there is lots of focus on interactive visualisation software. However what are the options the distribution and delivering of […]