Tag: data analysis

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

Carl Setzer
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

Carl Setzer4 Comments

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

Carl Setzer1 Comment
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!

The Business of Data

Carl Setzer

This quarter I’ve heavily focused on data. Of my three classes, one is on SQL and another is focused on database theory and design. As part of the theory and design class, I’ve been thinking a bit about Business Intelligence (BI) systems.

What are BI systems?

Business Intelligence Systems are tools that enable management (and other people) to analyze business activities. This includes past and current activities. Additionally, these tools are extremely valuable in predicting future behavior. They enable organizations to assess their effectiveness, strategize and plan for the future, as well as control various elements of the business. Ultimately, their function is to assist and guide decision-making. 

How do BI systems differ from transaction processing systems?

Transaction processing systems, aka: operational systems, facilitate and monitor primary business operations such as sales, purchasing, and inventory control. They are involved in the ongoing stream of daily business operations. Operational systems are, generally, the core program of the business. 

Business Intelligence Systems focus on management’s decision-making and analysis needs. Often, BI systems are disconnected from operational databases. BI systems pull their data from three possible sources:

  1. From the data within the operational database. However, they do not modify, insert or delete the operational data. It’s critical that analytics remain separate from the operational system. 
  2. From data that have been extracted from the operational system. This database might be completely different from the operational, including being a different DBMS, or even a non-database tool like Excel.
  3. BI systems can also analyze data purchased from third-party data vendors. 

I am finding data systems to be incredibly fascinating. Though it is one of the “areas of the future”, that’s not the whole thing. I see how valuable data is to, well, everyone. There are so many ways to benefit any organization and so many ways to misuse it.