-
Want to see something that I saw recently that freaked me out? Whilst doing my routine checks, I came across this bad boy. I confirmed that my NETGEAR ReadyNAS 316 6-Bay is at its end-of-life, https://www.netguardstore.com.au/Netgear-EOL.asp. I thought ahead to what potentials this could mean for the data that I have been collecting since 2008.…
-
Throughout university, I came across various concepts, but didn’t fully understand how I could implement them into real-world situations. Over those years in my Economics and Commerce degrees, it always felt like I was chasing the understanding as it had been a few years since leaving high school and I hadn’t thought about particular concepts,…
-
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 Default currency =IF(AND($B2>$D$2,$C2=”Tulsa”),1,0) Referencing other sheets =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) Remove duplicates List of Unique IDs =IFERROR(VLOOKUP(A3,$A$2:$B2,2,0),“EMP”&MAX(RIGHT($B$2:B2,LEN($B$2:B2)-SEARCH(“p”,$B$2:B2))+1)) Multiple dependent dropdown…
-
Learn the fundamentals of Statistics Learn SQL Learn Python for Data Analysis Learn Data Manipulation and Visualisation Learn Statistical Analysis Learn Data Visualisation Tools Work on Projects Learn Data Storytelling 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…
-
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.…
James Miller CV
Data Analyst | Process Improvement | Skilled in Statistical Analysis, Data Visualisation, and Instructional Delivery | Excel, Google Sheets, SQL, Python, Power BI
Blog
Leave a Reply