Which of the following is NOT a valid data source that Power BI can connect to directly?
Anonymous Quiz
4%
Excel
5%
SQL Server
12%
Web page
79%
Adobe Photoshop
โค3
What is the DAX language used for in Power BI?
Anonymous Quiz
11%
Creating visualizations
10%
Connecting to data sources
73%
Defining calculations and measures
6%
Managing user security
โค6
What is the purpose of the "Get Data" feature in Power BI?
Anonymous Quiz
8%
To create new visualizations
82%
To connect to data sources and import data
8%
To publish reports to the Power BI Service
2%
To define data relationships
โค4๐ฅฐ1
What is the purpose of a slicer in Power BI?
Anonymous Quiz
7%
To create a calculated column
77%
To filter data in a report interactively
5%
To create a hierarchy
11%
To define a relationship between tables
โค3
Scenario based Interview Questions & Answers for Data Analyst
1. Scenario: You are working on a SQL database that stores customer information. The database has a table called "Orders" that contains order details. Your task is to write a SQL query to retrieve the total number of orders placed by each customer.
Question:
- Write a SQL query to find the total number of orders placed by each customer.
Expected Answer:
SELECT CustomerID, COUNT(*) AS TotalOrders
FROM Orders
GROUP BY CustomerID;
2. Scenario: You are working on a SQL database that stores employee information. The database has a table called "Employees" that contains employee details. Your task is to write a SQL query to retrieve the names of all employees who have been with the company for more than 5 years.
Question:
- Write a SQL query to find the names of employees who have been with the company for more than 5 years.
Expected Answer:
SELECT Name
FROM Employees
WHERE DATEDIFF(year, HireDate, GETDATE()) > 5;
Power BI Scenario-Based Questions
1. Scenario: You have been given a dataset in Power BI that contains sales data for a company. Your task is to create a report that shows the total sales by product category and region.
Expected Answer:
- Load the dataset into Power BI.
- Create relationships if necessary.
- Use the "Fields" pane to select the necessary fields (Product Category, Region, Sales).
- Drag these fields into the "Values" area of a new visualization (e.g., a table or bar chart).
- Use the "Filters" pane to filter data as needed.
- Format the visualization to enhance clarity and readability.
2. Scenario: You have been asked to create a Power BI dashboard that displays real-time stock prices for a set of companies. The stock prices are available through an API.
Expected Answer:
- Use Power BI Desktop to connect to the API.
- Go to "Get Data" > "Web" and enter the API URL.
- Configure the data refresh settings to ensure real-time updates (e.g., setting up a scheduled refresh or using DirectQuery if supported).
- Create visualizations using the imported data.
- Publish the report to the Power BI service and set up a data gateway if needed for continuous refresh.
3. Scenario: You have been given a Power BI report that contains multiple visualizations. The report is taking a long time to load and is impacting the performance of the application.
Expected Answer:
- Analyze the current performance using Performance Analyzer.
- Optimize data model by reducing the number of columns and rows, and removing unnecessary calculations.
- Use aggregated tables to pre-compute results.
- Simplify DAX calculations.
- Optimize visualizations by reducing the number of visuals per page and avoiding complex custom visuals.
- Ensure proper indexing on the data source.
Free SQL Resources: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v
Like if you need more similar content
Hope it helps :)
1. Scenario: You are working on a SQL database that stores customer information. The database has a table called "Orders" that contains order details. Your task is to write a SQL query to retrieve the total number of orders placed by each customer.
Question:
- Write a SQL query to find the total number of orders placed by each customer.
Expected Answer:
SELECT CustomerID, COUNT(*) AS TotalOrders
FROM Orders
GROUP BY CustomerID;
2. Scenario: You are working on a SQL database that stores employee information. The database has a table called "Employees" that contains employee details. Your task is to write a SQL query to retrieve the names of all employees who have been with the company for more than 5 years.
Question:
- Write a SQL query to find the names of employees who have been with the company for more than 5 years.
Expected Answer:
SELECT Name
FROM Employees
WHERE DATEDIFF(year, HireDate, GETDATE()) > 5;
Power BI Scenario-Based Questions
1. Scenario: You have been given a dataset in Power BI that contains sales data for a company. Your task is to create a report that shows the total sales by product category and region.
Expected Answer:
- Load the dataset into Power BI.
- Create relationships if necessary.
- Use the "Fields" pane to select the necessary fields (Product Category, Region, Sales).
- Drag these fields into the "Values" area of a new visualization (e.g., a table or bar chart).
- Use the "Filters" pane to filter data as needed.
- Format the visualization to enhance clarity and readability.
2. Scenario: You have been asked to create a Power BI dashboard that displays real-time stock prices for a set of companies. The stock prices are available through an API.
Expected Answer:
- Use Power BI Desktop to connect to the API.
- Go to "Get Data" > "Web" and enter the API URL.
- Configure the data refresh settings to ensure real-time updates (e.g., setting up a scheduled refresh or using DirectQuery if supported).
- Create visualizations using the imported data.
- Publish the report to the Power BI service and set up a data gateway if needed for continuous refresh.
3. Scenario: You have been given a Power BI report that contains multiple visualizations. The report is taking a long time to load and is impacting the performance of the application.
Expected Answer:
- Analyze the current performance using Performance Analyzer.
- Optimize data model by reducing the number of columns and rows, and removing unnecessary calculations.
- Use aggregated tables to pre-compute results.
- Simplify DAX calculations.
- Optimize visualizations by reducing the number of visuals per page and avoiding complex custom visuals.
- Ensure proper indexing on the data source.
Free SQL Resources: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v
Like if you need more similar content
Hope it helps :)
โค7
What is the correct syntax to print "Hello, World!" in Python?
Anonymous Quiz
87%
print("Hello, World!")
3%
echo "Hello, World!"
9%
printf("Hello, World!")
โค4
Which data type is used to store a sequence of characters in Python?
Anonymous Quiz
13%
Integer
4%
Float
79%
String
4%
Boolean
โค6
Which of the following is a valid way to define a list in Python?
Anonymous Quiz
13%
my_list = (1, 2, 3)
18%
my_list = {1, 2, 3}
66%
my_list = [1, 2, 3]
3%
my_list = "1, 2, 3"
โค4
Which loop is used to iterate over a sequence (like a list or a string) in Python?
Anonymous Quiz
31%
while loop
61%
for loop
8%
if loop
โค4
What will be the output of the following code?
my_string = "Python" print(len(my_string))
my_string = "Python" print(len(my_string))
Anonymous Quiz
14%
5
61%
6
6%
7
18%
Error
โค8
SQL Interviews LOVE to test you on Window Functions. Hereโs the list of 7 most popular window functions
๐ ๐ ๐๐จ๐ฌ๐ญ ๐๐๐ฌ๐ญ๐๐ ๐๐ข๐ง๐๐จ๐ฐ ๐ ๐ฎ๐ง๐๐ญ๐ข๐จ๐ง๐ฌ
* RANK() - gives a rank to each row in a partition based on a specified column or value
* DENSE_RANK() - gives a rank to each row, but DOESN'T skip rank values
* ROW_NUMBER() - gives a unique integer to each row in a partition based on the order of the rows
* LEAD() - retrieves a value from a subsequent row in a partition based on a specified column or expression
* LAG() - retrieves a value from a previous row in a partition based on a specified column or expression
* NTH_VALUE() - retrieves the nth value in a partition
React โค๏ธ for the detailed explanation
๐ ๐ ๐๐จ๐ฌ๐ญ ๐๐๐ฌ๐ญ๐๐ ๐๐ข๐ง๐๐จ๐ฐ ๐ ๐ฎ๐ง๐๐ญ๐ข๐จ๐ง๐ฌ
* RANK() - gives a rank to each row in a partition based on a specified column or value
* DENSE_RANK() - gives a rank to each row, but DOESN'T skip rank values
* ROW_NUMBER() - gives a unique integer to each row in a partition based on the order of the rows
* LEAD() - retrieves a value from a subsequent row in a partition based on a specified column or expression
* LAG() - retrieves a value from a previous row in a partition based on a specified column or expression
* NTH_VALUE() - retrieves the nth value in a partition
React โค๏ธ for the detailed explanation
โค18
I see so many people jump into data analytics, excited by its popularity, only to feel lost or uninterested soon after. I get it, data isnโt for everyone, and thatโs okay.
Data analytics requires a certain spark or say curiosity. You need that drive to dig deeper, to understand why things happen, to explore how data pieces connect to reveal a bigger picture. Without that spark, itโs easy to feel overwhelmed or even bored.
Before diving in, ask yourself, Do I really enjoy solving puzzles? Am I genuinely excited about numbers, patterns, and insights? If youโre curious and love learning, data can be incredibly rewarding. But if itโs just about following a trend, it might not be a fulfilling path for you.
Be honest with yourself. Find your passion, whether itโs in data or somewhere else and invest in something that truly excites you.
Hope this helps you ๐
Data analytics requires a certain spark or say curiosity. You need that drive to dig deeper, to understand why things happen, to explore how data pieces connect to reveal a bigger picture. Without that spark, itโs easy to feel overwhelmed or even bored.
Before diving in, ask yourself, Do I really enjoy solving puzzles? Am I genuinely excited about numbers, patterns, and insights? If youโre curious and love learning, data can be incredibly rewarding. But if itโs just about following a trend, it might not be a fulfilling path for you.
Be honest with yourself. Find your passion, whether itโs in data or somewhere else and invest in something that truly excites you.
Hope this helps you ๐
โค16๐3