Lately, I have been incorporating more visualizations into the validation and testing phases of analytic development. Most recently, I was working on an analytic to identify GL accounts that are being smoothed. We want to identify when accountants are inappropriately reducing the volatility of an account, presumably because they do not want to explain variances … Continue reading Updating PowerBI through a single connection
Like most of you, in my career up to this point I have focused on analytics and analytic techniques common to the audit world. Analysis of financial and operational controls is the mainstay of our work and where we spend most of our time. We look at data elements such as journal entries, purchase orders, … Continue reading Where in the world?
Unless you have been under a rock for the past few days, you have probably heard about United Airline's PR disaster. A paying customer was injured during his forced removal from a flight and videos and images of his bloodied face have gone viral all over the world. It has not helped that the passenger … Continue reading The Risk of Compliance
I call myself a data analyst. My company also calls me a data analyst. But for some time now I have had a nagging feeling of unworthiness of this title because I don't do data analyst things such as regressions and machine learning. In fact, I really don't touch anything resembling statistics in my analytical … Continue reading The Meaning of Life, the Universe, and Internal Control Statistical Models
I apologize for the delay to my monthly postings. January was a busy month and I needed a break to focus on work and home. I had hoped my first post regarding Unicode would also be my last. Unicode and its many flavors tends to be a distracting annoyance while developing analytics. Our applications usually … Continue reading À Does Not Equal À, A Unicode Story
I got a call from the 1990s a few months ago asking for their font back. I declined and explained that just because something is old, does not mean it cannot still be good. Sometimes, things created long ago have a unique value that endears them to be used even today. Not everything has a … Continue reading Courier of Information