Regular Price: £500 Batch Price: From £500 📅 View Dates & Prices Course Overview This course is for BI Developers and DB professionals responsible for preparing data for multidimensional analysis. This course helps students on how to design and develop SQL Server Analysis Service Databases. It covers dimensional modeling, development of dimensions and development of cubes. Students will also learn to apply business logic in the cube using calculations, named sets and KPI. This course also cover some of the Advanced features like implementing security for different users of analysis service. Requirements Knowledge about SQL Server and Data Warehouse concepts. Our SQL for Beginners and SQL Server Integration Services (SSIS) Training Courses cover all of the prerequisites. Course Content Introduction to SSAS Introduction to SSAS Usage and Benefits of SSAS Business Intelligence OLAP VS OLTP Dimensional Modelling Basics of Dimensional Modelling Creating a Data Source Different types of modelling Creating a CUBE using wizard Schema generation Data Source View Named calculations Named queries Dimension Development -1 Create dimension using wizard Dimension designer Attributes Implementing a Date dimension Unknown Member Attribute properties Dimension Development -2 Best practises – customization User hierarchies Parent child hierarchy Attribute relationship Translations Development tasks CUBE Development -1 Cube Wizard Cube Designer Measure properties Aggregate functions Role playing dimension Additional measures Dimension usage CUBE Development -2 Aggregations Perspectives Translations Cube Development Tasks Calculations – Basic Calculations overview Calculations Designer Calculation Tools Formula Calculation to Sum Testing a calculation Functions Color and font expressions Calculations – Advanced Calculated members of dimension Named sets Key performance indicators Administrative Tasks Deployment using SSDT Deployment wizard Storage wizard Processing options Security User security Dimension security Testing security Multiple roles Default member Cell level security Administrative security Advanced Analysis Service Partitions Writeback Referenced Relationship Many-Many Relationship Introduction to MDX Basics of MDX MDX VS SQL Usage of MDX Tuples and Sets Axes , Rows and Columns Cell Properties MDX Functions Hierarchies in MDX Hierarchy Navigation Course Dates, Prices & Enrolment All Training Physical Classes Virtual Classes UTC British Time (UK, Ireland, Iceland) Central European Time (France, Germany, Sweden) Eastern European Time (Finland, Cyprus) Eastern Time (New York, Toronto, Montreal) Central Time (Chicago, Houston, Winnipeg) Mountain Time (Calgary, Denver, Edmonton) Mountain Time (Phoenix) Pacific Time (Los Angeles, Seattle, Vancouver) Singapore Time Arabic Standard Time (Qatar, Saudi Arabia) Gulf Standard Time (UAE, Oman) Australian Eastern Time (Sydney, Melbourne) Western Australia Time (Perth) New Zealand Time China Standard Time (China, Taiwan, Hong Kong) Scroll right for more details There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later.