Menu

Data / BI

IT Spend Analysis sample dashboard

July 28, 2020
| No Comments
| Data / BI, Power BI, Sample work

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

April 16, 2020
| No Comments
| Power BI, Sample work

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

December 4, 2019
| No Comments
| Sample work, SQL

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

what is Data cleaning and standardisation? why we need it?

October 30, 2019
| 4 Comments
| Data cleaning and standardisation

As businesses generate and accumulate large amounts of data, it becomes a herculean task to remove unwanted or inaccurate data. While modifying such data sets requires effort, identifying and removing them are not easy either. Data cleaning identifies incorrect data and modifies it according to requirements. Data that is cleaned will then need to be transformed into a standard…

Read More

Pivot and Unpivot columns

October 30, 2019
| No Comments
| Power BI

In PowerBI there is a nifty trick where you can pivot or unpivot your data in the Query Editor. This saves you from having to do this in SQL or which ever source you are using for your data. There are just 4 simple clicks to pivot your data! First you need to select the column you want to…

Read More

SQL Server Functions

October 20, 2019
| No Comments
| SQL

SQL Scalar functions UCASE() – Converts a field to upper case LCASE() – Converts a field to lower case MID() – Extract characters from a text field LEN() – Returns the length of a text field ROUND() – Rounds a numeric field to the number of decimals specified NOW() – Returns the current system date and time FORMAT() –…

Read More

Stored Procedure – with example

October 14, 2019
| No Comments
| SQL

What is Stored Procedure? A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again. So if you have an SQL query that you write over and over again, save it as a stored procedure, and then just call it to execute it. You can also pass parameters…

Read More

SSRS – Introduction

October 1, 2019
| No Comments
| SSRS

SQL Server Reporting Services(SSRS) is a solution that customers deploy on their own premises for creating, publishing, and managing reports, then delivering them to the right users in different ways, whether that’s viewing them in web browser, on their mobile device, or as an email in their in-box. How does SSRS work? Below is the reporting life cycle follow by…

Read More

SSIS – Introduction

October 1, 2019
| No Comments
| SSIS

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data integration and data transformation tasks. It is basically an ETL tool part of the Microsoft Business Intelligence suit that is mainly used to achieve Data Integration. What is Data Integration ? Data integration…

Read More

SQL – A beginner’s guide

September 22, 2019
| No Comments
| SQL

Comments in SQL There are two ways in which you can comment in SQL, i.e. either the Single-Line Comments or the Multi-Line Comments. Single-Line Comments The single line comment starts with two hyphens (–). So, any text mentioned after (–), till the end of a single line will be ignored by the compiler. Multi-Line Comments  The Multi-line comments start with /* and end with */….

Read More

Verified by MonsterInsights