Live Interview of a Fresher | Power BI😲 | Answered 95% Questions ✔
Vložit
- čas přidán 4. 02. 2024
- Codebasics Data Analyst Bootcamp Link:
codebasics.io/bootcamps/data-...
-------------------------------------
Topmate Link to book call 1:1 - topmate.io/learnwidgiggs
-------------------------------------
Link for the Scenario based QnA in Power BI: • Scenario based QnA - P...
Link for the Power Bi Interview QnA playlist :
• Power BI Interview QnA
Link for the SQL QnA playlist :
• SQL Interview QnA for ...
Link for the Data Warehousing QnA playlist :
• DW Concepts Based QnA
☀ Connect with me Here on Social Media ☀
LinkedIn : / shashank-singh-🇮🇳-ba4b...
Instagram : / learnwidgiggs
Your queries:
power bi interview questions
power bi interview questions and answers
power bi interview
power bi interview questions for experienced professionals
power bi interview questions for freshers
deloitte power bi interview questions
power bi scenario based interview questions
power bi service interview questions
scenario based power bi interview questions
power bi practice scenarios
power bi real time scenarios
shashank singh power bi
power bi scenario based questions
sql and power bi interview questions
capgemini power bi interview questions
accenture power bi interview questions
power bi managerial round interview questions
how to explain project in power bi interview
power bi roadmap
power bi jobs for freshers
power bi project explanation in interview
power bi resume for freshers
power bi fresher jobs
power bi resume
power bi developer resume
power bi resume for 2 years experience india
power bi developer resume for experienced
Following answers given by chatGPT:
1. **Index Column in Power BI:**
- In Power BI, an index column is a column created to provide a unique identifier for each row in a table. It helps in uniquely identifying each record and can be useful in scenarios where you need a sequential order for your data.
2. **Difference between Fact Table and Dimension Table:**
- Fact tables contain quantitative data (measurements), and they are typically large. Dimension tables store descriptive information and are smaller. The primary difference lies in the type of data they hold and their size.
3. **Snowflake Schema:**
- The snowflake schema is a type of database schema where a dimension table is normalized into multiple related tables. This normalization reduces redundancy but increases the complexity of queries compared to a star schema.
4. **Normalization:**
- Normalization is the process of organizing data in a database efficiently to eliminate redundancy and dependency. It involves dividing large tables into smaller ones and defining relationships between them.
5. **Cardinality:**
- Cardinality defines the relationship between tables in a data model. It can be one-to-one, one-to-many, or many-to-many. Preferably, one-to-many relationships are often preferred in data modeling.
6. **Difference between Donut Chart and Pie Chart:**
- Both charts display parts of a whole, but a donut chart has a hole in the center, allowing for additional information or labels. This can enhance readability compared to a pie chart.
7. **Difference between Measure and Calculated Column:**
- A measure is a dynamic calculation based on the context of the data, and it is evaluated at runtime. A calculated column is a static column added to a table, and its values are computed during data refresh.
8. **Page Level Filter:**
- A page-level filter applies to all visuals on a specific page in a Power BI report. It allows you to filter the entire page based on selected criteria.
9. **What-If Parameters:**
- What-If parameters are used to enable users to dynamically input values into calculations or filters, allowing for scenario analysis and decision-making.
10. **Field Parameters:**
- Field parameters in Power BI allow users to create dynamic expressions that reference fields in their data model. They provide flexibility in calculations.
11. **DATESINPERIOD Function:**
- DATESINPERIOD is a DAX function used to retrieve a table of dates for a specified period, such as the last month or the next quarter.
12. **Creating a Calendar Table with DAX Functions:**
- You can create a calendar table using DAX functions like CALENDAR or CALENDARAUTO. These functions generate a range of dates that can be used as a date dimension in your data model.
13. **Iterator Functions:**
- Iterator functions in DAX, such as SUMX or FILTER, operate on each row of a table, applying a specified expression or calculation.
14. **Difference between DATEADD and SAMEPERIODLASTYEAR:**
- DATEADD is used to shift a date by a specified number of intervals, while SAMEPERIODLASTYEAR returns a table that contains a column of dates for the same period in the previous year.
15. **Row Level Security:**
- Row-level security in Power BI restricts data access at the row level based on user roles. It ensures that users only see the data relevant to their role.
16. **Data Gateway:**
- A data gateway is a tool that facilitates secure and efficient communication between Power BI and on-premises data sources. It helps maintain data connectivity and refresh.
Can u pla guide where I need to take coaching
This type of interviews helps us very much specially to the freshers like.me .
Thank you for sharing this kind of videos 🙏🏻
Finished watching
Thanks for posting....it really helpful for the interview preparation.
Thank you for your efforts.
Glad to hear this.
DISTINCTCOUNT(COLUMN) can be used to count the distinct value in a column.
yes, distinct count can be used to count records of 20000
Very informative video
I think, he answer beautifully to most of the questions.
True
do a video like this for experienced as well, it will help us understand the level of topics to prepare
Sure.
Really, It's huge informative interview.
Thanks @learnwidgiggs, Please keep posting such video's!!
Glad you found it useful 🙏
Drill through asn was incorrect drill through and drill down are 2 different thing.
Btw nice video ❤
Great
Thank you sir ❤
Welcome!
It's a really amazing interview. Kudos 😊
Glad you enjoyed it!
Good
Please provide video of those who switch their company in power bi domain.
U should answer the questions unanswered by the candidate... Also if u feel answers are not upto the mark.. then do answer that also.. :)
Thanks for the video.
Sir Pavan lalwani sir's 2020 power bi videos are very helpful
Hi I need vedios
Pls make video's office work in data analyst main focus in which topic sir
Noted.
Hi Sir , attended interview 2nd round of Capgemini on 1st Feb. These are the questions asked. could u please help us with the ans. 1)can we use Username and userprinciple name in static RLS 2) Does Power bi maintain/store historical data and how? 3)is it possible to create drill down and drill up on 3 fact tables 4)if there are constraint applied on table, does Primary key and Foreign key will affect in power bi? 5)if we are taking data from DB, table has 6k rows and table got truncated has only 1 k rows. Does Power bi will have all the 6 K rows from the table? 6)how will u identify type of license looking at workspace? what is the size of workspace? What is the unit testing in power bi? do u do the report validation, how do u do that? how will you cross verify the data which is coming from data source to report? did u done any automation? what is dual mode ?
Thank you so much brother for providing such Valuable questions 🙏
Did you get the answers?
@shwari..hey did you get the Answer
Excuse me , I want to know r u a fresher or have experience?
1. **Can we use Username and User Principle Name (UPN) in static Row-Level Security (RLS)?**
Yes, you can use both Username and User Principle Name (UPN) in static Row-Level Security (RLS) in Power BI. Static RLS allows you to define roles and manually specify which users or groups have access to specific rows of data based on predefined criteria such as username or UPN.
2. **Does Power BI maintain/store historical data, and how?**
Power BI itself does not maintain historical data. However, you can configure Power BI to store historical data by connecting it to data sources that store historical information, such as databases or data warehouses. By regularly refreshing data in Power BI and storing historical snapshots in your data source, you can analyze historical trends and patterns over time.
3. **Is it possible to create drill-down and drill-up on three fact tables?**
Yes, it is possible to create drill-down and drill-up functionality in Power BI reports across multiple fact tables. You can achieve this by defining relationships between the fact tables and using hierarchies or custom drill-down paths to navigate through different levels of granularity in your data model.
4. **If constraints are applied on a table, does Primary Key and Foreign Key affect Power BI?**
Constraints such as Primary Key and Foreign Key defined in the underlying data source (e.g., a database) do not directly affect Power BI. Power BI imports data from the data source based on the defined relationships in the data model. However, enforcing referential integrity through Primary Key and Foreign Key constraints in the data source can help maintain data consistency and accuracy, which is reflected in Power BI reports.
5. **If a table with 6k rows gets truncated to 1k rows in the database, will Power BI still have all the 6k rows?**
No, if a table with 6k rows gets truncated to 1k rows in the database, Power BI will only have access to the remaining 1k rows when refreshing data from the data source. Power BI reflects the current state of the data in the source system at the time of data refresh.
6. **How do you identify the type of license and workspace size in Power BI? What is unit testing in Power BI? Do you perform report validation, and how? Have you done any automation? What is dual mode?**
These questions delve into more technical aspects of Power BI administration, including license management, workspace management, testing methodologies, validation processes, automation, and the concept of dual mode (import mode and DirectQuery mode). The answers to these questions may vary based on the organization's specific setup and the individual's experience with Power BI administration and development.
Powerbi service is very important to know
Right.
Please give us latest resume formatt for 2 yrs exp 😢
Hi Shashank ........all the questions that u have asked , make a special video demonstrating the all questions with scenario based examples .
Noted.
Brother ek video banao 3,4,5 year experience wale logo ke liye interview questions kaise hoge kya kya hoge ispe
Noted.
After 13:19, from which power bi topics u r asking questions?
Such a nice video. Hello brother can you please make a detailed video on the power bi service.
Noted.
small request from my side
please mention all the questions in description...
All the questions that I ask are spontaneous and also its not possible to write the scenario based questions in words.
Sir, Why did you not ask questions related to project whatever he done because I faced a interview and they more curious about projects .
He's a fresher na?
Is he get the job?
Hi, if anyone wants to connect can let me know. I want to connect with people on the same path as I feel it helps a lot 😅.
Hi Sir, I am 2024 passout (IT).
skilled in Python, SQL, Power BI, Excel, AWS, Azure, Data Wearhouse.
Not getting any interview.
Is there not enough job in data analytics or am I doing something wrong?
Please help me sir.
Do you have a PL 300 or TDS certificate?
Sufficient.
@@learnwidgiggs what I should do now?
will there will job in data analyst for 2022 batch? in mnc?
Yes.
Hi Shasank. can you make a video of unpivot columns concept in power bi.
Noted.
Did he get a job ?
I think Fact and dimensional table wrong ans.
what would be your answer?
@@user-cl8ly7nj1x Fact tables and dimension tables play different but important roles in a data warehouse. Fact tables contain numerical data, while dimension tables provide context and background information. Both types of tables are necessary for effective data analysis and decision-making
Is this even real? I can clearly see the candidate trying his best(but failed) to mimic another person.
It's a mock interview. There was a delay in his voice while recording.. sorry for that. But everything is genuine.
@@learnwidgiggs my bad, I judged too quickly. Apologies.
Hi can I connect with you ?
Social media links in the description box.