Data Analyst Technical Interview Questions and Answers

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024
  • Data Analyst Technical Interview Questions and Answers
    ===========VIDEO COURSE============================
    ✅ Mastering Excel Video Course
    www.innozant.c...
    ✅ Mastering Power BI Video Course
    www.innozant.c...
    ✅ Mastering VBA Video Course
    www.innozant.c...
    ✅ Mastering SQL Video Course
    www.innozant.c...
    Visit - innozant.com
    =====================================================
    ===========HYBRID CLASSES============================
    ✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
    ✅ Database Training(SQL , PL\SQL , Oracle Developer)
    ✅ Mastering Data Science
    Visit - innozant.com
    ====================================================
    Videos in a Sequence -Basic to Advanced EXCEL
    Basic Excel- • Basic Excel-The Learni...
    Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
    Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
    Excel What if Analysis- • Excel What if Analysis
    Excel Array and Sumproduct- • Excel Array & Sumprodu...
    Excel Lookup Functions- • Excel Lookup Functions...
    Excel Pivot Tables- • Excel Pivot Tables
    Excel Power Pivot- • Excel Power Pivot
    Excel Power Query- • Excel Power Query
    Excel Chart and Infographics- • Excel Chart and Infogr...
    Excel Dashboard & Reports- • Excel Dashboard & Reports
    Value add-ons Playlist
    ProQuest-Check Point- • Excel ProQuest-Check P...
    Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
    StudsTalk -The Journey begins- • StudsTalk-The Journey ...
    QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
    Excel Tips and Tricks- • Excel Tips & Tricks
    MIS Interview Cracker- • MIS Interview Cracker
    MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
    Excel Maharaj- • EXCEL MAHARAJ - For Ex...
    Microsoft Powerpoint- • Microsoft Powerpoint
    Microsoft Word- • Microsoft Word
    Office 365- • Office 365
    Google Sheets- • Google Sheets
    Microsoft Outlook- • Microsoft Outlook
    Power BI- • Power BI
    Excel VBA- • Excel VBA Macro
    TezXL Jata Shorts- • #shorts | जो TRIM के ब...
    Announcements- • Announcements
    Website - "www.innozant.com"
    Let's Connect:
    Instagram ► / innozantinfotech
    Facebook ► / innozantinfotech
    Telegram►t.me/innozanti...
    #innozant #exceltricks #indexformula#indexmaharaj

Комментарии • 61

  • @surendrarajput731
    @surendrarajput731 8 месяцев назад +1

    Good Teaching sir ji, Aapke video se Mera mis me intrest aaya h

  • @createyour6681
    @createyour6681 8 месяцев назад +1

    great video sir

  • @thebeast-ks4ph
    @thebeast-ks4ph 8 месяцев назад

    On whole RUclips i find only your channel without missing any topic and content.thank you guruji♥️.i wonder why your channel is having less subscribers

    • @Innozant
      @Innozant  8 месяцев назад

      Thanks dear for your valuable feedback.Keep learning and Keep growing

  • @Ann_2208
    @Ann_2208 8 месяцев назад +4

    Excel tak toh thik but salary range me 30k tak hi mil Rahi or Jayda salary ke lye SQL mang rahe hai kese sikhu ab

    • @nishachauhan5636
      @nishachauhan5636 8 месяцев назад

      Aapne Excel mai vba bhi sikha hai

    • @Ann_2208
      @Ann_2208 8 месяцев назад +1

      @@nishachauhan5636 nhi mere case me aksar Aisa hota hai ki me Sikh toh lu but sikhne ke bad koi job nhi deta sab bolte experience ab organisation ka experience kaha se dikhau

    • @HoneyGymnastt
      @HoneyGymnastt 8 месяцев назад

      Right Bro​@@Ann_2208

  • @Saluja2407
    @Saluja2407 8 месяцев назад +1

    Sir youtube pr apke chnanels pr hee mis aur excel ki achi videos aur playlist h... But yrr kise na bhi data anylast ka upar koe videos aur playlist nhi bnayi h...Sir pls ap data anylast ki videos bhi provide krvao...

    • @Innozant
      @Innozant  8 месяцев назад

      Video aate rhenge..keep learning

  • @syedfaraz1903
    @syedfaraz1903 5 месяцев назад

    Good 😊

  • @ahmadghaffar6213
    @ahmadghaffar6213 8 месяцев назад

    ❤Plz make full video of excel interview questions and answers like this videos in which include dashboard and MIS reports.....

  • @susmitapoddar3889
    @susmitapoddar3889 8 месяцев назад

    sir maine pura excel ap hi sai sikha hai, ab data analyst ki tyaari kar rahi
    hu aisa vedio hi aur upload kijiye sir bohot help hoga

    • @Innozant
      @Innozant  8 месяцев назад

      Thanks dear..haan upload hoga aur videos

  • @Altaf_Alam
    @Altaf_Alam 8 месяцев назад +1

    Thank u very much sir ❤
    Sir plz upload the short videos of your last beautiful lines 😊❤

  • @Altaf_Alam
    @Altaf_Alam 8 месяцев назад +1

    3. We can use DSUM function 😊❤

  • @abhisheksinha8120
    @abhisheksinha8120 8 месяцев назад +1

    Sir i am very benefited from you Excel videos
    I want to learn vba so please let me know how i get you all vba lecture video.

    • @Innozant
      @Innozant  8 месяцев назад

      Visit innozant webskte for more details

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 8 месяцев назад +1

    🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹 🌹 सीखते रहो, सिखाते रहो l❤
    🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤

  • @shivii88
    @shivii88 8 месяцев назад +1

    I'm first sir and I'm also want this type video

    • @Innozant
      @Innozant  8 месяцев назад

      Thanks dear

  • @aakashkumarverma281
    @aakashkumarverma281 8 месяцев назад

    Sir apki kripa se excel me bht acha hu aur logical hu with data studio google site gsuit vba power bi ye sab ata he pls isi skill ko use karke me achi income karna chahta hu pls help me sir

    • @Innozant
      @Innozant  8 месяцев назад

      Ye skills seekhna ht jaroori h career growth ke liye

  • @vasimshaikh5833
    @vasimshaikh5833 8 месяцев назад

    Value added questions 😊💯✌️

  • @abhishekchaubey4789
    @abhishekchaubey4789 8 месяцев назад

    Sir please make video on business analyst also.. 🙏

  • @Altaf_Alam
    @Altaf_Alam 8 месяцев назад

    2. No, vlookup is not case sensitive 😊

  • @AB_MAFIYA
    @AB_MAFIYA 8 месяцев назад

    Sir mai apka fan ban Gaya hu sie ek video nse option chain data feed in Google sheet live or banaiye na please..

  • @joydeepsen594
    @joydeepsen594 8 месяцев назад

    Jha sir please make a video series of these and topics are SQL,EXCEL and Power Bi,Power Query.It will be more helpful for us.

    • @Innozant
      @Innozant  8 месяцев назад

      Except sql all playlist are there in sequence .kindly check all playlist

  • @matrixeducationbangladesh5141
    @matrixeducationbangladesh5141 8 месяцев назад

    Good

  • @mayurrajude
    @mayurrajude 8 месяцев назад

    kindly give us an Excel formula I have an Excel 365 version, so kindly base my Excel 365 below mention -
    We own some assets that have been acquired in different financial years. There is a specific condition to be applied while calculating the depreciation of these assets. If an asset was procured before September, a depreciation rate of 15% will be applied. However, if it was acquired after September, a rate of 7.5% will be applied. For the initial purchase of an asset, we will apply the specified conditions accordingly. After the first year, a consistent depreciation rate of 15% will be applied for every annual procurement.

  • @hafizuddin9507
    @hafizuddin9507 8 месяцев назад

    Sir! I m ur big fn, Plz help me, about RANK
    If i have two or more ranges, mark, grade to rank,
    For example,
    Masud: grade-5, mark-80
    Rana: grade-5, mark-88
    Robi: grade-5, mark-70
    Lina: grade-4.90, mark- 90
    I want, it 1st rank by grade, if there same grade got more then 1 student, that case it will rank by mark...
    How to do it sir, plz help

  • @prajwalshetty2047
    @prajwalshetty2047 8 месяцев назад

  • @sadashivkage3133
    @sadashivkage3133 8 месяцев назад

    🙏🙏

  • @Abhisheksoni8738
    @Abhisheksoni8738 8 месяцев назад

    nice sir ji.sir in how many days can learn sql

  • @Abhisheksoni8738
    @Abhisheksoni8738 8 месяцев назад

    i have a multiple phone number and i want to extract only those number which have last 3 digit 345. using filter in excel sir give the solution

  • @MuhammadRamzan-rz5kw
    @MuhammadRamzan-rz5kw 8 месяцев назад

    Sir I want u help in excel data ?

  • @ishtiyahmad
    @ishtiyahmad 8 месяцев назад

    I am first ❤ sir

  • @adarsh_p16
    @adarsh_p16 8 месяцев назад

    Sir please teach us SQL

  • @ujjawalanand5216
    @ujjawalanand5216 8 месяцев назад

    as a fresher data analyst ki hiring kb se start hogi sir

  • @dakshbachhety97
    @dakshbachhety97 8 месяцев назад

    Hello Sir,
    Mai gurgaon me rhta hu or apke institute me admission le k VBA or Power BI sikhna chahtu hu pls process btaye

    • @Innozant
      @Innozant  8 месяцев назад

      Innozant website visit kriye ya team innozant se call par connect krkd detail lijiye

  • @KaranSaim
    @KaranSaim 8 месяцев назад

    Sir actually I know I can clear machine round interview but technical round I won't clear.😀😀

  • @parulgulati9331
    @parulgulati9331 8 месяцев назад

    please provide some practical practice question also

    • @Innozant
      @Innozant  8 месяцев назад

      Assignmemt master folder link is there in video description

    • @Abhisheksoni8738
      @Abhisheksoni8738 8 месяцев назад

      i have a multiple phone number and i want to extract only those number which have last 3 digit 345. using filter in excel

    • @parulgulati9331
      @parulgulati9331 8 месяцев назад

      @@Abhisheksoni8738 ..use formula right to extract last 3 no.

    • @Abhisheksoni8738
      @Abhisheksoni8738 8 месяцев назад

      @@parulgulati9331 thank you I know but I want to extract using filter option

  • @sswrogaming3070
    @sswrogaming3070 8 месяцев назад

    1

  • @Farhansaikh00
    @Farhansaikh00 8 месяцев назад

    Sir, tell me how to join your class

    • @Innozant
      @Innozant  8 месяцев назад +1

      Kindly call/connect with team innozant or visit innozant channel

    • @Farhansaikh00
      @Farhansaikh00 8 месяцев назад

      @@Innozant

    • @Farhansaikh00
      @Farhansaikh00 8 месяцев назад +1

      @@Innozant How can I contact you?

  • @mayursaini27
    @mayursaini27 8 месяцев назад

    Approximate

  • @saifahmad2134
    @saifahmad2134 8 месяцев назад

    I am second 😂