Onur DemircioğluWhat I’ve read/watched this month (2024 June)Regular monthly update what I’ve read or watchedJul 7Jul 7
Onur DemircioğluMiscellaneous Holiday Calculations (Turkey)I want to make some calculations regarding calendar and holidays such as “Are there any years which all holidays are workdays?”Jun 17Jun 17
Onur DemircioğluCalculating Median of Cash Withdrawal with PythonPreviously, we had calculated median of cash withdrawal with SQL, Excel, PL/SQL and Excel VBA, Google Sheets Apps Script. And finally we…Jun 7Jun 7
Onur DemircioğluWhat I’ve read/watched this month (2024 May)Regular monthly update what I’ve read or watchedJun 2Jun 2
Onur DemircioğluConversion PART_KEY Column into Date FormatI am using a table on the data warehouse containing PART_KEY column. This column also has partitioned which is good. Partitions are good…May 31May 31
Onur DemircioğluCalculating Median of Cash Withdrawal with Google Sheets Apps ScriptPreviously, we had calculated median of cash withdrawal with SQL, Excel, PL/SQL and Excel VBA, now we are using Google Sheets Apps Script.May 24May 24
Onur DemircioğluGoogle Apps Script (Sheets) Finding the Last RowWhile writing Apps Script on Google Sheets, I often need the find the last row. Although there is a built-in function only for this purpose…May 17May 17
Onur DemircioğluCalculating Median of Cash Withdrawal with Excel VBAPreviously, we had calculated median of cash withdrawal with SQL, Excel and PL/SQL, now we are using Excel VBA.May 10May 10
Onur DemircioğluCalculating Median of Cash Withdrawal with PL/SQLPreviously, we had calculated median of cash withdrawal with SQL and Excel, now we are using Oracle PL/SQL.May 3May 3