Blog Archives

Little useless-useful R functions – QR-Code Clock

Ever wanted to have a clock on the wall or in the office, that is not binary. But it is QR-Code clock 🙂 Well, now you can have it. This useless R function generates new QR Code for every given

Tagged with: , , , , ,
Posted in R, Useless R functions

Little useless-useful R functions – Vanishing sentences

Let’s play with some words. More in particular with vanishing words. Using two packages: ggplot2 and gganimate we will construct a animation (looped), where sentences will be vanishing, word by word. A nice way to train the ggplot animations. The

Tagged with: , , , , , , , , ,
Posted in R, Useless R functions

Little useless-useful R functions – Useless animated showcase of plot() function

Plot() function is R’s most generic function for plotting different types of graphs. And making a animation of sample graphs with is as useless as it can be useful for educational purposes. Animation would look like this: So the gist

Tagged with: , , , , ,
Posted in Uncategorized, Useless R functions

New features in Power BI for Data Analysts – Small multiples, Anomaly Detection and Zoom on visuals

Great new features have bundled and are now available in Power BI. With December 2020 update, all of the features described in this blog post will be available. Once you downloaded the latest update (as of writing of this blog,

Tagged with: , , , , , ,
Posted in Uncategorized

Little useless-useful R function – Psychedelic Square root with x11()

Yes, the name of today’s function is wacky, because it gives you the flickering feeling when running it with x11() function. In addition is uses simple square root and cosine function to calculate the points in graph to give it

Tagged with: , , , ,
Posted in Uncategorized

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 and graphs or tables changed, in accordance with selection. And

Tagged with: , , , , ,
Posted in Uncategorized

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 properties and change the settings. But every so often in

Tagged with: , , , ,
Posted in Uncategorized

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 also very important. Having all the slicers hidden has always

Tagged with: , , , , , , ,
Posted in Uncategorized

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

Tagged with: , , , ,
Posted in Uncategorized

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: , , , , ,
Posted in Uncategorized
Follow TomazTsql on WordPress.com
Programs I Use: SQL Search
Programs I Use: R Studio
Programs I Use: Plan Explorer
Rdeči Noski – Charity

Rdeči noski

100% of donations made here go to charity, no deductions, no fees. For CLOWNDOCTORS - encouraging more joy and happiness to children staying in hospitals (http://www.rednoses.eu/red-noses-organisations/slovenia/)

€2.00

Top SQL Server Bloggers 2018
TomazTsql

Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond

Discover WordPress

A daily selection of the best content published on WordPress, collected for you by humans who love to read.

Revolutions

Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond

Reeves Smith's SQL & BI Blog

A blog about SQL Server and the Microsoft Business Intelligence stack with some random Non-Microsoft tools thrown in for good measure.

SQL Server

for Application Developers

Business Analytics 3.0

Data Driven Business Models

SQL Database Engine Blog

Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond

Search Msdn

Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond

R-bloggers

Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond

Data Until I Die!

Data for Life :)

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

Grant Fritchey

Intimidating Databases and Code

Madhivanan's SQL blog

A modern business theme

Alessandro Alpi's Blog

DevOps could be the disease you die with, but don’t die of.

Paul te Braak

Business Intelligence Blog

Sql Insane Asylum (A Blog by Pat Wright)

Information about SQL (PostgreSQL & SQL Server) from the Asylum.

Gareth's Blog

A blog about Life, SQL & Everything ...

SQLPam's Blog

Life changes fast and this is where I occasionally take time to ponder what I have learned and experienced. A lot of focus will be on SQL and the SQL community – but life varies.

William Durkin

William Durkin a blog on SQL Server, Replication, Performance Tuning and whatever else.

$hell Your Experience !!!

As aventuras de um DBA usando o Poder do $hell

Design a site like this with WordPress.com
Get started