Comment by KevinChen6

MDX describes data through a multidimensional structure, which makes the semantic model it presents closer to the real business, and based on this multidimensional model for more complex queries, SQL models can also provide similar capabilities, but it may be laborious or even extremely difficult to achieve when dealing with complex queries, but MDX also has disadvantages compared to SQL, that is, to thoroughly understand the multidimensional data model than to understand the SQL table model requires more learning costs.