-
In one of my jobs, I’m responsible for the communication and scheduling of people into events. I was asked to prepare some bulking emails for a series of dates and various recipients. I wanted to make this process as easy on myself as possible, so I created a Google Sheet that would account for all…
-
Whilst considering ways to implement statistics and algorithms into my workplace tasks, I came across the idea of collusion. The definition of collusion is ‘secret or illegal cooperation or conspiracy in order to deceive others’, but I’m essentially looking for a way to detect if there’s been interference between 2 or more persons in regards…
-
After the last post, I realised how beneficial it might be to someone, somewhere on the internet, to have access to some of the lesson plans/units that I had created. The early days for me were spent looking over individual lessons, lesson plans, and unit plans. I was attempting to understand how they all connected…
-
When you teach at 0.8FTE, you could end up having around 16 contact hours in a week. Sounds great, right? Consider the planning that goes on outside of that. Sure, maybe in the afternoons or mornings, but also on the weekends. And holidays. If you’ve been doing it for a few years, you’ll have enough…
-
Today marks my 53rd blog and the one year anniversary of this blog! On the 7th July, 2023, I quit my job as a school teacher on the north east coast of Tasmania. It had been an extremely intense year and a half where I had spent so much time doing reflection as opposed to…
-
Homework Review It’s been two weeks since this post, but how did you go with the homework? Here is a link to the solutions, which I crafted, and the (shorted) implemented solution (below): https://docs.google.com/spreadsheets/d/1SMesfxuEwgVPPm3O8UJgaeQ4RtWNrkd39y2UEkgb9jc/edit#gid=1362202755 =SUBSTITUTE(SheetB!A1,“want”,“here”) =SUBSTITUTE(SUBSTITUTE(SheetB!A2,“here”,“guilty”),“alibi”,“guilty”) =SUM(SheetB!A5:A12) =AVERAGE(SheetB!A5:A12) =MEDIAN(SheetB!A5:A12) =IFERROR(VLOOKUP(A3,$A$2:$B2,2,0),“EMP”&MAX(RIGHT($B$2:B2,LEN($B$2:B2)-SEARCH(“p”,$B$2:B2))+1)) =REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(A1, “\d+”, “Y”), “e”, “x”),“[.’,]”, “p”) =IFERROR(ARRAYFORMULA({{1;2;3;4},{1;2;3;4}^2,{1;2;3;4}^(1/2),{1;2;3;4}/(RANDBETWEEN(0,4))}),“WHOOPSY!”) =QUERY(QUERY(‘FAQ7’!A2:I25,“SELECT Col2, Col4, Col5, Col6”,1),“SELECT Col1, Col2, Col3,…
-
This is the “final” instalment of the Data Analyst Roadmap. Honestly, this particular post has taken a lot of mental energy to create, but I will delve into that next week. For now, enjoy this ultimate roadmap post. Unlocking the Melody of Commerce: Exploring the Impact of Music on Financial and Psychological Dynamics https://docs.google.com/spreadsheets/d/1ZKZ3brAg-23wxU4UD5ZJy4t7O6qAl2eqZjZCvvl8gvQ/edit#gid=584651760 Caveat:…
-
I thought it would be a good idea to collate some Google Sheets Troubleshooting information. This guide includes some Frequently Asked Questions and some not so Frequently Asked Questions, but still interesting nonetheless. When I originally set out to make this post, I thought it would be a short and sweet entry into the log.…
-
In one of the jobs that I’m currently working, I was asked to run a training/Professional Learning session on Google Sheets. The not-for-profit organisation utilises the software in many different ways primarily for budgeting, but includes various accounting purposes and budget burndown tracking. Without understanding where the users Excel/Google Sheets literacy stood, I developed some…
-
Introduction The last post in this Data Analyst Roadmap series was regarding the use of Data Visualisation tools. Given that I have previously outlined how I have displayed understanding and analysis within statistics, SQL, Python, and data manipulation & visualisation, it is now time to use all of these tools and techniques in projects. This…
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