Little useless-useful R function – DataFrame Maker
Series of useless R functions continues. This time writing long code to generate random data.frame.Read more ›continue reading.
Author: tomaztsql
Creating data files in Azure Blob Storage for SQL Server database with Powershell
Storing SQL Server database files in Azure blob storage is a great solution for all the databases that are often migrated between instances, servers, virtual machines, or would have been...continue reading.
Quine with R
Quine is a self-reproducing function or a computer program that will output its source source or itself. Terms used are for these programs are also self-replicating programs, self-reproducing programs or...continue reading.
Power BI Measures in slicer
Power BI measures are mainly used to show and visualize data, that can be measured. But from time to time, end-users will want to have measures to be easily selected...continue reading.
Essential list of useful R packages for data scientists
I have written couple of blog posts on R packages (here | here ) and this blog post is sort of a preset of all the most needed packages for...continue reading.
Custom Power BI visual for Line chart with two Y-Axis
Power BI support certain type of visuals that are by default available in the document. These are absolutely great and work perfectly fine, have a lot of capabilities to set...continue reading.
What and who is IT community? What does it take to be part?
This blog post is long over due and has been rattling in my head for long time. Simply and boldly put it, community is everyone involved behind the result of...continue reading.
The palindrome of 02.02.2020
As of writing this blog-post, today is February 2nd, 2020. Or as I would say it, 2nd of February, 2020. There is nothing magical about it, it is just a...continue reading.
Sudoku game with R
Sudoku is a classical logical game based on combinatorial number replacement puzzle. Objective is to to fill 9×9 matrix with digits so that each column, each row, and each box...continue reading.
Working with Windows CMD system commands in R
From time to time, when developing in R, working and wrangling data , preparing for machine learning projects, it comes the time, one would still need to access the operating...continue reading.
Custom Power BI filter pane with hide/show feature
Having as much possible Power BI estate when it comes to putting the visuals for data exploration, is everyone’s dream. But the slicers for “slicing and dicing” the data is...continue reading.
Advent of Code 2019 challenge with R
I have decided to tackle this year’s Advent Of Code using R (more or less). I know there are more preferred languages, such as Python, C#, Java, JavaScript, Go, Kotlin,...continue reading.
November 2019 update and decomposition tree
I am super excited about all the new features that November 2019 update brought to Power BI Desktop. Complete list is here. Great new visual for all the data analysts...continue reading.
Hangman game with R
Hangman is a classic word game in which you need to need to guess as many possible letters in word, so you can guess the word, before running out of...continue reading.
Finding duplicates in data frame across columns and replacing them with unique values using R
Suppose you have a dataset with many variables, and you want to check: if there are any duplicated for each of the observation replace duplicates with random value from pool...continue reading.
Python Pandas MultiIndex and reading data from SQL Server
Python Pandas multiIndex is a hierarchical indexing over multiple tuples or arrays of data, enabling advanced dataframe wrangling and analysis on higher data dimensionality. Everyone have had come across multiIndex...continue reading.
Creating data frame using structure() function in R
Structure() function is a simple, yet powerful function that describes a given object with given attributes. It is part of base R language library, so there is no need to...continue reading.
Number 6174 or Kaprekar constant in R
Not always is the answer 42 as explained in Hitchhiker’s guide. Sometimes it is also 6174. Kaprekar number is one of those gems, that makes Mathematics fun. Indian recreational mathematician...continue reading.
Installing R using Powershell
Installing R from scratch and creating your favorite IDE setup is especially useful when making fresh installation or when you are developing and testing out different versions. This blogpost will...continue reading.
