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 structures9 min read·Apr 29, 2024----
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…11 min read·Mar 10, 2024--1--1
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…11 min read·Dec 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…7 min read·Dec 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.6 min read·Nov 30, 2023--1--1
Igor PlotnikovinDev GeniusMage: Simplifying ETL Pipelines for Custom SolutionsUser-friendly, functional, block-based approach to building ETL pipelines without over-engineering6 min read·Nov 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.7 min read·Nov 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 database9 min read·Oct 26, 2023----
Igor PlotnikovHiring Programmers and Staying Within Budget: SQL Case StudyToday we are going to review one popular task that you might have faced or have yet to face when applying for the position of a data…6 min read·Sep 3, 2023----
Igor PlotnikovinMicrosoft Power BIStreamline Your Power BI Workflows with Version Control, Dataflows, and Deployment PipelinesIn the world of business intelligence, getting version control right has always been a big deal for Power BI users. In the past, trying to…7 min read·Aug 25, 2023--1--1