-
Answer from last year’s blog What IF We Did Something Else? A post at the end of last year, I created some images that outline the IF process. When you’re using an IF function for something simple, like looking for a ‘Yes’ or ‘No, ‘1’ or ‘0’, or ‘Pass’ or ‘Fail’, then it can be…
-
Well, the time has come. I have been asked to join the Teach for Australia (TFA) team as an Admissions & Placement Officer. This means that I will be assessing potential candidates for the TFA program and assisting their journey through resolving educational inequity. Since it is the start of a new year (2024) and…
-
I wanted to leave a brief message of gratitude for the year. Many people have been involved with my growth over the past few years, for various reasons, but I have to credit them as well as myself for that growth. I take the time throughout the year to consider those around me, but also…
-
Answer from last week’s blog: How did you go with last week’s blog? Could you figure it out? Could you make it more efficient than my answer? =FILTER(UNIQUE(H5:H),UNIQUE(H5:H)<>“”,UNIQUE(H5:H)<>“Character”,UNIQUE(H5:H)<>“Main Characters”)Link to the Google Sheet here: 23 – Having Issues Finding Peoples’ Names? What IF? This is a fun question. What if we reduced the price on that…
-
In a previous post, I had to anonymise some names before posting. During that process, I realised that it was the perfect opportunity to show how I performed this task at the moment’s notice. Here’s the spreadsheet if you want to follow along: This is an example of the original dataset (with the original names…
-
Source: https://www.digitalgolf.ca/ I was engaged in a Freelance Data Analysis job where I was asked to assess some time-bound golfing information. The person was interested in discovering time metrics and then inferring potential golfing group times. During a phone call that I had, they were able to give me some basic information about the sport…
-
Solution from Last Week’s Problem Given what you learned from the blog last week, were you able to solve the problem using the matrix method? Adalia and James shopped at the same store. Adalia bought 5 kg of apples and 2 kg of bananas and paid altogether $22. James bought 4 kg of apples and…
-
Welcome to the third instalment of the optimisation series. If you want to play catch up, here are the first and second instalments. After studying matrices at university, I realised that I didn’t understand them. A lot of increased myelination (allowing for the rapid transmission of neural information along neural fibres; increasing one’s ability to…
-
The summary from last week’s post is that I was preparing to build a Data Analysis Pipeline. This was the macro plan that the project was being planned around. I’m going to use this plan as a way to outline this blog. Finalised Dashboard https://lookerstudio.google.com/s/gJ2pMR8EdWY Gathering all of the Necessary Information Data Whilst thinking about…
-
Thinking about previous experiences within data analysis, project management, and comparing what is available in my portfolio, I thought I’d take this opportunity to plan out another project to display. Specifically, this plan is about translating raw data into meaningful information for intended stakeholders to make decisions on. Having lived in a rural area for…
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