Learning to create a Speedometer Dial in MS Excel

One can learn to create a remarkable workable speedometer (also called as a speedo) chart, which will be equipped with a fully functional moving needle. It will be created with the use of a combination of doughnut and pie charts. We will also add an additional touch, which will be an exciting control panel for the speedometer with a scrollbar.

There are several charts available with MS Excel’s Chart Wizard that offers everything other than a quirky speedometer chart. With a proper speedometer chart, we can display data in a very slick way. We have mentioned a few nifty hacks and tricks in this section, with which one can create both a speedometer chart as well as a scrollbar right from the control toolbox bar which will also allow us to change the data entered into the worksheet simultaneously.

Read More

Impact of Big Data Analytics In Bridging India's Tax Gap!

India's performance on the 'Tax Revenue as a % of GDP' parameter is by far the lowest within the BRICS economies.Estimates peg the effective taxpayers in India to be less than 4-5% of its population.

• The current government has shown emphasised focus on increasing tax base and tackling black money through policy interventions like demonetisation, GST, tax agreements, Benami Property Act, etc.
• These initiatives will allow the revenue departments to develop a data supply chain that will capture and store data at an unprecedented scale, and speed. This data can be supplemented with data generated through digital transactions, JAM (Jan Dhan, Aadhaar & Mobile) trinity, and data from other digital platforms.

Read More