Markscan Senior Data Analyst Interview Questions and Answers

Q1. Tell me about yourself
Ans. 
I am a Senior Data Analyst with 5+ years of experience in analyzing complex data sets and providing actionable insights.
• 5+ years of experience in data analysis

• Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

• Strong problem-solving skills and ability to communicate findings to non-technical stakeholders
Answered by AI
Add your answer
Q2. Asked about recent project
Add your answer
Q3. Types of join in sql
Ans. 
Types of join in SQL include inner join, outer join, left join, right join, and full join.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full join: Returns ro
Answered by AI
Add your answer
Q4. Case when statement questions
Add your answer

Q1. Complex Sql Questions and problems
Add your answer
Q2. Case study about segmentation and dashboarding
Add your answer

Q1. SQL window function
Add your answer
Q2. Python data mining of unstructured data
Ans. 
Python data mining of unstructured data involves extracting valuable insights from text, images, videos, etc.
• Use Python libraries like NLTK, spaCy, and scikit-learn for text mining

• Utilize techniques like natural language processing (NLP) and machine learning for data extraction

• Preprocess data by tokenizing, stemming, and removing stop words before analysis
Answered by AI
Add your answer

Q1. Basic skill discussion
Add your answer
Q2. Basic work experience discussion
Add your answer

Q1. Behavioural questions
Add your answer
Q2. Questions to understand cultural fit
Add your answer

Question on Probability and basic aptitude questions

Q1. Question were related to Past projects
Add your answer
Q2. SQL and Excel medium level questions
Add your answer

Hacker rank test mostly on sql

Q1. Focused on Statistical analysis and sql. More sql questions on window functions
Add your answer
Q2. Sql joins and aggregation functions
Add your answer

3 questions are there.

MySQL basics,
Sorting,
group by,
pivot

Case studies basic to advanced MySQL.

Q1. How many type of conections are available in Power BI?
Ans. 
There are four types of connections available in Power BI.
• Power BI Desktop Connection

• Power BI Service Connection

• Power BI Mobile Connection

• Power BI Gateway Connection
Answered by AI
Add your answer
Q2. What is incremental refresh in Power BI?
Ans. 
Incremental refresh is a feature in Power BI that allows you to refresh only a portion of your data instead of the entire dataset.
• Incremental refresh is useful for large datasets that take a long time to refresh.

• It allows you to refresh only the new or updated data since the last refresh.

• You can set up incremental refresh by defining a range of values for a column that represents the refresh window.

• For example, you can...read more
Answered by AI
Add your answer
Q3. Diffrence between direct connection and live connection?
Ans. 
Direct connection is a static connection to a data source, while live connection is a dynamic connection that updates in real-time.
• Direct connection requires data to be imported into the analysis tool, while live connection accesses data directly from the source.

• Live connection allows for real-time updates and analysis, while direct connection requires manual refreshing.

• Direct connection is useful for small datasets or...read more
Answered by AI
Add your answer
Q4. Where power pivot is available in Power bi?
Ans. 
Power Pivot is available in Power BI Desktop and Power BI Service.
• Power Pivot is a data modeling tool in Excel that allows you to create relationships between tables and perform complex calculations.

• In Power BI Desktop, you can access Power Pivot by going to the 'Data' tab and selecting 'Manage Relationships'.

• In Power BI Service, you can access Power Pivot by going to the 'Settings' menu and selecting 'Data Sources'.

• Po...read more
Answered by AI
Add your answer
Q5. Use of SELECTEDVALUE() fax function?
Ans. 
SELECTEDVALUE() is a DAX function used to return the value of a column if it has only one distinct value.
• Used in Power BI to retrieve the value of a column if it has only one distinct value

• Returns an error if the column has more than one distinct value

• Can be used in combination with IF statement to handle errors

• Example: SELECTEDVALUE('Table'[Column], 'No value found')

• Example: IF(ISBLANK(SELECTEDVALUE('Table'[Column])),...read more
Answered by AI
Add your answer
Q6. How can we create a dependent slicer in Power bi?
Ans. 
Dependent slicer in Power BI allows filtering of data based on selection in another slicer.
• Create two slicers, one for the main category and another for the sub-category.

• Add the main category slicer to the report page and select the sub-category slicer.

• Go to the Format pane and select the 'Edit interactions' option.

• Choose the 'Filter' option for the sub-category slicer.

• Now, when a main category is selected, the sub-cat...read more
Answered by AI
Add your answer
Q7. How many type of filters are available in Power bi?
Ans. 
There are three types of filters available in Power BI.
• Visual level filters

• Page level filters

• Report level filters
Answered by AI
Add your answer
Q8. How can we share a power bi report with an external user?
Ans. 
To share a Power BI report with an external user, we can use the Publish to Web feature or share it via email.
• Use the Publish to Web feature to generate an embed code that can be shared with external users

• Ensure that the report contains only non-sensitive data before using the Publish to Web feature

• Alternatively, share the report via email by granting access to the external user's email address

• The external user must ha
Answered by AI
Add your answer