UpScalio Business Analytics Manager Interview Questions and Answers

I have built interactive Tableau dashboards that provide actionable insights for business decision-making.

• I start by understanding the business objectives and key metrics to be tracked.

• I gather and clean the relevant data to ensure accuracy and completeness.

• I design the dashboard layout to present the data in a visually appealing and intuitive manner.

• I use Tableau's features like filters, parameters, and calculated fie...read more

Yes, it is possible to standardise datasources for different dashboards.

• Standardising datasources involves creating a unified data structure and format.

• Data can be transformed and cleaned to ensure consistency across dashboards.

• Using data integration tools or platforms can help automate the standardisation process.

• Examples of standardising datasources include merging multiple databases into a single source or convertin

SQL: Row numbers, group by and having

• Row numbers can be generated using the ROW_NUMBER() function in SQL

• GROUP BY is used to group rows based on a specific column or columns

• HAVING is used to filter the grouped rows based on a condition

• Example: SELECT column1, column2, ROW_NUMBER() OVER (ORDER BY column1) AS row_num FROM table_name GROUP BY column1 HAVING column2 > 10