This site under reconstruction.
I’m revisiting a project that had lots of data – so much that I could not work with it in Excel very well. I was forced to build up the formulas, file by file. I would build a column of formulas to do one thing and if it worked, save that file with the formula. Let’s…
After spending 4 or 5 weeks on developing ideas for a dashboard for an upcoming huge project, I finally have a rudimentary dashboard. With that experience behind me, here are some ideas of what to do when you are given a project to pull together something. 1. If you can, find out what the goal is. In my…
While I continue the roll out and training on the report automation project, I’m starting a new project. But before I start describing, in vague terms, my new project, I want to talk about something I learned about training on the report automation. A lot of the folks that I train are not familiar with computers…
Before I left on a retreat, I was playing around with Access and data model. Pivot tables have something called data model and I was playing around with it to see how it works. What I found was that it allows you to combine two tables, kind of like Access’ joining of tables and/or queries….
I’ve been working a bit with Access the last few months because I’m working with a set of data that is huge. Huge as in I originally had to break up the problem into separate Excel spreadsheets in order to arrive at a smaller data set. Once I got Access, it cut that problem out…
Even a HR specialist can be a data scientist! Okay, I read an article in LinkedIn/Pulse about an HR specialist spending the past year working with data to see if he could see any trends. I’m sure most data scientists would take offense at the HR person calling himself a data scientist – it is…
You must be logged in to post a comment.