When building a FastAPI project with PostgreSQL, you need a reliable way to manage your database schema over time. As your application evolves, simple table creation is not enough. You need a way to safely apply, track, and roll back changes.
Alembic provides a structured, version-controlled approach to database migrations. In this guide, weโll walk through how to set up Alembic with FastAPI, SQLModel, and PostgreSQL, including common issues youโll run into when working with Docker.
Learn how to use Amazon S3 manifests to safely reprocess millions of S3 objects at scale without data ambiguity or production incidents. As consultants, we operate in the realm of clients with mature systems. One of the most common places for those systems is AWS. Amazonโs S3 (Simple Storage Service) remains one of the most popular enterprise storage solutions. Letโs …
In today’s data-driven world, organizations have access to vast amounts of data, but how exactly do you interpret those millions of rows of data? This is where data visualization comes into play, transforming complex data sets into easily understandable visuals. Data visualization is, without a doubt, one of the most important aspects of Business Intelligence (BI).
In one of my previous blogs, I talked about BI and why it is important for a company to practice and implement this in their workspace. Now, in this blog series, we are going to dive deeper into a data visualization tool called Power BI.
Docker is a pretty magical tool that streamlines server and environment setup while helping to eliminate the operating system and software version variables. Itโs one of the best ways to mitigate the classic โWorks on my machine!โ obstacle many developers run into when sharing or promoting their code.
When a lot of people think of Docker, the last thing they think of is Microsoft or Windows. It took many years for Docker to even officially support Windows. As a .NET developer, I always wanted the stability that Docker offers, and today, I can have it. In the post below, Iโll dive into how to dockerize an MSSQL Server.
I’m sure you’ve come across the term “Business Intelligence” or “BI” in your workplace or on LinkedIn. It’s remarkable how many people are now embracing the advantages it offers for making better business decisions, making data more accessible and comprehensible, and much more.
One of the primary objectives of BI is to enable companies to make informed, data-driven decisions by following a multi-step process. This process encompasses data collection through ETL (Extract, Transform, Load), data analysis, data visualization, and the subsequent presentation of findings to key decision-makers within the organization. These tasks are accomplished using BI tools and various programming languages, which are employed to access and analyze extensive datasets. The results are then presented in reports that incorporate charts, graphs, maps, and key performance indicators (KPIs) for a detailed overview of the business’s performance.