WonderBotz Lead Technical Writer Interview Questions and Answers

Q1. Scenario based on filter table
Add your answer
Q2. Find rolling total without reset
Ans. 
Calculate rolling total without resetting at specified interval
• Use DAX formula with functions like CALCULATE, FILTER, and EARLIER

• Create a measure that calculates the running total based on the current and previous rows

• Consider using variables to store intermediate results for efficiency
Answered by AI
Add your answer
Q3. Shift one cell Down in table using dax
Ans. 
Use DAX function to shift one cell down in a table
• Use the LAG function in DAX to shift values down in a column

• Specify the number of rows to shift as a parameter in the LAG function

• Example: LAG([Column], 1) will shift values in 'Column' down by one row
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a passionate content writer with a background in journalism and a love for storytelling.
• Background in journalism

• Passionate about storytelling

• Experience in creating engaging content

• Strong research skills

• Familiarity with SEO best practices
Answered by AI
Add your answer
Q2. Tell me about your content writing experience
Ans. 
I have over 5 years of experience in content writing for various industries including technology, travel, and lifestyle.
• Created engaging and SEO-friendly content for websites, blogs, and social media platforms

• Conducted thorough research on topics to ensure accuracy and credibility

• Worked closely with marketing teams to develop content strategies and campaigns

• Managed editorial calendars and deadlines to ensure timely del...read more
Answered by AI
Add your answer

Q1. Why did you leave your previous company
Ans. 
Seeking new challenges and opportunities for growth.
• Desire for career advancement

• Limited opportunities for growth in previous company

• Seeking new challenges and experiences
Answered by AI
Add your answer
Q2. How this company will be helpful for your career
Ans. 
This company offers opportunities for growth, learning, and development in the field of content writing.
• Provides mentorship and training programs to enhance writing skills

• Offers exposure to diverse projects and industries

• Encourages creativity and innovation in content creation

• Opportunities for career advancement and networking

• Access to tools and resources for professional development
Answered by AI
Add your answer

Q1. Wat is cardinality
Ans. 
Cardinality refers to the uniqueness of values in a column or relationship.
• Cardinality is the number of unique values in a column or relationship.

• High cardinality means a column has many unique values, while low cardinality means few unique values.

• For example, a column like 'Customer ID' may have high cardinality, while 'Gender' may have low cardinality.
Answered by AI
Add your answer
Q2. Challenges faced
Add your answer

Q1. Write SQL query
Ans. 
SQL query to retrieve data from a table
• Use SELECT statement to specify columns to retrieve

• Use FROM statement to specify the table to retrieve data from

• Use WHERE statement to filter the data based on conditions
Answered by AI
Add your answer

Q1. What are duplicates and references
Ans. 
Duplicates are identical copies of data, while references are pointers to the same data in memory.
• Duplicates are exact copies of the original data.

• References point to the same data in memory.

• Duplicates can lead to inconsistencies in data analysis.

• References are more memory efficient than duplicates.
Answered by AI
Add your answer
Q2. How do you implement incremental refresh
Ans. 
Incremental refresh in Power BI allows for loading only new or modified data to improve performance.
• Set up incremental refresh policy in Power BI Service

• Define a range of values for the refresh policy

• Use parameters to filter data based on the refresh policy

• Schedule regular refreshes to update the dataset
Answered by AI
Add your answer

Brief information about Business Intelligence (BI) tools.

Q1. What is the role of Power BI in today's market?
Add your answer
Q2. What are the differences between Power BI and Tableau?
Add your answer
Q3. What are some case studies that demonstrate the use of Power BI?
Add your answer

Q1. What are your salary expectations?
Add your answer

Q1. Experience , skills
Add your answer
Q2. Study, back ground
Add your answer
Q3. Any gap on work experience
Add your answer
Q4. Any gap on study
Add your answer
Q5. Family background
Add your answer

Q1. What is star schema and snowflake schema?
Ans. 
Star schema is a data warehouse schema where a central fact table is connected to multiple dimension tables. Snowflake schema is a normalized form of star schema.
• Star schema consists of a central fact table connected to multiple dimension tables

• Snowflake schema is a normalized form of star schema where dimension tables are further normalized into sub-dimension tables

• Star schema is denormalized for faster query performa...read more
Answered by AI
Add your answer
Q2. Explain about your experience in SQL joins
Add your answer
Q3. Tell me what ways you improve performance of report?
Ans. 
Performance of reports can be improved by optimizing queries, reducing data volume, using efficient visuals, and caching data.
• Optimize queries by removing unnecessary columns and filters

• Reduce data volume by aggregating data at the source or using incremental refresh

• Use efficient visuals like matrix instead of tables for large datasets

• Cache data to reduce query times for frequently accessed data
Answered by AI
Add your answer
Q4. What is data query and data flow?
Ans. 
Data query is the process of retrieving specific data from a database, while data flow is the movement of data from one point to another.
• Data query involves writing SQL queries to extract specific data from a database

• Data flow refers to the movement of data from source to destination through various transformations

• Data query is used to filter and retrieve relevant data, while data flow ensures data is processed and mov...read more
Answered by AI
Add your answer
Q5. Difference between power query and direct query
Ans. 
Power Query is used to import and transform data within Power BI, while Direct Query allows real-time data access from the data source.
• Power Query is used to import and transform data within Power BI before loading it into the data model.

• Direct Query allows Power BI to query the data source directly in real-time, without importing the data into the data model.

• Power Query is suitable for smaller datasets that can be loa...read more
Answered by AI
Add your answer
Q6. What is RANK & DENSE RANK in SQL
Ans. 
RANK assigns a unique rank to each row based on a specified column, while DENSE RANK assigns a unique rank to each distinct row.
• RANK function is used to assign a unique rank to each row based on a specified column

• DENSE RANK function is used to assign a unique rank to each distinct row, skipping ranks if there are ties

• RANK and DENSE RANK are commonly used in SQL queries to rank data based on certain criteria
Answered by AI
Add your answer
Q7. What is Calculated column and Measure?
Ans. 
Calculated column is a static column in a table calculated based on a formula, while Measure is a dynamic calculation based on aggregated data.
• Calculated column is created in Power BI using DAX formula and stored in the data model.

• Measure is a calculation performed on the fly based on the context of the visualization.

• Calculated columns are static and can be used for filtering and sorting, while Measures are dynamic and
Answered by AI
Add your answer
Q8. Tell me about complex DAX functions you used
Ans. 
I have used complex DAX functions like CALCULATE, FILTER, SUMX, etc. to perform advanced calculations in Power BI.
• Used CALCULATE function to apply filters and context changes to calculations

• Utilized FILTER function to filter data based on specific conditions

• Implemented SUMX function to iterate over a table and perform calculations for each row
Answered by AI
Add your answer
Q9. What is CALCULATED function and how it works?
Ans. 
CALCULATED function is used in Power BI to create custom calculations based on existing data in a report.
• CALCULATED function is used to create custom calculations in DAX (Data Analysis Expressions) language.

• It allows users to define complex calculations based on existing data in the report.

• CALCULATED function can be used with other DAX functions to perform calculations like aggregations, comparisons, and conditional lo...read more
Answered by AI
Add your answer
Q10. What is query folding in power BI?
Ans. 
Query folding in Power BI is a process where Power BI pushes the data transformation steps back to the data source.
• Query folding improves performance by reducing the amount of data loaded into Power BI.

• It allows Power BI to leverage the capabilities of the data source for data transformation.

• Commonly used with relational databases like SQL Server, Oracle, etc.

• Example: When filtering data in Power BI, query folding will...read more
Answered by AI
Add your answer
Q11. Tell me about types of Context
Ans. 
Types of context refer to the different ways in which data can be analyzed and interpreted in Power BI.
• Row context: evaluates calculations row by row

• Filter context: applies filters to data before calculations

• Query context: used in DAX queries to retrieve data

• Relationship context: determines how tables are related
Answered by AI
Add your answer
Q12. Fundamentals of POWER BI?
Ans. 
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
• Power BI is a business analytics tool by Microsoft

• It allows users to create interactive visualizations and reports

• Users can connect to various data sources to import data

• Power BI offers a wide range of data visualization options such as charts, graphs, and maps

• Users can share and collaborat
Answered by AI
Add your answer
Q13. DDL & DML commands?
Add your answer
Q14. Give me an example forINNER JOIN in sql
Ans. 
INNER JOIN is used to combine rows from two or more tables based on a related column between them.
• Use INNER JOIN to retrieve rows from both tables that have matching values in the specified column

• Syntax: SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name

• Example: SELECT Orders.OrderID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.Cus
Answered by AI
Add your answer

It was like a gaming test

Q1. Basics of engineering Graphics
Add your answer
Q2. Two importance of writer
Ans. 
Two important aspects of a writer are creativity and attention to detail.
• Creativity allows a writer to come up with unique and engaging content.

• Attention to detail ensures that the content is accurate and well-organized.

• For example, a technical writer may need to creatively explain complex concepts in a clear and concise manner, while also paying close attention to grammar and formatting.

• Another example could be a crea...read more
Answered by AI
Add your answer