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…Jul 2, 2023Jul 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…Apr 10, 20231Apr 10, 20231
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…Apr 9, 2023Apr 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…Apr 8, 2023Apr 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…Mar 22, 2023Mar 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…Mar 15, 2023Mar 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…Jan 9, 2023Jan 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…Nov 2, 2022Nov 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…Oct 24, 20221Oct 24, 20221
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…Oct 24, 2022Oct 24, 2022
