All vs Allselected vs Allexcept DAX | Power BI Interview
Codebasics Data Analyst Bootcamp Link:
codebasics.io/bootcamps/data-analytics-bootcamp-with-practical-job-assistance?refId=9a4fdd14-f2b7-4b19-9fcf-0d7bb9e9b6b7
-------------------------------------
Topmate Link to book call 1:1 - topmate.io/learnwidgiggs
Link for the Scenario based QnA in Power BI: kzread.info/head/PLk-s1KYuT-PmgxTJKTcXwvxBgMb7rUnza
Link for the Power Bi Interview QnA playlist :
kzread.info/head/PLk-s1KYuT-Pk2a1mbFe-nH7BNVdQjsWVU
Link for the SQL QnA playlist :
kzread.info/head/PLk-s1KYuT-Pk5y28Mdl86ZfD6kgGjDdml
Link for the Data Warehousing QnA playlist :
kzread.info/head/PLk-s1KYuT-PmIb7RNUID63j9aTd5igtSw
☀ Connect with me Here on Social Media ☀
LinkedIn : www.linkedin.com/in/shashank-singh-🇮🇳-ba4b59150
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
Пікірлер: 49
Crystal clear ♥️ Thanks man for the wonderful explanation.
@learnwidgiggs
6 ай бұрын
Glad it was helpful!
Very clearly explained. Thanks a lot.
Very nice explanation. Thank you very much. So basically, AllExcepts is the opposite of All
Nice video ,my doubts are cleared only by your videos .thanks a lot .
@learnwidgiggs
9 ай бұрын
Glad to hear that.
Thank you for making this video based on my request
@learnwidgiggs
9 ай бұрын
Welcome😊
Nice explanation
Many Thanks for all videos!! Good work,keep it up🙏🙂👌
@learnwidgiggs
Ай бұрын
Most welcome 😊
Hi there! Is it true that we need to sign in to access all the features provided in power BI?
Really superb. Clear explanation with a simple example. Thanks Shashank for sharing this video with us.😊
@learnwidgiggs
Ай бұрын
Glad you liked it.
Thanks for the videos
@learnwidgiggs
9 ай бұрын
Welcome 😊
Thank you for sharing this Important Interview Question with us Sir. You are looking very nice in Black Shirt.👌
@learnwidgiggs
9 ай бұрын
Dhanyawad 🙏
Good Content always 🙂
@learnwidgiggs
9 ай бұрын
Thank you 😊
Nicely explained 👌
@learnwidgiggs
4 ай бұрын
Glad to hear this!
Hi Bro. Your video's are helped me a lot. I have a question which asked me in an interview. How to cache the data / pre-calculating data to optimize speed ?
@raahinakeethadath9725
8 ай бұрын
File-options-setting-global- clear cache
@b.prabakaran9979
4 ай бұрын
In Power BI, you can optimize performance and speed by caching data through various methods. Here are some strategies you can use to cache or pre-calculate data in Power BI: DirectQuery vs. Import Mode: Power BI offers two main data storage modes: Import and DirectQuery. Import mode loads data into Power BI's internal data model, allowing for faster performance as data is cached in memory. DirectQuery mode queries data directly from the data source, which can be slower but ensures real-time data access. You can choose the appropriate mode based on your data size, refresh frequency, and performance requirements. Data Refresh Scheduling: Schedule regular data refreshes to ensure that your dataset stays up-to-date while also caching the data for faster access. Power BI allows you to set up automatic refresh schedules for datasets, ensuring that the data is refreshed at specified intervals. Incremental Data Refresh: Implement incremental data refresh to update only the new or changed data since the last refresh. This helps reduce data refresh time and optimizes performance, especially for large datasets. Data Aggregation: Pre-aggregate or summarize data where possible to reduce the volume of data loaded into memory. Aggregating data at a higher level of granularity can improve query performance and reduce memory usage. Optimize DAX Measures: Write efficient DAX measures that minimize the computational load on the data model. Avoid using complex or nested calculations that can slow down query performance. Use Calculated Columns Sparingly: Limit the use of calculated columns, especially if they involve heavy calculations or string manipulations. Calculated columns can increase the size of the data model and impact performance. Partitioning: Partition large tables into smaller segments based on date ranges or other criteria. Partitioning helps improve query performance by allowing Power BI to query only relevant segments of data. Optimize Data Model Relationships: Create optimized relationships between tables in your data model to improve query performance. Use appropriate cardinality and cross-filter direction settings based on your data relationships. Use Aggregations: Set up aggregations to store pre-calculated summary data at different levels of granularity. Aggregations help accelerate query performance, especially for large datasets. Data Compression: Ensure that your data is stored in a compressed format to reduce storage requirements and improve query performance. Power BI automatically compresses data where possible. By implementing these strategies, you can effectively cache data and optimize performance in Power BI, resulting in faster report rendering and improved user experience.
Helpful information
@learnwidgiggs
9 ай бұрын
Glad you found it useful
I have a question that is, I have a table visual with 5 fields and I have same in the slicer now where ever the client select any two fields it have to give the difference how can we get any idea that u can share
@learnwidgiggs
9 ай бұрын
Didn't get your question
@monishpilla4137
9 ай бұрын
@@learnwidgiggs I have 5 feilds in my slice if my client select any two of them it have to give the difference of them
Live class they provide
make videos about data modeling and give the examples also.
@learnwidgiggs
8 ай бұрын
Okay..noted
Bro on wednesday my interview is their plz suggest me the important questions from python and power bi
@Engineering4675
9 ай бұрын
@bangalore?
@kanavvasudeva1799
9 ай бұрын
@@Engineering4675 hyderabad
@learnwidgiggs
9 ай бұрын
From Power BI side, just revise all the videos from this channel...you are good to go.
Hello Shashank i want to know the answer of one question which was asked in one of my recent interview, where should i share my question with you ?
@learnwidgiggs
9 ай бұрын
You can share on my mail id. (mail id present in the about section of the channel)
Is it necessary to take pl 300 exam to become data analyst
@learnwidgiggs
9 ай бұрын
No
Hi Shashank, yesterday i make a comment here, however it's deleted. I think you don't want to reply me.
@learnwidgiggs
9 ай бұрын
Sorry I didn't see any message of yours. Maybe KZread would have deleted it on its own if founded it as spam.
@abhishekvrm2777
7 ай бұрын
😂
Table a Column1 12 15 35 65 Approved Pending 67 98 Pending Approved This is the data how to do sum here?
@ananyabhattacharyya2362
3 ай бұрын
First convert the non numeric values to null using conditional statement. Then sum the latest column which is recently made.
@sandhyah6089
Ай бұрын
@@ananyabhattacharyya2362 not working
Asked in EY Product Name Category AbcBike Bike Bike123 Bike DEF Accessories LFG Accessories Bike Bike Need to create this in Power Bi category calculated column My solution Category = Switch ( TRUE(), CONTAINSSTRING(‘Table[Product Name],”Bike”),”Bike”, CONTAINSTRING(‘Table[Product name ],”Accessories “),”Acceesories”, “Accessories “ )
paid promotion na , kitna diya aapko ???????