What’s your experience in creating dashboards? Can you share what tools you’ve used for the purpose?

Dashboards are essential for managers, as they visually capture KPIs and metrics and help them track business goals. That said, data analysts are often involved in both building and updating dashboards. Some of the best tools for the purpose are Excel, Tableau, and Power BI (so make sure you’ve got a good command of those). … Read more

Which Excel functions have you used on a regular basis so far? Can you describe in detail how you’ve used Excel as an analytical tool in your projects?

If you are an Excel expert, it would be difficult to list all the functions you have experience using. Instead, concentrate on highlighting the more difficult ones, particularly statistical functions. If you have experience utilizing the more challenging functions, hiring managers will presume you have experience using the more basic ones. Be sure to highlight … Read more

How many years of SQL programming experience do you have? In your latest job, how many of your analytical projects involved using SQL?

SQL is considered as one of the easiest scripting languages to learn. So, if you want to be competitive on the job market as a Data Analyst, you should be able to demonstrate excellent command of SQL. Even if you don’t have many years of experience, highlight how your skills have improved with each new … Read more

What scripting languages have you used in your projects as a data analyst? Which one you you’d say you like best?

Most large companies work with numerous scripting languages. So, a good command of more than one is definitely a plus. Nevertheless, if you aren’t well familiar with the main language used by the company you apply at, you can still make a good impression. Demonstrate enthusiasm to expand your knowledge, and point out that your … Read more

What’s your knowledge of statistics and how have you used it in your work as a data analyst?

Data analysts should have basic statistics knowledge and experience. That means you should be comfortable with calculating mean, median and mode, as well as conducting significance testing. In addition, as a data analyst, you must be able to interpret the above in connection to the business. If a higher level of statistics is required, it … Read more