OD10988 - Managing SQL Business Intelligence Operations

  1. Technical
  2. Microsoft Technical
  3. SQL Server
  4. SQL Server 2016
  5. OD10988 - Managing SQL Business Intelligence Operations

Self-paced (3 months access)

$0
or GET IT WITH SATVs

This On-Demand Microsoft Official Curriculum (MOC) Course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.

Module 1: Introduction to Microsoft SQL Server BI Solution

Lessons
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI

Module 2: SQL Server BI Features with Microsoft SharePoint

Lessons
  • Capabilities of Power BI with SharePoint
  • SharePoint with analysis services
  • SharePoint with reporting services
  • Deploying SQL server BI in a SharePoint environment

Module 3: Operating Analysis Services

Lessons
  • Configuring an analysis services server
  • Tuning an analysis services server
  • Analysis services security
  • Analysis services high availability and disaster recovery

Module 4: Supporting Analysis Services

Lessons
  • Testing analysis services cubes
  • Tuning analysis services
  • Maintaining analysis services

Module 5: Operate and Support Reporting Services

Lessons
  • Installing a native mode report server
  • Installing reporting services with SharePoint
  • Reporting services with Microsoft Azure virtual machines
  • Reporting services errors

Module 6: Share PowerPivot Workbooks in SharePoint Server

Lessons
  • PowerPivot for SharePoint
  • Install and configure PowerPivot for SharePoint

Module 7: Operate and Support Power BI

Lessons
  • Power BI desktop
  • PowerBI.Com
  • Mobile Power BI
The primary audience for this course are business intelligence professionals. The secondary audiences for this course are technically proficient business users
Before attending this course, students must have: In addition to their professional experience, students who attend this training should already have the following technical knowledge: • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas) • Some exposure to basic programming constructs (such as looping and branching) • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable. • Familiarity with SharePoint Server and Microsoft Office applications – particularly Excel

$1,130

Includes 3 months access to:
  • Microsoft official content
  • Course training videos
  • Hands-on labs
  • Practice exercises
  • Knowledge Checks
REGISTER NOW

Registration of Interest

Course has been added to your shopping cart.

OD10988 - Managing SQL Business Intelligence Operations
Free PDF Course Outline

Please choose which format you wish to download:
Start Download

By providing us with your email, you agree to the terms of our Privacy policy.

Success!

We've sent you an email to with the download links for your selected course outline.

Be sure to check your junk mail folder, just in case your mailbox didn't like our email!


Thanks
Your friends @ New Horizons

About Microsoft On-Demand Learning

Build your Microsoft technical expertise while balancing the demands of your schedule. The new MOC On-Demand series courses combine high-quality video lectures, live hands-on labs and knowledge-checks in a self-paced format to help you build skills as your schedule allows—all at once or five minutes at a time.

MOC On-Demand at a Glance

Self-Paced Learning

The modular structure offered by MOC On-Demand courses lets learners complete training piecemeal or in an order they choose.

Immediate Feedback on Mastery

Knowledge checks at the end of each module and each course tell learners whether they’ve mastered the content and are ready to move on.

SATV Eligible

Similar to In-class Microsoft official curriculum courses, MOC On-Demand is eligible for payment via Software Assurance Training Vouchers (SATVs)

Direct From the Source

MOC On-Demand is brought to you by the people who wrote the software. The content is based on the official Microsoft official curriculum (MOC).

Learn Anywhere Anytime

The high-quality in-depth video content, labs and knowledge checks are all available to you via the cloud 24 X 7.

Live Hands-on
Labs

Unlike other on-demand offerings that offer simulated labs, MOC On-Demand gives customers a live, real-time environment for hands-on training.

About OLLAnywhere

New Horizons’ OLLAnywhere is a revolutionary training delivery method that allows students to attend live instructor-led training from anywhere in Australia.

This Virtual Instructor Led Training (VILT) model allows students to experience the same award-winning training from expert instructors, access hands-on labs and use authorised vendor courseware, all from a remote location.

Gone are the days of having to travel long distances to attend training; now we bring the training to you!

Top 3 benefits of OLLAnywhere:

  • Learn from the convenience of your work, home or nearest New Horizons location
  • Gain remote access to LIVE, instructor-led training from industry certified trainers
  • Connect virtual teams for collaborative group learning.
Learn More ...
top

OLLAnywhere is a revolutionary way of utilising cutting-edge technology to allow students to attend live instructor-led training from anywhere in or outside of Australia.