• Group M HR Data Analyst

    Group M HR Data Analyst position I saw Group M posted this job advertisement on 7 Aug 2021 and decided to help you identify the skills you require for the job. The link to the job advertisement can be found here https://www.linkedin.com/jobs/search/?currentJobId=2669934758&pivotType=jymbii And these are my opinion on what you need to have to excel in the job. Reporting to the Head of HR The HR Analyst is reporting to the Head of HR. This means that the person must have some knowledge of HR matters. This is what we call domain knowledge. Experience with tools and languages such as Tableau, Microsoft Power BI, SQL, R, Python The HR job…

  • Are you really a data-driven marketer?

    Running some ads and showing some numbers from the ad results does not help to make a data-driven marketer. Anyone can simply pick the numbers from the marketing campaign report and present the same numbers. To become a Data-Driven marketer, you need to Set up the marketing campaign the right way so that you can collect as much data as possible. If you do it wrongly, the data is gone forever.   Collating the data into Excel is the easiest and the cheapest option. If you can’t even handle the data in Excel, you can’t handle the data in any other tools. Analyze the results of your campaign. Every ad…

  • Are you aware of these 2 developments?

    A letter to those who have sent their staff for my training or who have attended my courses. Do you know these 2 developments?1.We have just launched a new advanced Excel course2.There is a skillsfuture credit for corporate 1. We have launched a new advanced Excel course How advanced is this Excel course? This course is even more advanced than “Hidden Secrets in Data Analysis in Excel”. In this course, we do not use worksheet functions. We use Power Query, a function that is designed to prepare your data for analysis. This function works exactly the same way as any data analytics tools (including Power BI and Tableau) out there…

  • This sounds like a lame question but it’s not

    This sounds like a lame question but it’s really not. When I asked this question in the workshop, most people gave different answers other than the right one. Every answer sounded logical and they all seemed correct. But until you really know how to define it, you are not really into data analytics. Knowing the right answer increases your sensitivity to data and helps build your foundation in data analytics. Want to know what is that question? . . . . The question is: What is Data? Want to know the answer? Come to our data analytics course to find out. http://www.everydayexcel.com/data-analytics/

  • Learning Excel is a dead end

    Learning Excel is a dead end He took aim at the body. It was easier to hit the body than the head. As he readied himself, he held his breath for a second and pulled the trigger. It was a perfect shot. 4 more rounds to go and each one of them was hit around the same area. “I am going to get my marksmanship this time round” He told himself. After all the practice that he had done, he believed his effort had paid off. When the result was announced, he was shocked. He failed his shooting test. He couldn’t believe it because he saw his last 5 shots…

  • The #1 rule of data analytics

    The first rule of data analytics

    The #1 rule of data analytics is not to touch the original data. By that, I DO NOT mean create a copy and work on it. You should still be using the original data but you should not make any change to the source file. All the changes should be done within the data analytics area. This area is available in Excel as well as Power BI. If you are able to fulfil this first rule, you will find that your analysis and/or your report is maintenance free. If you do not understand this first rule, you are not in data analytics yet. Sign up for our data analytics course…

  • where should you be in the next 10 years

    Where should you be in the next 10 years?

    For the last 20 years, you have invested your prime into becoming a domain expert. Those experience are valuable and cannot be easily replaced with just some text book knowledge or technology. But with the explosion of the internet, the learning curve to reach where you are now is going to be shorten. In order to stay relevant or reinvent yourself, you need to equip yourself with new skills.  Data Analytics is one of the up and coming skills that you can acquire to enhance your capability as a domain expert. It is not for IT. It is for domain experts like you who are in marketing, sales, supply chain,…

  • FB-video-ads

    How video ads perform in FB

    You have created a video and you would like to advertise in Facebook. Do you plan to advertise in post feeds, video feeds and/or stories? That depends on who you wish to attract. According to the stats I collected, it looks like post feeds is still gives you more exposure than video feeds. I have also placed ads on stories but there was no impression at all from FB or Instagram stories. That tells me that this stories do not work well for video ads. If your target group is woman, you should restrict your ads to woman only. If not, you budget will be wiped out by men who…

  • what is a data conqueror?

    What is a data conqueror? A Data Conqueror is one who can analyze any data given to him with minimal effort. He canclean any data,transform it to Pivot Table friendly format, andcombine multiple data sets together.A data conqueror makes use of our PACE framework to acquire data, model it, generate insights and help in making business decisions.Our course makes use of Excel as a base to learn data analytics. As you acquire data analytics skills in our course, you can apply your data analytics skills using other data analytics tools such as Power BI, Tableau, Watson Studios, etc.Here are some feedbacks from the graduates:”Save tremendous amount of time and effort…