Advance concepts mostly involves knowledge of window functions, cleaning the data format, working with different date formats, etc. Before proceeding, you should actually go through different ways of casting data types and other widows functions.1.Create the cumulative revenue ...
Continue readingSQL Intermediate Questions
Let's get started with some intermediate level SQL queries. Try to frame an approach before hoping to the solution because once you see the answer you will find it easy to understand.I think there will be around 15 ...
Continue readingBasic Queries to get you started
I hope you have already read the introduction part where we discussed about the execution flow of all the clauses in SQL.Today we will discuss around 15 questions which shall give you a good launching pad to ...
Continue readingIntroduction to SQL
Structured Query Language is the base of your Data Science career. You will always be surrounded with SQL queries and it's very important to understand the basics of the language.We will not waste time on defining terminologies associated ...
Continue readingSupply Chain Analytics – Using PuLP in Python
TheDataMonk
Grand Master
Uncategorized
Comments Off on Supply Chain Analytics – Using PuLP in Python
2328 views
There are three types of programming which we can do in Supply Chain a. Linear Programming – It involves creating a model on continuous variables b. Integer Programming – It involves creating a model on only Discrete ...
Continue readingSupply Chain Analytics
We all have a fair idea about the supply chain. In a layman term, we can say that the supply chain analytics helps in improving the operational efficiency and effectiveness by providing "data-driven" decisions at the operational and ...
Continue readingData Science Terms which are often confused
TheDataMonk
Grand Master
Uncategorized
Comments Off on Data Science Terms which are often confused
1155 views
Data Science = Maths+Code+Business UnderstandingMany a time you come across different terminologies which sounds confusing. We will try to make them easier for you to understand and to remember 1.Data Scientist vs Data AnalystData Scientist ...
Continue readingLinear Regression Part 3 – Evaluation of the model
TheDataMonk
Grand Master
Uncategorized
Comments Off on Linear Regression Part 3 – Evaluation of the model
1091 views
Check out Part 1 and Part 2 of the series before going furtherLinear Regression Part 1 - Assumption and Basics of LRLinear Regression Part 2 - Code and implementation of model If you ...
Continue readingLinear Regression Part 2 – Implementation of LR
TheDataMonk
Grand Master
Uncategorized
Comments Off on Linear Regression Part 2 – Implementation of LR
1116 views
We already know the assumptions of the Linear Regression. We will quickly go through the implementation part of the Linear Regression. We will be using R for this article(Read Sometimes, I am more comfortable in R :P )Remember ...
Continue readingAssumptions Of Linear Regression – Part 1
Here we will talk about the assumptions of Linear Regression which will let you understand LR and will help you tackle questions in your interview. I personally know a handful of candidates who have bosted themselves as a ...
Continue reading