The Institute of Management Accountants has a new podcast called “Count me In.” The bi-weekly podcast covers the latest developments in the fields of accounting and finance.
Topics thus far include blockchain, business innovation, data analytics and much more.
https://podcast.imanet.org/ to subscribe.
Data analytics is changing many areas of accounting. One area that it will have a dramatic effect is financial planning and analysis.
The following chart shows some of the differences.
Strategic Finance July 1, 2019
For a more complete review of the changes, go to:
Can their be a downside? When electric cars are running, they are virtually silent. This poses a danger to those that may be visually impaired, shorter, or even those that are distracted.
The European Union has proposed that these cars be fitted with an Acoustic Vehicle Alert System that will vary the noise with the speed of the vehicle.
To read more about this feature, go to:
Your colleague just handed you a complex spreadsheet for you to maintain. The first thing you need to know is which cells contain formulas.
The easiest way to display all formulas is to press CTRL + ~ (tilde).
The tilde is on the key to the left of ‘1’.
Display Formulas – CTRL + ~
If you have been following this site, you already know what Big Data Analytics are. Here is a great, short video to help explain to your friends.
Harvard Business Review named the data scientist the sexiest job of the 21st century. This job requires significant computing and statistical skills.
With the rise of analytics and artificial intelligence, these skills are needed, but even more critical are individuals that have excellent business acumen.
These individuals can fill the role of translator. Not in the traditional language sense, but translate business requirements for the technical individuals.
” translators play a critical role in bridging the technical expertise of data engineers and data scientists with the operational expertise of marketing, supply chain, manufacturing, risk, and other frontline managers. In their role, translators help ensure that the deep insights generated through sophisticated analytics translate into impact at scale in an organization. “
For more on these roles, see the article at:
You have perfected your data analysis with a pivot table and you are about to share with other users. Slicers make Pivot Tables easier for other users to filter data in the table.
Slicers are a pop-up dialog box which allow the user to click on button to quickly filter the data.
Click in your Pivot Table. From the Pivot Table Tools > Analyze toolbar, Click Insert Slicer. Select the fields to provide a filter.
4. To filter select the value on the slicer dialog box.
Slicers with Pivot Table
To select multiple values, click on the Multi-Select icon then click on the desired values. To clear the filter, select the Clear Filter icon with the red x to display all values.
Imagine — the busiest shopping day of the week and all of the systems to checkout customers are shutdown. Imagine you are one of the largest retailers nationwide.
Target Corporations experience an outage on Saturday of all stores nationwide due to a software outage. It seems the software outage was caused by routine maintenance — which obviously failed.
More from the
Wall Street Journal at https://www.wsj.com/articles/target-stores-suffer-nationwide-outage-11560627812
Adobe and UC Berkley researchers are using machine learning to review photos to determine if a face in the picture has been changed using Photoshop.
For the full story, go to
As businesses move to more AI-generated modeling and higher forms of data analytics, we still need to apply common sense? In other words, don’t blindly trust the data.
Image by Gerd Altmann from Pixabay
This articles describes some of the pitfalls of not critically analyzing data output and gives some solutions.