• Home
  • About Me
  • Contact Me

Data Cornering

Journey in work with data

  • Facebook
  • Twitter
  • LinkedIn

Data Cornering

  • Home
  • About Me
  • Contact Me
  • Facebook
  • Twitter
  • LinkedIn
Info

Popular Categories

Top PostsAll posts

chart with gradient color in Excel
DataViz Excel

Line chart with gradient color in Excel

If you have a data set with certain characteristics, you might want to take a chance and create a line chart with gradient…

by Janis Sturis May 3, 2022 Comments0
file creation and modification datetime in R
R

How to get when a file is created or modified in R

Year and month combination in R
R

Year and month combination in R

Switch Power BI chart axis dimensions
DAX Power BI

Switch Power BI chart axis dimensions

Latest Posts

pattern of numbers from string in R
R

How to extract the pattern of numbers from text in R

by Janis Sturis January 31, 2022 Comments0
all columns from CSV file with Power Query
Power BI Power Query

Always import all columns from CSV file with Power Query

by Janis Sturis January 28, 2022 Comments2
dplyr message: Adding missing grouping variable
dplyr R

dplyr: Adding missing grouping variable

by Janis Sturis January 25, 2022 Comments0
How to add legend title in Excel chart
Excel

How to add legend title in Excel chart

by Janis Sturis January 17, 2022 Comments0
neon effect in Excel
DataViz Excel

How to create a glowing line chart in Excel

by Janis Sturis January 14, 2022 Comments0
filter data in R
R

filter in R

by Janis Sturis January 13, 2022 Comments0
where R packages are installed
R

find and change where R packages are installed

by Janis Sturis January 12, 2022 Comments0
add a column to the R data frame
R

How to add a column to the R data frame

by Janis Sturis January 6, 2022 Comments0
import Excel file in R
From Excel To R R

read Excel files in R

by Janis Sturis January 4, 2022 Comments0
dense rank in R
R

determine rank in R

by Janis Sturis December 28, 2021 Comments0

Posts navigation

Newer Newer Posts Page 1 Page 2 Page 3 … Page 21 Older Older Posts

Categories

Reader PicksAll posts

chart with gradient color in Excel
DataViz Excel

Line chart with gradient color in Excel

If you have a data set with certain characteristics, you might want to take a chance and create a line chart with gradient…

file creation and modification datetime in R
R

How to get when a file is created or modified in R

Here is how to get information when the file is created or modified in R. With help of R, you can extract this…

Year and month combination in R
R

Year and month combination in R

The year and month combination in R is possible in different ways. In my case, it is a combination in one data frame…

Switch Power BI chart axis dimensions
DAX Power BI

Switch Power BI chart axis dimensions

Here is a solution to add more analytical capabilities to your Power BI charts. Switch Power BI chart axis dimensions to get data…

weighted average using DAX
DAX Power BI

How to calculate weighted average using DAX in Power BI

Here is how to calculate weighted average using DAX in Power BI. By creating a measure that calculates the weighted average, you can…

remove values in R data frame
R

Replace values in the entire R data frame or range of columns

Sometimes data frames or a wide range of columns might contain values that you want to remove or replace. Here is how to…

OR operator in DAX
DAX Power BI

3 ways how to create OR logic in DAX

OR logic in DAX is frequently used in various Power BI calculations. The bad and the good news is that you can create…

Export data from R to Excel
Excel R

Export data from R to Excel

Here is how to export data from R to Excel. If you want to write an R data frame in an xlsx file,…

Excel advanced filter tips and tricks
Excel

Top 6 Excel advanced filter tips and tricks

Here are my top 6 Excel advanced filter tips and tricks. It is a great tool to speed up and optimize filtering processes…

filter by data frame row number in R
R

How to filter by data frame row number in R

RStudio data viewer is a great tool to look into data, but sometimes it is necessary to filter by data frame row number…

  • Copyright © 2022 Data Cornering
  • Powered by WordPress
  • Theme: Uku by Elmastudio
Follow me
  • Facebook
  • Twitter
  • LinkedIn