Learn With Sundar

Get Started

  • SQL Server sp_execute_external_script Stored Procedure – Get Started with SQL Server Machine Learning Services – Part 3

    Introduction When we want to execute any external language script in SQL Server, then we have to sp_execute_external_script stored procedure. sp_execute_external_script  is a new system stored procedure which was introduced in the SQL Server 2016. It is mainly used to execute the Machine Learning Services such as Python and R in SQL Server. Executing Python…

  • Power BI Tips and Tricks – Power BI Dashboard Tutorials

    Introduction Who will say to NO to know some tips and tricks which will improve our productivity and also makes task simpler. In this article, we will discuss some important simple tips and tricks in Power BI to create Dashboards and reports. 5 Simple Tips and Tricks If we want to keep same visualization for…

  • Connect Power BI With Different Data Sources

    Introduction In the previous article, we discussed about the different data sources that can provide data for Power BI. In this article we will learn how to connect those data sources with Power BI. I recommend you to refer the previous article to get better understanding. As mentioned before, in this article we will learn,…

  • Data sources for the Power BI

    Introduction In this article, we will learn “How to connect Power BI with difference Data Sources”. With Power BI, we can connect different types of data such like from Excel to Online data. Connecting Power BI with Different Data Sources Select Get Data option from the Home Menu in the Ribbon tool. This will list…

  • SQL Query To Increase Salary By Percentage For All Employees In A Table

    Introduction Sometimes we may need to increase the current column value by Percentage. The very good example is Salary in an organization. We need to update the salary of each employee based on the Hike Percentage. Increasing Salary By Percentage In this example, lets assume the Hike percentage is equal for all employees, and I…

  • What is Power BI Desktop – Quick Overview to Power BI Desktop

    Introduction If we want to access Power BI for FREE, then Power BI Desktop is option, a free application that we can install on our local computer that lets us connect to, transform, and visualize your data. We can create Data Model by connection to multiple different data sources. With this data model we can build…

Subscribe

Enter your email below to receive updates.