Krzysztof NowakNon-equi joinsIn this short article I will show example of using Non-equi in R, with special emphasis on between operator, which makes syntax closer to…Sep 101Sep 101
Krzysztof NowakFix dates with regular expressions and RIn this short post, I will show one way to standardize dates. Our tools will be the R language and its text functions along with regular…Jul 1, 2023Jul 1, 2023
Krzysztof NowakDynamic pivot tables in SQLA few months ago I published a short note on how to create a pivot table in SQL. Today I would like to show you a more scalable solution.Jun 13, 2022Jun 13, 2022
Krzysztof NowakMultiple SQL queries filtered with predefined variableLets imagine that you are going to created 3 separated reports:Sep 5, 2021Sep 5, 2021
Krzysztof NowakPivot Table in SQL for Sales Analise ? Sure!Lets consider three tables:Sep 2, 2021Sep 2, 2021
Krzysztof NowakIs bestseller most profitable? Lets check with SQLLets take following table. It shows product name, sales number, price and area of sales.Aug 29, 2021Aug 29, 2021
Krzysztof NowakUtilizing Window Function for Ranking comparison in SQLLets imagin that we have Sales table that presents 3 products, order numbers and regions where they were sold.Aug 27, 2021Aug 27, 2021