-
In a previous post, I outlined how someone might be able to track their stock portfolio. Speaking of, have you copied this version? Have you made your own? I would love to see what you’ve done – link it in the comments below! How does one get to the point of tracking their stocks though?…
-
If I asked you what the price of a pencil is today, what would you say? What if I asked you what the price of a pencil is today knowing that it was $1.05 yesterday – what is the price of the pencil today? What about if it was $1.05 two days ago and $1.05…
-
In the ongoing Data Analyst Roadmap series, we’ve navigated through pivotal terrains like statistics, SQL, Python for data analysis, data manipulation, and statistical analysis. Now, entering the sixth phase, we’re delving into the area of data visualisation tools. Within the data analyst’s toolkit, the art of conveying insights is just as critical as the analytical…
-
In a previous post, I outlined how you can use the ‘Solver’ add-in to optimise decision on profit based on a single-item revenue and cost structure, and the optimal mix of inputs for six products to maximise profit. Whilst hearing about one of my bosses discussing allocating people into groups recently, I was reminded about…
-
Homework Review How did you go with those 3 exercises from 2 weeks ago? Here is the link to the blog solutions: https://docs.google.com/spreadsheets/d/12HzdwkqLbfFiwKOtYpnBTnOVRZdp3aDruJAwEhso8eE/edit#gid=222398939 Google Sheets Charts Diving into the world of making charts in Google Sheets allows me to transform all of those numbers and words into something that can be easily understood and a…
-
Statistical analysis stands as a cornerstone in the journey of data analysis, serving as a pivotal force in extracting meaningful insights and aiding informed decision-making. Positioned as the quantitative backbone, it empowers analysts and data scientists to derive reliable predictions and conclusions. This type of analysis furnishes the necessary tools for describing and summarising data.…
-
How often do people respond to your emails? How often do they open it? How often do they delete your emails before even opening it? Something that a marketing analyst aims to do is optimise their email campaigns. Something that would be beneficial for them is knowing the probability of a customer actually engaging with…
-
There are a few approaches that I take to making these posts. Some data I will use from an online source (and reference), whereas others I will generate using equations. Since privately tutoring some local young people, I have had the pleasure (actually not sarcasm) of revisiting geometry. This meant that I had to relearn…
-
As an extension from last week, this week is showing how we can take one language (VBA) and translate/transform it to another (JavaScript). We’re taking it from the native Microsoft Excel and putting it into the Google Sheets cloud. https://docs.google.com/spreadsheets/d/14yweiJQAF9tef1J2c0a4Bj8viCOQgqkwUHx8GezdQr8/edit#gid=0 Fahrenheit to Celsius Converter First, let’s start by opening up a new Google Sheet: Next,…
-
So. It’s come to this. You have developed so many formulas that you’re sick of having to use the same combination over and over again to give you the same outcome for different datasets. Did you know that you can make your own custom formulas in Excel? I’m sure that this is what people would…
James Miller CV
Data Analyst | Process Improvement | Skilled in Statistical Analysis, Data Visualisation, and Instructional Delivery | Excel, Google Sheets, SQL, Python, Power BI
Blog
James Miller CV 
Leave a comment