Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit instead

Utilize your Business Intelligence with Analytics

Utilize your Business Intelligence with Analytics, Singapore SKillsFuture elarning online course

Course Description

Data is the fuel that powers modern business and the ability to aggregate and quickly slice and dice data to make accurate, timely decisions is vital in today's environment. Business intelligence is the set of techniques and tools that transform raw, day-to-day, operational data into categorized, aggregated, useful information for fast business analysis purposes. Microsoft's business intelligence tools including SQL Server 2014, SQL Server Analysis Services, Visual Studio/SSDT and Excel provide end users with the power to perform self-service BI and it provides developers the tools they need to create enterprise level BI systems. In this course, Mark Long, teaches you how to work with these tools to create multidimensional data cubes and Microsoft's new tabular data model to provide BI services and help you prepare for Microsoft's certification exam 70-466 Implementing Data Models and Reports with SQL Server.

Data plays an integral part in understanding analysis.

- Learn how to maintain your database
- Know how you should sort your data in SQL Server
- Learn about the different functions of data warehouse
- Be able to handle and monitor the activity in your database

This course is eligible for SkillsFuture Credit.

Course Objectives

1. Understand about the concept of Business Intelligence 
2. Able to install, configure and navigate the interface of SQL Server 2014 
3. Understand about the purpose of having a functional data warehouse
4. Know the different ways of analyzing data using SQL Server 
5. Able to apply different operations and commands in queries 

Related Courses

  • Microsoft OneNote 2013

    Microsoft OneNote 2013

    SGD $40.00

    Course Description

    Microsoft OneNote 2013 is used to store information in a central location where it can easily be shared, backed up, and searched. In this VTC course, author Brian Culp compares OneNote to a digital version of a spiral-bound notebook as he shows you how to quickly add text, pictures, video, and even handwritten notes. He also explains how OneNote integrates with other Office 2013 applications, especially Word, Excel, and Outlook. Additionally, Brian covers how to leverage powerful features such as the ability to link notes automatically, customize the interface, and quickly track down unread notes. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course 


  • Discover More of Your Data with Microsoft Excel

    Discover More of Your Data with Microsoft Excel

    SGD $40.00

    Course Description

    Microsoft Excel is one of the most popular programs to use for analyzing, extracting, and cleaning the tremendous amounts of data that we have collected. Learn how Microsoft Excel can manage and summarize your data with PowerPivot and Pivot Tables, automation and coding, along with the standard features of Arrays, functions such as MATCH and INDEX, and the Data Analysis Tools. Understand speed and file size limitations while appreciating the art of data cleaning and manipulation. Explore how the What If Analysis tools can help with plans and forecasts and consolidate and link data for interactive reports. This course will allow you to unleash the power of Excel to make accurate decisions based on your data and Excel's power.Realise the full potential of your data with Microsoft Excel. - Learn about the functions in Excel that can help your understand data better - Know the different ways of vizualising your data with Excel- Pick up the knowledge of utilizing Excel for better understanding your data- Learn how you can stretch your data for optimum analysis This course is SkillsFuture Credit Eligible.


  • Corel Painter 2016

    Corel Painter 2016

    SGD $45.00

    Course Description

    Corel Painter 2016 is the latest new update for the powerful and popular natural media emulator which is used by professional creative artists in a wide variety of genres and styles. This course, taught by longtime illustrator and fine artist Jason Maranto, is designed to quickly familiarize you with the core features of this powerful application. Focusing on all the main tools and functions with an in-depth but easy to follow style, this course is packed with professional workflow tips and tricks, and will help you to master Painter and create with confidence like never before.Dive into Corel Painter and unleash your artistic flare!- Learn about the tools and techniques available in Corel Painter - Know about the different types of tools and techniques used in Corel Painter - Discover the capability of Corel Painter to create dynamic creative content - Be able to produce content that can rival physical painting 



Welcome and Intro

Preview Available



Course Overview

Database Types

What is Business Intelligence?

BI Components

SQL Server Analysis Services

OLAP, Cubes, Etc.

About this Course

About the Exam

SQL Server 2014


SQL Server 2014 Editions

SQL Server Management Tools

SQL Server Data Tools

Integration Services

Analysis Services

Reporting Services

BI Clients

Data Quality Services

Master Data Services

Getting Set Up


What You Will Need

Hardware Requirements

Software Requirements

Getting SQL Server 2014

Getting Visual Studio Community 2013

Installing SQL Server 2014 pt. 1

Installing SQL Server 2014 pt. 2


Installing SSDT-BI

Tools Tour

Sample Databases

Installing Sample Databases pt. 1

Installing Sample Databases pt. 2

Working with Diagrams

SQL Server Connection Issue

Understanding Business Intelligence


BI Terminology pt. 1

BI Terminology pt. 2

Understanding BISM

BISM Architecture

Multidimensional vs. Tabular


Data Warehouse Basics


Dimensional Modeling

Fact Tables

Dimension Tables

Multidimensional Cube Development


Multidimensional Basics

Creating a Cube with SSDT

Creating a Cube Data Source

Creating a Data Source View pt. 1

Creating a Data Source View pt. 2

Making the Data User Friendly

Named Calculations

Creating the Cube

Creating Dimensions First

Formatting Output

Formatting Utility

Using the Dimension Designer

Understanding Attributes

Understanding Hierarchies pt. 1

Understanding Hierarchies pt. 2

User-Defined Hierarchies pt. 1

User-Defined Hierarchies pt. 2

Attribute Relationships

Creating Attribute Relationships pt. 1

Creating Attribute Relationships pt. 2

Defining Calculated Members pt. 1

Defining Calculated Members pt. 2

Understanding KPIs

Creating a KPI pt. 1

Creating a KPI pt. 2


Creating Aggregations



Multidimensional Queries


MDX Basics pt. 1

MDX Basics pt. 2

MDX Structure pt. 1

MDX Structure pt. 2


Using TopCount

Tabular Model Development


SSAS Tabular Basics

Creating a Tabular Project

Importing Data

Creating Measures

Analyze in Excel Button

Deploying a Tabular Model

Calculated Columns

Creating Hierarchies pt. 1

Creating Hierarchies pt. 2

Creating Hierarchies pt. 3

DAX Basics

Calculated Column or Measure


Creating KPIs

Course Wrap Up


Course Wrap Up

About the Author


About the Author

SkillsFuture Credit Eligible
SGD $45.00
(Price excludes GST)
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.