![House of Concepts](/img/default-banner.jpg)
- 165
- 283 491
House of Concepts
เข้าร่วมเมื่อ 21 ส.ค. 2022
Hi, there! It feels great that you have landed on this page to read about us.
We are putting a lot of efforts to make detailed learning videos on various technical concepts that will be helpful for anyone working or looking to work in IT industry.
Our aim is to share the knowledge and experience that we have gained over the years with each one of you.
You can show your appreciation by making sure you subscribe to our channel. Thank you!
Currently posting videos in Hindi. :)
All the study material and resources are available at our website.
Channel for Videos in English : www.youtube.com/@houseoftechconcepts
Email for business enquires: thehouseofconcepts@gmail.com
We are putting a lot of efforts to make detailed learning videos on various technical concepts that will be helpful for anyone working or looking to work in IT industry.
Our aim is to share the knowledge and experience that we have gained over the years with each one of you.
You can show your appreciation by making sure you subscribe to our channel. Thank you!
Currently posting videos in Hindi. :)
All the study material and resources are available at our website.
Channel for Videos in English : www.youtube.com/@houseoftechconcepts
Email for business enquires: thehouseofconcepts@gmail.com
Power BI INTERVIEW Question || SEARCH || DAX
In this video we are going to discuss about important Power BI Interview Question
********************** Must Watch Videos on this channel ************************************************
COMPLETE POWER BI Project in 4 Hours !!
th-cam.com/video/aEIf_JwzuJQ/w-d-xo.html
SQL in 7 HOURS (MySQL) !! + Interview Questions
th-cam.com/video/FAUkCNUZ1hE/w-d-xo.html
Complete Data Analyst Roadmap for 2024 in easy language:
th-cam.com/video/N2AfzjoBU9k/w-d-xo.html
Do watch our DAX 7 Hour Course:
th-cam.com/video/KmIdcQCcfzg/w-d-xo.html
Data Warehouse Complete Course - Must watch for beginners :
th-cam.com/video/fAQFLw6rV6w/w-d-xo.html
10 Important SQL Interview Questions - Good to Start :
th-cam.com/video/usS38YUmYv0/w-d-xo.html
End to End Project in Power BI:
th-cam.com/video/b5Peg5lwxag/w-d-xo.html
******************************* Important Playlists to understand concepts in detailed manner ********************
⭐⭐⭐Power Query Videos playlist:📚📚
---------------------------------------------------------------------
th-cam.com/video/P5i1Kzgk6TA/w-d-xo.html
⭐⭐⭐Data Modelling in Power BI videos playlist:📚📚
--------------------------------------------------------------------------------------------
th-cam.com/video/FyFsLKWU3VQ/w-d-xo.html
⭐⭐⭐Power BI Interview Questions Playlist:📚📚
------------------------------------------------------------------------------------
th-cam.com/video/dpitbEmU8u4/w-d-xo.html
⭐⭐⭐Power BI Concepts Playlist:📚📚
---------------------------------------------------------------------
th-cam.com/video/0C_8vjE5VNc/w-d-xo.html
⭐⭐⭐SQL Interview Questions Playlist:📚📚
---------------------------------------------------------------------
th-cam.com/video/oh3NVYQgYLE/w-d-xo.html
**********************************************************************
Website : houseoftechconcepts.com/
Instagram : @house.of.concepts
**********************************************************************
#beginners #interview #interviews #database #sql #like #share #subscribe #excel #datanalytics #datascience #tutorial #course #interview #project #mysql #case statement #pivoting #powerbi #dashboard #reports #stepbystep #endtoend #tableau #charts #notes #material
********************** Must Watch Videos on this channel ************************************************
COMPLETE POWER BI Project in 4 Hours !!
th-cam.com/video/aEIf_JwzuJQ/w-d-xo.html
SQL in 7 HOURS (MySQL) !! + Interview Questions
th-cam.com/video/FAUkCNUZ1hE/w-d-xo.html
Complete Data Analyst Roadmap for 2024 in easy language:
th-cam.com/video/N2AfzjoBU9k/w-d-xo.html
Do watch our DAX 7 Hour Course:
th-cam.com/video/KmIdcQCcfzg/w-d-xo.html
Data Warehouse Complete Course - Must watch for beginners :
th-cam.com/video/fAQFLw6rV6w/w-d-xo.html
10 Important SQL Interview Questions - Good to Start :
th-cam.com/video/usS38YUmYv0/w-d-xo.html
End to End Project in Power BI:
th-cam.com/video/b5Peg5lwxag/w-d-xo.html
******************************* Important Playlists to understand concepts in detailed manner ********************
⭐⭐⭐Power Query Videos playlist:📚📚
---------------------------------------------------------------------
th-cam.com/video/P5i1Kzgk6TA/w-d-xo.html
⭐⭐⭐Data Modelling in Power BI videos playlist:📚📚
--------------------------------------------------------------------------------------------
th-cam.com/video/FyFsLKWU3VQ/w-d-xo.html
⭐⭐⭐Power BI Interview Questions Playlist:📚📚
------------------------------------------------------------------------------------
th-cam.com/video/dpitbEmU8u4/w-d-xo.html
⭐⭐⭐Power BI Concepts Playlist:📚📚
---------------------------------------------------------------------
th-cam.com/video/0C_8vjE5VNc/w-d-xo.html
⭐⭐⭐SQL Interview Questions Playlist:📚📚
---------------------------------------------------------------------
th-cam.com/video/oh3NVYQgYLE/w-d-xo.html
**********************************************************************
Website : houseoftechconcepts.com/
Instagram : @house.of.concepts
**********************************************************************
#beginners #interview #interviews #database #sql #like #share #subscribe #excel #datanalytics #datascience #tutorial #course #interview #project #mysql #case statement #pivoting #powerbi #dashboard #reports #stepbystep #endtoend #tableau #charts #notes #material
มุมมอง: 380
วีดีโอ
Power BI INTERVIEW Question || Bookmarks || DAX
มุมมอง 54219 ชั่วโมงที่ผ่านมา
In this video we are going to discuss about important Power BI Interview Question Must Watch Videos on this channel COMPLETE POWER BI Project in 4 Hours !! th-cam.com/video/aEIf_JwzuJQ/w-d-xo.html SQL in 7 HOURS (MySQL) !! Interview Questions th-cam.com/video/FAUkCNUZ1hE/w-d-xo.html Complete Data Analyst Roadmap for 2024 in easy language: th-cam.com/video/N2AfzjoBU9k/w-d-xo.html Do watch our DA...
Power BI Interview Question || Power Query || M code
มุมมอง 573วันที่ผ่านมา
In this video we are going to discuss about important Power BI Interview Question Must Watch Videos on this channel COMPLETE POWER BI Project in 4 Hours !! th-cam.com/video/aEIf_JwzuJQ/w-d-xo.html SQL in 7 HOURS (MySQL) !! Interview Questions th-cam.com/video/FAUkCNUZ1hE/w-d-xo.html Complete Data Analyst Roadmap for 2024 in easy language: th-cam.com/video/N2AfzjoBU9k/w-d-xo.html Do watch our DA...
Power BI Interview Question || CONCATENATEX || Complete Scenario
มุมมอง 38914 วันที่ผ่านมา
In this video we are going to discuss about important Power BI Interview Question Must Watch Videos on this channel COMPLETE POWER BI Project in 4 Hours !! th-cam.com/video/aEIf_JwzuJQ/w-d-xo.html SQL in 7 HOURS (MySQL) !! Interview Questions th-cam.com/video/FAUkCNUZ1hE/w-d-xo.html Complete Data Analyst Roadmap for 2024 in easy language: th-cam.com/video/N2AfzjoBU9k/w-d-xo.html Do watch our DA...
Power BI Interview Question || ALL vs ALLSELECTED || Complete Scenario
มุมมอง 32414 วันที่ผ่านมา
In this video we are going to discuss about important Power BI Interview Question Must Watch Videos on this channel COMPLETE POWER BI Project in 4 Hours !! th-cam.com/video/aEIf_JwzuJQ/w-d-xo.html SQL in 7 HOURS (MySQL) !! Interview Questions th-cam.com/video/FAUkCNUZ1hE/w-d-xo.html Complete Data Analyst Roadmap for 2024 in easy language: th-cam.com/video/N2AfzjoBU9k/w-d-xo.html Do watch our DA...
SQL - GROUP BY & HAVING Clause || Complete Tutorial
มุมมอง 242หลายเดือนก่อน
In this video we are going to discuss about GROUP BY and HAVING Clause Must Watch Videos on this channel COMPLETE POWER BI Project in 4 Hours !! th-cam.com/video/aEIf_JwzuJQ/w-d-xo.html SQL in 7 HOURS (MySQL) !! Interview Questions th-cam.com/video/FAUkCNUZ1hE/w-d-xo.html Complete Data Analyst Roadmap for 2024 in easy language: th-cam.com/video/N2AfzjoBU9k/w-d-xo.html Do watch our DAX 7 Hour Co...
JOINS in MySQL || Complete Tutorial || Interview Questions
มุมมอง 298หลายเดือนก่อน
To download the material ... Checkout the following link and click on Download File button under JOINs in MySQL section houseoftechconcepts.com/pages/mySqlStudyMaterial.html Following Topics are covered in this video: .. 00:00 Introduction 01:11 What are Joins ? 03:30 Understanding Dataset. 05:08 Inner Join 11:20 Outer Joins in MySQL 13:49 Left Outer Join 18:18 Right Outer Join 20:29 Full Outer...
SQL in 7 HOURS (MySQL) !! + Interview Questions
มุมมอง 2.2Kหลายเดือนก่อน
To download the course material .. Checkout the following Link : houseoftechconcepts.com/pages/mySqlCourseStudyMaterial.html Following Topics are covered in this video 00:00:00 Introduction 00:03:24 Course Roadmap 00:07:02 What is Database ? 00:13:48 MySQL Installation 00:23:24 DDL & DML Commands 01:01:31 Select & Where clause 01:21:32 Order By & Limit 01:36:14 Operators in MySQL 02:04:38 Joins...
NATURAL JOIN vs CROSS JOIN || Important Interview Question
มุมมอง 1272 หลายเดือนก่อน
In this video we are going to discuss on Natural Join and Cross Join in detail To download the data file used in this video.Checkout the following link and click on DOWNLOAD File button under Natural and Cross Joins section houseoftechconcepts.com/pages/mySqlStudyMaterial.html Topics covered in this video: 00:00 Introduction 01:12 What is Natural Join 03:14 Practical Example of Natural Join 07:...
DDL DML DQL in SQL || Must Watch for Beginners
มุมมอง 1.4K2 หลายเดือนก่อน
To download the data file used in this video checkout the following link and click on Download button under DDL,DQL and DML commands: houseoftechconcepts.com/pages/sqlCourseStudyMaterial.html In this video we are going to discuss DML, DQL & DDL commands using SQL SERVER Topics covered in this video: 00:00 Introduction 00:12 Project Scenario 00:38 About SQL Server Management Studio 00:50 SQL Ser...
🔥Top SQL INTERVIEW Question🔥
มุมมอง 2812 หลายเดือนก่อน
In this Video we are going to discuss one of the important Interview Question based on Correlated Subquery.. To download the data file.. Checkout the following link and click on download file button present on Correlated Subquery section: houseoftechconcepts.com/pages/mySqlStudyMaterial.html 00:00 Introduction 00:40 Understanding Sample Data 01:32 Details of Interview Question 04:04 Writing Sol...
🔥SQL INTERVIEW Question | Handling NULLS in INNER JOIN🔥
มุมมอง 4272 หลายเดือนก่อน
In this video we are going to discuss an Interview Question based on Handling NULL values while performing INNER JOIN Topics covered in this video: 00:00 Introduction 00:48 Understanding Table Structure 01:56 Understanding INNER JOIN Output 05:01 Handling NULL values using COALESCE 07:29 Handing NULL using extra Condition 09:03 Summary of Video Must Watch Videos on this channel Complete Data An...
🔥SQL Interview Question | Must Watch for Beginners🔥
มุมมอง 5232 หลายเดือนก่อน
To download the data file used in this video checkout the following link: houseoftechconcepts.com/pages/mySqlStudyMaterial.html In this video we are going to discuss Important Interview Question based on COALESCE function in SQL Topics covered in this video: 00:00 Introduction 00:23 Understanding Dataset 02:25 What is COALESCE function ? 03:18 Basic Interview Scenarios 08:57 Interview Question ...
PYTHON in 3 HOURS || COMPLETE PROJECT
มุมมอง 1.4K3 หลายเดือนก่อน
To download the files used in this video, click on following link: houseoftechconcepts.com/pages/pythonprojectStudyMaterial.html Download all the 3 Parts: Data Analyst End to End Python Project(Waste Water Management) - Part 1 Data Analyst End to End Python Project(Waste Water Management) - Part 2 Data Analyst End to End Python Project(Waste Water Management) - Part 3 Please Subscribe to our ch...
🔥🔥POWER BI Interview Question 🔥🔥
มุมมอง 7124 หลายเดือนก่อน
To download the data file used in this video checkout the following link.. Click on Download Button present in Percentage of Total Sales Section ..... houseoftechconcepts.com/pages/powerBiInterviewStudyMaterial.html In this video we are going to discuss important Power BI Interview Scenario Topics covered in this video: 00:00 Introduction 00:23 Question Explanation 01:40 Data File Import in Pow...
🔥🔥IMPORTANT SQL INTERVIEW Question for BEGINNERS 🔥🔥
มุมมอง 6144 หลายเดือนก่อน
🔥🔥IMPORTANT SQL INTERVIEW Question for BEGINNERS 🔥🔥
COMPLETE POWER BI Project in 4 Hours !!
มุมมอง 6K5 หลายเดือนก่อน
COMPLETE POWER BI Project in 4 Hours !!
Learn DATA ANALYTICS using MYSQL - Complete Tutorial
มุมมอง 3786 หลายเดือนก่อน
Learn DATA ANALYTICS using MYSQL - Complete Tutorial
🔥Complete Data Analyst Roadmap : 2024🔥
มุมมอง 5676 หลายเดือนก่อน
🔥Complete Data Analyst Roadmap : 2024🔥
🔥 TOP 10 Important SQL Interview Questions 🔥
มุมมอง 1K8 หลายเดือนก่อน
🔥 TOP 10 Important SQL Interview Questions 🔥
Data Analysis using MySQL | INTERVIEW QUESTIONS
มุมมอง 2848 หลายเดือนก่อน
Data Analysis using MySQL | INTERVIEW QUESTIONS
DATA ANALYSIS in MySQL | INTERVIEW QUESTIONS
มุมมอง 2249 หลายเดือนก่อน
DATA ANALYSIS in MySQL | INTERVIEW QUESTIONS
DATA ANALYSIS in MySQL | Interview Questions
มุมมอง 2079 หลายเดือนก่อน
DATA ANALYSIS in MySQL | Interview Questions
RANK Window Function in MySQL ( INTERVIEW QUESTIONS )
มุมมอง 1949 หลายเดือนก่อน
RANK Window Function in MySQL ( INTERVIEW QUESTIONS )
MySQL Interview Questions - BEGINNER and ADVANCED
มุมมอง 2509 หลายเดือนก่อน
MySQL Interview Questions - BEGINNER and ADVANCED
Playlist kyo nhi bnate aap
nice explanation
Thanks for your kind words !! Keep supporting the channel !!
Hi, can you make a video SQL serve full course, because I am going to interview with SQL server and power bi. If possible then please do something or can give a traing on these technologies.
Hi Malay, I will definitely come up with a course of SQL Server .. In the meantime you can check our MySQL complete course video in which i have covered important SQL topics from important perspective.....
@@thehouseofconcepts thanks
Very informative...i started learning... thank you so much for this video 😊😊
Thanks for your kind words !! Keep supporting the channel !!
Where we can download 0lease
To download the data file .. Checkout the pinned comment ......
How many Power bi developers will be there in organisation? Startup, mid level and MNC
M language code used in this problem:- -> text.combine -> list.transform -> text.from
Thanks
Thank you for sharing amazing explanation on these interview questions!! Your explanation is clear and easy to understand
Thanks for your kind words !! Keep supporting the channel !!
Mast bhai
Thanks !! Keep supporting the channel !!
"Data doesn't lie; it guides."
Thanks !! Keep supporting the channel !!
Make the some videos on power bi service because i face lot of issue regarding
Hi .. Sure will come up with Power BI Service videos as well... Thanks for suggestion
Good one brother.
Thanks for your kind words !! Keep supporting the channel !!
Thank you
Thanks !! Keep supporting the channel !!
Awesome 👍
Thanks !! Keep supporting the channel !!
Nice❤
Thanks !! Keep supporting the channel !!
Where is views, index, CTE, Triggers, Stored Procedure, Functions
Summarize and SummarizeColumn function ?
Hi Vikas.. Will try to cover them in separate video... Thanks
❤ is se jayda kya du
Thanks for your kind words !! Keep supporting the channel !!
Excellent...thank u for the video
Thanks for your kind words !! Keep supporting the channel !!
Can we have the videos in english if possible
Any videos in english
do you also provide personal trainings?
32:31 from where you have taken 2^(13)
well done! Really Great Explaination
Thanks for your kind words !! Keep supporting the channel !!
Sir, thank you so much for teaching us a lot through your videos. We've learned many imp topics and hope you continue sharing your knowledge.
Thanks for your kind words !! Keep supporting the channel !!
Very nice 👍
Thanks .. Keep Supporting the channel !!
at 1:15:28 , after applying taht filter context you are not getting your desired result which was sum and even if you are getting you did not show that, please man at least tell that is usecase of filter context
Hi Bhavesh, We are getting our desired result ... Now, Lets understand like this... When we have used SUM function we were not be able to provide filter context and hence you have seen same Total values were duplicated for each row.. Now when we have used CALCULATE we have transformed row context to filter context explicitly due to which total values get filtered out and individual values get reflected against each row .. This was the entire scenario.. Hope this helps!!
could not fine measure tools tab, please help.
Hi Pawan, Its the dynamic tab appears only when selecting the specific Measure
Hello sir, Sir Rankx function me aapne ALL ka use kiya hai aap 1 bar aur achche se clear kr skte hai bcoz maine bohot videos dekh li but mujhe smjh nahi aa rha..main usko visualise nahi kr pa rha beacuse Maxx ya baki Iterator function me ALL ka use nahi krte...
Hi Vivek, We have shared new video on ALL vs ALLSELECTED .. Hope that will help ...
I have to say that this is the best video I have come across for Power BI dax formula's that too in easy understanding methods. Thanks a lot to you Sir for delivering such a masterpiece so gradually and smoothly. Best stuff for a person to learn Power BI.Thanks
Thanks for your kind words !! Keep supporting the channel !!
Very helpful Video Sir
Thanks for your kind words !! Keep supporting the channel !!
@@thehouseofconcepts Can u pls upload videos on End to End power Bi dashboards, which is related to realtime project, i am practicing for interview.
Aapka BI Dax ka marathon video dekh rahabhi aur Data modeling in power BI ka complete Marathon video banayea in Hindi language
Thanks for your kind words !! Yes will try to create complete Power BI video .. In the meantime you can check Power BI Projects video on this channel .. I have tried to explain important concepts of Power BI in those videos .. Keep Supporting !!
@@thehouseofconcepts Yes yes ek karke sara video dekh rhe hai
At 1:41:27 i beleive Instead of all(product_lookup) it will be all( product_lookup[product_name]). Filter context applied on product table will not be overwritten instead only the product_lookup[product name ] column filter will be overwrite by the dax. Other filter applied by product lookup table will work as it was working. At 1:45:03 even if you have used any other filter of the product_lookup table in outer filter that narrow downs product lookup rows. All will again unfold the all rows of product_lookup table as you have used all(product_lookup) and then apply product name - mobile filter. So the same number of rows come each time and thus the values will be same for all product or for any other outer filter context which will be mobile sales.
Hi Akay, Let's Understand like this Case 1: If we will change ALL(Product_Lookup) to ALL(Product_Lookup[Product_Name]) then what will happen filter context will get eliminated from Product_Name column only and Mobile Sales value will be duplicated for all the products but suppose we take Product ID in place of Product Name then filter context will work and Mobile Sales get reflected against Mobile Product ID only and for other product ids values will come empty due to filter context so it depends whether you want to remove filter context from all the columns or from single column of a table. Case 2 : Again, on similar lines because we have removed filter context on Product_Lookup table in our scenario values of Mobile Sales will be duplicated for all the products even if you replace Product_Name with Product_ID same values will be duplicated because we remove filter context from entire table not from specific column... Hope this helps!!
Wonderful explanation. I not only comprehensively understood factless fact table but whole star schema fucionality also through this video.
Thanks for your kind words !! Keep supporting the channel !!
What is power pivot?
Power Pivot is a technology that is helpful in creating data models , establishing relationships or creating calculations
@@thehouseofconcepts Thank you so much for your prompt response.
Make ETL testing end to end retail domain project it will help Till now no tech TH-cam channel made .
Hats off clear understood the topic
Thanks for your kind words !! Keep supporting the channel !!
Thanks for your kind words !! Keep supporting the channel !!
Hello..I have been watching your power Bi videos recently and learnt a lot from them. Requesting you to make one full end to end video covering most of the imp DAX functions and visualizations charts!Thanks.
Hi Thanks for your kind words !! We already have complete DAX course present on this channel .. Do checkout that ... & Keep supporting the channel !!
Can u share this PPT?
Hi Rohit.. You can take the screenshots for now
Tnx Sir
Really glad you’re finding it helpful…please keep supporting the channel…
When I run the exact code gives me error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
Hi, Kindly help me where are you running this code under New Measure or while creating creating New Table because from error it seems you are creating new measure not new table..
@@thehouseofconcepts OK.I am sorry . actually I realized my mistake a few seconds later. Instead of clicking table I had clicked on new measure. Later the error got rectified. Thanks for the concern