Business Intelligence Certificate Programs
|Reporting Queries with SQL and MDX (1.2 CEUs)
Learn how to use the two most commonly use reporting languages: SQL and MDX. In this class you will compare the similarities and differences between these two languages and how programming in both can increase your reporting proficiency. This class will challenge you with exercises that will help you solidify what you previously learned creating reports based on both cubes and data warehouses. Topics include how to create and run MDX scripts, MDX functions, Slicing and Dicing the cubes with MDX queries, contrasting MDX to SQL queries and knowing when to use them, as well as other important topics. Prerequisites: SQL Programming Level 2, DW Design, OLAP Cubes with SSAS or equivalent knowledge. Textbook included ($50 value).