Que. Give me your introduction
Ans. I have about 1 year of experience in Data Analytics & Reporting. I work on data analysis and business reporting tools like Excel, SQL, and Power BI. Before this I worked as a Trainee Analyst at B3 Intelligence where I gained hands on experience in data cleaning, analysis, viz & building reports. I have also worked on different projects like KPI tracking, workforce analytics.
Trainingya Rating On this Answer: 3/10
Que. What is your current role in your organization?
Ans. In my current role, I regularly work with large datasets, write SQL queries for data extraction and validations. I write complex queries using joins, CTEs, window function to prepare data for reporting.
Trainingya Rating On this Answer: 3/10
Que. Have you build Reports in power bi and What type of visuals are you used?
Ans. Yes, I have build a reports in power bi. I have worked on Dynamic KPI dashboard and Workforce Analytics Dashboard where I used different type of charts like Card, KPIs, Bar Chart , Line Chart, waterfall Chart and many non standard charts
Trainingya Rating On this Answer: 3/10
Que. Difference between table and metrices?
Ans. Table is used to display detailed row level Data. It does not support hierarchy and drill down and there is no column sub grouping. Matrices is used for summarized analysis. It support hierarchy and drill down. In metrices there is automatic subtotal and Grand total.
Trainingya Rating On this Answer: 3/10
Que. How will you optimize a report in power Bi?
Ans. There are several ways to optimize a report in power BI Use Data Query i.e. ETL process where we transform the the data according to our need then load the data Use aggregation- reduce the data size Use Incremental refresh- This allow partial data refresh only refresh new or modified records
Trainingya Rating On this Answer: 3/10
Que. What is Row level security and What are the steps?
Ans. RLS restricts data access for users based on their role
Steps:
Publish the report in power bi service
Create role
Test the role
Assign users to roles
Share the report
Trainingya Rating On this Answer: 3/10
Que. Replacement of summarize function?
Ans. Summarize() creates a new summary table grouped by specific column
Replacement –
Trainingya Rating On this Answer: 3/10
Que. Relationship in Power BI?
Ans. Relationship connects two tables using a common column so that data can flow between them for analysis
One to one
One to many
Many to one
Many to many
Trainingya Rating On this Answer: 3/10
Que. What is Recursion?
Ans. Recursion is defined as function calls itself to solve a problem. For example- Factorial
Trainingya Rating On this Answer: 3/10
Que. What is norms in supply chain?
Ans. Norms are the standard benchmark for evaluation business performance.
A common approach is:
Store the target value
Compare actual values
Use KPIs
Trainingya Rating On this Answer: 3/10
Que. What is temp Tables in SQL?
Ans. Temporary table is a table that is stored in temporary database
There is two types of temp tables
Local temp tables : denoted with # and automatically deleted when current window is closed
Global temp tables : denoted with ## and deleted when entire window is closed
Trainingya Rating On this Answer: 3/10
Que. Window function in sql?
Ans. Window function performs calculation across set of related rows without reducing rows
For eg; Row_number()
Rank(), dense_rank(),lag(),lead(),first_value(),Last_value()
Trainingya Rating On this Answer: 3/10
Que. 2nd highest department wise salary?
Ans. Select * from
(
Select *,
Dense_rank() over ( partition by dept order by salary desc) as rnk
From table
) t
Where rank=2
Trainingya Rating On this Answer: 3/10
Que. Suppose you have to make a dashboard and submit report next day in the morning. Will you make it by own take the help from AI?
Ans. Firstly I will go through the dataset and understand the data then I will find out what I have to Do in my dashboard. If the dataset is quite easy and easily find out the insights from that dataset then I will make it by own but if the dataset is complex then I will take he help from AI.
Trainingya Rating On this Answer: 3/10