Author: datapandasadmin

How To Track The Effectiveness of Email Campaign – Some Points to Consider

Bydatapandasadmin

Sometimes, you would want to track the effectiveness of your email marketing campaign. How do you start ? What do you look out for ? and What are some of the key things to consider. This lists some key things to look out for when tracking the effectiveness if your email campaigns Get access Access…

| |

Using Subqueries To Join 2 More Tables Which Do Not Have Unique Primary and Foreign Keys

Bydatapandasadmin

Using Subqueries to join 2 more tables which do not have distinct values in a column We want to find the number of Flight bookings by Country, number of Car bookings by Country and the number of Hotel bookings by Country all appearing in one table with same country on one row. We want to…

|

Rank a Place Visited By a Customer- Microsoft SQL Server – T-Transact

Bydatapandasadmin

This is a short guide to getting ranking or rating from Microsoft Sql Server customers. Ranking is taken by checking how many times a customer has visited a particular country divided by the total number of travels the customer has made within the database   /*make a back up of the recommender rankings table*/ truncate…

| |

Automatically Open Excel and Send Report Using Batch and VBA

Bydatapandasadmin

  We can use Visual Basic codes to automate some reports in Excel. Below are some simple codes to do this. First this is a batch file to open our Excel report called “data report.xlsm”, assuming the report file is in the same folder as the batch file. You can schedule the time this batch file is…

|

Splitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server

Bydatapandasadmin

Sometimes, you would want to split values in a column into separate rows  in SQL server.  This is a simple guide. Lets check the fields in the table we will be working with. select [orderID] ,[itemType] ,[price] ,[quantity] from [Antrak].[dbo].[ClothingSale] Let’s check the result:   We can see that the itemType field has different values…

Decision Tree Price Optimisation – Regression Tree
|

Decision Tree Price Optimisation – Regression Tree

Bydatapandasadmin

Price Optimisation can be achieved in several ways. I did a simple analysis of how you can use Decision Tree to price optimise a product. This article was published on Data Science Central which can be fully read here: Price Optimisation Using Decision Tree (Regression Tree) – Machine Learning   I  have received a lot…