- 443
- 1 133 166
Xpressurdata
India
เข้าร่วมเมื่อ 1 ก.พ. 2018
#1 Channel for Tableau/SQL Interview Preparation
Master Interview Question & Scenarios with Detailed Explanation of Major IT Companies
Hello, everyone! I'm Rahul Pawar, a dedicated Tableau Trainer and Tableau Ambassador. On this channel, I share my expertise, experiences to help you ace interviews in #Tableau, #Power BI, and #SQL.
On a Mission : to prepare you for your next job and guide you on your journey to a successful BI career. If you're gearing up for interviews or planning to step into a BI role, this channel is crafted for you.
I focus on delivering genuine, practical content-no clickbait, just real-world issues and use cases that we face every day as Tableau Developers and Data Analysts. My aim is to provide valuable insights that you can immediately apply.
Your feedback is always welcome to help enhance the content.
If you find my videos helpful, please consider subscribing and sharing with others.
Happy learning!
#Hyderabadi
For inquiries: xpressurdata@gmail.com
Master Interview Question & Scenarios with Detailed Explanation of Major IT Companies
Hello, everyone! I'm Rahul Pawar, a dedicated Tableau Trainer and Tableau Ambassador. On this channel, I share my expertise, experiences to help you ace interviews in #Tableau, #Power BI, and #SQL.
On a Mission : to prepare you for your next job and guide you on your journey to a successful BI career. If you're gearing up for interviews or planning to step into a BI role, this channel is crafted for you.
I focus on delivering genuine, practical content-no clickbait, just real-world issues and use cases that we face every day as Tableau Developers and Data Analysts. My aim is to provide valuable insights that you can immediately apply.
Your feedback is always welcome to help enhance the content.
If you find my videos helpful, please consider subscribing and sharing with others.
Happy learning!
#Hyderabadi
For inquiries: xpressurdata@gmail.com
Tableau Interview Questions and Answers | #xpressurdata
#tableauinterviewquestions, #tableauinterview, #tableau
🎯 Preparing for a Data Analyst role? I've got you covered! In this video, I dive deep into the most commonly asked #sqlinterview and #powerbiinterview BI/#tableauinterviewquestions . Whether you're a beginner or looking to brush up on your skills, these questions will give you the edge you need to ace your interview. Don't forget to like, share, and subscribe for more tips and tricks on landing your dream job in data analytics! 💼✨"
#tableauquestions
1. What is row level security? How you apply it?
2. How to use parameters with action filters?
3. Please explain where the fixed LOD appears during execution, as well as Include and Exclude LOD - Tableau Filters
4. What is data blending and what are the limitations of data blending?
5. Optimization in Tableau for the dashboard
#sqlquestions
SQL related question
1. How would you get all departments, even those without any employee
2. Tell me the count of the employees for each department
3. Difference between having and where?
#DataAnalyst #SQLInterviewQuestions #PowerBIInterview #DataAnalytics #JobInterviewTips #DataScience #TechInterviews #InterviewPrep #CareerGrowth #Tableau #DataVisualization #Hectranet
#SQLTips #PowerBITips #DataJobs #InterviewSuccess #TechCareers #CareerAdvice #AnalyticsCareer #JobPreparation #DataSkills #SQLQueries #PowerBIVisuals #DataEngineer #CareerDevelopment #TechIndustry #BI #AnalyticsCommunity #DataDriven #DataCareer #InterviewStrategy #TechJobs
🎯 Preparing for a Data Analyst role? I've got you covered! In this video, I dive deep into the most commonly asked #sqlinterview and #powerbiinterview BI/#tableauinterviewquestions . Whether you're a beginner or looking to brush up on your skills, these questions will give you the edge you need to ace your interview. Don't forget to like, share, and subscribe for more tips and tricks on landing your dream job in data analytics! 💼✨"
#tableauquestions
1. What is row level security? How you apply it?
2. How to use parameters with action filters?
3. Please explain where the fixed LOD appears during execution, as well as Include and Exclude LOD - Tableau Filters
4. What is data blending and what are the limitations of data blending?
5. Optimization in Tableau for the dashboard
#sqlquestions
SQL related question
1. How would you get all departments, even those without any employee
2. Tell me the count of the employees for each department
3. Difference between having and where?
#DataAnalyst #SQLInterviewQuestions #PowerBIInterview #DataAnalytics #JobInterviewTips #DataScience #TechInterviews #InterviewPrep #CareerGrowth #Tableau #DataVisualization #Hectranet
#SQLTips #PowerBITips #DataJobs #InterviewSuccess #TechCareers #CareerAdvice #AnalyticsCareer #JobPreparation #DataSkills #SQLQueries #PowerBIVisuals #DataEngineer #CareerDevelopment #TechIndustry #BI #AnalyticsCommunity #DataDriven #DataCareer #InterviewStrategy #TechJobs
มุมมอง: 675
วีดีโอ
Tableau Interview Questions and Answers | #xpressurdata
มุมมอง 670วันที่ผ่านมา
#tableauinterviewquestions, #tableauinterview, #tableau 🎯 Preparing for a Data Analyst role? I've got you covered! In this video, I dive deep into the most commonly asked #sqlinterview and #powerbiinterview BI/#tableauinterviewquestions . Whether you're a beginner or looking to brush up on your skills, these questions will give you the edge you need to ace your interview. Don't forget to like, ...
Master Tableau in Just 15 Minutes - Complete Beginner Tutorial|#xpressurdata
มุมมอง 415วันที่ผ่านมา
Want to learn Tableau but short on time? This quick and easy tutorial will take you from zero to hero in just 15 minutes! Whether you're a beginner or need a refresher, this video covers the essential Tableau skills you need to create powerful visualizations and dashboards. Learn how to connect to data, create charts, filters, and interactive dashboards with simple, step-by-step instructions. P...
Day in the Life of a Tableau Developer|#xpressurdata
มุมมอง 46114 วันที่ผ่านมา
Curious about what a Tableau Developer does on a daily basis? In this video, I walk you through the typical day-to-day activities of a Tableau Developer, including tasks like data preparation, building insightful dashboards, collaborating with stakeholders, and optimizing visualizations for performance. Whether you're an aspiring Tableau Developer or looking to understand this role better, this...
Tableau Interview Scenario |Rolling 12 M Sales|#Tableau #xpressurdata
มุมมอง 98721 วันที่ผ่านมา
#tableauinterviewquestions, #tableauinterview, #tableau Learn how to write Rolling 12 M sales with ease. This step-by-step tutorial is perfect for Tableau users looking to enhance their dashboards with intuitive navigation features. Whether you're a beginner or an experienced developer, this guide will help you improve user interaction and streamline your Tableau experience. #Tableau #DataVisua...
Tableau Interview Questions and Answers | #xpressurdata
มุมมอง 73921 วันที่ผ่านมา
#tableauinterviewquestions, #tableauinterview, #tableau 🎯 Preparing for a Data Analyst role? I've got you covered! In this video, I dive deep into the most commonly asked #sqlinterview and #powerbiinterview BI/#tableauinterviewquestions . Whether you're a beginner or looking to brush up on your skills, these questions will give you the edge you need to ace your interview. Don't forget to like, ...
Tableau Interview Tip: How to Explain Your Tableau Experience Effectively |#tableau #interviewtips
มุมมอง 46021 วันที่ผ่านมา
Welcome to #Xpressurdata In this video, I break down how to answer one of the most common Tableau interview questions: ‘Tell me about your Tableau experience.’ Using the STAR method (Situation, Task, Action, and Result), I’ll guide you through crafting a powerful response that showcases your skills and impresses interviewers. Whether you're a beginner or seasoned professional, this video will h...
Top SQL Interview Questions & Answers - Part 5 | Ace Your Tech Interview
มุมมอง 398หลายเดือนก่อน
Welcome to Part 5 of our SQL Interview Series! 🎓 Whether you're prepping for your next job interview or brushing up on your SQL skills, this video is packed with essential questions and answers that will help you stand out. From basic queries to advanced concepts, we cover the most commonly asked SQL interview questions and provide clear, concise explanations to ensure you understand the fundam...
Top SQL Interview Questions & Answers - Part 4 | Ace Your Tech Interview
มุมมอง 392หลายเดือนก่อน
Welcome to Part 4 of our SQL Interview Series! 🎓 Whether you're prepping for your next job interview or brushing up on your SQL skills, this video is packed with essential questions and answers that will help you stand out. From basic queries to advanced concepts, we cover the most commonly asked SQL interview questions and provide clear, concise explanations to ensure you understand the fundam...
Top SQL Interview Questions & Answers - Part 3 | Ace Your Tech Interview
มุมมอง 374หลายเดือนก่อน
Welcome to Part 3 of our SQL Interview Series! 🎓 Whether you're prepping for your next job interview or brushing up on your SQL skills, this video is packed with essential questions and answers that will help you stand out. From basic queries to advanced concepts, we cover the most commonly asked SQL interview questions and provide clear, concise explanations to ensure you understand the fundam...
Top SQL Interview Questions & Answers - Part 2 | Ace Your Tech Interview
มุมมอง 522หลายเดือนก่อน
Welcome to Part 2 of our SQL Interview Series! 🎓 Whether you're prepping for your next job interview or brushing up on your SQL skills, this video is packed with essential questions and answers that will help you stand out. From basic queries to advanced concepts, we cover the most commonly asked SQL interview questions and provide clear, concise explanations to ensure you understand the fundam...
Top SQL Interview Questions & Answers - Part 1 | Ace Your Tech Interview
มุมมอง 862หลายเดือนก่อน
Welcome to Part 1 of our SQL Interview Series! 🎓 Whether you're prepping for your next job interview or brushing up on your SQL skills, this video is packed with essential questions and answers that will help you stand out. From basic queries to advanced concepts, we cover the most commonly asked SQL interview questions and provide clear, concise explanations to ensure you understand the fundam...
Tableau Interview Scenario | How to Filter from 1 Dashboard to other #Tableau #xpressurdata
มุมมอง 987หลายเดือนก่อน
#tableauinterviewquestions, #tableauinterview, #tableau Learn how to apply Filter from 1 Dashboard to Other Dashboards with ease. This step-by-step tutorial is perfect for Tableau users looking to enhance their dashboards with intuitive navigation features. Whether you're a beginner or an experienced developer, this guide will help you improve user interaction and streamline your Tableau experi...
Tableau Interview Scenario | How to Create Reset Button in #Tableau #xpressurdata Reset Button
มุมมอง 924หลายเดือนก่อน
Tableau Interview Scenario | How to Create Reset Button in #Tableau #xpressurdata Reset Button
Tableau Interview Questions and Answers | #xpressurdata
มุมมอง 1.6Kหลายเดือนก่อน
Tableau Interview Questions and Answers | #xpressurdata
Tableau Interview Questions and Answers | #xpressurdata
มุมมอง 720หลายเดือนก่อน
Tableau Interview Questions and Answers | #xpressurdata
Tableau Interview Questions and Answers | #xpressurdata
มุมมอง 2.2Kหลายเดือนก่อน
Tableau Interview Questions and Answers | #xpressurdata
Tableau Interview Questions and Answers | #xpressurdata
มุมมอง 2K2 หลายเดือนก่อน
Tableau Interview Questions and Answers | #xpressurdata
Tabeau Interview Question and Answers | #xpressurdata
มุมมอง 2.3K2 หลายเดือนก่อน
Tabeau Interview Question and Answers | #xpressurdata
Tableau Interview Question and Answers | #xpressurdata
มุมมอง 1.7K2 หลายเดือนก่อน
Tableau Interview Question and Answers | #xpressurdata
Tableau Interview Scenario | Comparing Selected Year vs Current Year Growth
มุมมอง 9302 หลายเดือนก่อน
Tableau Interview Scenario | Comparing Selected Year vs Current Year Growth
Tableau Interview Scenario|Top3SubCat |#ytshorts, #interviewscenarios #tableaututorial
มุมมอง 3312 หลายเดือนก่อน
Tableau Interview Scenario|Top3SubCat |#ytshorts, #interviewscenarios #tableaututorial
Tableau Interview Question and Answers | #xpressurdata
มุมมอง 1.3K2 หลายเดือนก่อน
Tableau Interview Question and Answers | #xpressurdata
Tableau Interview Question and Answers | #xpressurdata
มุมมอง 2.5K2 หลายเดือนก่อน
Tableau Interview Question and Answers | #xpressurdata
Tableau Interview Question and Answers | Scatter Pie - Set 2| #xpressurdata
มุมมอง 1.4K3 หลายเดือนก่อน
Tableau Interview Question and Answers | Scatter Pie - Set 2| #xpressurdata
Tableau Interview Question and Answers | Scatter Pie | #xpressurdata
มุมมอง 1.6K3 หลายเดือนก่อน
Tableau Interview Question and Answers | Scatter Pie | #xpressurdata
Tableau Interview Question and Answers | Salesforce | #xpressurdata
มุมมอง 2K3 หลายเดือนก่อน
Tableau Interview Question and Answers | Salesforce | #xpressurdata
#Top10 |Tableau Interview Scenarios #xpressurdata
มุมมอง 2.9K3 หลายเดือนก่อน
#Top10 |Tableau Interview Scenarios #xpressurdata
Data Analyst Intern: Key Roles and Daily Tasks Explained
มุมมอง 5173 หลายเดือนก่อน
Data Analyst Intern: Key Roles and Daily Tasks Explained
Tableau Interview Scenario| Display Only Subtotals in Tableau | Step-by-Step Tutorial #xpressurdata
มุมมอง 1.6K3 หลายเดือนก่อน
Tableau Interview Scenario| Display Only Subtotals in Tableau | Step-by-Step Tutorial #xpressurdata
one question was asked in PWC there is a daily report which data refresh daily and the report has changes for one the server is down of datasource which SQL server and now we are getting the data in CSV files what changes we need to do in tableau server and desktop. 2. how to handle 10 million data in tableau and how you export the data in server and how you will optimize the report please make a video on this it will so helpful for us thanks you
Thanks you sir please create a dedicated video parameter actions with multiple scenario
EXL company for tableau developer 1: How to find the remaining days in the month in a dynamic way 2: on Viz level we have state wise sales. How to see each category wise sales on visualization. 3: How many LOD in Tableau 4: what is the use of relationships and join in Tableau. What is the difference between two of this. 5: what is the difference between parameters and filter. Have you used parameters action 6:how to handle duplicates in sql
Thanks for sharing 🙏
Hello sir , can you provide me the dataset ,that excel file ??
please share the notes access
Why dont you answer the questions ? What is the use of telling "This is a very important question" but you dont give the answer
Which one?
Parameter actions video plz
@@harishbabu1502 sure
Thank you sir , but I would request you to create a seperate video for Question number -2 (Use of parameter with Action filter or Action highlighted)
@@gauravghosh8002 sure
Size of the data is in millions means .. No. of rows in the joined tables are in millions? Can we say the data is in Terabytes ..
Thanks
Hi. Can I ask how do we export a list of users from here?
I need help to review and suggest my resume. Can I get sample resume also?
Pl join membership and msg me will do accordingly
Thank you sir for showcasing Rolling months Scanrio but it would be great if you provide how to handle this month's using a Parameter selection and that parameter is in Integer. So suppose I put 6 then I should get Rolling 6 months data sales from max date.
We can do that as well
Can u explain about CONTEXT filter s
Interesting
😄
Very helpful, thank you!
Thanks sir!! It is really beneficial for us who are going for the interview and know nothing. Please bring more such videos to get more understanding of how the things work.
Welcome Neha
Bro nice taking I learned tableau Do we have calls?
I think yes we do have
[Order Date]={ FIXED YEAR([Order Date]): MIN([Order Date])}
[Order Date]={ FIXED YEAR([Order Date]): MAX([Order Date])}
Hey rahul thanks for you content. But we also can achieve this by table calculation na ?
I want only for last 12. Not any other months
Hi Rahul... i'm Joel, I need some help. i have 2 YOE in analyst role and my primary tool is tableau and i've intermediate knowledge in mysql and good in excel. I've my naukri profile updated with the relevant skills as keywords and in resume too. i'm actively looking for jobs for past 2 months and my call frequency is really low. so is my YOE not that good enough or what should i do to get more calls. Can you please help me.
Im working for citi as a Tableau Developer.. to see this video is different fun 😅😂 What to focus: Citi projects are based on micromanagement. They follow agile methodology. So you have to know Jira, how to deploy dashboard to server using bitbucket and Udeploy. UAT testing for your dashboard. You will get one fix question on performance and dashboard security. Navigation between two tabs. Actions and use of parameters. They have their own themes for dashboard like citi logo and color. Best luck guys Edit: Custom SQL is must as they are using hive tables connection and you have to use Custom SQL for requested data to Tableau
Nice Explanation.
Hi Rahul, Few days back I saw your video where you showed Dynamic yoy,dod,mom,yoy.. I.e if I select sales for September 1-10 in need to see August 1-10 sales as well. Could you please share that video here?
Thank you very much 🙏
Welcome welcome 😁
Calls a rahe hai... For immediate joiners
1. Extract Filter 2. Data source Filter 3. Context Filter 4. Measure Filter 5. Dimension Filter 6. Column Calc. Filter
Super
Thanks for sharing valuable content , could you please did answers same as that sql
Ok brother
Extract filter -Datasource-context-dimension-measure-table calculation
Great playlist and videos on scenario based questions
Thanks Komal
Same question, kya kare aap batao sir , please help us
WITH RankedEmployees AS ( SELECT Departmentno, Employeeno, Salary, RANK() OVER (PARTITION BY Departmentno ORDER BY Salary DESC) AS SalaryRank FROM Employees ) SELECT Departmentno, Employeeno, Salary FROM RankedEmployees WHERE SalaryRank = 2;
Rahul Bhya, kindly share the data file
Rahul sir . Your questions are very helpful. Please continue with sql
Hi Rahul, can you please make video on RLS, today in my L2 round panel asked me how you will create group of 1000 employee and apply RLS on them?
Hi Rahul, We have 2 tables class1 and class 2 With columns rollno, name,subject, marks Task is to find top 2 for each class. in tableau in a single worksheet. Student with the highest total marks is first and 2nd highest total marks is ranked 2nd I was able to answer it in SQL but not in tableau. Please explain this using Excel with class1 and class2 as two tables
In tableau?
@@TechiRahul yes. Using Excel as Data source.
@@ShaliniSingh-oc8qlI have done it on Tableau. I have 2 sheets on Excel with columns Roll no, name, subject, marks each for class 1 and class 2 then I took it to tableau and performed a union. Created a sheet by adding the sheet name and name of the student on rows and sum of marks on the text card. Then used the index(can use rank as well) function to narrow it down to the top 2 students in each class. Let me know if any of this is unclear.
@@_TheHumbleGuy_ Thanks, I'll try and will get back to you in case of doubt.
@@ShaliniSingh-oc8ql sure
Kya tableau m coding ki jroort pdti h
Yes padti hai
@@TechiRahul tuff rhti yaa simple
@anuragchauhan2899 easy
Hi Bro, Thanks for super explanation . 11 are new customers if i am not wrong.
Thank you bro... it is very helpfull and ur explaination is good and very Understandable.....
can you help me out for round 2 interview for sql and tableau. i have cleared 1st round and the 2nd round is of 30 mins which type of questions they will ask
Sure,Please join membership n email we can connect n discuss
@@TechiRahul done already
is there any limit for no.of subscriptions?
Thank you Rahul I've been looking for this type of video from you for a very long time finally 😊
use dense rank() window function because if we have a multiple people with second highest salary at that point of time dense rank() function will give all the records with second highest salary but with row number() function we will get only one record.
Can we write a direct query without using the temporary table creation concept?
Can we use the MOD function in SQL to find the odd and even numbers?
For First 4 Letters we can use -SELECT ENAME,LEFT(ENAME,4) AS FIRST_4 FROM EMP
never used earlier u have showed very simple ways to create lod
Thanks Rahul, this one serves as a quick recap for my SQL rounds!
Bro please do a video with parameters actions as well