Posts

Showing posts from January, 2014

Big Data and Apache Hadoop – Part 1

Big data is data that exceeds the processing capacity of conventional database systems. The data is too big, moves too fast, or doesn't fit the strictures of your database architectures. Big data is a collection of data from traditional and digital sources inside and outside your company that represents a source for ongoing discovery and analysis. Unstructured data comes from information that is not organized or easily interpreted by traditional databases or data models, and typically, it's text-heavy. Metadata, Twitter tweets, and other social media posts are good examples of unstructured data. Multi-structured data refers to a variety of data formats and types and can be derived from interactions between people and machines, such as web applications or social networks. A great example is web log data, which includes a combination of text and visual images along with structured data like form or transactional information. As digital disruption transforms commun...

SQL Server Analysis Services (SSAS)

Business Intelligent Queries OLAP Queries– Online Analytical process Architecture Options Data Source -> Integration Service -> Data mart/Data ware House -> Integration Service -> Analysis Service -> Cube Browser/Reporting Services/SharePoint Services Database Development Design Dimensional Model -> Develop dimensions -> <- Develop cubes -> <- Add Calculations -> <- Deploy to server. Business Intelligent Development Studio Project Types Analysis Service Project – Develop from scratch Import Analysis Service Database Project Items Data Source Connection & Impersonation information Data Source View Cube – at least one for project Dimension – at least one for project Role – at least one for project Dimensional Model Development: Data Source Impersonation account must have READ permission on source Top Down vs. Bottom Up Design Top Down Design the cube and dimensions free...