Time functions in DAX are besides simple calculation functions, the most useful functions; mainly because time slicers are one of the most frequently used slicers in Power BI. New functions are coming to DAX (Data Analysis Expression Language) regularly, and…
TomazTsql
Tomaz doing BI and DEV with SQL Server and R, Python and beyond
Blog Archives
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, C++, Elixir, but it was worth trying. Into the 8th…
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 is: decomposition tree. To enable the decomposition tree, navigate to…
Tagged with: AdventureWorks, Decomposition tree, features, Power BI, Power BI Desktop, Visualization
Posted in Uncategorized
Posted in Uncategorized
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 tries (lives). Upon running out of tries, you are hanged!…
Installing SSIS, SSRS and SSAS with Visual Studio 2019
Visual Studio 2019 brings new installation of SQL Server Integration services and SQL Server Analysis Services and SQL Server Reporting Services. There is no need to download SSDT (SQL Server Data Tools for Visual Studio) as used to do with…
Tagged with: environment, extensions, SQL, SQL Server, SSAS, SSIS, SSRS, Visual Studio 2019
Posted in Uncategorized
Posted in Uncategorized
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 of existing values. In this manner, let’s create a…
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 in Python Pandas and had little annoyancens as the first…
Tagged with: multi index, multiIndex, pandas, Python, Python Pandas, reading, sp_execute_external_script, SQL Server
Posted in Uncategorized
Posted in Uncategorized
| DAX Time Functions… on Time functions in DAX | |
| Advent of Code 2019… on Advent of Code 2019 challenge… | |
| Hangman game with R… on Hangman game with R | |
| Hangman game with R… on Hangman game with R | |
 | Rob Pattyn on Installing SSIS, SSRS and SSAS… |
