How to align or format numbers centrally in Microsoft Excel table–

Topbullets.comYou may have come across this problem while you were trying to align everything centrally, but numbers don’t go to center. All other formats like date, text and account can be centrally aligned but once you change them to numbers with comma style, the format goes out of toss. I remember one conversation between one of my colleagues and his manager about formatting. The manager wanted everything in the table centrally aligned and my colleague was trying to explain, it was impossible. Both tried all tricks and finally, the manager had to agree with him. Today, I found one hack which helps to overcome this challenge. Continue reading

How to Create Cascading Filters in R Shiny Dashboard by

Topbullets.comIn Data Science visualization is a powerful tool. You can’t sell a concept but a product. Data analytics is science but presenting them through different graphs and charts is an art. We have many ways to present the numbers and a lot of software which make our life easy. Few of them which I have tried are Tableau, R Shiny, D3, QlikView and VBA Dashboard. Every tool has its own advantages and properties. Currently, I am working on R Shiny dashboard which is so beautiful and easy to learn. I would really encourage you to learn R Shiny if you do coding in R. It has a lot of in-built packages which can easily be deployed. Today let’s work on cascading filters one of the most important kinds of filters. Every other filter is connected to the predecessor filter. Continue reading