Upon the enlightening release of the Cambridge Analytica exposé that revealed the company's underhanded tactics it utilises to influence and manipulate people with a combination of data analytics, espionage, and 'honeypotting', I think it's incredibly important to discuss how the analytical community needs to ensure a commitment to honest and unbiased analytics, and ethically sourced … Continue reading Analytics and Ethics
How To… Excel: Create a Dynamic Data Range for a Chart
Continuing the theme of automatically updating charts, we’re going to look at how to make a chart deal with a dynamically changing data range. This is useful for situations where you have multiple measures that each have a different number of independent variables (the variables plotted on our x-axis, which was the month of the … Continue reading How To… Excel: Create a Dynamic Data Range for a Chart
HOW TO… Excel: Create an Automatically Updating Chart
Following on from our last series of HOW TO... Excel, we're going to expand the concepts used to create the dynamic data table and create another sheet for the same workbook that will be the home of an automatically updating chart! Unlike pivot charts, this will be able to update as soon as new data … Continue reading HOW TO… Excel: Create an Automatically Updating Chart
Florida Ticket Price Comparisons
I’m going on holiday soon! I’m headed to Florida with my parents and being the cost savvy Brits that we are we’re always on the hunt for a bargain. We wanted to go do some of the Theme Parks (we settled on Disney and/or Universal Studios) and went about finding the cheapest ticket rates we … Continue reading Florida Ticket Price Comparisons
Nintendo Console Dashboard Update
Using Linked Pictures to update my Nintendo Console Dashboard.
Game Dev: Balancing Adventurer Guild Simulator
For the past 2 weeks I’ve been working on developing a game in my spare time: it’s tentatively titled ‘Adventurer Guild Simulator’, as it’s about running an adventurer guild in a fantasy setting (think Dungeons and Dragons). In the game you’ll be hiring adventurers to go on quests to raise the reputation of the guild … Continue reading Game Dev: Balancing Adventurer Guild Simulator
Nintendo Console Dashboard
If it weren't apparent enough from my Splatoon 2 analyses, I love Nintendo. So, of all the things one can make a Dashboard about, of course I went ahead and created a Dashboard using data about Nintendo's array of home consoles. https://gfycat.com/BigheartedGrimyInexpectatumpleco This was done using Excel - but I'm really interested in working on … Continue reading Nintendo Console Dashboard
HOW TO… Excel: A Truly Non-Volatile Solution for Dynamic Data Tables
This is a follow-up to the last tutorial. Thanks to reddit user /u/small_trunks for noticing my blunder! Unfortunately, 'SUMIFS' couldn't be used on its own to create the dynamic data tables. But don't fret! I have another solution up my sleeve that doesn't rely on volatile functions like 'INDIRECT' and 'OFFSET'! It relies entirely on … Continue reading HOW TO… Excel: A Truly Non-Volatile Solution for Dynamic Data Tables
HOW TO… Excel: Using SUMIFS to Create a Dynamic Data Table
This is a continuation of the previous tutorial. Due to the volatility of the INDIRECT function, it may be necessary to avoid using it when trying to create large dashboards which will be handling and outputting large amounts of data. So, we’ll need an alternative in these cases. One of the ways this can be … Continue reading HOW TO… Excel: Using SUMIFS to Create a Dynamic Data Table
HOW TO… Excel: Create a Dynamic Data Table Using INDIRECT and Combo Boxes
Creating a full and cohesive user experience in an Excel based dashboard can be really difficult if you don't know where to start. Often, the easiest way to approach the situation will be to utilise Pivot Tables and Pivot Charts, which come with useful tools like slicers to dynamically filter the data with a touch … Continue reading HOW TO… Excel: Create a Dynamic Data Table Using INDIRECT and Combo Boxes
