Achievers Data Engineering
Achievers Data Engineering
  • Видео 78
  • Просмотров 260 834
SQL Interview Questions & Answers | Part 9 | SQL query to list employee and manager name.
Hi Data Enthusiasts,
Welcome the video series of SQL interview question and answers. This is Part 8 of SQL Interview Question and Answers series.
I will try to add as many as questions in this series based on my experince along with this if you want me add any question then you let me know in the comments or drop me an email at achieversdataeninerring@gmail.com I'll make sure to make video on it asap.
In this video I have discussed about a common interview question related to writing a logical SQL query.
in this video we have discussed the question about writing a query to list all employees and their managers, including employees who do not have a manager
I'm sure it will help you to clear yo...
Просмотров: 195

Видео

SQL Interview Questions & Answers | Part 8 | Populate numbers from 1 to 10 without any function
Просмотров 3213 месяца назад
Hi Data Enthusiasts, Welcome the video series of SQL interview question and answers. This is Part 8 of SQL Interview Question and Answers series. I will try to add as many as questions in this series based on my experince along with this if you want me add any question then you let me know in the comments or drop me an email at achieversdataeninerring@gmail.com I'll make sure to make video on i...
SQL Interview Questions & Answers | Part 7 | How to select which column to index in SQL
Просмотров 753 месяца назад
Hi Data Enthusiasts, Welcome the video series of SQL interview question and answers. This is Part 7 of SQL Interview Question and Answers series. I will try to add as many as questions in this series based on my experince along with this if you want me add any question then you let me know in the comments or drop me an email at achieversdataeninerring@gmail.com I'll make sure to make video on i...
SQL Interview Questions & Answers | Part 6 | Difference Between Clustered and Non Clustered Index
Просмотров 1063 месяца назад
Hi Data Enthusiasts, Welcome the video series of SQL interview question and answers. This is Part 6 of SQL Interview Question and Answers series. I will try to add as many as questions in this series based on my experince along with this if you want me add any question then you let me know in the comments or drop me an email at achieversdataeninerring@gmail.com I'll make sure to make video on i...
SQL Interview Questions & Answers | Part 5 | Use case of Lag Function
Просмотров 1423 месяца назад
Hi Data Enthusiasts, Welcome the video series of SQL interview question and answers. This is Part 5 of SQL Interview Question and Answers series. I will try to add as many as questions in this series based on my experince along with this if you want me add any question then you let me know in the comments or drop me an email at achieversdataeninerring@gmail.com I'll make sure to make video on i...
SQL Interview Questions & Answers | Part 4 | Use case of Lead Function
Просмотров 973 месяца назад
Hi Data Enthusiasts, Welcome the video series of SQL interview question and answers. This is Part 4 of SQL Interview Question and Answers series. I will try to add as many as questions in this series based on my experince along with this if you want me add any question then you let me know in the comments or drop me an email at achieversdataeninerring@gmail.com I'll make sure to make video on i...
SQL Interview Questions & Answers | Part 3 | What would be the Row count after applying JOIN?
Просмотров 1544 месяца назад
Hi Data Enthusiasts, Welcome the video series of SQL interview question and answers. This is Part 3 of SQL Interview Question and Answers series. I will try to add as many as questions in this series based on my experince along with this if you want me add any question then you let me know in the comments or drop me an email at achieversdataeninerring@gmail.com I'll make sure to make video on i...
SQL Interview Questions & Answers | Part 2 | Aggregation Query
Просмотров 1094 месяца назад
Hi Data Enthusiasts, Welcome the video series of SQL interview question and answers. This is Part 2 of SQL Interview Question and Answers series. I will try to add as many as questions in this series based on my experince along with this if you want me add any question then you let me know in the comments or drop me an email at achieversdataeninerring@gmail.com I'll make sure to make video on i...
SQL Interview Questions & Answers | Part 1| Query execution Order
Просмотров 1344 месяца назад
Hi Data Enthusiasts, Welcome the video series of SQL interview question and answers. This is Part 1 of SQL Interview Question and Answers series. I will try to add as many as questions in this series based on my experince along with this if you want me add any question then you let me know in the comments or drop me an email at achieversdataeninerring@gmail.com I'll make sure to make video on i...
Part 13 : Parameterize Pipeline in Azure Data Factory
Просмотров 753Год назад
#Azure @MSDataFactory #etl #LearnADF #datafactory #azuredatafactory #achieversdataengineering Join our WhatsApp channel to get updates on all videos and community support- whatsapp.com/channel/0029VaAX4xJ1dAw0gtRvf72r Hi, This is part 12: Introduction to the Azure Data Factory tutorial series. This Playlist will cover all you need to know to get started with Azure Data Factory. By end of the pl...
Part 12: Parameterize Data Sets in Azure Data factory
Просмотров 494Год назад
#Azure @MSDataFactory #etl #LearnADF #datafactory #azuredatafactory #achieversdataengineering Join our WhatsApp channel to get updates on all videos and community support whatsapp.com/channel/0029VaAX4xJ1dAw0gtRvf72r Hi, This is part 12: Introduction to the Azure Data Factory tutorial series. This Playlist will cover all you need to know to get started with Azure Data Factory. By end of the pla...
Part 11: Parameterize linked services in Azure Data factory
Просмотров 941Год назад
#Azure @MSDataFactory #etl #LearnADF #datafactory #azuredatafactory #achieversdataengineering Join our WhatsApp channel to get updates on all videos and community support whatsapp.com/channel/0029VaAX4xJ1dAw0gtRvf72r Hi, This is part 11: Introduction to the Azure Data Factory tutorial series. This Playlist will cover all you need to know to get started with Azure Data Factory. By end of the pla...
Part 10: Copy Data from on-prem to Azure using Data factory | Setup self hosted Integration Run time
Просмотров 1,4 тыс.Год назад
#Azure @MSDataFactory #etl #LearnADF #datafactory #azuredatafactory #achieversdataengineering Join our WhatsApp channel to get updates on all videos and community support whatsapp.com/channel/0029VaAX4xJ1dAw0gtRvf72r Link to Microsoft document - learn.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime?tabs=data-factory Hi, This is part 10: Introduction to the Azure Da...
Part 9 : Monitor Pipelines in Azure data Factory
Просмотров 1,8 тыс.Год назад
#Azure @MSDataFactory #etl #LearnADF #datafactory #azuredatafactory #achieversdataengineering Join our WhatsApp channel to get updates on all videos and community support whatsapp.com/channel/0029VaAX4xJ1dAw0gtRvf72r Link to Microsoft document - learn.microsoft.com/en-us/azure/data-factory/tumbling-window-trigger-dependency Hi, This is part 9: Introduction to the Azure Data Factory tutorial ser...
Part 8: Tumbling window Triggers in Azure data Factory | Azure Data Factory Tutorial for beginners
Просмотров 814Год назад
#Azure @MSDataFactory #etl #LearnADF #datafactory Join our WhatsApp channel to get updates on all videos and community support whatsapp.com/channel/0029VaAX4xJ1dAw0gtRvf72r Link to Microsoft document - learn.microsoft.com/en-us/azure/data-factory/tumbling-window-trigger-dependency Hi, This is part 8: Introduction to the Azure Data Factory tutorial series. This Playlist will cover all you need t...
Part 7: Triggers in Azure Data Factory | Schedule Trigger | Storage Event Trigger | Custom Trigger
Просмотров 606Год назад
Part 7: Triggers in Azure Data Factory | Schedule Trigger | Storage Event Trigger | Custom Trigger
Part 6: Copy Activity in Azure data Factory | Creating Linked Service | Create Data Set
Просмотров 1,5 тыс.Год назад
Part 6: Copy Activity in Azure data Factory | Creating Linked Service | Create Data Set
Part 5: Copy Activity in Azure data Factory - Creating required resources
Просмотров 386Год назад
Part 5: Copy Activity in Azure data Factory - Creating required resources
Part 4: Azure data Factory Key components | Pipeline | Activity | Data flows | Runtime
Просмотров 337Год назад
Part 4: Azure data Factory Key components | Pipeline | Activity | Data flows | Runtime
Part 3: Navigating in Azure data Factory
Просмотров 372Год назад
Part 3: Navigating in Azure data Factory
Part 2: Creating your First Azure data Factory
Просмотров 442Год назад
Part 2: Creating your First Azure data Factory
Part 1: Introduction to Azure data Factory | Azure Data Factory overview | ADF Tutorial
Просмотров 2 тыс.Год назад
Part 1: Introduction to Azure data Factory | Azure Data Factory overview | ADF Tutorial
Chat GPT Real World Challenges and Practical Use Cases
Просмотров 192Год назад
Chat GPT Real World Challenges and Practical Use Cases
Text Analytics in Power BI : Use AI in power BI to perform Sentimental Analysis
Просмотров 6 тыс.Год назад
Text Analytics in Power BI : Use AI in power BI to perform Sentimental Analysis
Power BI Administration: Admin Portal Part 1 - Tenant Settings
Просмотров 3,5 тыс.Год назад
Power BI Administration: Admin Portal Part 1 - Tenant Settings
Power BI Interview Question and Answers: Live Recorded Interview on Power BI, SQL
Просмотров 1,4 тыс.2 года назад
Power BI Interview Question and Answers: Live Recorded Interview on Power BI, SQL
Power BI Interview: Live recorded Power BI interview
Просмотров 4,8 тыс.2 года назад
Power BI Interview: Live recorded Power BI interview
Power BI Interview Question & Answers: Handling multiple Dates and Date Slicers in power BI Report
Просмотров 1,5 тыс.2 года назад
Power BI Interview Question & Answers: Handling multiple Dates and Date Slicers in power BI Report
Power BI Tips & Tricks- Data Visualization Best Practices (Microsoft PBI Team Recommended)
Просмотров 7822 года назад
Power BI Tips & Tricks- Data Visualization Best Practices (Microsoft PBI Team Recommended)
11 Data Transformation - Adding Columns in Power BI Query Editor
Просмотров 8832 года назад
11 Data Transformation - Adding Columns in Power BI Query Editor

Комментарии

  • @robertotosta5334
    @robertotosta5334 14 дней назад

    Amazing!

  • @rahulrajput4060
    @rahulrajput4060 15 дней назад

    Thx for this video it was very easy to understand

  • @naveenshindhe2893
    @naveenshindhe2893 21 день назад

    When Power BI assets, such as reports, datasets, dataflows, etc., are published in a new tenant, their GUIDs (globally unique IDs) change, should we make a note of this, can you please reply

  • @Felix-yb7tl
    @Felix-yb7tl 26 дней назад

    Thank you for this clear and concise example!! Can you show us how to create a visual for a comparison analysis on spending by different customers over different months? Keeping the percentage/variance change as a visual!

  • @emmanuelaolaiya
    @emmanuelaolaiya Месяц назад

    Thank you so much

  • @JohnDataAnalyst
    @JohnDataAnalyst Месяц назад

    you are too fast and you dont explain each step especially for newbies

    • @AchieversDataEngineering
      @AchieversDataEngineering Месяц назад

      Thank you for watching. You slow down the video by going into settings. If you have a question related to any topic please feel free to reach out me.

  • @SaiSeravan
    @SaiSeravan 2 месяца назад

    Part 2 ?

  • @simonfook
    @simonfook 2 месяца назад

    very clear step by step video, many thanks and like it!!!

  • @Jan-b6z6f
    @Jan-b6z6f 2 месяца назад

    You saved my life! Thank you!!!

  • @Sirigineedi_Navann
    @Sirigineedi_Navann 3 месяца назад

    Thanku brother 😊

  • @ayushimaurya88
    @ayushimaurya88 3 месяца назад

    Good info, thank you for posting!

  • @arupanandabehera1527
    @arupanandabehera1527 3 месяца назад

    Good job

  • @Basha-f2t
    @Basha-f2t 3 месяца назад

    For keep learning Please add more vidoe's on other important topics and as your concept is very clear and understandable. Thank you for your efforts.

  • @Sirigineedi_Navann
    @Sirigineedi_Navann 3 месяца назад

    wonderful one brother thank you so much

  • @mandarchavan1036
    @mandarchavan1036 3 месяца назад

    Keep it up ..waiting for today’s video

    • @AchieversDataEngineering
      @AchieversDataEngineering 3 месяца назад

      Here is today's videos - ruclips.net/video/3ozm2ICHS70/видео.html Thank you for watching!

  • @mandarchavan1036
    @mandarchavan1036 4 месяца назад

    Thanx for providing link in distribution…good improvement…keep it up..waiting for tomorrow

  • @mandarchavan1036
    @mandarchavan1036 4 месяца назад

    if it is possible for you so share csv file or copy pest everything on transcript..it will be greate help

    • @AchieversDataEngineering
      @AchieversDataEngineering 4 месяца назад

      I have added the query in a text file you can download it from below location- drive.google.com/file/d/1a-2rai-F3fUip65-f3Kk9pwT4us0v53X/view?usp=sharing Thank you!

  • @mandarchavan1036
    @mandarchavan1036 4 месяца назад

    you are doing great but try to upload at least one quation every day

    • @AchieversDataEngineering
      @AchieversDataEngineering 4 месяца назад

      I definitely want to make this possible. Thank you for your support! 🙏

  • @seshulatha
    @seshulatha 4 месяца назад

    You r Awesome 🎉

  • @ganeshhon8345
    @ganeshhon8345 4 месяца назад

    Thank you, its really helpfull

  • @nishant98
    @nishant98 4 месяца назад

    keep up the good work my guy !

  • @reteshp1170
    @reteshp1170 4 месяца назад

    Hi Great video! Do you have any examples where you are comparing a months from the current year and previous year? If I select the year 2022 and month September then it should compare the data between September 2021 and September 2022.

    • @AchieversDataEngineering
      @AchieversDataEngineering 4 месяца назад

      Thank you! we can such view using below process- 1) Create single select slicer for year and month. 2) Create measure for selected value to get selected year and month 3) Create same period last year DAX and use selected year and month value as variable from above DAX, to get the last year/month value. Hope it helps. Thank you!

  • @pujachandra2652
    @pujachandra2652 4 месяца назад

    How to apply this trick on table? As I see am not able to hide the column headers.

    • @AchieversDataEngineering
      @AchieversDataEngineering 4 месяца назад

      For table headers, try setting up conditional formatting to make it white or to match the background based on a measure. Like when row count is zero, set column header text to white.

  • @AdrianCoronado-c1s
    @AdrianCoronado-c1s 5 месяцев назад

    Do you have any advice to make it more dynamic? in the way where I can change the month to week, day o quarter?

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

      Yes, It is possible to achieve what you have mentioned. It would be little complex. With use of selectedvalue, Bookmarks, calendar table it can be done.

  • @AdrianCoronado-c1s
    @AdrianCoronado-c1s 5 месяцев назад

    Two years ago was this video posted and still being useful, thank you! Do you have any advice to make it more dynamic? in the way where I can change the month to week, day o quarter?

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

      I'm Glad it was helpful. Please feel free to drop me a detailed email and with some sample data if possible. We can try to achieve what you are looking for.

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

    you are amazing thanks

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

    hi i am completely new to azure data factory ,,, i am facing an issue while creating a linked service connecting to on premise sql server via self hosted integration runtime in order to copy data from on-premise sql server to azure ,, while testing connection it says connection failed and the error message is Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'WIN-I2HINOLIHH5\SQLEXPRESS', Database: 'northwind', User: 'sa'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) The certificate chain was issued by an authority that is not trusted Plz help me out,, if possible i can also share my screen via any conferencing medium

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

    good video structure

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

    Excellent tutorial! Very helpful!

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

    sir where can i find the data please @ACAchieversDataEngineering

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

      There is n number of source available for free data. Best option install SQL server free developer version in your laptop and try AdventureWorks sample databases. Links given below. www.microsoft.com/en-in/sql-server/sql-server-downloads learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms Let me know in case any issue. Thank you!

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

    Thanks for the video Please create a video about how to have a custom message when no data in chart

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

      Thank you for your positive comment. " video about how to have a custom message when no data in chart" I believe this is what I have discussed in this video, if no please let me know the details will try to figure out something. Thank you for watching.

  • @deeswift-z1h
    @deeswift-z1h 6 месяцев назад

    Hi , Can you kindly create it with DAX and other calculations which can show page numbers

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

      Well that is a good question. I will try out something. Thank you for watching.

  • @AndyPrice-h2y
    @AndyPrice-h2y 6 месяцев назад

    Fantastic explanation - thankyou.

  • @shrutikhanna3203
    @shrutikhanna3203 6 месяцев назад

    you skipped DataBricks to compare with them.

  • @mykhairulfirdaus
    @mykhairulfirdaus 6 месяцев назад

    Great explanation, very helpful!. How to create a calendar based on Financial Year April - March?

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

      Thank you! To create fiscal year, we can define fiscal year month end in calendar Auto DAX, and then create a calculated column for YYYY-YY as per our requirement. Thank you for watching. learn.microsoft.com/en-us/dax/calendarauto-function-dax

  • @dnyaneshwarudhare1074
    @dnyaneshwarudhare1074 7 месяцев назад

    thanks

  • @mahmoudtalaat9770
    @mahmoudtalaat9770 7 месяцев назад

    Can you write new measure

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

      Sorry for the delayed response. can you please explain the issue like which measure. We can look into it. Thank you for watching.

  • @kanikasharma6509
    @kanikasharma6509 7 месяцев назад

    Part 2 link?

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

      Will share it soon!

    • @sairamhb
      @sairamhb 4 месяца назад

      @@AchieversDataEngineering part 2 and whole thing of power bi admin

  • @anandrengasamy1298
    @anandrengasamy1298 7 месяцев назад

    Excellent one buddy

  • @alghbashnehmohammad9597
    @alghbashnehmohammad9597 7 месяцев назад

    When i add the verince it summrozed by sum so the % not reflected right i tried to change it to non summrized but it is not availbe it mandatory to selcet one choice sum ,avg ,medin ,, how i can fix this issue

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

    no further video came to show to pass parameters using config table.

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

    bhai subscribe ka itni der tar irritate karta hai, iska kuch karon

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

      Sure, Thank you for highlighting this. Will look into it and correct in upcoming videos.

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

    Thanks for sharing knowledge

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

    What is Sensitivity label in Power Bi and What is use the use cases?

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

      This can help - learn.microsoft.com/en-us/power-bi/enterprise/service-security-sensitivity-label-overview

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

    Please make videos on DAX, Dataware house, Spark Thanks

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

    Very Nice explanation, that Grid your using that we have implemented in our company MAQ Software 😊 Thanks

  • @bajigunturu1178
    @bajigunturu1178 9 месяцев назад

    Great explaination but that arrows and text only cards are going away and those are disappearing when you hover on it.. So that is the issue right, what is the Sol for thst

    • @AchieversDataEngineering
      @AchieversDataEngineering 9 месяцев назад

      Hi @bajigunturu1178 , While you are setting these objects in proper order using send back or bring front options, turn on the option to "maintain Layer order" too, it will work. You can also group them after arranging them in proper order. Thank you for watching.

  • @mummypoko1530
    @mummypoko1530 9 месяцев назад

    For the proactive preparation for text analysis, is it all using Power Bi can deal with or need collaborate with R or python to tokenize data?

  • @mummypoko1530
    @mummypoko1530 9 месяцев назад

    can u show how the text analysis show by bar chart or table?

  • @aftabsuco5233
    @aftabsuco5233 9 месяцев назад

    This is exactly i was looking for thanks a ton ♥