Conditional Formatting on Errors in Excel
Hello Friends! Today we’ll be seeing a very simple and very useful way to find out the errors in Excel sheet. This is very handy if you have a sheet with 100’s of rows and columns and can save lot of time.
Tag: Analytics
Rank Chart in Tableau
Today we’ll be learning how to create Rank chart in Tableau. Rank chart is very effective way to show the ranking of the dimension variation across the year,category or any other dimension. The Rank chart is easy to create and very useful.
How to Create your first Pivot Tables in 5 minutes (or less!)
Pivot tables are one of the most notable features of Microsoft Excel. And it’s easy to see why once you are familiar with the feature. To a beginner, they may seem a bit mysterious or intimidating. But once you learn a few basics to get started, you will be well on your way to visualizing your data in new and useful ways.
Regional UK map in Tableau
Hello friends today we’ll be learning how to create regional UK map. UK is having more than 2500 post codes but having around 10 regions. Getting an insights is very difficult as you can see in the final image(in the end of the tutorial).
#MakeoverMonday Le tour de france(1903-2016)
I was following #MakeoverMonday by Tableau since long time but didn’t submit any viz. This is my first viz though it is late but the time I spent was totally worth it.
Multiple Measures in single chart in Tableau
Hello friends! Today we’ll be looking at quick Tableau tip to show multiple measure values in chart in easy 3 steps.
Advanced Table in Excel using VBA
Hello friends! Today we’ll be learning about the Advanced Table in Excel using VBA. This post will be very using useful. Advanced Table in excel is very useful in many cases and also to replace pivot table in Excel.
File conversion tool: Cometdocs
Hi friends! It’s been long since I write any post. Today we’ll be looking into a very useful tool which is not exactly related to analytics. The tool is Cometdocs. Cometdocs easy to use and focus on wide range of users. But talking form the analytics perspective Cometdocs is amazing products for Teachers, students, researchers, scientists, data journalists etc.