Ksenia UdovitskaiaMastering Loops in Python: Automate Your Code with Efficiency and EaseAs an IT specialist, you can encounter situations where you must reuse a piece of code multiple times. For instance, when automating the…4 min read·Jul 2, 2023----
Ksenia UdovitskaiaSQL queries you must know (with examples) — PART 3Previously I published two parts in the series of SQL queries you must now. This tutorial will provide 14 solutions to basic and…6 min read·Apr 10, 2023--1--1
Ksenia UdovitskaiaDesign a Motorbike producer Database — Example ER diagram + SQL codeThis database is design as a brief representation of the connections in a database system for a motorbike producer. We assume here that a…3 min read·Apr 9, 2023----
Ksenia UdovitskaiaWhat’s new in the last SQL Server version?SQL Server 2022 was released this winter. Microsoft introduced several new features and improvements. The key changes relate to its…2 min read·Apr 8, 2023----
Ksenia UdovitskaiaHow to install Python with Anaconda: easy guidelineSince Python is an interpreted language, you must install the software to perform data analysis or run scripts on your computer. If you…3 min read·Mar 22, 2023----
Ksenia Udovitskaia3 ways to calculate the difference between two months in TableauSuppose you must compare two dates to show how sales changed (i.e., quarterly, semi-annual, or year-to-year). In that case, you might be…7 min read·Mar 15, 2023----
Ksenia UdovitskaiaTableau Desktop Tip1: How to remove a special character from name?If your data concludes some symbols such as arrows, commas, dashes or the hash, you might need to detach those characters from the text…3 min read·Jan 9, 2023----
Ksenia UdovitskaiaSQL queries you must know (with examples) — PART 2A couple weeks ago I published an article about SQL queries Part 1 queries Part 1 on Medium. This tutorial will provide you with three…4 min read·Nov 2, 2022----
Ksenia UdovitskaiaDesign a Bike shop Database — Example ER diagram + SQL codeIf your business is still uses multiple Excel tables it’s time to create a database system with the logical structure that will help you…3 min read·Oct 24, 2022--1--1
Ksenia UdovitskaiaMeasure marketing performance for a startup—with an Excel templateIf you are a startup you need to scale as fast as you can. You might be lost in a variety of metrics figuring out how to analyze your…3 min read·Oct 24, 2022----