Igor PlotnikovinMicrosoft Power BIEnding the Nightmare of Power BI Versioning: View Only The Changes You Actually MadePower BI made versioning possible in a way that lost its original purpose — easy version tracking and change management. Today we’ll fix…Sep 17Sep 17
Igor PlotnikovinDev GeniusAsyncio Made Easy: Quick Dive Into Asynchronous Programming In PythonYou will learn how to write asynchronous code that is efficient and easy to understand, with a focus on making API requestsJun 28Jun 28
Igor PlotnikovinLearning SQLUnderstanding Recursive SQL for Hierarchical Data StructuresIn this article, we will explore the usage of recursive queries in PostgreSQL to work with data organized in tree-like structuresApr 29Apr 29
Igor PlotnikovinData Engineer ThingsBuilding a BI Stack for a Startup: Insights and Lessons LearnedImagine that you’ve joined a startup as its first and only BI developer, with the primary responsibility of implementing customer…Mar 101Mar 101
Igor PlotnikovinDev GeniusHow I Built a Data Application for Tariff Management at Tele2 Using StreamlitBack in 2020, when I worked for Tele2 as a product reporting analyst, I watched our Product Lifecycle Management Team struggle every time…Dec 29, 2023Dec 29, 2023
Igor PlotnikovinDev GeniusWhy Generate Your Own API Client Library and How Simple Is It to Do?Consider a scenario where a business wants to integrate a third-party service or platform into its existing infrastructure. Let’s say a…Dec 6, 2023Dec 6, 2023
Igor PlotnikovinMicrosoft Power BIShould You Reconsider Your Approach to Time Conversion in Power BI?Handling timezones in Power BI as well as any other BI tool is crucial for accurate reporting and analysis across different regions.Nov 30, 20231Nov 30, 20231
Igor PlotnikovinDev GeniusMage: Simplifying ETL Pipelines for Custom SolutionsUser-friendly, functional, block-based approach to building ETL pipelines without over-engineeringNov 23, 2023Nov 23, 2023
Igor PlotnikovinLearning SQLThree Absolutely Different Approaches to the Same Task: Register Shifts SQL Case StudyWe’ll compare the efficiency and performance of these strategies and try to find out which approach works best.Nov 8, 2023Nov 8, 2023
Igor PlotnikovinDev GeniusTake Your Data Task Logging in Python to the Next Level with sqlite-utilsIn this article, we’re going to dive into the why and how of effective logging for your custom Python scripts using SQLite databaseOct 26, 2023Oct 26, 2023