Skip to main content

Posts

Showing posts from July, 2018

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...

How I am using Google Analytics to Track Job Applications

Finding a job in the US is a complicated process. It is challenging. If you are a student from another country then it gets tougher. You have to make yourself stand out from the crowd. How do you do that? One of the things that everybody suggests is to work on some interesting projects and display your work online. It's always great to have an online portfolio. The next thing you do is send cold emails to recruiters and try to network with them. How do you know the recruiter is interested? Well, they go through your blog and see if you have done anything that interests them. But did they have a look? That is where google analytics come up. Setup Google analytics with Blogger as shown in my earlier blog post . Now, you have to create a filter to filter yourself from the views. How to add a filter? 1. Open Google Analytics . 2. Click on the Admin ⚙ button. 3. Click on All Filters . 4. Click on the Filters Button . 5. Click on Add Filters . 6. Click on Create a ...

You Hungry? Use this dashboard to find restaurants in India.

Dataset:  Zomato Kaggle Dataset The dashboard acts as a tool to search for restaurants in the major cities of India.  Go ahead and select the city from the slicer and find out what is the average cost to have food in your city is. Do you want food to be delivered, click on deliveries and find out which restaurants deliver nearby? The dashboard was created using Microsofts Power BI.

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 ...

NYC Taxi Demand Prediction

Click here to check the code on NYC Demand Prediction

ANN based Churn Prediction Model

Click here to view my code on github

Sberbank Realty Price prediction Kaggle Challenge

Sberbank Challenge GitHub Code

Performance Analysis of Machine Learning Algorithms on Classification

Click to view GitHub Code

Power BI tutorial 1: Installing Power BI and creating a simple Bar Graph.

In this tutorial, we are going to look at how to install my favorite Business intelligence tool, Microsoft Power BI and also try to solve a problem using it. Installation steps: Step 1: Click on this link . Step 2: Under Power BI, click on the download button as shown in the image below. Step 3: After the download is complete. Double click and open the PBIDesktop.msi file and follow the instructions to complete the installation. Once the installation is complete, open Power BI from your start menu. Dataset : Download the Vancouver Crime dataset from Kaggle (crime.csv). Problem: We have been tasked to find out which crime has happened the most in Vancouver. So let's get started. 1. As shown in the figure, click on the Get Data button.  2. Select Text/CSV option and click on connect. 3. Select the crime.csv file from wherever you have saved it and click OK. 4. Click Load in the preview window. 5. If the data is load...