In my last post I visualized the earth movement around the sun. Now we will see Step by step tutorial to create the same visualization.
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.
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).
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.
Hello friends! recently I was working on some Tableau dashboards and found a very good usecase of donut charts which can be used multiple ways. Easy to use and visualize. Today we’ll be learning how to create category wise donut chart. I’ve used superstore data for the tutorial.
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.
Hello friends! this is a post after a long time. Recently I started learning Excel-VBA and I’ve created an Interactive dashboard in excel. I got the inspiration from here. It doesn’t have much use of VBA for that I’ll post tutorials.
I am also attaching the Excel file to reuse and interact with it.
On my previous post on Password Protected Dashboard I got so many queries regarding the procedure to create the same. The Process will be similar to the Toggle switch in Tableau. We’ll be learning how to make Password Protected dashboard in Tableau in just 3 steps, yes only 3 steps!