Return to home page
Searching: Muskingum library catalog
Record 518 of 850
  Previous Record Previous Item Next Item Next Record
  Reviews, Summaries, etc...
EBOOK
Author Rad, Reza.
Title Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide.
Imprint Birmingham : Packt Publishing, 2014.

Subject SQL server.
Client/server computing.
Relational databases.
Description 1 online resource (350 pages)
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.
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.
Note English.
Print version record.
ISBN 9781849688895 (electronic bk.)
1849688893 (electronic bk.)
1306823285
9781306823289
9781849688888
1849688885
OCLC # 880826831
Additional Format Print version: Rad, Reza. Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide. Birmingham : Packt Publishing, 2014 9781849688888