Author: jamesmillermusic
-
46 – Autoregressive Moving Average Models
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…
-
45 – 6/8 Learn Data Visualization Tools
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…
-
44 – Optimisation 7: Excel’s Solver II
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…
-
43 – How to use Google Sheets Charts
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…
-
42 – 5/8 Learn Statistical Analysis
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…
James Miller CV 