We all know I love coffee. This year, I would like to learn about my tea preferences. Unlike my coffee options; wherein I can use an outside source to help me find my preferred coffee bean styles - tea is more varied. I decided to take part in a Twinings Tea Adventure which encouraged me to track my reviews. Because the review spreadsheet is in Microsoft Excel, I am expanding … [Read more...] about Review Tracking with Excel Power Query
analytics
NPPES Exploration
I was introduced to the NPPES database last week and decided to carry the NPPES Exploration into the weekend. The dataset is quite large and it's definitely another box of woe. For those interested, the dataset can be found at the following web address: https://nppes.cms.hhs.gov. It is over 7 gigabytes and refused to open. Since I was having such difficulty … [Read more...] about NPPES Exploration
Enquiring Penguins Using Qlik Sense
I had a lot of fun at the OCRUG Hackathon this weekend. Saturday night we took a break from our team presentation building to get to know each other a little while doing what we love - working with data. We were randomly assigned to teams for each of four questions. Using the tools of our choice, each team was given five minutes to make use of this penguins dataset to answer … [Read more...] about Enquiring Penguins Using Qlik Sense
Analysis on USA Spending
I've been doing a little investigating for a company who has an interest in providing services with regards to government funding for small businesses. They have a motivating mission, which drove me to spend a little bit of time on the USA Spending website and get to know the API. All of a sudden, I stumble across this report on USASpending.gov: This immediately reminded … [Read more...] about Analysis on USA Spending