0

Auto Download Outlook Email Attachment – Code in VBA by Topbullets.com

Topbullets.comI get some raw data through email every day. Now when I want to do some analysis on the data I need to go through the inbox, search for that particular data and then download it to local. The process is very tedious. Now I am very happy that I have got rid of this manual process. Kudos to Google! I want to share the tutorial with very basic code. One can easily leverage the VBA code to write some complicated criteria and enhance it further. Here I am using snapshots from Outlook 2013 but have tested the feature in 2007 and was working fine. Without talking too much let’s start. Continue reading
0

Auto Send Email Through Outlook via Python Code – Topbullets.com

Topbullets.comI wrote an article on How to send email through ASP.NET and it helped a lot of people. Automating such processes always save lot of time and manual intervention. Currently in my project one process takes 45 minutes to run and one needs to look out at screen continuously for any error or if code stops in between. For that I wrote a python code which track the process and send email notification instantly if code stops or runs completely. The article can also be useful for someone who is looking for a python code to know which windows applications are running or open any Windows application using Python. Continue reading
0

[Solved] R code for AdStock rate in Marketing mix modeling

Topbullets.comMarketing mix is an important tool to understand the effect of our marketing budget and helps to prioritize different channels. In the role of data analyst you would certainly come across this term and sometimes you would need to develop a model for the same. As we discussed in our previous blog, AdStock is one of the most important entities in Marketing mix modeling and this should be addressed while developing the model. Today I am going to write R code for the same. I want to request you to read my previous article to understand the concept. Continue reading
0

Understanding the concept of Advertisement AdStock and Importance of it in Marketing Mix Modeling

Topbullets.comAs I wrote in my previous blog that advertisement is basically nothing but a paid version of promoting your brand or product or services. Please read it here if you want to know more about advertisement and different kinds of advertisements. So companies spend millions of dollars on ads not just to make awareness of their products but also to stay in customers’ mind (retention). What is retention? Let’s discuss it today. Continue reading
0

[Solved] Student Becomes the Teacher – Code Academy Problem’s Solution

Topbullets.comHello friends! From last few days I have been learning Python and I found Code Academy extremely helpful. The way they make you to solve a big problem into small small chunk is very helpful to understand each and every steps properly and increase the problem solving skills. I have been following their tutorial on Python and recently completed one not very tough but interesting problem on the combination of List, Dictionary and Function. I hope if you came here from Google then you must be trying to find the solution of “Grading the students” problem. Though it is not advisable to look after the solution; you should try harder but if you have done all your efforts and want to get some hints here is the solution. Continue reading