Reflections on Paul Waldman’s “The death of the CIA Factbook and Trump’s war on usefulness​”

woman working in lab

As someone deeply interested in data and data systems, I’ve been thinking about how the Trump administration’s attacks on data, these collections of information that are critical to researchers and scientists. And how they’ve also been attacking science, research, and innovation.

This administration has been fighting a sweeping information war meant to distort and suppress facts, ideas, and history that doesn’t “align with the president’s agenda,”

I find this distressing and deplorable. It’s monumentally short-sighted. It’s cost is extreme. America can not maintain it’s lead in innovation and technology without this knowledge. Add this to the cuts to research funding and the US is decimating it’s future. Access to this knowledge is key to moving society forward, aka: innovating. In this case, we’re looking specifically at the CIA Factbook, an amazing tool I’ve used on many occasions as it’s extremely useful, which Mr. Waldman points out seems to be one of the criteria for deletion.

Besides the attack on data, the Administration’s efforts to cut funding to so much scientific research is additionally concerning. This is feeding a brain drain that’s further eroding our scientific and technical leadership. These will take decades to recover from. If we ever can. The global academic community seeks to leverage our short-sidedness.

There are some counterpoints that give me some hope. There are many organizations that are working to collect this knowledge for the Library of Alexandria is burned. Here are just a few (with descriptions provided by Gemini):

In addition to the efforts to retain the knowledge we’ve already collected, I’m also heartened by the rest of the world seeking to recruit our leading researchers, ensuring that their critical work continues.

An aside: I wonder if, at the macro level, this will benefit humanity. Disbursing talent might make science more diverse and richer. I hope it also make it more resilient to the manic moodswings of social opinions. Even if it’s a net benefit to society, though, this situation will have a painful, negative impact for years to come.

So, please, take a minute to read Paul Waldman’s article “The death of the CIA Factbook and Trump’s war on usefulness”. Then take a moment and look over the list above, and give what you can to help capture this knowledge.

Completed another Certificate: Harnessing the Power of Data with Power BI

close up photo of survey spreadsheet

I’ve been working lately on Coursera’s Microsoft Power BI Data Analyst certificate. I just completed the current course, Harnessing the Power of Data with Power BI. I find this valuable as I don’t know Power BI (BI = Business Intelligence) that well yet. I have extensive experience with Excel and Google Sheets. I studied database theory and design, SQL/MySQL, and created gobs of databases for my Web Development Degree. Power BI is a powerful tool that many organizations want/need for data analysts, which seems like a great fit for me at this juncture of my career. I’ve been working with Excel and the rest of Office for decades. I’ve worked with Oracle and SQL Server databases. I’ve built reports and dashboards. I’ve enjoyed this kind of work to the point of volunteering for it.

So, I’ve slowly been diving in and getting Power BI under my belt. It looks like a key piece for me to evolve into Data Analyst roles, for which I’m pretty excited. Again, it looks like a blend of my skills and interests. Even my current network and server admin work ties in, as databases often live on servers, and thus, networks are crucial.

Power BI

I’ve been adjusting my studies to focus on data. Right now, I’ve working on mastering Power BI, a Microsoft data analytics tool. Yesterday, as I’m finally starting to dive deep, I had a moment of sadness. I remember a role where this tool didn’t exist. I was cleaning up data from a multitude of sources, just me, Excel, and a wee bit of Visual Basic. And I had to tweak the process every month. The powerful tools in Power BI, and Power Query, would’ve been so helpful. I’m looking forward to what I can do with these modern tools.

Another Course Completed: System Administration and IT Infrstructure Services

close up photo of matrix background

I’m making my way through the Google IT Support Professional Certificate. I appreciate the refresher of many of my courses from pursuing my ATA in Web Application and Cloud Development. It may seem counterintuitive that I took two classes in CISCO Networking and one (of two) classes for the A+ certificate. But I saw value in them and did my best to fit them in.

And I’m getting to learn some new stuff, too. For instance, even though I’ve been managing Active Directory, I’ve not had the chance to dive deeply into things like Group Policies. And having an overview of data backups and disaster recovery was very insightful.

So, I have two more courses to go to finish this Certificate. I have a few different directions I can go once I finish this. The most obvious is to leverage my existing work in IT Administration and start exploring network administration. Another option, which builds more on my ATA is data systems (data analytics, database administration, that sort of thing). I do a fair amount of that right now, too. Less so in my work at the Edmonds Waterfront Center, but there’s quite a bit of alignment with what I’m doing at Trinity. I’ve been feeding a lot of ideas, my backgound, etc, into ChatGPT, and it’s recommending the data path. That seems good as I’m seeing things like “The outlook for network administrator jobs is mixed, with the U.S. Bureau of Labor Statistics (BLS) projecting a decline in employment by 3% from 2023 to 2033”. And then this “The U.S. Bureau of Labor Statistics (BLS) has projected substantial growth for occupations related to data analysis, with some categories seeing increases as high as 23% or more between 2023 and 2033.”

I’m trying to keep moving forward, to keep learning relevant skills. The world is changing so fast, one must work to keep up.

AI Impacts On Admin Work

woman in professional wear seated in front of monitor

I’ve heard a LOT about the expected impacts of AI on developers. When I was laid off right at the beginning of the pandemic, I opted to make a career pivot into Web Development, so I’ve paid attention to this trend closely. Add in all the lay-offs within the whole developer community, and this career, so recently highly lucrative, has become rather bleak. So much so that I’ve been looking backwards at returning to admin work (which is one of my two jobs right now). Now I see that admin work will be getting hit pretty hard by AI, too.

Earlier this week, I was on a Google Meet. With that, we used the built-in tool to create meeting notes. And, my God, it worked nicely! I was quite impressed. Now, as a long-time admin, taking and distributing meeting notes has been a significant part of my work. I’m confident that this will be done by AI going forward. And I expect that transition to be pretty quick.

Another key part of being an admin is scheduling travel. I expected AI to be able to coordinate travel pretty well. So, I did an experiment where I gave ChatGPT a very rough itinerary for a multi-stop business trip, asked it to recommend flights and hotels. It did a nice job with a few extra prompts. I had a pretty solid itinerary within 2 minutes. Impressive.

After just these two considerations, I am confident that AI will revolutionize Admin work significantly. With the job outlook for this work bleak (BLS projects a loss of 12,400 admin jobs between 2024 and 2034), and AI eroding the work, I expect it to become harder to find roles. (Yet it’s the main type of work I’m recruiters reach out to me for…go figure). It makes my decision to pivot to web development during the pandemic, and now shifting to data analysis seem that much more prudent.

Anyway, onwards!

Forward Motion

gray and black laptop computer

I haven’t written about this much, but my current career development focus is on Data Analysis. To start with, I like working in Excel. I’ve found spreadsheets fascinating since the days of Lotus 123. In addition, as many of you know, I spent the Pandemic working on a degree in Web Application and Cloud Development at Edmonds College. During that, I spent a huge amount of time studying data: databases, database construction, SQL, database theory and design. That was some of my favorite coursework.

Recently, I discovered the role of data analyst. It looks like a fantastic blend of these elements. And it’s a growing field, which says a LOT in today’s economic climate! This looks like a way I can make a solid contribution now, and have lots of room to grow. It seems a great blend of my past, my studies, and where I am right now, in order to grow into the future.

Digging a bit deeper, I see some key areas for growth in the short-term.

  • Data Visualization:
    • I have not worked with Tableau or Power BI…or any of the other visualization tools. I have created presentations where I manually built visualizations (yay PowerPoint!), mostly graphs, but a few times with PhotoShop. I’m really looking forward to diving in deeper to what I can do with Power BI (which is my next series of course work on Coursera).
  • Excel:
    • I’m a solid user of Excel, having it used it extensively in pretty much every role I’ve had in the past 20 or so years. Budgets, project tracking, dashboards, project feasibility, and operations analysis, I’ve done all of these in Excel. But there’s always room to grow! And it’s an evolving product, so even more to keep learning.
  • Statistics:
    • I have only a rudimentary understanding of statistics. I want to expand that greatly. I think I’ll take statistics at Edmonds College soon.

These are the short-term learnings I’m planning on feeding myself with. I also think that the WGU BS in Data Analytics looks really interesting. And having that Bachelors will be valuable, and that knowledge critical.

During my studies at Edmonds, we touched on big data, data lakes, data warehouses, as well as No SQL based stored data. This all looks fascinating to me.

So, I’ve launched into the Data Analytics studies with Coursera’s Microsoft Power BI Data Analyst Professional Certificate. I finished the first course yesterday, Preparing Data for Analysis with Microsoft Excel. It was solid review of my skills, which I appreciated. Now, I shift to Power BI, which will be new. I’m pretty excited for Power BI. And I’m excited at what my future holds.

I hope the same for you!

All Hail The Sysadmins!

ethernet cables plugged on a server rack

I’ve long loved the webcomic xkcd. This one drifted through my inbox and thought it worthy of all the sysadmins I know.

As far as my own sysadmin skills, I do hate running cables and (shudder) crimping connectors. As I only have one thumb, these evolutions are rather uncomfortable, and sometimes painful.

Anyway, sysadmin types out there, you have my respect and admiration! Keep that uptime high!

Looking Forward: Career Thoughts

close up photo of survey spreadsheet

I’m a bit behind on my 2025 planning. This “bug” I’ve been fighting has sapped away SO much energy. As I’m FINALLY feeling my energy return (at least more of it) this week, I’m starting to map out what my career direction and focus looks like in 2025 and forward.

Quick summary: I spent the pandemic working on a degree in Information Systems with its main focus on Web Development. In a weird twist of fate, I finished it right as the tech sector meltdown was hitting hardest. Competing with 500k+ tech workers has made the transition challenging. But I did land an IT role. Currently, I work 1/2 time as an IT/Systems Analyst for the Edmonds Waterfront Center, and 1/2 as a “tech savvy” Administrative Assistant. I feel like I’m straddling both my past and my future. My vision of my future, though, is to move full-time into IT/Information Systems. And that’s the plan I’m building.

However, that’s not a narrow enough focus. Within this umbrella is a huge array of roles. Network administrator, help desk analyst, web developer, systems analyst, information security, and data analyst….and there’s plenty more! First world problems, a plethora of riches….you know.

Anyway, focus, right?

After looking over my notes, exploring all the projects I’ve worked on the past few years, reviewed the classes I’ve taken, exploring what I’ve found the most fulfilling, most valuable, and even what I thought was the most fun, I have pretty much narrowed things down to what I’ll call “data systems”.

I’ve worked with data in many settings, and have spend many hours with Excel. And I like this stuff! While studying for my ATA, I got to work with a LOT of database systems and tools. Besides extensive projects in Access, I got to do a lot of work with SQL. Not just MySQL, but also SQL Server, and even a few variants of Oracle. I find this stuff endlessly fascinating. And I see that “data” is a huge growth area in our economy. Between data analytics, data security, data warehouses, and data lakes, there’s a huge need for people who both understand these systems and structures, but also, well, enjoy it! My experience with data is pretty extensive as well. From budget tracking for my teams at both Starbucks and Microsoft, creating dashboards for real estate teams, and tracking projects and feasibility for construction companies, I’ve done a lot.

Looking towards the future, I want to dive deeper into key skills. First, Data Visualization. I have studied design and worked extensively with PowerPoint. Power BI and Tableau are a logical next step. Thus, I’ve started the Microsoft Power BI Data Analyst course on Coursera. I also want to build my skills in Python/R and Statistics. Perhaps via the IBM Data Analyst Cert or Google’s Data Analytics Cert. I’ll evaluate that as I move forward.

As I was cementing my data plan, a YouTuber that I value, Network Chuck, posted a video with a “Hacker” career roadmap (really, network engineering/cybersecurity). It sounded so cool! But, as much as it sounds awesome, I need to accept I’ve made my roadmap and need to move forward with it.

I recognize the place of privilege I’m in, where I have all these options that I struggle to choose amongst. For that, I’m grateful.

So, I know some of you have experience in this area. I’d love your thoughts on my framework/vision (I’m still turning it into a plan). And if you have any advice, I’d deeply appreciate your thoughts.

Animated Navigation Bar: 50 Projects in 50 Days

person encoding in laptop

Today we created an animated navigation bar with (mostly) CSS. I easily see a use case for this one, which makes it that much more fun.

You click on the “x” or the double line (depending on the view you’re in) to change the animation.


Besides growing my developer skills, I’m considering what work I should/could do in the near term. It’s going to be a bit before I feel ready to do coding interviews, much feel ready to jump into a production environment. But that’s not the only thing I can do with all that I’ve learned over the past few years.

My studies have covered a pretty broad swath of technology. Besides the keys to web development (HTML, CSS, and JavaScript), we also looked at JQuery and PHP. Stretching beyond the rudiments, we went pretty deep into databases (theory as well as design), system analysis and design, and project management (amongst other things). Also, I added some courses in Cisco Networking (the internet is a network, right?), desktop support (one more class then I will have a certificate in desktop support), and system architecture. Combining this with my pre-ATA career, I think this sets me up to be a great system analyst. I understand the technical side of things, and what business leaders want/need. I will do an excellent job bridging the gap between “business” and IT. Thus, I’m leaning that way in my job search.

What do you think? Any guidance you have to offer me as I transition? I’d love to hear your thoughts.