Skip to main content

ANN based Churn Prediction Model

Comments

Post a Comment

Popular posts from this blog

Sberbank Realty Price prediction Kaggle Challenge

Sberbank Challenge GitHub Code
Post a Comment
Read more

Aggregation using SQL (Game Consoles dataset)

Let's analyze the sales of Console Games. We are tasked to extract insights from the company. The dataset we will be using is the Console Games Dataset . I have imported the data into my MS SQL Server (Transact SQL). Table Design: Challenge #1: What are the total sales of video games in North America, Europe, and Japan. SELECT SUM(na_sales) AS TOTAL_NA_SALES, SUM(eu_sales) AS TOTAL_EU_SALES, SUM(jp_sales) AS TOTAL_JP_SALES FROM [dbo].[console_games]; Result:  In North America, the total sales were 4310.5M copies, in Europe, it was 2382.36M and in Japan it was 1266.38M. So what if I had to get the total sales in the world. The easier method would be to create a column to have total sales. Challenge #2: Create a new column to get the total sales. ALTER TABLE [dbo].[console_games] ADD global_sales float; UPDATE [dbo].[console_games] SET global_sales = na_sales + eu_sales + jp_sales + other_sales; Result: I have a new column with the glob...
Read more

Connecting your blogger.com blog to Google Analytics

Scenario 1: You are blogging one fine morning. You Notice that you have gained a large audience. You decide you want to cater better to your audience.  You want to understand your audience demographics better. Scenario 2: You are blogging one fine morning. You Notice that you have gained a large audience. You decide you want to sell your product on your blog. You need to understand where your bottlenecks are when selling your product. The best thing to do in both the scenarios is to connect your blog with google analytics. What is Google Analytics? According to Wikipedia, Google Analytics  is a  freemium   web analytics  service offered by  Google  that tracks and reports website traffic. To get an in-depth knowledge of Google Analytics, you can enroll in the free course that google offers. How do you connect and trach your blog's traffic on google analytics? First things first, set up your ...
Post a Comment
Read more