A while back I was introduced to the concept of test-driven development by my brother-in-law. Test driven development means writing tests for your code before you actually write the code. Once you have written a test that fails, you then write the code needed to cause the test to pass. By writing tests first, you … Continue reading Is my code still working?
By my reckoning, my last blog post was in July, which means I have now missed 2 monthly posts. I apologize for that. Since July I have made the huge decision to accept employment with a new company and move myself and my family from Wisconsin to North Carolina. Now that the move is completed … Continue reading Please don’t make me read your code
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