All articles with 'R' Tag

Awesome chart to visualize Salary Increases for 3,500+ people [Tutorial]

Published on Aug 17, 2017 in Charts and Graphs, R programming
Awesome chart to visualize Salary Increases for 3,500+ people [Tutorial]

Game for some charting awesomeness?

Off late, I have been doing a lot of data analysis and visualization on performance ratings, salary hike, gender pay equality etc. Today let me share you an awesome way to visualize massive amounts of data.

Scenario: Your organization of 3,686 people recently went thru annual performance ratings & review process. At the end of it, everyone was offered some salary increase (from $0 to $24,000 per year). You have 7 business groups. How do you tell the story of all these salary hikes in one chart?

How about the one above?

Ready to know how to create this in Excel? Read on.

Continue »

Employee Performance Panel Charts in Power BI with R

Published on Aug 11, 2017 in Power BI, Power Query
Employee Performance Panel Charts in Power BI with R

Yesterday we saw a beautiful example of panel charts with R. Today let me show you how to create the same (or even better) with Power BI & R. What you need: Power BI Desktop and R Raw data set – rem-data.csv Creating Panel Charts in Power BI with R Load CSV data in to […]

Continue »

Employee Performance Panel Charts – Excel vs. R [video]

Published on Aug 10, 2017 in Charts and Graphs, R programming
Employee Performance Panel Charts – Excel vs. R [video]

Recently, I had to make a bunch of panel charts. After wrangling with Excel (and a tiny bit of VBA) to create them, I wondered if we are suffering needlessly by being too loyal to Excel. I switched to R and could create these panel charts in almost no time (well, first I had to learn how to pivot the data using dplyr). Today, let me share the experience.

Continue »