Realizing value from my BI technology Microsoft

Realizing value from my BI technology | Microsoft

Create strategic applications using high performance of in-memory technology OLTP, storage (datawarehouse) data, business intelligence tools and analyzes. SQL Server 2014 uses a current set of tools for deploying and database management both locally and in the cloud.

Microsoft Azure SQL Data Warehouse Overview

MICROSOFT SQL SERVER KEY FEATURES

Datawarehouse in the cloud

Microsoft Azure SQL Data Warehouse is a complete cloud-based BI suite based on Microsoft technology allowing to create and deploy datawarehouses within very short time-frame.

OLTP Database engine

SQL Server is an easy-to-administrate database
Handling of large volumes of data
OLTP
In-memory OLTP
High availability
Hybrid-cloud

OLAP engine

Microsoft Analysis Services allows you to create analytical cubes to store your business performance
Define your KPIs
Define your analytical axes

ETL data flows

Microsoft Integration Services enables data ETL services
Extract data from a large variety of sources
Transform this data into valuable information: compute new fields, combine sources…
Load information to targets
Monitor data flows

Self-Service dashboarding

Power Pivot is a great tool for gathering together data from disparate sources and combining it into a single model for analysis.

Power Query is the solution to discover data and use more advanced techniques for transforming data.

Power BI for Office 365 is a new business-intelligence (BI) solution that extends the self-service BI capabilities in Excel. Power BI enables users to share their work in the cloud while maintaining a secure connection to on-premises and cloud-based data sources and allows users to interact with reports in a browser or on a mobile device by accessing a common repository hosted in a special SharePoint site dedicated to Power BI. Users can even designate favorite reports to more easily find the reports they need most often and can get answers from their data by asking natural-language questions

Big Data

HDInsight is a Hadoop-based platform that you can use to process data of all kinds in the cloud. In particular, HDInsight is useful for processing high volumes of structured and unstructured data, which traditional relational database systems typically cannot support for a variety of reasons. HDInsight allows you to quickly establish an infrastructure for big data analysis, whether you want to develop a proof of concept for a big data solution or support ongoing analytical requirements in a production environment. Furthermore, HDInsight integrates with Microsoft’s business-intelligence tools to enable users to enhance big data with additional sources and then explore and analyze the results to gain deeper insights.

PolyBase provides an interface that allows you to work with data stored in HDFS by using SQL syntax in PDW queries—in a manner similar to querying a linked server from SQL Server—rather than MapReduce jobs. You can even use PolyBase to join relational data in PDW with data in HDFS. In addition, you can use PolyBase to move data from PDW to HDFS or vice versa. Furthermore, you can use Power Query or Power Pivot to connect to PDW and use PolyBase to import data from HDFS into Excel.

SQL SERVER 2016 NEW FEATURES

Enhanced in-memory performance

provides up to 30x faster transactions, more than 100x faster queries than disk-based relational databases and real-time operational analytics

New Always Encrypted technology

helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes

Stretch Database technology

keeps more of your customers’ historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner without application changes

Built-in advanced analytics

provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database

Business insights through rich visualizations

on mobile devices with native apps for Windows, iOS and Android

Simplified management

of relational and nonrelational data by querying both with T-SQL using PolyBase

Faster hybrid backups, high-availability and disaster
recovery scenarios

to back up and restore your onpremises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure

SQL Server Editions

SQL Server is available in three principal editions. All three editions have tighter alignment than their predecessors and were designed to meet the needs of almost any customer. Each edition comes in a 32-bit and 64-bit version. The principal editions are the following:

Enterprise edition

The Enterprise edition of SQL Server 2014 is the uppermost SKU and is considered the premium offering. It is designed to meet the highest demands of large-scale data centers and data warehouse solutions by providing mission-critical performance and availability for tier 1 applications and the ability to deploy private-cloud, highly virtualized environments and large, centralized, or external-facing business-intelligence solutions.

The Enterprise edition features include the following:

  • A maximum number of cores, subject to the operating system being used
  • Unlimited virtualization
  • AlwaysOn to achieve advanced high availability
  • Unlimited virtualization for organizations with software assurance
  • Support for the new columnstore indexing feature
  • Advanced auditing
  • Transparent data encryption
  • Compression and partitioning

In addition, all the features and capabilities of the Business Intelligence edition are available, including:

  • Reporting
  • Analytics
  • Multidimensional BI semantic model
  • Data quality services
  • Master data services
  • In-memory tabular BI semantic model
  • Self-service business intelligence

Standard edition

The Standard edition is a data-management platform tailored toward departmental databases and limited business-intelligence applications that are typically appropriate for medium-class solutions, smaller organizations, or departmental solutions. It does not include all the bells and whistles of the Enterprise and Business Intelligence editions, although it continues to offer best-in-class manageability and ease of use. Compared with the Enterprise and Business Intelligence editions, the Standard edition supports up to 16 cores and includes the following features:

  • Spatial support
  • FileTable
  • Policy-based management
  • Corporate business intelligence
  • Reporting
  • Analytics
  • Multidimensional BI semantic model
  • AlwaysOn 2-Node failover clustering to achieve basic high availability
  • Up to four processors, up to 64 GB of RAM, one virtual machine, and two failover clustering nodes

Business Intelligence edition

The Business Intelligence edition offers organizations the full suite of powerful BI capabilities, such as scalable reporting and analytics, Power View, and PowerPivot. It is tailored toward organizations that need corporate business intelligence and self-service capabilities but do not require the full online transactional processing (OLTP) performance and scalability found in the Enterprise edition. Here is a high-level list of what the Business Intelligence edition includes:

  • Up to a maximum of 16 cores for the Database Engine
  • Maximum number of cores for business-intelligence processing
  • All of the features found in the Standard edition
  • Corporate business intelligence: Reporting, Analytics, Multidimensional BI semantic model
  • Self-service capabilities: Alerting, Power View, PowerPivot for SharePoint Server
  • Enterprise data management: Data quality services, Master data services
  • In-memory tabular BI semantic model
  • Basic high availability can be achieved with AlwaysOn 2-Node failover clustering

USE MICROSOFT SQL SERVER TO PREPARE DATA FOR

Tableau Software

Learn more →

Qlik Sense

Learn more →

OTHER DATA PREPARATION solutions