Do interviewers ask for dashboards?

Great insights man. It's really useful to see an actual interview.

I couldn't follow your steps, it was so fast.

ONE QUESTION, WHOLE BI LESSON ,MY GOD IT HAS TAKEN MORE THAN 10 MINUTES

create table CRICKET (TEAM varchar(10)) insert into CRICKET values ('INDIA') insert into CRICKET values ('PAK') insert into CRICKET values ('ENG') insert into CRICKET values ('RSA') insert into CRICKET values ('AUS') select A.TEAM,B.TEAM from (select *,ROW_NUMBER()over (order by TEAM) as RN from CRICKET) as A inner join (select *,ROW_NUMBER()over (order by TEAM) as RN from CRICKET) as B on A.RN<B.RN order by A.TEAM

This PS person is acting like he knows everything in the data field.

Hi Akshay Bayas, can I have your LinkedIn Profile?

Which company was it ?

Can we trigger tableau extract refresh using MySQL ? I have completed Using python automations for tableau extract but need to trigger automation using sql. Is its possible ? If yes can you give me the littile details ?

Interviewers r idiots thy ask irrelvnt skills which r not mentioned in cv 😂😂😂

in which stage to use SQL and Python?

Why would any data engineer become a data analyst

What are company sre using tableau and power bi

How did you got the interview call for Tech M...??? Please help

Hi sir.. i am fresher can you plz help me.in getting job in canada..can u share ua contact number?

cascading filter

For union we get 5 output and union all we get 10 output

How can you join two tables if the columns are not common, table joined based on primary key and foreign key concept, with due respect but what the interviewer mentioned the query at time of the video 21:32 i.e. not correct, clearly "Bretty Doe" has never ordered mousepad ,his customer id is 5 , pls someone correct me if I am wrong ,right query will be below SELECT c.first_name, c.last_name, od.item, od.amount, sh.status from Customers c left join Orders od on c.customer_id=od.customer_id left join Shippings sh on c.customer_id=sh.customer where c.age > 25;

How many years of experience was this interview for?

this type of courage i need in interview thanks bro

*Promo SM*

SELECT AVG(c.age) AS average_age FROM Customers c JOIN Shippings s ON c.customer_id = s.customer WHERE s.status = 'Pending';

helpful

Target vs profit -bullet chart we can use

in your frist quetion query where are you joining emp and dept tables?

I think answer of last question was delivered wrong. If I got proper data. TABLE A x 2 1 NULL 1 3 4 TABLE B x 1 NULL 2 3 2 5 select * from A as a inner join B as b on a.x=b.x INNER JOIN x x 2 2 2 2 1 1 1 1 3 3 THERE ARE 5 RECORDS SHOUL COME.

select *, dense_rank () over (order by amount desc) as dn_rnk, rank () over (order by amount desc) as rnk, row_number () over (order by amount desc) as row_number from orders order by amount desc last question answer

Inner join - 5 Left join - 7 Outer join - 7 8:47

Nice Thanks for sharing this, did you get call for second round as well?

Thank you for your video) It is very useful👍

It will be more useful for every data analyst & as well as our subscribers 🎉🎉🎉

Good explanation... could you make a sample video of creating a resume according to the job description ❤❤❤

Hindi????

i finished +2 at 2017,in this year going to pursue an online degree ,will i get a job as an data analyst in six months doing a course on this?

Did you crack the interview

Sir how to contact with u for mentorship

The 2nd interviewer was just having basic understanding of data analysis. He was just pulling your leg and checking your confidence level. At the end of the interview you could have said I know all these terminologies but today I got little confuse instead of saying I agree.

If you want to increase your youtube channel make video on fresher jobs.

Hi, akshay, Please keep posting these kind of tableau interview. It really helps alot.

Awesome sir

Hey, The term that will call for the filters to add up is ' Cascade filter' i guess

Hi akshay, we can use 'clear all' button to refresh the filters at a same, by using actions.

Awesome sir

Order of Execution of SQL query: FROM > WHERE > GROUP BY > HAVING > SELECT > ORDER BY > LIMIT

I think it will also work: Highest salary: select emp_name, max(salary) from <table_name> order by 2 desc limit 1

SQL Query Execution Order: FROM > WHERE > GROUP BY > HAVING > SELECT > ORDER BY > LIMIT

How to contact you

Hlo sir can u give me interview tips i want

Is there any demand for power bi now. Which is better power bi ot tableau or qlikview

if you add voice to this video it will more helpful and you doing very fast