hey actually i learned alot from you and I just given an interview for saama technogy and cleared technical round I am sharing interview question here can you please make a video like how to give an answer to interviewer to build impression like just wanted to say I want focus on body language, answering tact, in what way have to tell answer . 1)itroduction? 2)projects? 3)what types of filters. 4)order of filter 5)data bleanding and relationship difference. 5.1) what is * sign in data blending why it's come and how to remove it. scenario based question 6)two dimesions customer id order date find the customers who have order in 2014 two ways in set go to conditin then by formula year(order date)=2014 ===in and out manner result 1st solution second solution {fixed [customerid]: attr(orderdate)} 7)find first orderdate of each customer {fixed [customerid]:min[orderdate])} 8)joins table1 table2 1 1 2 1 3 2 5 4 null null inner = 1 1 1 1 2 2 left= 1 1 1 1 2 2 3 null 5 null null null right 1 1 1 1 2 2 4 null null null
full 1 1 1 1 2 2 3 null 5 null null null null 4 null null (table2) 9)find the employee with second highest salary select name from (select name,salary,dens_rank() over(order by salary desc) as rn) where rn=2; 10)find total revenue year wise select year sum(sales) from customers group by year; hope you will consider my reply and thanks for everything.
hey actually i learned alot from you and I just given an interview for saama technogy and cleared technical round I am sharing interview question here can you please make a video like how to give an answer to interviewer to build impression like just wanted to say I want focus on body language, answering tact, in what way have to tell answer .
1)itroduction?
2)projects?
3)what types of filters.
4)order of filter
5)data bleanding and relationship difference.
5.1) what is * sign in data blending why it's come and how to remove it.
scenario based question
6)two dimesions
customer id
order date
find the customers who have order in 2014
two ways
in set go to conditin then by formula year(order date)=2014 ===in and out manner result 1st solution
second solution
{fixed [customerid]: attr(orderdate)}
7)find first orderdate of each customer
{fixed [customerid]:min[orderdate])}
8)joins
table1 table2
1 1
2 1
3 2
5 4
null null
inner =
1 1
1 1
2 2
left=
1 1
1 1
2 2
3 null
5 null
null null
right
1 1
1 1
2 2
4 null
null null
full
1 1
1 1
2 2
3 null
5 null
null null
null 4
null null (table2)
9)find the employee with second highest salary
select name from (select name,salary,dens_rank() over(order by salary desc) as rn) where rn=2;
10)find total revenue year wise
select year sum(sales) from customers group by year;
hope you will consider my reply and thanks for everything.
You have very good knowledge on Tableau
Thanks a lot
Do you take tableau classes?
Thank you!
You're welcome!
sooooooperu
you could simple use discrete and drop sale on size and color then you would have received the same result :)
Wil this work on specific dates of the relevant months.
How can I get the bar one next to the other one rather than one over the other?
hi is there a new invite link for whatsapp?