Achievers Data Engineering
Achievers Data Engineering
  • Видео 78
  • Просмотров 247 173
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...
Просмотров: 127

Видео

SQL Interview Questions & Answers | Part 8 | Populate numbers from 1 to 10 without any function
Просмотров 301Месяц назад
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
Просмотров 67Месяц назад
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
Просмотров 91Месяц назад
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
Просмотров 105Месяц назад
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
Просмотров 83Месяц назад
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?
Просмотров 1452 месяца назад
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
Просмотров 962 месяца назад
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
Просмотров 1052 месяца назад
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
Просмотров 614Год назад
#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
Просмотров 392Год назад
#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
Просмотров 813Год назад
#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,2 тыс.Год назад
#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,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/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
Просмотров 726Год назад
#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
Просмотров 533Год назад
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,3 тыс.Год назад
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
Просмотров 339Год назад
Part 5: Copy Activity in Azure data Factory - Creating required resources
Part 4: Azure data Factory Key components | Pipeline | Activity | Data flows | Runtime
Просмотров 303Год назад
Part 4: Azure data Factory Key components | Pipeline | Activity | Data flows | Runtime
Part 3: Navigating in Azure data Factory
Просмотров 326Год назад
Part 3: Navigating in Azure data Factory
Part 2: Creating your First Azure data Factory
Просмотров 396Год назад
Part 2: Creating your First Azure data Factory
Part 1: Introduction to Azure data Factory | Azure Data Factory overview | ADF Tutorial
Просмотров 1,8 тыс.Год назад
Part 1: Introduction to Azure data Factory | Azure Data Factory overview | ADF Tutorial
Chat GPT Real World Challenges and Practical Use Cases
Просмотров 182Год назад
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,1 тыс.Год назад
Power BI Administration: Admin Portal Part 1 - Tenant Settings
Power BI Interview Question and Answers: Live Recorded Interview on Power BI, SQL
Просмотров 1,4 тыс.Год назад
Power BI Interview Question and Answers: Live Recorded Interview on Power BI, SQL
Power BI Interview: Live recorded Power BI interview
Просмотров 4,7 тыс.Год назад
Power BI Interview: Live recorded Power BI interview
Power BI Interview Question & Answers: Handling multiple Dates and Date Slicers in power BI Report
Просмотров 1,4 тыс.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)
Просмотров 7582 года назад
Power BI Tips & Tricks- Data Visualization Best Practices (Microsoft PBI Team Recommended)
11 Data Transformation - Adding Columns in Power BI Query Editor
Просмотров 6692 года назад
11 Data Transformation - Adding Columns in Power BI Query Editor

Комментарии

  • @SaiSeravan
    @SaiSeravan 8 дней назад

    Part 2 ?

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

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

  • @Jan-b6z6f
    @Jan-b6z6f 24 дня назад

    You saved my life! Thank you!!!

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

    Thanku brother 😊

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

    Good info, thank you for posting!

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

    Good job

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

    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 Месяц назад

    wonderful one brother thank you so much

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

    Keep it up ..waiting for today’s video

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

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

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

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

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

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

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

      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 2 месяца назад

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

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

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

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

    You r Awesome 🎉

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

    Thank you, its really helpfull

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

    keep up the good work my guy !

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

    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 2 месяца назад

      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 2 месяца назад

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

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

      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 2 месяца назад

    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 2 месяца назад

      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 2 месяца назад

    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 2 месяца назад

      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 3 месяца назад

    you are amazing thanks

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

    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 3 месяца назад

    good video structure

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

    Excellent tutorial! Very helpful!

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

    sir where can i find the data please @ACAchieversDataEngineering

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

      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 3 месяца назад

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

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

      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 4 месяца назад

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

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

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

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

    Fantastic explanation - thankyou.

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

    you skipped DataBricks to compare with them.

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

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

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

      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 5 месяцев назад

    thanks

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

    Can you write new measure

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

      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 5 месяцев назад

    Part 2 link?

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

      Will share it soon!

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

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

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

    Excellent one buddy

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

    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 6 месяцев назад

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

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

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

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

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

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

    Thanks for sharing knowledge

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

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

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

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

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

    Please make videos on DAX, Dataware house, Spark Thanks

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

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

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

    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 6 месяцев назад

      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 7 месяцев назад

    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 7 месяцев назад

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

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

    This is exactly i was looking for thanks a ton ♥

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

    Thanks for your demo, but I think a lot of people would also like to be able to generate an action based on the selection in a list box or, for example, when the value of a 'Card' changes. I find it a limitation to be obliged to use a 'Button' object to associate an action. Do you have any idea if this is possible in any other way than with a button?

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

      Hi @stephanedegeye9539 , Thank you for watching and asking question. As per my knowledge and current features supported by Power BI, I don't so this possible to change chart view based on value selection other than button. But alternatively we can do below to achieve kind of similar results- 1) Using "Field parameters" to select and view different set of measures but in same chart type. 2) Using "Drill though" option to navigate to different page having different type of visual.

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

    So I watch de full video waiting for tips on de main image (how to select columns in a table view) but you never mentioned this except when you start the video... curious.

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

      Hi @rcbarbosa, You may go to Modeling >> Fields option and select the columns you want to see in a slicer. Once selected , check the option to add a slicer. It will automatically add a slicer having selected columns. Hope it will help. Thank you for watching.

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

    how to change the tenant setting to default setting?

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

    🙋 bro your videos are very helpful 👍 I have some doubt : I think for MOM% the calculation would be Divide( CurrentMonth - PreviousMonth / PreviousMonth ) instead of Vairance - PreviousMonth ? & I want to know that you have done 13 videos of ADF is it enough to get entry level job.....

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

      Hi @Mahesh717, Yes, you are correct it should be Divide( CurrentMonth - PreviousMonth / PreviousMonth ). Regarding ADF videos, It may not be sufficient but definitely a good way to start. Thank you for watching!

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

    Good 👍

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

    Tq bro ❤