{"id":633,"date":"2022-07-29T11:31:40","date_gmt":"2022-07-29T11:31:40","guid":{"rendered":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/product\/microsoft-sql-server-2019-analysis-services-ssas\/"},"modified":"2023-09-06T06:22:01","modified_gmt":"2023-09-06T06:22:01","slug":"microsoft-sql-server-2019-analysis-services-ssas","status":"publish","type":"product","link":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/product\/microsoft-sql-server-2019-analysis-services-ssas\/","title":{"rendered":"Microsoft SQL Server 2019 Analysis Services (SSAS)"},"content":{"rendered":"<p style=\"background: #FFB250;\"><span style=\"font-size: 24.0pt; line-height: 107%; color: white;\">Overview\u00a0<\/span><\/p>\n<p>Analysis Services is a combination of two analytical engines (VertiPaq for multidimensional cubes and Data Mining and xVelocity for Tabular Data Models) used in decision support and business analytics. It provides enterprise-grade semantic data model capabilities for business intelligence (BI), data analysis, and reporting applications such as Power BI, Excel, Reporting Services, and other data visualization tools. This course provides a full introduction to the use of both of these engines in an enterprise environment.<\/p>\n<p>You will learn about creating cubes and their constituent components, the use of MDX to query the cubes, as well as how to customize a cube with KPI, actions, perspectives, and language translations. You will also learn about the differences and similarities between cubes and tabular data models, how to create a tabular data model, and the use of DAX to query the model. The third major component of the course is a form of Machine Learning called Data Mining. Data Mining is the analysis of large data set to reveal hidden patterns and trends. This course will teach you how to create a Data Mining solution, how to compare and validate different data mining options (models) for a given data set, and how to use your chosen model in a consumer-friendly client.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"background: #FFB250;\"><span style=\"font-size: 24.0pt; line-height: 107%; color: white;\">Exams<\/span><\/p>\n<p>This course includes an exam and certification by the Cyber Studies Institute.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p><strong>| Total Course Video Hours: <\/strong>8 Hrs 56 Min<br \/>\n<strong>|\u00a0 Videos: <\/strong>50<br \/>\n<strong>|\u00a0 Course Access:<\/strong> 12 Months Unlimited Access<br \/>\n<strong>|\u00a0 Study Method:<\/strong> Online Video Lessons<br \/>\n<strong>|\u00a0 Course Type:<\/strong>\u00a0Certificate Course<br \/>\n<strong>|\u00a0 Award:<\/strong> Cyber Studies Institute<\/p>\n","protected":false},"featured_media":644,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[38,41,31],"product_tag":[],"class_list":["post-633","product","type-product","status-publish","has-post-thumbnail","product_cat-data-administration","product_cat-it-developing-networking","product_cat-development-programming","first","instock","sale","virtual","purchasable","product-type-simple","customify-col"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product\/633","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/comments?post=633"}],"version-history":[{"count":2,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product\/633\/revisions"}],"predecessor-version":[{"id":1153,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product\/633\/revisions\/1153"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/media\/644"}],"wp:attachment":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/media?parent=633"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product_brand?post=633"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product_cat?post=633"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product_tag?post=633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}