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.

Oh, Spreadsheets!

statistics survey sheet

It pains me to see someone fill in data in a spreadsheet, then use a calculator to compute everything. It adds discomfort when the math errors are what first catch your eye. I hope I didn’t upset the originator by adding my =sum functions.

Anyway, I hope your Friday is fantastic and your weekend is wonderful.

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.

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!

Another Certificate Earned: Agile Project Management

eyeglasses resting on laptop keyboard close up

I’ve been busy the past few weeks. Today I completed the second-to-last course for the Google Project Management certificate: Agile Project Management. The purpose of this series is to help tie together my years of admin work with my passion for technology. I now just need to finish my capstone project. After that, I will work on the Power BI Certificate.

I’m currently seeking to leverage the disparate parts of my career (the years of admin work, studies of web development, data systems, databases, SQL, my weird love of Excel, and my project management work into a hybrid role that leverages my strengths in organization, communication, and data analysis to facilitate seamless technical operations and enhance digital strategies.

Using Google’s Gemini, I am building plans for this work. I have a solid short-term plan in place, and am working on the medium and long-term parts. I’m pretty pleased with what’s been pulled together. I find it a nice use of AI. It can aggregate and summarize research that would take me hours (at best) or days to do.

I’ve also done some re-design on my website as part of the plan. It’s a key part of my communications and marketing. (Side note: I’m not sure I like this new theme, but I’ll give it a bit and see if it grows on me). I have a fair amount of work to do, so I’ll be tackling this in waves.

Thanks for reading all the way through. I have more to talk about with this journey, so subscribe to stay in touch. Most importantly, I appreciate each and every one of you!

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!

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.

Microsoft Security Issue

woman in black hoodie holding a bank card

Over the past few days, I’ve been receiving multiple emails from Microsoft’s Account Team with single-use codes. At first, I assumed that my son or wife was trying to access the account. And the folks at Microsoft added the text “If you didn’t request this code, you can safely ignore this email. Someone else might have typed your email address by mistake.” But I started to get concerned as the number of these messages increased and no one said “hey dad, I can’t get in the Office”. Finally, I decided it was time to figure out what was going on.

So, I first logged into my Microsoft account (account.microsoft.com) and went to the security panel. From there I opened “View My Activity”.

What I saw alarmed me. There multiple attempts to log in from places like Vietnam and Guyana.

Now, I was pretty confident in my account’s security. I update my password regularly and use a strong password. And when I looked at the “session activity” it states that “incorrect password entered”. Which seems pretty solid. I’m pretty sure that an old password has been leaked from a data breach and is in some list available on the dark web.

But I think it’s not adequate. Exploring further, I realize that I had not yet enabled two-factor authentication, nor connected it to my authentication app. So, I fixed that promptly. I firmly believe everyone really should do these steps for all their account. Do you know where to do that? I thought I’d help out by adding the steps.

One enables that from the Advanced security panel.

I encourage all of you to make sure your security settings are using the most up-to-date protocols:

  • Multifactor authenication
  • Authentication Apps
  • Pass Keys

Also, I opted to sign out of EVERY app. Yeah, it’s a bit of a pain, but I don’t want to have my information compromised. I like that I can do that from the control panel.

Anyway, we really can’t be too safe on today’s internet, can’t we?

Have you seen a spike in Microsoft Single Use Code emails that are not from you? Let me know in the comments.

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.