Colgate Global Business Services Data Analyst Interview Questions and Answers

Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.

• YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.

• QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.

• Thes...read more

Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.

• Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.

• Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.

• Import is suitable for smaller datasets, while direct query is better for large da

Developed a script for forecasting using KNN and data science models.

• Developed a script using Python to forecast sales for a retail company using KNN algorithm.

• Built a data science model to predict customer churn for a telecom company using logistic regression.

• Used time series analysis to forecast stock prices for a financial services company.

• Developed a script to predict the likelihood of a customer defaulting on a lo...read more