Azure, .NET, SharePoint/Office 365, Power Platform, ADF - Knowledge Base

Azure DevOps provides a feature called Query Editor where you can put your query using simple UI and run this. Simple query can be place/create here very easily. Complex query like join query would be a tricky one. Here, I tried to simplify how we can design a join query using Query Editor. Let's say I want to see all the bugs which already got closed or resolved by my team. Here, we know which ADO field is what for. For example ADO field AreaPath represents project team. In SQL term it is like SELECT * FROM MT-DEVOPS-PROJECT-DATA WHERE PROJECT=My-Project AND TYPE='Bug' AND (STATUS = 'Resolved' OR STATUS = 'Closed'  OR STATUS = 'Completed')

R is a programming languages, mostly used in statistical and analysis  purpose. It also provides good graphical representation, like chart can be created easily with analytical data. We are using machine learning and in Data Science computing as well. R is available as Free Software under GNU General Public License. Here is R project link -  https://www.r-project.org/about.html  and manual/documentation link -  https://cran.r-project.org/manuals.html R language can run on Unix as well as in Windows. You can download R from CRAN home page  https://cran.r-project.org/ . Both for Unix and Window. There is one great IDE for R as well, and this is from RStudio. Here you can download R Studio -  https://rstudio.com/products/rstudio/ Here more about  R from Wikipedia -  https://en.wikipedia.org/wiki/R_(programming_language) Also, link from public R official blog -  https://developer.r-project.org/Blog/public/ R do have some great features like below which makes more flexible on