IT Spend Analysis sample dashboard

The IT Spend Analysis sample analyses the planned vs. actual costs of an IT department. This comparison helps us understand how well the company planned for the year and investigate areas with huge deviations from the plan. The company in this example goes through a yearly planning cycle, and then quarterly it produces a new latest estimate (LE) to…

Read More

Power BI Dashboard

Hello Friends, in this article i am going to share some of my dashboard samples i have created using NSW public transport, School and Property median value data available online. My dashboard shows how the property median value of each suburb differs from the availability of  school and transport accordingly. The above image illustrates the Property median value by…

Read More

Calculating GeoDistance between two points

In this article, we are going to see how to calculate Geo-distance between two points using SQL server. You can calculate geo distance using spatial types – geography datatype in SQL server. This type represents data in a round-earth coordinate system, You can find out detailed information at Spatial type: Geography The default syntax for to convert Latitude and Longitude into Geography…

Read More

Verified by MonsterInsights