DATA ANALYSIS

Separate Strings

This example teaches you how to separate strings in Excel.

The problem we are dealing with is that we need to tell Excel where we want to separate the string. In case of Smith, Mike the comma is at position 6 while in case of Williams, Janet the comma is at position 9.

1. To get the first name, use the formula below.

Explanation: to find the position of the comma, use the FIND function (position 6). To get the length of a string, use the LEN function (11 characters). =RIGHT(A2,LEN(A2)-FIND(",",A2)-1) reduces to =RIGHT(A2,11-6-1). =RIGHT(A2,4) extracts the 4 rightmost characters and gives the desired result (Mike).

2. To get the last name, use the following formula.

Explanation: to find the position of the comma, use the FIND function (position 6). =LEFT(A2,FIND(",", A2)-1) reduces to =LEFT(A2,6-1). =LEFT(A2,5) extracts the 5 leftmost characters and gives the desired result (Smith).

3. Select the range B2:C2 and drag it down.

Refer: http://www.excel-easy.com/data-analysis.html

This example teaches you how to separate strings in Excel.

1. To get the first name, use the formula below.

2. To get the last name, use the following formula.

3. Select the range B2:C2 and drag it down.

Refer: http://www.excel-easy.com/data-analysis.html

Separate Strings

View detail

10 things that wowed me in Excel 2013

I have used Flash Fill and it make me surprised.

http://chandoo.org/wp/2013/04/03/best-new-features-in-excel-2013/

10 things that wowed me in Excel 2013

View detail

Date 13/800: thứ 2 14-10-2013: tạo calculation từ cube

Ta có thể tạo các tính toán phức tạp trên cube thông qua calculation.

Date 13/800: thứ 2 14-10-2013: tạo calculation từ cube

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuh61LhX0k1Y-b_kGxY4LCUwIO2EIpVQAIvjeMQ06T_3WfAm8FID-cd0UklTyVTyluM4LPXaZnKVcjthyOBO_yuXQV-bRtEH1KttE73rcXgQrgpugBljvfHdXEmAQHLL951_QgeBFhb3s/s72-c/create-calculation-cube-ssas.png

View detail

Date 12/800

Sự khác biệt giữa Star schema và snowflake schema

In a star schema, you create dimensions from single
tables joined to a fact table. In a snowfl ake schema, you create dimensions from two or more
joined dimension tables.

Date 12/800

View detail

Date 12/800: thứ hai 7-10-2013: BI semantic model

http://www.mssqltips.com/sqlservertip/2818/understanding-the-sql-server-2012-bi-semantic-model-bism/

Đại khái là nó giống như 1 nền tảng BI thống nhất, unified BI flatform, cho phép người dùng có thể dùng multidimensional model hay tabular model, kết hợp những công nghệ hiện tại và công nghệ mới

--------------

SSAS 2012 cung cấp 3 cách tiếp cận để xây dựng BI semantic model: multidimensional, tabular and power pivot.

http://msdn.microsoft.com/en-us/library/hh212940(v=sql.110).aspx

BISM được xây dựng như 1 model thống nhất cho mọi đối tượng người dùng, từ user đến developer.

http://www.codeproject.com/Articles/506032/WhatplusisplusBIplusSemanticplusmodelplus-BISM-plu

Date 12/800: thứ hai 7-10-2013: BI semantic model

View detail

Date 11/800

Measures

If you had a calculated measure that returned the percentage of sales along some dimension, what type of measure would this be?

Choose your answer:

	Additive
	Semiadditive
	Nonadditive
	Partial

Measures

If you had a calculated measure that returned the percentage of sales along some dimension, what type of measure would this be?

Choose your answer:

	Additive
	Semiadditive
	Nonadditive
	Partial

Date 11/800

View detail

Date 11/800: chủ nhật 6-10-2013

MDX: multi dimensional eXpression:

Just as Structured Query Language (SQL) is a query language used to retrieve data from relational

databases, Multi-Dimensional eXpressions (MDX) is a query language used to retrieve data from

Analysis Services databases. MDX supports two distinct modes:

‰ Expressions language: Defi ne and manipulate Analysis Services objects and data to calculate

values.

‰ Query language: Retrieve data from Analysis Services.

MDX was originally designed by Microsoft and introduced in 1998 with SQL Server Analysis

Services 7.0, but it is nevertheless a general, standards-based query language to retrieve data from

OLAP databases. Many other OLAP providers support MDX, including Microstrategy’s Intelligence

Server, Hyperion’s Essbase Server, and SAS’s Enterprise BI Server. There are those who want to

extend the standard for additional functionality, and MDX extensions have indeed been developed

by individual vendors, but the constituent parts of any extension are expected to be consistent with

the MDX standard. Analysis Services provides several extensions to the MDX standard defi ned by

the OLE DB for OLAP specifi cation. In this book you learn about the form of MDX supported by

SQL Server Analysis Services 2012.

Khái niệm về Measure Group
Measure Groups: Measure groups are composed of one or more columns of a fact
table that, in turn, are composed of the data to be aggregated and analyzed. Measure
groups combine multiple measures under a single entity.

Business intelligence is nothing more than analyzing your data and making
actionable decisions.

Trả lời 1 câu hỏi liên quan đến Analysis services, nó hỏi ssas có thể chạy trong mode nào, tôi trả lồi windows authentication và nó đã đúng,
tham khảo: http://msdn.microsoft.com/en-us/library/ms144288(SQL.90).aspx