Microsoft SQL Server 2014 business intelligence development beginner's guide : get to grips with Microsoft Business Intelligence and data warehousing technologies using this practical guide / Reza Rad ; cover image by Artie Ng.

Format:

Book

Author/Creator:

Rad, Reza, author.

Contributor:

Ng, Artie, cover designer.

Series:

Learn by doing: less theory, more results.

Language:

English

Subjects (All):

SQL server.

Databases--Development.

Databases.

Database management--Computer programs.

Database management.

Physical Description:

1 online resource (350 pages)

Edition:

First edition

Other Title:

SQL Server 2014 business intelligence development beginner's guide

Place of Publication:

Birmingham, England : Packt Publishing Ltd, 2014.

Language Note:

English

System Details:

text file

Biography/History:

Rad Reza: Reza Rad has more than 10 years of experience in databases and soft ware applications. Most of his work experience is in data warehousing and business intelligence. He has worked with Microsoft technologies from SQL Server 7 and Visual Basic 6 to the latest versions of SQL Server and. NET. He has a Bachelor's degree in Computer Engineering. Reza is a DW/BI architect and consultant. He has worked with large enterprises around the world and delivered high-quality data warehousing and BI solutions for them. He has worked with industries in different sectors, such as Health, Finance, Logistics, Sales, Order Management, Manufacturing, Telecommunication, and so on. Reza has been awarded the Microsoft Most Valuable Professional in SQL Server from 2011 to 2014. He is an international speaker in SQL Server, BI, and DW conferences around the world. He speaks in SQL PASS Summits, Microsoft TechEd, SQL Saturdays, SQL Server user groups, and code camps. Reza has written books on SQL Server and databases. One of his most recent books is SQL Server 2012 Integration Services: An Expert Cookbook, Packt Publishing. Reza is a big fan of data-related technologies, his expertise is in EIM, ETL, Data governance, big data, data warehousing, BI, data visualizati on, Master Data Management, OLAP, and so on. He is the author of Webcast series on the RADACAD website (http: //www. radacad. com). He writes articles and blog posts on his technical blog (http: //www. rad. pasfu. com); he writes about most of the Microsoft technologies, such as SSIS, MDS, DQS, SSAS, Power BI, HDInsight, and so on. His blog contains the latest information on his presentations and publications. Reza is a Mentor and a Microsoft Certified Trainer. He has been in the professional training business for many years. He conducts extensive 400 handed-level training for many enterprises around the world via both remote and in-person training. He is an active member of MSDN forums, especially those on SQL Server and Power BI. He is also the leader of the New Zealand Data Warehousing and Business Intelligence user group, which is a registered chapter of PASS.

Summary:

Written in an easy-to-follow, example-driven format, there are plenty of step-by-step instructions to help get you started! The book has a friendly approach, with the opportunity to learn by experimenting.If you are a BI and Data Warehouse developer new to Microsoft Business Intelligence, and looking to get a good understanding of the different components of Microsoft SQL Server for Business Intelligence, this book is for you.It's assumed that you will have some experience in databases systems and T-SQL. This book is will give you a good upshot view of each component and scenarios featuring th

Contents:

Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Data Warehouse Design; Understanding Business Intelligence; The architecture and components of a BI system; The data warehouse; Extract Transform Load; Data model - BISM; Data visualization; Master Data Management; Data Quality Services; Building the data warehouse; Dimensional modeling; Fact or measure; Dimension; The Fact table; Grain; The star schema; An example of Internet sales; FactSales; The customer dimension; DimDate; DimProduct; DimStore; Types of facts

The Factless Fact table - The Bridge tableTypes of dimensions; Slowly Changing Dimension; SCD type 0; SCD type 1; SCD type 2; Summary; Chapter 2: SQL Server Analysis Services Multidimensional Cube Development; Why is OLAP required?; Understanding the SQL Server Analysis Services engine; Developing your first cube; Time for action - creating an Analysis Services project; Time for action - creating the first cube; Time for action - viewing the cube in the browser; Dimensions and measures; Time for action - using the Dimension Designer; Time for action - change the order of the Month attribute

Time for action - modifying the measure propertiesData Source View; Time for action - creating a Named Calculation; Time for action - using a Named Query; Using dimensions; Time for action - adding a Fact relationship; Hierarchies; Time for action - creating a hierarchy; Multidimensional eXpression, calculated members, and Named Sets; Time for action - writing an MDX query; Time for action - calculated members; Deploying and processing; Time for action - deploying an SSAS project; Time for action - processing the data; Summary

Chapter 3: Tabular Model Development of SQL Server Analysis ServicesIntroducing SSAS Tabular; Developing a tabular project; Time for action - creating a tabular project; Time for action - creating measures; Creating hierarchies; Time for action - creating a hierarchy from a single table; Time for action - creating a hierarchy from multiple tables; Data Analysis eXpression, calculated columns, and measures; Time for action - using time intelligence functions in DAX; Securing the data; Time for action - security in tabular; Storage modes

Time for action - creating a model with the DirectQuery storage modeTabular versus Multidimensional SSAS; Summary; Chapter 4: ETL with Integration Services; Understanding ETL and data consolidation; Staging; SQL Server Integration Services; Integration Service projects and packages; Time for action - creating your first SSIS project; The Control Flow tab; Time for action - working with Control Flow tasks; The Data Flow tab; Time for action - loading customer information from a flat file into a database table with a Data Flow Task; Containers and dynamic packages

Time for action - looping through CSV files in a directory and loading them into a database table

Notes:

Includes index.

"Learn by doing: less theory, more results."--Cover.

Description based on online resource; title from PDF title page (ebrary, viewed June 5, 2014).

ISBN:

9781849688895

1849688893

OCLC:

880826831