Press "Enter" to skip to content

Day: December 3, 2024

Interpolating Missing Values in R

Published 2024-12-03 by Kevin Feasel

Steven Sanderson fills in the blanks:

Interpolation is a method of estimating missing values based on the surrounding known values. It’s particularly useful when dealing with time series data or any dataset where the missing values are not randomly distributed.

There are various interpolation methods, but we’ll focus on linear interpolation in this article. Linear interpolation assumes a straight line between two known points and estimates the missing values along that line.

Read on to see how you can perform linear interpolation in R.

Leave a Comment

Blank Dates and DAX

Published 2024-12-03 by Kevin Feasel

Marco Russo and Alberto Ferrari are blanking on us:

Handling missing dates in a semantic model can be challenging, especially when working with DAX time intelligence functions. Dates might be missing for various reasons: incomplete data entry, system errors, special placeholder values like 0000, or dates set far in the future. We will see that using a blank is the best way to manage missing dates, even though you should pay attention to DAX conditional expressions operating on those dates. We will also consider how to hide these blanks in a Power BI report if their presence is not desired in charts and slicers.

Read on to learn more.

Leave a Comment

Optimizing AWS Costs

Published 2024-12-03 by Kevin Feasel

Albert McQuiston speaks my language (that is, saving money):

Every organization looks to save on its cloud expenses to align with business objectives. With the following tips, you can optimize your Amazon Web Services (AWS) cloud expenditure and review the key aspects where you can save more effectively.

Read on for some high-level tips. It doesn’t cover things like spot instances, but does a pretty decent job of laying out the problem and showing some of the cost and budgeting tools available to figure out where your company’s money is going.

Leave a Comment

GiST Indexes and Range Queries in PostgreSQL

Published 2024-12-03 by Kevin Feasel

Lee Asher can’t be limited to a single point:

Our Part I query used the following WHERE clause:

WHERE tsrange(o.start_time, o.end_time) && tsrange(p.enter, p.leave)

The “tsrange()” functions return timestamp ranges. But overlap queries aren’t limited to timestamps; they can be constructed from integers and floating-point values too. Imagine an arbitrage database that tracks the minimum and maximum price paid for a commodity.

Read on for examples of other types of ranges, preventing range intersection, and more.

Leave a Comment

External Data Sharing in OneLake

Published 2024-12-03 by Kevin Feasel

Jens Vestergaard shares some info about sharing some info:

At #MSIgnite Microsoft announced a new feature in Fabric that allows people from one organization to share data with people from another organization. You might ask yourself why is this even news, and rightly so. Up until last week, professionals have had to use tools like (S)FTP clients like FileZilla, Azure Storage Explorer, WeTransfer or similar products in order to share data. Some of these tools are in fact hard to use and/or understand for a great number of business users – they are familiar with Windows and the Office suite and not much more. This is all to be expected, as business users in general should focus on business stuff rather than IT stuff.

Read on to see how this has changed, and an update to what I consider one of the coolest products to come out of Microsoft Fabric.

Leave a Comment