• 0800 677 1232
  • info@robustittraining.com
  • Facebook:
  • LinkedIn:
  • Youtube:
  • Black Friday Sale Has Started: Click here to see deals

MCSA SQL Server 2016 Business Intelligence

EXAM CODE 70-768

About

This certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes.

Who should take this exam?

This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.

Benefits of training with us

  • Intuitive and rewarding online training resources

  • 24/7 access to our unique course materials

  • Custom built practical tasks and challenges
  • Official mock examinations to fully prepare you for any final exams
  • Career advice and CV support once training has been completed
  • Full printable course materials, allowing you take your learning offline at your own convenience

Enquiry Form

Request More Information

Design a multidimensional business intelligence (BI) semantic model (25-30%)
Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
  • Design, develop, and create multidimensional databases; select a storage model
Design and implement dimensions in a cube
  • Select an appropriate dimension model, such as fact, parent-child, roleplaying, reference, data mining, many-to-many, and slowly changing dimension; implement a dimension type; define attribute relationships
Implement measures and measure groups in a cube
  • Design and implement measures, measure groups, granularity, calculated measures, and aggregate functions; define semi-additive behavior

Design a tabular BI semantic model (20-25%)
Design and publish a tabular data model
  • Design measures, relationships, hierarchies, partitions, perspectives, and calculated columns; create a time table; publish from Microsoft Visual Studio; import from Microsoft PowerPivot; select a deployment option, including Processing Option, Transactional Deployment, and Query Mode
Configure, manage, and secure a tabular model
  • Configure tabular model storage and data refresh, configure refresh interval settings, configure user security and permissions, configure row-level security
Develop a tabular model to access data in near real time
  • Use DirectQuery with Oracle, Teradata, Excel, and PivotTables; convert in-memory queries to DirectQuery

Develop queries using Multidimensional Experssions (MDX) and Data Analysis Experssions (DAX) (15-20%)
Create basic MDX queries
  • Implement basic MDX structures and functions, including tuples, sets, and TopCount
Implement custom MDX solutions
  • Create custom MDX or logical solutions for pre-prepared case tasks or business rules, define a SCOPE statement
Create formulas by using the DAX language
  • Use the EVALUATE and CALCULATE functions, filter DAX queries, create calculated measures, perform data analysis by using DAX

Configure and maintain SQL Server Analysis Service (SSAS) (30-35%)
Plan and deploy SSAS
  • Configure memory limits, configure Non-Union Memory Architecture (NUMA), configure disk layout, determine SSAS instance placement
Monitor and optimize performance
  • Monitor performance and analyze query plans by using Extended Events and Profiler, identify bottlenecks in SSAS queries, monitor processing and query performance, resolve performance issues, configure usability limits, optimize and manage model design
Configure and manage processing
  • Configure partition processing; configure dimension processing; use Process Default, Process Full, Process Clear, Process Data, Process Add, Process Update, Process Index, Process Structure, and Process Clear Structure processing methods; configure Parallel, Sequential, and Writeback processing settings
Create Key Performance Indicators (KPIs) and translations
  • Configure KPI options, including Associated measure group, Value Expression, Goal Expression, Status, Status expression, Trend, Trend expression, and Weight; create KPIs in multidimensional models and tabular models; create and develop translations

  • Official Microsoft 70-768 Exam
  • Online or classroom training
  • Interactive mock exams
  • Live Lab (access to LIVE software)
  • Free Phone Support
  • Online & Email Support
  • World wide Recognised Qualification
  • Unlimited access for 12 months
  • Database Administrator
  • IT Security Specialist
  • Network Administrator
  • Systems Analyst
  • Database Engineer
  • Computer Network Technician
  • Database Architect

Courses you might also be interested in

MTA Database Fundamentals


This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on...

Find out more

MCSA SQL Server 2012/2014


This certification demonstrates your skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments. This exam is intended for SQL Server database administrators, system engineers...

Find out more

MCSA SQL Server 2016 Development


This exam is intended for database professionals who build and implement databases across organisations and who ensure high levels of data availability. Their responsibilities include creating database files, data types ...

Find out more

MCSA SQL Server 2016 Admin


This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently...

Find out more

Our training is trusted and accredited
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1