Unlocking Human Potential: A Guide to HR Analytics
Hello friends!! Today we’ll be learning about the HR analytics and potential.
Read moreAuthor: Niket Kedia
Approval using Power Automate for new file in SharePoint using
Hello friends!! Today we’ll be creating an approval system in Power Automate (formerly known as Microsoft Flow) for new file is added in a SharePoint. Attaching the Power Automate flow in the blog post to learn step by step the automation process.
Read moreMake Sudoku generator using Python
Hello friends! Today we’ll be learning create Sudoku generator using Python. This is simple python code in the tutorial.
Read moreDependent dropdown list in Excel
Hello friends! Today we’ll be learning create dependent drop down list in Excel. Excel sheet used in this tutorial is attached to this blogpost to download.
Read moreCreate the calendar table with Power Query
Hello friends! Today we’ll be learning create calendar table with Power Query. Creating a calendar table using Power Query can be beneficial for several reasons like Data Consistency, Customization, Data Modeling etc. using M language to generate a range of dates.
Read moreDifferent Methods to Find Unique Values in SQL
Hello friends! Today we’ll be learning different methods to find unique values in SQL. When working with large datasets in SQL, it is often essential to find unique values for analysis or reporting purposes. Thankfully, SQL provides several approaches to identify distinct or unique values within a column or a dataset.
Read moreConcatenate text from multiple rows into a single text string and vice versa
Hello friends! Today we’ll be learning how to concatenate text from multiple rows into a single text string and vice versa. Easy to follow code attached in the tutorial. When working with large datasets in SQL Server, it’s common to need to combine text from multiple rows into a single text string. This can be useful for creating reports, generating email notifications, or creating custom messages for users. In this blog post, we’ll explore some techniques for concatenating text from multiple rows in SQL Server.
Read more15 things to do with just a single line of Pandas code
Pandas is a popular library for data manipulation and analysis in Python. Here are 15 things you can do with just a single line of Pandas code.
Read more