Let’s explore some features of PowerBI and its impressive visual outputs. Not only can we generate reports that are visually appealing, meaningful, but they are dynamic, fully interactive, thereby fully engaging our audience. Dataset details: The dataset is retrieved from Microsoft’s free repository of datasets (aka marketplace) that are real-world data but anonymized. This can […]
Blog
Behind every goal, there’s science. Anatomy of a goal (part1)
With the World Cup, Copa America underway, obviously I try to catch some games and follow the scores on matches I missed. The other day I noticed a chart on BBC site that showed charts with points plotted on a field where the ball had traveled on a particular game. This got me thinking, how […]
Wading through Billions of $$$!
Welcome to this post. Today, I want to share my process of retrieving some Mega Million Lottery winning data, curating them, and analyzing them to tell a story. The results may or may not make us super-rich 🙂 but I certainly had fun throughout the process. Disclaimer: I used Excel, but this is not a […]
World’s Oldest Cat Is 31! So, what do you as an analyst?
Did you know the world’s oldest living cat is now 31 years old? My first thought was: “that’s old alright! But how does it translate to human age? Must be really old.” Turns out, yes it is. Although it’s not that straight forward as many of us learned in the past, but not too difficult […]
Risks & Odds: Matter of Life or Death (Analytics)
Risks & Odds ratios are heavily used in medical fields mainly to track survivability of patients or effectiveness of some treatment on patients. You’re not a surgeon, nor a doctor. But you’re in charge to deliver information that’ll be used to determine the future of all patients! (e.g. Whether to administer a particular treatment, to […]
Analysis of Wine Data (analytics)
You’re given a massive list of data about wines around the world, their prices (a huge range from $4 to $3300 per bottle!), expert tasters’ scores, who scored them, how many scored them, name of the wine, description of the win, their origins including country, province, region, subregion, their variety or category, just to name […]
The Dictionary Challenge-Part 2
This is a continuation of the Dictionary Challenge previously completed. To follow along, you should read that post here. So, we have already downloaded a free Webster dictionary but completely unformatted and unstructured. So, we created a new file in a more structured way that our program can process. The code is in the previous […]
The Dictionary Challenge-Part 1
Ok, today I’m inflicting a self-imposed challenge…here it is: Get an English dictionary. Then find how many words start with vowels. How many words are there starting with “odd” letters, which I’ll set as: Z, Q, J. Then find the longest word in that dictionary. (Say, we’re going to make a word guessing game) All […]
Burger-Economy Charting! (Excel)
Welcome back! Just saw the latest released data on Big Mac prices world-wide, and the articles showing some simple histograms—and some of them even slapped on a cheesey (pun intended) burger animation to make their hohum horizontal bar charts appear to be more eye-catching. Well, today I’ll show you how to use the same data […]
Let’s Roll! — 2 dice…and find the probability and chart it (Python)
What numbers will you get if you roll 2 dice? How about we find out by writing a program? Can we then chart the results over as many rolls as we want? And then interactively play with the chart? Asking a lot! But yes, I will do ALL of the above here. Better yet, why […]