- Видео 78
- Просмотров 247 173
Achievers Data Engineering
Индия
Добавлен 1 июл 2011
I'm glad that you have found something informative or interesting which dragged you to read about my channel.
Hi,
My name is Gyanendra Maurya. At the Achievers Data Engineering RUclips channel, I'm aiming to share the Data Engineering knowledge that I have gained over my professional experience.
If you're willing to learn, my content will help you acquire new data skills and help you to be a better Data enthusiastic person.
If you think I can be any form of help for your career change or you want me to make a video on any specific topic, feel free to reach out to me at achieversdataengineering@gmail.com or let me know in the comments of any video.
Thank you!
Keep Learning!
Hi,
My name is Gyanendra Maurya. At the Achievers Data Engineering RUclips channel, I'm aiming to share the Data Engineering knowledge that I have gained over my professional experience.
If you're willing to learn, my content will help you acquire new data skills and help you to be a better Data enthusiastic person.
If you think I can be any form of help for your career change or you want me to make a video on any specific topic, feel free to reach out to me at achieversdataengineering@gmail.com or let me know in the comments of any video.
Thank you!
Keep Learning!
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...
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
Part 2 ?
very clear step by step video, many thanks and like it!!!
Thank you! I'm glad it was helpful!
You saved my life! Thank you!!!
Thank you! I'm so glad that, it was helpful.
Thanku brother 😊
Thank you!, I'm glad it was helpful.
Good info, thank you for posting!
I'm glad it was helpful!
Good job
Thank you! I'm glad it was helpful.
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.
Thank you! I'm glad you found the videos helpful.
wonderful one brother thank you so much
I'm glad it was helpful. Thank you for watching and subscribing.
Keep it up ..waiting for today’s video
Here is today's videos - ruclips.net/video/3ozm2ICHS70/видео.html Thank you for watching!
Thanx for providing link in distribution…good improvement…keep it up..waiting for tomorrow
Thank you!
if it is possible for you so share csv file or copy pest everything on transcript..it will be greate help
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!
you are doing great but try to upload at least one quation every day
I definitely want to make this possible. Thank you for your support! 🙏
You r Awesome 🎉
Thank you! I'm glad it was helpful.
Thank you, its really helpfull
You're welcome! I'm glad it was helpful.
keep up the good work my guy !
Thank you!
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.
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!
How to apply this trick on table? As I see am not able to hide the column headers.
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.
Do you have any advice to make it more dynamic? in the way where I can change the month to week, day o quarter?
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.
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?
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.
you are amazing thanks
Thanks to you as well for this comment. I'm glad you liked it.
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
good video structure
Thank you! I'm glad it was helpful.
Excellent tutorial! Very helpful!
Thank you!, I'm glad it was helpful!
sir where can i find the data please @ACAchieversDataEngineering
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!
Thanks for the video Please create a video about how to have a custom message when no data in chart
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.
Hi , Can you kindly create it with DAX and other calculations which can show page numbers
Well that is a good question. I will try out something. Thank you for watching.
Fantastic explanation - thankyou.
Thank you!
you skipped DataBricks to compare with them.
Great explanation, very helpful!. How to create a calendar based on Financial Year April - March?
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
thanks
Thank you for watching.
Can you write new measure
Sorry for the delayed response. can you please explain the issue like which measure. We can look into it. Thank you for watching.
Part 2 link?
Will share it soon!
@@AchieversDataEngineering part 2 and whole thing of power bi admin
Excellent one buddy
Thank you! I'm glad it was helpful.
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
no further video came to show to pass parameters using config table.
Will post more videos soon.
bhai subscribe ka itni der tar irritate karta hai, iska kuch karon
Sure, Thank you for highlighting this. Will look into it and correct in upcoming videos.
Thanks for sharing knowledge
Thank you for watching.
What is Sensitivity label in Power Bi and What is use the use cases?
This can help - learn.microsoft.com/en-us/power-bi/enterprise/service-security-sensitivity-label-overview
Please make videos on DAX, Dataware house, Spark Thanks
Sure, We will try
@@AchieversDataEngineering yes please
Very Nice explanation, that Grid your using that we have implemented in our company MAQ Software 😊 Thanks
Great 👍Thank you!
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
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.
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?
can u show how the text analysis show by bar chart or table?
This is exactly i was looking for thanks a ton ♥
I'm glad it was helpful. Thank you for your comment.
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?
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.
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.
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.
how to change the tenant setting to default setting?
Hi, sorry for the delayed response, but I did not get your question.
🙋 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.....
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!
Good 👍
Thank you!
Tq bro ❤