2c:I[678754,["/_next/static/immutable/chunks/1xy3h0f4a7gwr.js","/_next/static/immutable/chunks/09rzx5v5d6llo.js","/_next/static/immutable/chunks/0bq7z7dkkhzal.js","/_next/static/immutable/chunks/1kaj2_-zstwt5.js","/_next/static/immutable/chunks/0zxwjamz963uz.js","/_next/static/immutable/chunks/1wlp0m0ragz3c.js","/_next/static/immutable/chunks/2sp2zdz2z1-7-.js","/_next/static/immutable/chunks/0uqyi6k1m1402.js","/_next/static/immutable/chunks/0ck4oxtv53k8z.js","/_next/static/immutable/chunks/2capg7jj7swji.js","/_next/static/immutable/chunks/2gi7rpv7z1xnv.js","/_next/static/immutable/chunks/1k_tihxum3889.js","/_next/static/immutable/chunks/0nqu-0tdf9m4g.js","/_next/static/immutable/chunks/1f100_dyl5yfh.js","/_next/static/immutable/chunks/1p4djdrofy2_z.js","/_next/static/immutable/chunks/3g59p5k3jyky7.js","/_next/static/immutable/chunks/2txbn8ubvjjqc.js","/_next/static/immutable/chunks/41_itu3yea6ep.js","/_next/static/immutable/chunks/29l93xbpch82t.js","/_next/static/immutable/chunks/27zvz1op_vasj.js","/_next/static/immutable/chunks/27-22y3o590uz.js","/_next/static/immutable/chunks/2099qy2efzrfl.js","/_next/static/immutable/chunks/316i617hpmqkl.js","/_next/static/immutable/chunks/2yxmcd5w5mvzh.js","/_next/static/immutable/chunks/19gqympwall9e.js","/_next/static/immutable/chunks/36ptvsri7w2wc.js","/_next/static/immutable/chunks/31ebro7-y7os5.js","/_next/static/immutable/chunks/0nf9ch44lck2p.js","/_next/static/immutable/chunks/2jl1uvzejfp83.js","/_next/static/immutable/chunks/2p62s7olvti8v.js","/_next/static/immutable/chunks/3lvtf3jpc7c8d.js","/_next/static/immutable/chunks/2zn2lnrmmoffk.js","/_next/static/immutable/chunks/35ra4cw_6c8k9.js","/_next/static/immutable/chunks/0izzcn4zumxv2.js","/_next/static/immutable/chunks/3y8dwielyf2ju.js","/_next/static/immutable/chunks/0i7myz6vfscmj.js","/_next/static/immutable/chunks/1yp2t3wsxcdy_.js","/_next/static/immutable/chunks/16b78zrfhhzh_.js","/_next/static/immutable/chunks/3d12naphx39u3.js","/_next/static/immutable/chunks/3pguk-ilpn_1a.js","/_next/static/immutable/chunks/3nczya3qqxfc_.js"],"default"] 32:I[27201,["/_next/static/immutable/chunks/1xy3h0f4a7gwr.js","/_next/static/immutable/chunks/09rzx5v5d6llo.js","/_next/static/immutable/chunks/0bq7z7dkkhzal.js","/_next/static/immutable/chunks/1kaj2_-zstwt5.js","/_next/static/immutable/chunks/0zxwjamz963uz.js","/_next/static/immutable/chunks/1wlp0m0ragz3c.js","/_next/static/immutable/chunks/2sp2zdz2z1-7-.js","/_next/static/immutable/chunks/0uqyi6k1m1402.js","/_next/static/immutable/chunks/0ck4oxtv53k8z.js","/_next/static/immutable/chunks/2capg7jj7swji.js","/_next/static/immutable/chunks/2gi7rpv7z1xnv.js","/_next/static/immutable/chunks/1k_tihxum3889.js","/_next/static/immutable/chunks/0nqu-0tdf9m4g.js","/_next/static/immutable/chunks/1f100_dyl5yfh.js","/_next/static/immutable/chunks/1p4djdrofy2_z.js","/_next/static/immutable/chunks/3g59p5k3jyky7.js"],"IconMark"] 2a:["$","img",null,{"height":"1","width":"1","style":{"display":"none"},"alt":"","src":"https://www.facebook.com/tr?id=3659591550929113&ev=PageView&noscript=1"}] 2b:T54d,{"@context":"https://schema.org","@graph":[{"@type":"ItemPage","@id":"https://topmate.io/ketan_goel_analytics_expert/1415168#page","url":"https://topmate.io/ketan_goel_analytics_expert/1415168","mainEntity":{"@id":"https://topmate.io/ketan_goel_analytics_expert/1415168#service"}},{"@type":"Service","@id":"https://topmate.io/ketan_goel_analytics_expert/1415168#service","name":"Naukari Profile Setup Hacks + Other Job Hacks","url":"https://topmate.io/ketan_goel_analytics_expert/1415168","provider":{"@id":"https://topmate.io/ketan_goel_analytics_expert#person"},"serviceType":"1:1 Call","description":"Let recruiters reach out to you!","offers":{"@type":"Offer","price":999,"priceCurrency":"INR","availability":"https://schema.org/InStock","url":"https://topmate.io/ketan_goel_analytics_expert/1415168"},"additionalProperty":[{"@type":"PropertyValue","name":"Duration","value":"30 minutes"}]},{"@type":"Person","@id":"https://topmate.io/ketan_goel_analytics_expert#person","name":"Ketan Goel","url":"https://topmate.io/ketan_goel_analytics_expert","jobTitle":"Analytics Lead @Meesho | Linkedin 170k+ Followers Whatsapp Job Updates Community 100k+ Members 6+ Years Analytics Experience Interviewed 300+ profiles for Analytics roles Career Transition Mentor Instagram username: _goel_ketan","image":"https://static.topmate.io/ihahp5zRNcCzAnUWJiX2Nm.jpeg"}]}2d:Ta02,

Struggling to crack those tough SQL interview questions? Yearning for the confidence to ace your technical interviews and land your dream job? You've come to the right place! I'm Ketan Goel, a seasoned expert in analytics, career guidance, and resume building, and I'm here to guide you through every step of your career transformation.

Unlock Your Data Skills with Our Comprehensive SQL Guide

Gain exclusive access to over 200 meticulously solved SQL problems, all evaluated and tested on the prestigious LeetCode platform. This extensive collection is designed to equip you with the skills and confidence to navigate any SQL challenge that comes your way.

What's Inside:

200+ Real-World SQL Problems: Each with detailed solutions and explanations
Tested on LeetCode: Ensuring precision and reliability
Structured Learning Path: From beginner to advanced levels
Practical Application: Learn through real-world scenarios
Instant Access: Downloadable documents for your convenience

Imagine being able to approach your SQL interviews with confidence, knowing that you have mastered the hardest questions and techniques. Our meticulously curated collection will pave the way for success in your analytics, product management, software engineering, or MBA career.

Why Choose Our Guide?

Expert Guidance: Leverage the knowledge and experience of Ketan Goel, who has helped over 500 individuals transition into their desired roles.
Transformative Results: Clients have spoken highly of Ketan's patient, insightful, and practical approach, resulting in career transformations and highly coveted job opportunities.
Money-Back Guarantee: Your satisfaction is our priority. If you're not satisfied with our resources, we offer a hassle-free refund.

"Ketan's exceptional expertise in analytics and career guidance helped me gain clarity and confidence. His personalized advice was instrumental in securing my desired job. Highly recommend!" - Testimonial

Don't let uncertainty hold you back any longer. Equip yourself with the tools and knowledge needed to ace your SQL interviews. Download the Leet Code SQL Questions and Solutions today and take the first step towards unlocking your full potential and career success.

Let’s connect soon, and I'll ensure you'll say, "It feels a lot better than before."

2e:Tbfa,

Unlock the door to analytics mastery with our 60 Day Analytics Mastery Plan 🚀! Whether you're just starting out or looking to enhance your existing skills, this comprehensive plan packs 11 🔥 resources that rival expensive courses. Curated and designed for both beginners and experienced analysts, this is your gateway to becoming an analytics expert.

I'm Ketan, and I've dedicated my career to helping over 100 individuals transform their roles, gain confidence, and crack those elusive job interviews. From personal experience, I understand the hurdles and the importance of the right mentorship—now, I’m here to share these invaluable insights and strategies with you.

Embark on this 60-day journey to mastery, covering:

Excel Functions 📊: Master the essential Excel functions for data analysis.
Excel for Business Analysis 📈: Utilize Excel to drive business decisions.
Excel Dashboarding 💡: Create compelling and informative dashboards.
Understanding SQL Statements 🔐: Gain foundational SQL knowledge.
SQL for Business Analysis 🎯: Leverage SQL to understand your business data.
Statistics 📊: Crack the code of data through statistical analysis.
Problem Solving & Guesstimates 🤔: Improve your analytical thinking and estimation skills.
Business Domain Knowledge (e-commerce) 🛒: Deep dive into e-commerce analytics.
Storytelling/Communication 🗣: Master the art of presenting data effectively.
Data Visualization tools (Tableau/Power BI) 📊: Visualize data with industry-leading tools.
Resume Writing Resources 📝: Craft a resume that stands out to employers.

"It feels a lot better than before" — this is what you'll say after connecting with me. With these carefully curated resources and my guidance, you’ll achieve your goal of becoming an analytics master in just 60 days!

Extra tips to maximize your journey:

Dedicate Time Daily ⏰: Consistency is key to mastering new skills.
Collaborate with Others 🤝: Join a community or find a study partner for mutual growth.
Seek Help 🙋‍♀️: Don’t hesitate to ask questions and seek assistance when stuck.

Rest assured, if our discussions don’t meet your expectations, your investment is fully refundable. 🚀 Join the 500+ individuals who have benefited from this roadmap. I look forward to helping you achieve your career goals. Access the resources within 24-48 hours after your request and start your transformation today!

With determination and the right guidance, you can conquer the world of analytics. Let’s get started on this exciting journey together.

See you soon!

Thanks,
Ketan

2f:T6cf,

Are you on the lookout for an enriching collaboration to elevate your career to new heights? Whether you're diving into Analytics, Product Management, Software Engineering, or pursuing an MBA, I'm here to guide you every step of the way.

I'm Ketan Goel, and I've successfully assisted over 100 individuals in transforming their careers into roles they truly desire. If you're struggling to secure interviews despite numerous applications or feeling unsure about your interview skills, take a deep breath—your journey to confidence and clarity starts here.

With my rich professional experience and effective job hacks, I'm committed to resolving your struggles and boosting your confidence. Here’s how we can make that happen:

Uncover tailored strategies to ace job applications and interviews
Receive practical, actionable guidance that aligns with your career aspirations
Benefit from detailed insights and patient explanations to overcome obstacles
Boost your confidence and gain clarity in your professional journey

Expect to leave each conversation feeling better and more prepared than before, just like many others who have worked with me. And if you aren't satisfied with our discussions, relax—your investment is fully refundable.

"Ketan's deep expertise and practical guidance have had a transformative impact on my career. His patient explanations and tailored strategies boosted my confidence and clarified my professional path." - Testimonial

Ready to transform your career? Reach out for any collaboration and let’s get started on paving your path to success.

Looking forward to connecting soon!

Thanks,
Ketan Goel

30:T76c,

Feeling overwhelmed by the multitude of career options in Analytics, Product Management, Software Engineering, or even MBA? It's time to get the answers and guidance you need. I'm Ketan Goel, with 4 years of hands-on experience in the analytics domain across both product and service-based industries. I've successfully mentored over 100 individuals, helping them transform their careers into their desired roles with my professional insights and job hacks.

Our personalized 1:1 Mentorship and Resume Review session will address all your burning questions, including:

What is Business Analytics?
Steps to Become a Business Analyst
How to Transition after X Years of Experience
Roadmap to a Career as a Business Analyst
Recommended Courses/Resources for Learning Analytics

Imagine having a clear, actionable plan tailored to your unique career aspirations. With my expertise and personalized advice, you’ll gain the confidence to:

Create a standout resume that captures the attention of hiring managers
Navigate job applications and secure those coveted interview calls
Prepare for and excel in interviews with confidence-boosting strategies
Efficiently transition or advance your career in your chosen field

My commitment to your success means you'll experience a supportive mentorship environment, tailored to equip you with the practical skills and strategies needed to excel. If our discussions don't meet your expectations, don't worry—your money is fully refundable. Together, we’ll boost your career prospects and confidence.

Empower yourself with this invaluable mentorship and resume review session. Book your slot today, and let's embark on your journey to professional excellence.

Thanks,
Ketan Goel

31:T91f,

Feeling stuck in your career journey and uncertain about your next steps? Look no further! I'm Ketan, a dedicated mentor with a proven track record of helping over 100 individuals transform their careers and achieve their professional goals in Analytics, Product Management, Software Engineering, and more.

Take this unique opportunity to leverage my experience and insights, honed through years of overcoming career obstacles and perfecting job hacks. Whether you're struggling to land interview calls, feeling low on confidence, or unsure about how to navigate your career path, I'm here to offer clear, actionable advice tailored specifically to you.

Here's how we can work together to elevate your career:

Personalized Guidance: Ask me any question related to your career challenges, and you'll receive customized advice that's relevant to your unique situation.
Proven Strategies: Gain access to practical tools and strategies I've successfully used to help others secure their dream roles.
Boost Confidence: Receive the support you need to overcome interview anxiety and build the self-assurance necessary for career success.
Tailored Answers: My responses are carefully crafted based on your LinkedIn profile and resume to ensure they align with your specific career aspirations.
Satisfaction Guaranteed: Not satisfied with our discussion? No worries, your investment is fully refundable.

One thing you will definitely say after connecting with me is, "It feels a lot better than before!"

How to get started: Provide your LinkedIn profile URL and resume Google Drive link along with your query, stating:

Your Concern: What specific career challenge are you facing?
Your Efforts: What steps have you taken so far to address this issue?
Previous Attempts: Have you tried solutions you've found through Google or ChatGPT? Were they helpful?

Let's turn that 1% effort into a higher chance of success. Connect with me today and start conquering your career goals with confidence and clarity.

Looking forward to assisting you!

Best,
Ketan

1f:[[["$","$L12",null,{"id":"meta-pixel-3659591550929113","strategy":"afterInteractive","children":"!function(f,b,e,v,n,t,s)\n{if(f.fbq)return;n=f.fbq=function(){n.callMethod?\nn.callMethod.apply(n,arguments):n.queue.push(arguments)};\nif(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\nn.queue=[];t=b.createElement(e);t.async=!0;\nt.src=v;s=b.getElementsByTagName(e)[0];\ns.parentNode.insertBefore(t,s)}(window,document,'script',\n'https://connect.facebook.net/en_US/fbevents.js');\nfbq('init','3659591550929113');\nfbq('track','PageView');"}],["$","noscript",null,{"children":"$2a"}]],["$","script",null,{"type":"application/ld+json","dangerouslySetInnerHTML":{"__html":"$2b"}}],["$","$L2c",null,{"service":{"id":1415168,"title":"Naukari Profile Setup Hacks + Other Job Hacks","description":"

Book this call,If you want your Naukari profile to perform similar to this?

","short_custom_description":"Let recruiters reach out to you!","duration":30,"charge":{"amount":999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"user":36947,"questions":[{"id":1165945,"created":"2025-07-14T22:54:36.772147+05:30","modified_date":"2025-07-14T22:54:36.772163+05:30","question":"Share your updated resume","type":"upload","compulsory":true,"service":1415168},{"id":1165946,"created":"2025-07-14T22:54:47.677955+05:30","modified_date":"2025-07-14T22:54:47.677974+05:30","question":"Share your Linkedin Id","type":"text","compulsory":true,"service":1415168},{"id":998086,"created":"2025-01-28T14:41:57.495862+05:30","modified_date":"2025-07-14T22:56:05.758601+05:30","question":"Can you share what are you exactly expecting out of this call. Please be specific and mention things in pointers. Also mention what steps you have taken to solve the current problems!","type":"text","compulsory":true,"service":1415168}],"skip_payment":false,"is_visible":true,"enabled":true,"schedule":3583,"bookings_count":4,"booking_upcoming_count":4,"username":"ketan_goel_analytics_expert","show_seats_left":false,"show_sale_count":false,"show_bookings_count":false,"is_donation":false,"dynamic_questions":[],"promised_response_time":48,"type":1,"section":1,"images":[],"show_extra_info":true,"tweak_meta_data":[],"short_description":"Video Meeting","original_charge":{"amount":1199,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"record_session":false,"can_edit_date":false,"thumbnail_images":[],"specific_date":null,"bookings_limit":null,"group_call":false,"has_flexible_charge":true,"how_to_use":null,"package_services":[],"total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"session_count":0,"currency":{"code":"INR","currency":"Indian Rupee","display_text":"₹"},"break_after_call":0,"custom_text":null,"number_of_pages":0,"document_thumbnail_url":"","document_url":null,"package_validity_in_months":0,"suggested_support_my_work":{"amount":1249,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"ppp_enabled":true,"show_discount_code":false,"follower_charge":{"amount":999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"follower_total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"cohort_noun":"Webinar","shareable_image":null,"visits":null,"display_original_charge":{"amount":1199,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"suggested_price":{"amount":1999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"cohort_no_of_sessions":1,"session_names":[],"display_suggested_price":{"amount":1999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"avg_ratings":5,"booking_count":3,"cohort_weekdays":[],"cohort_sessions":[],"is_cohort":false,"showcased_testimonials":[],"recording_ab_enabled":false,"suggested_prices_list":[{"amount":999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},{"amount":1499,"currency":"Indian Rupee","code":"INR","display_text":"₹"},{"amount":1999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},{"amount":2998,"currency":"Indian Rupee","code":"INR","display_text":"₹"}],"ppp_applied":false,"auto_request_testimonials":true,"apply_all":false,"meta":null,"enable_course_demo":false,"show_course_content":false,"ai_description_enabled":false,"ai_description":null,"skills":[],"recording_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"record_automatically":false,"provide_certificate":false,"course":null,"service_label":null,"service_payment_cta_label":null,"cover_image_url":null,"thumbnail_url":null,"service_video_url":null,"redirect_config":null,"site_pages_count":0,"is_localised_currency":false,"user_currency":{"code":"INR","currency":"Indian Rupee","display_text":"₹"},"service_meta_info":{"order_type":"custom","variant":null,"sample_service_charge":null},"referral_query":false,"tags":[{"key":"average_rating","value":5}],"emi_enabled":false,"cohort_end_date":null},"user":{"id":36947,"first_name":"Ketan","last_name":"Goel","display_name":"Ketan Goel","username":"ketan_goel_analytics_expert","social_url":null,"title":"Analytics Lead @Meesho | Linkedin 170k+ Followers\nWhatsapp Job Updates Community 100k+ Members\n6+ Years Analytics Experience\nInterviewed 300+ profiles for Analytics roles \nCareer Transition Mentor \nInstagram username: _goel_ketan","description":"Are you someone \r\n>>who is exploring career in Analytics/product management /Software engineering/MBA !!? \r\n>> Who has applied to 100+ jobs but no interview call?!!\r\n>> Low on confidence to crack interviews!!?\r\n\r\nWell your struggle ends here!\r\nI helped 500+ Individuals in transforming there career into desired roles through my professional learnings and job hacks!\r\n\r\nThroughout my career, there's been a lot of obstacles and not always the best mentorship. Hence I am here to resolve your struggles and boost your confidence!\r\n\r\nOne thing you will definitely say after connecting with me is\r\n\"It feels a lot better than before\"\r\n\r\nIn case you are not satisfied with our discussions, no worries. Your money is total refundable.\r\n\r\nMeet you soon.\r\n\r\nThanks \r\nKetan","expertise":18,"timezone":"Asia/Kolkata","system_timezone":"America/Los_Angeles","profile_pic":"https://static.topmate.io/ihahp5zRNcCzAnUWJiX2Nm.jpeg","full_name":"Ketan Goel","services":[{"id":1639667,"title":"Download Ketan's Resume Copy with Youtube Tutorial","duration":0,"charge":{"amount":299,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"user":36947,"is_donation":false,"bookings_count":4,"show_bookings_count":false,"promised_response_time":48,"type":5,"section":1,"cohort_noun":"Webinar","cohort_no_of_sessions":1,"specific_date":null,"bookings_limit":null,"total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"session_count":0,"currency":{"code":"INR","currency":"Indian Rupee","display_text":"₹"},"is_cohort":false,"show_seats_left":false,"break_after_call":0,"original_charge":{"amount":999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"package_validity_in_months":0,"has_flexible_charge":true,"show_discount_code":false,"show_sale_count":false,"follower_charge":{"amount":299,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"follower_total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"ppp_enabled":true,"display_original_charge":{"amount":999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"tags":[{"key":"average_rating","value":5}],"how_to_use":"

Hey,

A) Please create a copy of google doc file of my resume to edit for your use case. Multiple people will have access to this link hence do not ask for edit access.

B) Please do watch the video tutorial

C) Do tell me in my inbox if you start getting interview calls post making changes as suggested in my tutorial

Cheers!

Hey!

Please use this list judiciously. To take maximum benefit, research about companies mention in the list and do targeted cold emailing.

Do not try bulk emailing, that is worst strategy!

Best of luck

Ketan

>Check Plan Pricing and next steps: https://shorturl.at/QgDqt

>Pay the subscription fee here: UPI : careeraccelerationclub@ibl

","recording_ab_enabled":false,"ai_description_enabled":false,"ai_description":null,"course":null,"enable_course_demo":false,"show_course_content":false,"service_label":null,"service_payment_cta_label":null,"cover_image_url":null,"thumbnail_url":null,"service_video_url":null,"redirect_config":null},{"id":1327128,"title":"Jobs/Referrals/Internship Whatsapp Channel Updates","duration":0,"charge":{"amount":249,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"user":36947,"is_donation":false,"bookings_count":3208,"show_bookings_count":false,"promised_response_time":48,"type":5,"section":1,"cohort_noun":"Webinar","cohort_no_of_sessions":1,"specific_date":null,"bookings_limit":null,"total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"session_count":0,"currency":{"code":"INR","currency":"Indian Rupee","display_text":"₹"},"is_cohort":false,"show_seats_left":false,"break_after_call":0,"original_charge":{"amount":999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"package_validity_in_months":0,"has_flexible_charge":true,"show_discount_code":false,"show_sale_count":true,"follower_charge":{"amount":249,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"follower_total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"ppp_enabled":true,"display_original_charge":{"amount":999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"tags":[],"how_to_use":null,"recording_ab_enabled":false,"ai_description_enabled":false,"ai_description":null,"course":null,"enable_course_demo":false,"show_course_content":false,"service_label":null,"service_payment_cta_label":null,"cover_image_url":null,"thumbnail_url":null,"service_video_url":null,"redirect_config":null},{"id":1450689,"title":"Leet Code SQL Questions and Solutions","duration":0,"charge":{"amount":249,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"user":36947,"is_donation":false,"bookings_count":13,"show_bookings_count":false,"promised_response_time":48,"type":5,"section":1,"cohort_noun":"Webinar","cohort_no_of_sessions":1,"specific_date":null,"bookings_limit":null,"total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"session_count":0,"currency":{"code":"INR","currency":"Indian Rupee","display_text":"₹"},"is_cohort":false,"show_seats_left":false,"break_after_call":0,"original_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"package_validity_in_months":0,"has_flexible_charge":true,"show_discount_code":false,"show_sale_count":false,"follower_charge":{"amount":249,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"follower_total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"ppp_enabled":true,"display_original_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"tags":[{"key":"average_rating","value":5}],"how_to_use":null,"recording_ab_enabled":false,"ai_description_enabled":false,"ai_description":"$2d","course":null,"enable_course_demo":false,"show_course_content":false,"service_label":null,"service_payment_cta_label":null,"cover_image_url":null,"thumbnail_url":null,"service_video_url":null,"redirect_config":null},{"id":521790,"title":"60 Day Analytics Mastery Plan 🚀","duration":0,"charge":{"amount":299,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"user":36947,"is_donation":false,"bookings_count":514,"show_bookings_count":false,"promised_response_time":48,"type":5,"section":1,"cohort_noun":"Webinar","cohort_no_of_sessions":1,"specific_date":null,"bookings_limit":null,"total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"session_count":0,"currency":{"code":"INR","currency":"Indian Rupee","display_text":"₹"},"is_cohort":false,"show_seats_left":false,"break_after_call":0,"original_charge":{"amount":1999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"package_validity_in_months":0,"has_flexible_charge":true,"show_discount_code":false,"show_sale_count":false,"follower_charge":{"amount":299,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"follower_total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"ppp_enabled":true,"display_original_charge":{"amount":1999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"tags":[{"key":"average_rating","value":4.5},{"key":"best_seller","value":true}],"how_to_use":null,"recording_ab_enabled":false,"ai_description_enabled":false,"ai_description":"$2e","course":null,"enable_course_demo":false,"show_course_content":false,"service_label":null,"service_payment_cta_label":null,"cover_image_url":null,"thumbnail_url":null,"service_video_url":null,"redirect_config":null},{"id":1299820,"title":"Collaboration Or Guest Lecture invite","duration":60,"charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"user":36947,"is_donation":false,"bookings_count":73,"show_bookings_count":false,"promised_response_time":48,"type":2,"section":1,"cohort_noun":"Webinar","cohort_no_of_sessions":1,"specific_date":null,"bookings_limit":null,"total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"session_count":0,"currency":{"code":"INR","currency":"Indian Rupee","display_text":"₹"},"is_cohort":false,"show_seats_left":false,"break_after_call":0,"original_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"package_validity_in_months":0,"has_flexible_charge":true,"show_discount_code":false,"show_sale_count":false,"follower_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"follower_total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"ppp_enabled":true,"display_original_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"tags":[],"how_to_use":null,"recording_ab_enabled":false,"ai_description_enabled":false,"ai_description":"$2f","course":null,"enable_course_demo":false,"show_course_content":false,"service_label":null,"service_payment_cta_label":null,"cover_image_url":null,"thumbnail_url":null,"service_video_url":null,"redirect_config":null},{"id":200761,"title":"1:1 Mentorship/Resume review","duration":45,"charge":{"amount":2999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"user":36947,"is_donation":false,"bookings_count":55,"show_bookings_count":true,"promised_response_time":48,"type":1,"section":1,"cohort_noun":"Webinar","cohort_no_of_sessions":1,"specific_date":null,"bookings_limit":null,"total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"session_count":0,"currency":{"code":"INR","currency":"Indian Rupee","display_text":"₹"},"is_cohort":false,"show_seats_left":false,"break_after_call":15,"original_charge":{"amount":9999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"package_validity_in_months":0,"has_flexible_charge":false,"show_discount_code":false,"show_sale_count":false,"follower_charge":{"amount":2999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"follower_total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"ppp_enabled":true,"display_original_charge":{"amount":9999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"tags":[{"key":"average_rating","value":4.9},{"key":"popular","value":true}],"how_to_use":null,"recording_ab_enabled":false,"ai_description_enabled":false,"ai_description":"$30","course":null,"enable_course_demo":false,"show_course_content":false,"service_label":null,"service_payment_cta_label":null,"cover_image_url":null,"thumbnail_url":null,"service_video_url":null,"redirect_config":null},{"id":148276,"title":"Only for referrals Request","duration":0,"charge":{"amount":1,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"user":36947,"is_donation":false,"bookings_count":1898,"show_bookings_count":false,"promised_response_time":24,"type":2,"section":1,"cohort_noun":"Webinar","cohort_no_of_sessions":1,"specific_date":null,"bookings_limit":null,"total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"session_count":0,"currency":{"code":"INR","currency":"Indian Rupee","display_text":"₹"},"is_cohort":false,"show_seats_left":false,"break_after_call":0,"original_charge":{"amount":999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"package_validity_in_months":0,"has_flexible_charge":false,"show_discount_code":false,"show_sale_count":false,"follower_charge":{"amount":1,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"follower_total_charge":{"amount":0,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"ppp_enabled":true,"display_original_charge":{"amount":999,"currency":"Indian Rupee","code":"INR","display_text":"₹"},"tags":[{"key":"average_rating","value":4.7},{"key":"popular","value":true}],"how_to_use":null,"recording_ab_enabled":false,"ai_description_enabled":false,"ai_description":"$31","course":null,"enable_course_demo":false,"show_course_content":false,"service_label":null,"service_payment_cta_label":null,"cover_image_url":null,"thumbnail_url":null,"service_video_url":null,"redirect_config":null}],"buffer":240,"reviews_count":278,"query_price":0,"paid_query_title":"Ask a question","query_description":"Ask me any anything and I'll revert with a detailed answer","query_tags":"","bookings_count":7528,"show_bookings_count":true,"show_rating_on_profile":true,"show_bookings_on_profile":true,"show_testimonials_on_profile":true,"is_featured":false,"theme_details":{"theme":"#E18C45","backgroundColor":"#E18C45"},"is_subscribe_enabled":true,"user_quality_metrics":{"college_quality":2,"company_quality":2,"category":"data_analyst","first_paid_created":"2023-02-21","followers":129789,"premium_user_score":4},"meta_image":"https://res.cloudinary.com/topmate/image/upload/s--Sy8YtRO7--/c_scale,h_628,w_1200/c_fit,g_south_west,h_320,l_profile_pics:ketan_goel_analytics_expert_8aoizyErWH6wCbEUhJdvLY,w_333,x_91,y_219/c_fit,co_rgb:000000,g_south_west,h_56,l_text:Poppins_36:topmate.io%252Fketan_goel_analytics_expert,w_850,x_124,y_36/v1/meta-image/metanew_kuwlcc.png","booking_period":60,"services_with_app":[],"social_urls":[{"link":"www.linkedin.com/in/kg97/","name":"linkedin"},{"link":"https://www.instagram.com/_goel_ketan/","name":"instagram"},{"link":"https://whatsapp.com/channel/0029Va5RkYRBqbrCyLdiaL3M","name":"custom"},{"link":"www.linkedin.com/in/kg97/","name":"website"}],"notice_period":{"type":"Minutes","value":240},"is_webinar_enabled":true,"microsoft_donation":false,"has_custom_package":false,"ratings_count":278,"highlights":[{"id":0,"text":"","type":102,"image":"","description":[{"name":"Data Manipulation","endorsements":2},{"name":"Product Analytics","endorsements":2},{"name":"Data-driven Decision Making","endorsements":1},{"name":"Business Strategy","endorsements":1},{"name":"Product Management","endorsements":3},{"name":"Program Management","endorsements":3},{"name":"People Management","endorsements":2},{"name":"Problem Solving","endorsements":null},{"name":"Data Science","endorsements":null},{"name":"SQL","endorsements":4},{"name":"Tableau","endorsements":3},{"name":"Business Analytics","endorsements":3},{"name":"Project Management","endorsements":1},{"name":"Machine Learning","endorsements":1},{"name":"Data Analysis","endorsements":1},{"name":"Statistical Data Analysis","endorsements":1},{"name":"Business Analysis","endorsements":1},{"name":"Strategic Planning","endorsements":null},{"name":"Analytical Skills","endorsements":1},{"name":"Artificial Intelligence (AI)","endorsements":1},{"name":"Microsoft Word","endorsements":3},{"name":"Microsoft Excel","endorsements":2},{"name":"Microsoft Office","endorsements":2},{"name":"C++","endorsements":1},{"name":"Microsoft PowerPoint","endorsements":1},{"name":"ANSYS","endorsements":1},{"name":"SolidWorks","endorsements":1},{"name":"Python","endorsements":1},{"name":"Python (Programming Language)","endorsements":1},{"name":"Azure ML","endorsements":null},{"name":"Microsoft Azure Machine Learning","endorsements":null},{"name":"Microsoft Azure","endorsements":null},{"name":"pandas","endorsements":null},{"name":"Seaborn","endorsements":null},{"name":"Management","endorsements":null},{"name":"Azure AI","endorsements":null},{"name":"EDA","endorsements":null},{"name":"Matplotlib","endorsements":null},{"name":"NumPy","endorsements":null},{"name":"Cross Functional Team Building","endorsements":null}]},{"id":1,"url":"https://jpmc.fa.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1001/job/210654498?utm_medium=jobboard&utm_source=LinkedIn","type":1,"image":"https://jpmc.fa.oraclecloud.com:443/hcmUI/CandidateExperience/images?imageId=0848BB3A-5E59-48BF-9AEC-F465299455DA","title":"Analytics Solution- Analyst"}],"pixel_track_id":null,"liked_properties":[{"property":"Helpful","total":77},{"property":"Insightful","total":63},{"property":"Friendly","total":89}],"year_end_achievements":["https://sharing-image-assets.s3.ap-south-1.amazonaws.com/new-year-1_slide_36947_130746.jpg","https://sharing-image-assets.s3.ap-south-1.amazonaws.com/new-year-2_slide_36947_131738.jpg","https://sharing-image-assets.s3.ap-south-1.amazonaws.com/new-year-3_slide_36947_132419.jpg","https://sharing-image-assets.s3.ap-south-1.amazonaws.com/new-year-4_slide_36947_133102.jpg","https://sharing-image-assets.s3.ap-south-1.amazonaws.com/new-year-5_slide_36947_133713.jpg","https://sharing-image-assets.s3.ap-south-1.amazonaws.com/new-year-6_slide_36947_134450.jpg","https://sharing-image-assets.s3.ap-south-1.amazonaws.com/new-year-7_slide_36947_135141.jpg"],"whitelabel_details":null,"avg_ratings":4.6,"total_ratings":278,"is_verified":true,"beta_tester":false,"enabled_support_my_work":false,"reschedule_policy":1,"discount_percentage_buy_in":0,"testimonials_count":195,"campaign":{"christmas":false,"thanksgiving":true},"journey_post_link":null,"show_chatbot":false,"premium_user":true,"recording_ab_enabled":false,"badges":[{"id":56660,"icon":"https://res.cloudinary.com/topmate/image/upload/v1765289697/badges/updated_badges2/Popular_a8bnmv.png","sub_title":"500 views","title":"Popular","type":"Popular","svg_content":null,"order":0,"is_visible":true},{"id":126030,"icon":"https://res.cloudinary.com/topmate/image/upload/v1734395504/2024-Awards/timekeeper_zcf6vl.png","sub_title":"Most Minutes","title":"Time Keeper '24","type":"Time Keeper '24","svg_content":null,"order":0,"is_visible":true},{"id":125509,"icon":"https://res.cloudinary.com/topmate/image/upload/v1734395503/2024-Awards/maincharacter_cbq3fg.png","sub_title":"Most Bookings","title":"Main Character '24","type":"Main Character '24","svg_content":null,"order":0,"is_visible":true},{"id":126512,"icon":"https://res.cloudinary.com/topmate/image/upload/v1734395505/2024-Awards/trusted_pro_z94vo9.png","sub_title":"Most Testimonials","title":"Trusted Pro '24","type":"Trusted Pro '24","svg_content":null,"order":0,"is_visible":true},{"id":127568,"icon":"https://res.cloudinary.com/topmate/image/upload/v1734395504/2024-Awards/eliteadvisor_kp5y2h.png","sub_title":"Most 1:1s","title":"Elite Advisor '24","type":"Elite Advisor '24","svg_content":null,"order":0,"is_visible":true},{"id":62668,"icon":"https://res.cloudinary.com/topmate/image/upload/v1765289665/badges/updated_badges2/Hustler_hnmcyp.png","sub_title":"Top Earners","title":"Hustler","type":"Hustler","svg_content":null,"order":0,"is_visible":true},{"id":62327,"icon":"https://res.cloudinary.com/topmate/image/upload/v1765289665/badges/updated_badges2/Community_Care_l9hchi.png","sub_title":"Host a free 1:1","title":"Community Care","type":"Community Care","svg_content":null,"order":0,"is_visible":true},{"id":61986,"icon":"https://res.cloudinary.com/topmate/image/upload/v1765289665/badges/updated_badges2/Host_Worthy_j3w7hk.png","sub_title":"Hosted a Webinar","title":"Host Worthy","type":"Host Worthy","svg_content":null,"order":0,"is_visible":true},{"id":61645,"icon":"https://res.cloudinary.com/topmate/image/upload/v1765289665/badges/updated_badges2/Curator_slbgcr.png","sub_title":"Sold a product","title":"Curator","type":"Curator","svg_content":null,"order":0,"is_visible":true},{"id":39309,"icon":"https://res.cloudinary.com/topmate/image/upload/v1765289665/badges/updated_badges2/top_5_zqw2ei.png","sub_title":"10 bookings","title":"Top 5%","type":"Top 5%","svg_content":null,"order":0,"is_visible":false},{"id":127994,"icon":"https://res.cloudinary.com/topmate/image/upload/v1734395503/2024-Awards/dmenergy_levgri.png","sub_title":"Most DM's resolved","title":"DM Energy '24","type":"DM Energy '24","svg_content":null,"order":0,"is_visible":true},{"id":128560,"icon":"https://res.cloudinary.com/topmate/image/upload/v1734395504/2024-Awards/topspeaker_uo65un.png","sub_title":"Most Webinars","title":"Top Speaker '24","type":"Top Speaker '24","svg_content":null,"order":0,"is_visible":true},{"id":129454,"icon":"https://res.cloudinary.com/topmate/image/upload/v1734395505/2024-Awards/topproducts_k4eol9.png","sub_title":"Most Product Sold","title":"Top Products '24","type":"Top Products '24","svg_content":null,"order":0,"is_visible":true},{"id":130304,"icon":"https://res.cloudinary.com/topmate/image/upload/v1734395505/2024-Awards/viralsensation_mrmkwx.png","sub_title":"Most Profile Views","title":"Viral Sensation '24","type":"Viral Sensation '24","svg_content":null,"order":0,"is_visible":true},{"id":130721,"icon":"https://res.cloudinary.com/topmate/image/upload/v1734395504/2024-Awards/northstar_iu7rg0.png","sub_title":"Top Performing Users","title":"North Star '24","type":"North Star '24","svg_content":null,"order":0,"is_visible":true},{"id":61304,"icon":"https://res.cloudinary.com/topmate/image/upload/v1765289665/badges/updated_badges2/People_s_Choice_ovbaw2.png","sub_title":"5 bookings","title":"People's Choice","type":"People's Choice","svg_content":null,"order":0,"is_visible":true},{"id":61056,"icon":"https://res.cloudinary.com/topmate/image/upload/v1765289697/badges/updated_badges2/top0.1_cqwkyv.png","sub_title":"Best of Best","title":"Top 0.1%","type":"Top 0.1%","svg_content":null,"order":0,"is_visible":true},{"id":5213,"icon":"https://res.cloudinary.com/topmate/image/upload/v1765289697/badges/updated_badges2/top1_pok0jq.png","sub_title":"25 bookings","title":"Top 1%","type":"Top 1%","svg_content":null,"order":0,"is_visible":true},{"id":329011,"icon":"https://res.cloudinary.com/topmate/image/upload/v1788356822/badges/year_badges/builders_23.png","sub_title":"Joined in 2023","title":"Builders '23","type":"Builders '23","svg_content":null,"order":0,"is_visible":true},{"id":20,"icon":"https://topmate-production.s3.ap-south-1.amazonaws.com/badges/badge-data.svg","sub_title":"Data","title":"Top Expert","type":"Top Expert","svg_content":null,"order":1,"is_visible":true}],"testimonial_image":{"id":3,"url":"","type":"lottie"},"ai_testimonial_short":"Ketan Goel is highly regarded for his insightful career guidance in analytics, offering tailored advice and fostering confidence in his mentees.","ai_testimonial_long":"Ketan Goel has received outstanding feedback for his mentorship and guidance in analytics and career development. Clients praised his ability to provide clear, actionable insights, tailored advice, and a supportive environment that fosters confidence. Many reported significant improvements in their career prospects and skill sets, highlighting his empathetic listening and expert knowledge.","ai_testimonial_tags":["Expertise","Transformative","Practical Guidance","Career Transitions","Data Analytics","Resume Optimization","Empathetic","Patient","Insightful","Actionable Advice","Expertise","Insightful","Patient","Transformative","Career Guidance","Detailed","Confident","Practical","Expertise","Guidance","Transformative","Career Insights","Confidence Boost","Tailored Strategies","Mentorship","Analytics","Career Transition","Practical Advice","Expertise","Transformative","Insightful","Mentorship","Career Guidance","Practical Strategies","Empathetic","Confidence Building","Detailed","Expert","Insightful","Helpful","Patient","Career Guidance","Resume Building","Transformative","Practical","Expert","Insightful","Transformative","Supportive","Empathetic","Career Guidance","Analytics Champion","Practical Advice","Boosts Confidence","Knowledgeable","Empathetic","Insightful","Transformative","Supportive","Actionable","Guidance","Expert","Career Development","Mentorship"],"currency":{"code":"INR","currency":"Indian Rupee","display_text":"₹"},"is_localised_currency":false,"push_notification_optin":false,"expertise_id":18,"service_meta_info":{"order_type":"price_low_high","variant":null},"daily_traffic_payout":true,"earn_by_creating":true,"earn_by_answering":true,"revenue_sharing":true,"enable_partner_payouts":true,"expertise_string":"Others","date_joined":"2023-02-12T18:15:03.485218+05:30","attendance_percentage":null,"meta_analytics":{"generated_sites_reward":true},"ultra_premium_user":true,"enable_robylon":false,"enable_no_cost_emi":false,"chatbot_customization":null,"enable_beta_service_site":true,"abandoncart_addon_v2":true,"expertise_tags":[],"icp_line":null,"faqs":[{"question":"What is a data analytics career and what does a data analyst actually do?","answer":"A data analytics career revolves around using data to answer business questions — you collect and clean data, write queries (mostly in SQL), build dashboards in tools like Excel, Power BI or Tableau, and present insights that help teams make decisions. Unlike pure coding roles, it blends numbers, business understanding and storytelling, which is why people from engineering, commerce and even non-tech backgrounds move into it. In India, analysts are hired across e-commerce, fintech, consulting, BFSI and product companies, making it one of the most accessible entry points into the data field."},{"question":"What does a typical data analyst career path look like in India?","answer":"A data analyst career in India usually begins as a junior or entry-level analyst, then progresses to data analyst, senior data analyst, and then analytics lead or analytics manager. From there, people either move into head-of-analytics roles or pivot into data science, product management or analytics engineering. Analysts who deepen their SQL, pick up Python, and build strong domain knowledge in sectors like e-commerce or fintech tend to move up the ladder much faster."},{"question":"Are data analyst careers for freshers realistic without prior work experience?","answer":"Yes — data analyst careers for freshers are among the most realistic ways into the data field because the core skills (SQL, Excel, basic Python and one visualization tool) can be self-taught and demonstrated through projects. Companies in India hire freshers from engineering, BSc, BCom and MBA backgrounds as long as the resume shows hands-on projects, internships and clear fundamentals. The bigger hurdle is getting shortlisted, which is why a project-heavy resume, an optimized Naukri and LinkedIn profile, and referrals matter more than marks."},{"question":"How do I start a data analyst career from scratch with no technical background?","answer":"The honest answer to how to start a data analyst career from scratch is a 3–6 month roadmap: first master Excel and SQL (the non-negotiables), then learn one BI tool like Power BI or Tableau, pick up basic Python, and build 2–3 end-to-end projects on real datasets such as sales, e-commerce orders or customer churn. Document the projects on GitHub and LinkedIn, rewrite your resume around them, and start applying while networking with analysts for referrals. Most generic guides on how to start a data analyst career skip this sequencing, which is exactly where most beginners lose months."},{"question":"What does data analyst career growth look like in terms of roles and salary?","answer":"Data analyst career growth in India is strong: freshers typically start around ₹4–8 LPA, senior analysts with 3–6 years of experience commonly earn ₹12–25 LPA in product and e-commerce companies, and analytics leads or managers cross ₹30 LPA. Growth is less about years and more about ownership — analysts who independently handle SQL at scale and tie their work to business outcomes like retention, revenue or funnels move up fastest. The role also opens doors to data science, product analytics and analytics management tracks."},{"question":"What is the scope of a data analyst career in the future with AI becoming so common?","answer":"A data analyst career in the future looks secure, but the profile is shifting: AI and auto-insight tools are removing repetitive reporting work, while demand is rising for analysts who can frame the right business question, validate AI-generated outputs, and turn analysis into decisions. Skills like SQL, statistics, experimentation and deep domain understanding in e-commerce, fintech or supply chain are becoming the real differentiators. Analysts who upskill toward data science, analytics engineering or product analytics will have the widest set of options."},{"question":"How do I start a data scientist career, and is it very different from data analytics?","answer":"There is no single formula for how to start a data scientist career, but the proven route is building statistics, Python, machine learning fundamentals and SQL, then proving them through 2–3 solid projects or Kaggle work rather than certificates alone. It differs from analytics — analysts describe and diagnose business problems while data scientists build predictive models — so transitioning from an analyst role, where you already understand business data, is usually the lowest-risk path. Many Indian companies also prefer internal transitions, making a strong analyst foundation the fastest gateway into data science."},{"question":"How should I prepare for SQL interview questions as a fresher?","answer":"If you are planning how to prepare for SQL interview questions, block out 3–4 focused weeks: start with SELECT, WHERE, GROUP BY, HAVING and all JOIN types, then move to subqueries, CTEs and window functions like ROW_NUMBER and RANK. Most SQL interview questions and answers for freshers revolve around a predictable core — WHERE vs HAVING, finding the second-highest salary, removing duplicates and basic aggregations — so master these patterns by writing every query by hand instead of only reading solutions. Finish with 1–2 mock interviews where you explain your logic aloud, since interviewers weigh your thought process as much as your final output."},{"question":"What is the best way to practice SQL interview questions before an interview?","answer":"If you are unsure how to practice SQL interview questions, the biggest mistake is passive reading — instead, solve real problems daily for 45–60 minutes on platforms like LeetCode SQL, HackerRank or StrataScratch. Attempt every question fully before peeking at the solution, then rewrite the accepted answer in your own style and note the underlying pattern, such as window functions, self joins or deduplication. In the final week, do timed mock interviews, ideally with someone who has actually sat on the interviewer's side, because explaining your query out loud is a separate skill from writing it."},{"question":"Which SQL interview questions are asked in data analyst interviews?","answer":"Most SQL interview questions for data analyst roles are business-scenario based: month-over-month growth, retention or repeat-purchase rates, top-N products per category, funnel drop-offs, and finding duplicates or gaps in data. Expect window functions (RANK, LAG, ROW_NUMBER), CTEs and multi-table joins rather than pure theory questions. If you are targeting e-commerce or marketplace companies, practice on schemas with orders, products, users and payments tables — that closely mirrors their actual interview datasets."},{"question":"What are SQL interview questions and answers for experienced candidates like?","answer":"SQL interview questions and answers for experienced candidates go beyond syntax into query optimization, indexing, performance tuning on large tables, and complex window-function scenarios, often wrapped in a case-study format where you design a metric from scratch. Interviewers probe your trade-offs — why you chose a CTE over a subquery, how you would cut a query's runtime, how you validate data quality. Prepare 2–3 detailed stories from your own work, such as a slow query you fixed or a pipeline you improved, because experience-level rounds lean heavily on real examples."},{"question":"What should a data analyst resume look like?","answer":"A strong data analyst resume is one page (two at most), ATS-friendly, and leads with a short summary, followed by skills like SQL, Excel, Python and Power BI/Tableau, then experience or projects written with quantified impact — \"built a dashboard that cut reporting time by 40%\" beats \"responsible for reporting\". Add links to GitHub, dashboards or portfolio work, keep the layout single-column and clean, and mirror keywords from the job description so it clears ATS filters. Recruiters spend under 30 seconds on the first scan, so SQL, projects and measurable impact must be visible in the top third of the page."},{"question":"How do I make a data analyst resume with no experience?","answer":"Most guides on how to make a data analyst resume with no experience overcomplicate things — the fix is replacing the experience section with 2–3 substantial projects: end-to-end analyses on public datasets showing the business question, your SQL or Python approach, and a measurable outcome. Add internships, freelance work or college projects framed in analytics language, and treat certifications as supporting proof rather than the headline, since projects carry the weight. Before applying, get the resume reviewed by a working analyst, because freshers lose the most ground to vague, task-based descriptions."},{"question":"How should I structure a data analyst resume for 3 years of experience?","answer":"A data analyst resume for 3 years of experience should shift focus from projects to impact: lead each role with 3–4 bullets quantifying outcomes, such as revenue influenced, dashboards adopted, query runtimes reduced or experiments supported. Keep SQL, Python and BI tools in a tight skills line, add domain context like e-commerce, fintech or logistics, and trim college-level projects — at this stage hiring managers scan for ownership and business metrics. Be prepared to defend every number on the resume during the interview, since experienced-level screens almost always drill into your claimed impact."},{"question":"Where can I find a reliable data analyst resume template for freshers?","answer":"Choose a data analyst resume template for freshers that is single-column, ATS-safe and orders sections as summary, skills, projects and education — avoid designer templates with tables, graphics or two-column layouts that parsing software misreads. Templates shared by mentors who regularly screen or interview analytics candidates are the safest starting point, because they reflect what actually gets shortlisted rather than what merely looks good. Whichever template you pick, customize it for each job description instead of sending the same PDF everywhere."}]}}]] 22:null 26:[["$","title","0",{"children":"Naukari Profile Setup Hacks + Other Job Hacks with Ketan Goel"}],["$","meta","1",{"name":"description","content":"Naukari Profile Setup Hacks + Other Job Hacks with Ketan Goel · Let recruiters reach out to you! · 1:1 Call · 30 mins · ₹999 · Topmate"}],["$","link","2",{"rel":"manifest","href":"/manifest.json","crossOrigin":"$undefined"}],["$","meta","3",{"name":"robots","content":"index, follow"}],["$","link","4",{"rel":"canonical","href":"https://topmate.io/ketan_goel_analytics_expert/1415168"}],["$","meta","5",{"name":"yandex-verification","content":"0c572762b08c1459"}],["$","meta","6",{"name":"facebook-domain-verification","content":"xewq3sfwoskylhfigrhakv2hy7zemf"}],["$","meta","7",{"property":"og:title","content":"Naukari Profile Setup Hacks + Other Job Hacks with Ketan Goel"}],["$","meta","8",{"property":"og:description","content":"Naukari Profile Setup Hacks + Other Job Hacks with Ketan Goel · Let recruiters reach out to you! · 1:1 Call · 30 mins · ₹999 · Topmate"}],["$","meta","9",{"property":"og:url","content":"https://topmate.io/ketan_goel_analytics_expert/1415168"}],["$","meta","10",{"property":"og:image","content":"https://topmate.io/cdn-cgi/image/width=1600,fit=contain,quality=90/https://res.cloudinary.com/topmate/image/upload/s--Sy8YtRO7--/c_scale,h_628,w_1200/c_fit,g_south_west,h_320,l_profile_pics:ketan_goel_analytics_expert_8aoizyErWH6wCbEUhJdvLY,w_333,x_91,y_219/c_fit,co_rgb:000000,g_south_west,h_56,l_text:Poppins_36:topmate.io%252Fketan_goel_analytics_expert,w_850,x_124,y_36/v1/meta-image/metanew_kuwlcc.png?ogv=2"}],["$","meta","11",{"property":"og:type","content":"website"}],["$","meta","12",{"name":"twitter:card","content":"summary_large_image"}],["$","meta","13",{"name":"twitter:title","content":"Naukari Profile Setup Hacks + Other Job Hacks with Ketan Goel"}],["$","meta","14",{"name":"twitter:description","content":"Naukari Profile Setup Hacks + Other Job Hacks with Ketan Goel · Let recruiters reach out to you! · 1:1 Call · 30 mins · ₹999 · Topmate"}],["$","meta","15",{"name":"twitter:image","content":"https://topmate.io/cdn-cgi/image/width=1600,fit=contain,quality=90/https://res.cloudinary.com/topmate/image/upload/s--Sy8YtRO7--/c_scale,h_628,w_1200/c_fit,g_south_west,h_320,l_profile_pics:ketan_goel_analytics_expert_8aoizyErWH6wCbEUhJdvLY,w_333,x_91,y_219/c_fit,co_rgb:000000,g_south_west,h_56,l_text:Poppins_36:topmate.io%252Fketan_goel_analytics_expert,w_850,x_124,y_36/v1/meta-image/metanew_kuwlcc.png?ogv=2"}],["$","link","16",{"rel":"shortcut icon","href":"/favicon.svg"}],["$","link","17",{"rel":"icon","href":"/favicon.svg","type":"image/svg+xml"}],["$","link","18",{"rel":"apple-touch-icon","href":"/favicon.svg"}],["$","$L32","19",{}]]

Naukari Profile Setup Hacks + Other Job Hacks with Ketan Goel

Ketan Goel

Naukari Profile Setup Hacks + Other Job Hacks

About this session