Sir, I have one question from filters. You have shown and explained things like WHERE CUST_ID IN , NOT IN , LIKE etc but suppose I want to do a mix of both : CUST_NO IN ('101','103') AND REGION LIKE '%H') So here, data has to be filtered from 2 columns : REGION and CUST_NO. how can we do that?
Also, suppose i want to use AND as well as OR operator based on requirement. how is that done?
Hello Sir, For Exercise 3.1 we have to find out the profit for each state with Manager names. For this, is it necessary to perform a Inner join? Isn't it enough if we just establish a relationship in Logical layer?
Also, the generated visualization does not match with the solution provided in the .pdf file and it shows some negative profit. Can you help me on this?
I have used both the sample - superstore and Sales target set and created a bullet chart (by adding a reference line - Quartile). But I couldn't get a bar plots as in the reference dashboard picture. What I get is a stacked bar ( For Sales of two data set). But in the reference picture, entire bar is decoded as per the two sales range.
The Simplilearn community is a friendly, accessible place for professionals of all ages and backgrounds to engage in healthy, constructive debate and informative discussions. Get your pressing questions answered,
participate in monthly contests, create polls to get a feel for the market, build your network, and more! Pull up a chair and come join the discussion -today!