Advanced Programming in SQL and Python – the course for business analysts – this course aims to equip students with advanced skills in SQL and Python, focusing on their application in business analytics. Through seven mini analytical case studies, students will gain hands-on experience in solving real-world business problems. Course Structure: Week 1-2: Introduction and…
Normalization aims to eliminate redundancy and enforce data integrity by organizing data into logical, dependency-driven forms.
Customer Retention Survival Analysis. In survival analysis, the hazard ratio (HR) is the risk coefficient described the rate when event occurs in some conditions to the same events occurred under the control variable of interest. For example, in a clinical study of a treatment, the treated population may die at twice the rate of the…
Advanced Programming in Data Analysis in data-driven world has got a new meanning. Advanced programming skills are essential for effective data analysis. This blog post explores the key concepts and techniques covered in the first part of the course “Zaawansowane programowanie w analizie danych,” led by Dr. Mieczysław Pawłowski from UMCS. We will delve into…
The task is to convert html field to url. Row date we can get via this query We got data like this We can use string_split to convert html field to url. After that we got following result Happy coding.
Matplotlib jest to jedna z najpopularniejszych bibliotek, która służy do tworzenia wizualizacji danych w Pythonie. Matplotlib została stworzona przez Johna D. Huntera w 2003 roku jako otwartoźródłowa biblioteka umożliwiająca tworzenie statycznych, animowanych i interaktywnych wykresów w Pythonie. Biblioteka jest wydawana na licencji BSD, co oznacza, że jest darmowa i można jej używać zarówno w projektach…
Ceny mieszkań w Polsce w latach 2013-2022 rosły. Opracowanie przedstawia analizę ceny za 1m2 mieszkań w Polsce w latach 2013-2022 w zależności od liczby mieszkań oddanych do użytku, metrażu. Autorzy opracowania: Joanna Świrgoń, Mateusz Łuczyński Analiza cen mieszkań w Polsce w ciągu ostatnich dziesięciu lat jest tematem szczególnie istotnym ze względu na dynamiczne zmiany w…
How To Set The First Day of Week DATEFIRST – SET DATEFIRST = 1 sets the first day of the week to Monday. In SQL Server, the first day of the week can be set to any day from 1 (Monday) to 7 (Sunday). This setting affects the output of date-related functions like DATEPART and…
Measuring product similarity, and recommendation understanding in the realm of e-commerce, is paramount. It serves as the cornerstone for various decision-making processes, ranging from product recommendations tailored to individual preferences to detecting duplicate entries in vast datasets. At its core, product similarity encompasses the comparison of attributes, features, and user interactions, aiming to identify items…
Similarity measure in text corpus is the distance between two vectors where the vector dimensions represent the features of two objects. Similarity is the measure of how similar or how different two objects are. The measure of similarity is the degree of similarity and vice versa. Usually, it is measured in the range 0 to…