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.
Listen to the question again it says in "power query editor". The answer is we can just click on the view column report on the entire dataset, it is automatically set for 1000 rows
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.
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 ?
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.
As a contributor not able to give access correct me if am wrong he can see both dataset and report and he can develop the report but he doesnt have any priviliges to give access to other memebers
Hi Sir, My question is that I have started to learn advanced excel and powerbi , As a fresher the companies can hire the people who are leraning the powerbi,sql and advanced excel please give me suggestion for this for the data analyst role there is a future but the companies can hire the freshers or not thats my question .
bhai ai kaam khatam kar raha hai. I am already in IT company . almost kaam ai kar raha hai . only hr ki post ka kaam ai nahi kar raha hai . layoff hoga badei level par hoga . please koi bhi youtuber reality nahi bata raha but yei real hai . yei apna course sell karnei kaei lyei kuch bhi bol rahei hai 🔴🔴🔴🟡🟡🟡🟢🟢🟢🟢
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.
@@NitishKumar-l5s9s 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
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
it's very us useful foe me Thank you!!
Thank you 😊
This type of interviews helps us very much specially to the freshers like.me .
Thank you for sharing this kind of videos 🙏🏻
DISTINCTCOUNT(COLUMN) can be used to count the distinct value in a column.
yes, distinct count can be used to count records of 20000
Listen to the question again it says in "power query editor". The answer is we can just click on the view column report on the entire dataset, it is automatically set for 1000 rows
do a video like this for experienced as well, it will help us understand the level of topics to prepare
Sure.
I think, he answer beautifully to most of the questions.
True
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.
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.
Sir Pavan lalwani sir's 2020 power bi videos are very helpful
Hi I need vedios
Drill through asn was incorrect drill through and drill down are 2 different thing.
Btw nice video ❤
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.
Thanks for posting....it really helpful for the interview preparation.
Thank you for your efforts.
Glad to hear this.
After 13:19, from which power bi topics u r asking questions?
It's a really amazing interview. Kudos 😊
Glad you enjoyed it!
Powerbi service is very important to know
Right.
Please provide video of those who switch their company in power bi domain.
I think the drill through answer was incorrect. He explained drill down.
As a contributor not able to give access correct me if am wrong he can see both dataset and report and he can develop the report but he doesnt have any priviliges to give access to other memebers
Really, It's huge informative interview.
Thanks @learnwidgiggs, Please keep posting such video's!!
Glad you found it useful 🙏
Hi Sir,
My question is that I have started to learn advanced excel and powerbi , As a fresher the companies can hire the people who are leraning the powerbi,sql and advanced excel please give me suggestion for this for the data analyst role there is a future but the companies can hire the freshers or not thats my question .
Finished watching
How can we see column prolife for entire dataset and not just for first 1000 rows ??
Anyone ??
Hi Shashank ........all the questions that u have asked , make a special video demonstrating the all questions with scenario based examples .
Noted.
Did he get a job ?
Pls make video's office work in data analyst main focus in which topic sir
Noted.
Very informative video
bhai ai kaam khatam kar raha hai. I am already in IT company . almost kaam ai kar raha hai . only hr ki post ka kaam ai nahi kar raha hai . layoff hoga badei level par hoga . please koi bhi youtuber reality nahi bata raha but yei real hai . yei apna course sell karnei kaei lyei kuch bhi bol rahei hai 🔴🔴🔴🟡🟡🟡🟢🟢🟢🟢
Power BI is working very slow in my system... can you please mention minimum requirements in a system to run Power BI smoothly... Thnx
@@AmirKhan-li8zi Increase RAM
@@learnwidgiggs its 4GB .. how much do I need to run smoothly..
@@AmirKhan-li8zi Atleast 8Gb
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.
Is he get the job?
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?
@@somnathdutta6311have you got job now?
@@nishyt8912 yes, cognizant
Brother ek video banao 3,4,5 year experience wale logo ke liye interview questions kaise hoge kya kya hoge ispe
Noted.
will there will job in data analyst for 2022 batch? in mnc?
Yes.
Please give us latest resume formatt for 2 yrs exp 😢
Thank you sir ❤
Welcome!
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?
Such a nice video. Hello brother can you please make a detailed video on the power bi service.
Noted.
Hi Shasank. can you make a video of unpivot columns concept in power bi.
Noted.
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 😅.
I think Fact and dimensional table wrong ans.
what would be your answer?
@@NitishKumar-l5s9s 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
Correct
Great
Wilson Charles Anderson Christopher Moore Donna
Good
Hi can I connect with you ?
Social media links in the description box.