-
In a previous post, I was considering how people might be using AI to solve their problems, or potentially create interesting & efficient solutions that they were unable to develop within a particular timespan. With Ai easily within reach of those who understand how to engage with it, I believe that there is the internal
-
Impetus Well, that whole foreshadowing thing happened a lot quicker than I thought. When I attempted to kick up https://app.plex.tv/web/app# and was greeted with a server error, an initial wave of fear flew through me. I opened the NAS’s GUI and was presented with the following error: Opening the error up, I got to see
-
This blog is all about the long-game. In July, I created this ARMA model to best predict portions of the stock market. I have nothing invested and I was just curious as to the best way to integrate some knowledge I drilled at university. It just so happens that I can learn some coding skills
-
Homework Review How did you go with those 6 tasks from last week’s blog? Here are the solutions that I came up with for those tasks: Task 1: Create a Pivot Table to summarise total sales by region and income level: Task 2: Create a Pivot Table to filter sales data by gender and drill
-
A while ago, a friend of mine asked, “Why should we even use Pivot Tables?” This question was more than just a curiosity; it was an opportunity to transform how they interacted with data. Pivot Tables and Pivot Charts in Google Sheets do wonders for your data by turning seemingly chaotic fragments of data into
-
Excel and Google Sheets are fun. However, if you don’t possess a lot of logic around it, they can be quite daunting. Knowing where all of the aesthetic functions are. What they mean. How you can use them. The moment you figure out that you should be separating out your data types into different cells
-
I’m a natural problem solver. Sometimes though I can spend a fair bit of time mulling over the problem before acting on different approaches to take when attempting to solve it. One thing that I have been working on is acting on the problem fairly soon and iterating through various approaches. Ironically, I’m also attempting
-
Personally, I love this kind of post. I love the idea of cognitive restructuring. There’s something about understanding how your brain works and learning how to unlearn. When I went to university for the second time, I went to sit through a university degree where I had to unlearn a bunch of concepts that took
-
Premise A few months back, a friend contacted me with an interesting Excel question. They were responsible for maintaining qualitative approaches to the physical maintenance of equipment used by university students. They were asked to develop reports of each equipment box that was lent out and provide quantitative feedback for their qualitative metrics. They had
-
In the world of data analysis and spreadsheet management, the ability to simplify and streamline complex formulas is invaluable. This is where the LET function in Google Sheets comes into play. While many may associate LET with Microsoft Excel, it’s a concept that has been prevalent in programming languages like Python and BASIC for quite
James Miller CV
Emerging Data Analyst and Lifelong Learner | Skilled in Statistical Analysis, Data Visualisation, and Instructional Delivery | Excel, Google Sheets, SQL, Python, Power BI
Blog
James Miller CV 
Leave a comment