How to quickly drop columns in R in data frame
Here are multiple ways how to drop one or multiple columns in the R data frame. You can use R base functionality or…
Latest Posts
How to quickly drop columns in R in data frame
Here are multiple ways how to drop one or multiple columns in the R data frame. You can use R base functionality or…
Logarithmic transformation in R, inverse logarithmic transformation in R
Logarithmic transformation in R is one of the transformations that is typically used in time series forecasting. If your forecasting results have negative…
Calculate weighted average in Excel PivotTable in 2 ways
Here are a few methods on how to calculate the weighted average in Excel PivotTable or DAX. It is not so simple as…
How to connect to the Salesforce data with R
Here is how to get necessary Salesforce data with R. Previously, there was a package RForcecom, but now you should use the salesforcer…
Data dictionary in Power BI by using Q&A, GIF background
Here is a fun way to use Q&A functionality to build a data dictionary in Power BI. The first question might be –…
How to connect to the Salesforce data with Power Query, Power BI, Excel
Here is how to connect to the Salesforce data with Power Query in Excel or Power BI. For the Salesforce CRM data exploration,…
How use dplyr distinct with exceptions, select unique rows in R
Here are several examples of how to use dplyr distinct to select only unique rows in the data frame. Examples starting with situations…
Add custom button with a shortcut to Excel file in Power BI report
When the Power BI report is not enough, here is how to add an interactive button as a shortcut to the Excel file…
How to bind R data frames vertically
Here is how to bind two or more R data frames vertically using different methods and dealing with possible errors. Binding R data…
Reader PicksAll posts
How to quickly drop columns in R in data frame
Here are multiple ways how to drop one or multiple columns in the R data frame. You can use R base functionality or…
Logarithmic transformation in R, inverse logarithmic transformation in R
Logarithmic transformation in R is one of the transformations that is typically used in time series forecasting. If your forecasting results have negative…
Calculate weighted average in Excel PivotTable in 2 ways
Here are a few methods on how to calculate the weighted average in Excel PivotTable or DAX. It is not so simple as…
How to connect to the Salesforce data with R
Here is how to get necessary Salesforce data with R. Previously, there was a package RForcecom, but now you should use the salesforcer…
Data dictionary in Power BI by using Q&A, GIF background
Here is a fun way to use Q&A functionality to build a data dictionary in Power BI. The first question might be –…
How to connect to the Salesforce data with Power Query, Power BI, Excel
Here is how to connect to the Salesforce data with Power Query in Excel or Power BI. For the Salesforce CRM data exploration,…
How use dplyr distinct with exceptions, select unique rows in R
Here are several examples of how to use dplyr distinct to select only unique rows in the data frame. Examples starting with situations…
Add custom button with a shortcut to Excel file in Power BI report
When the Power BI report is not enough, here is how to add an interactive button as a shortcut to the Excel file…
How to bind R data frames vertically
Here is how to bind two or more R data frames vertically using different methods and dealing with possible errors. Binding R data…
How to calculate weighted mean in R
Calculation of weighted mean in R is done easily by dedicated function or mathematically. Here are a couple of situations and solutions to…