It is a rare thing that a date can be a palindrome. But it happens. And the idea is the following, to cover all different date formats and for the given period And to do some useless extraction of the…
It is a rare thing that a date can be a palindrome. But it happens. And the idea is the following, to cover all different date formats and for the given period And to do some useless extraction of the…
A simple, yet effective way to set your colour palette in R using ggplot library. After that, we can start “chaining” ggplot graphs. Scatter plot Barchart / Histogram Boxplot 3.14 chart Finally custom colours! As always, the complete code is…
Calculating cumulative percentage or percentage per group for each time can sometimes be a task with a slight twist. Let’s check this with ggplot2 and tidyverse. Three (out of many more) ways to show how this can be achieved. using…
Uselessness is such a long useless word! In statistics, R-squared is a statistical measure, that determines the proportion of variance in dependent variable that can be explained by the independent variable. Therefore, it ranges in value from 0 to 1…
From previous blogpost(s): Deleting Power BI datasets using Powershell Daily monitoring and using statistics and activity logs for your Power BI tenant is always a great way to track the activity of your end users. If you need statistics to…
Progress bar showing the number of days until end of the year. Yes, only based on the days and not hour. And needless to say, the progress is soothing using ASCII charts. So the function is fair to say, simple…
This little useless-useful R function is not that useless after-all. Many of the R programmers have had some issues with namespaces in R environment and lost some time debugging, that turned out to be due to variable name or function…
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 data science, statistical usage and every-day usage with R. Among…
R has been around long time and the packages have evolved through the years as well. From the initial releases, updates, to new packages. Like many open-source and community driven languages, R is not an exception. And getting the first…
SQL Server Reporting services (SSRS) is an outstanding tool for creating, deploying and managing paginated, mobile, KPI reports as well as Power BI reports. Tool provides simple way to share and get data insights in your corporate environment. (Photo source:…
Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond
A daily selection of the best content published on WordPress, collected for you by humans who love to read.
Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond
A blog about SQL Server and the Microsoft Business Intelligence stack with some random Non-Microsoft tools thrown in for good measure.
for Application Developers
Data Driven Business Models
Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond
Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond
Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond
Data for Life :)
sharing my experiences with the Microsoft data platform, Fabric, enterprise Power BI, SQL Server BI, Data Modeling, SSAS Design, SSRS, Dashboards & Visualization since 2009
Intimidating Databases and Code
Ramblings
A modern business theme
DevOps could be the disease you die with, but don’t die of.
Business Intelligence Blog
Information about SQL (PostgreSQL & SQL Server) from the Asylum.
A blog about Life, SQL & Everything ...
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 a blog on SQL Server, Replication, Performance Tuning and whatever else.
As aventuras de um DBA usando o Poder do $hell