Colleges and Universities Offering Implementing Data Models and Reports with Microsoft SQL Server in South Africa

Institutions Offering Implementing Data Models and Reports with Microsoft SQL Server

•  MasterGrade IT, Cape Town  
  Course entry requirements
  -At least 2 years’ experience of working with relational databases, including:
  -Designing a normalized database.
  -Creating tables and relationships.
  -Querying with Transact-SQL.
  -Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  -Some exposure to basic programming constructs (such as looping
  
  Program duration
  (i) Instructor Led Learning
  -5 Days
  
  (ii) Video Learning
  -5 Days
  
  Course outline
  -Implement a Tabular Data Model in SQL Server Analysis Services.
  -Use DAX to enhance a tabular model.
  -Create reports with Reporting Services.
  -Enhance reports with charts and parameters.
  -Manage report execution and delivery.
  -Implement a dashboard in SharePoint Server with Performance Point Services.
  -Use Data Mining for Predictive Analysis.
  -Describe the components, architecture, and nature of a BI solution.
  -Create a multidimensional database with Analysis Services.
  -Implement dimensions in a cube.
  -Implement measures and measure groups in a cube.
  -Use MDX Syntax.
  -Customize a cube.

---

More Certificate Courses in South Africa

---

View all courses in South Africa

---