Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide.

Mostrar otras versiones (1)

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 looki...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Rad, Reza
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Publishing, 2014.
Temas:
SQL server.
SQL server
Client/server computing.
Relational databases.
Architecture client-serveur (Informatique)
Bases de données relationnelles.
COMPUTERS > Client-Server Computing.
Client/server computing
Relational databases
Acceso en línea:Texto completo
Tabla de Contenidos:
  • 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.

Ejemplares similares