eBook - ePub
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Reza Rad
This is a test
- 350 páginas
- English
- ePUB (apto para móviles)
- Disponible en iOS y Android
eBook - ePub
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Reza Rad
Detalles del libro
Vista previa del libro
Índice
Citas
Información del libro
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 the use of that component in Data Warehousing and Business Intelligence systems.
Preguntas frecuentes
¿Cómo cancelo mi suscripción?
¿Cómo descargo los libros?
Por el momento, todos nuestros libros ePub adaptables a dispositivos móviles se pueden descargar a través de la aplicación. La mayor parte de nuestros PDF también se puede descargar y ya estamos trabajando para que el resto también sea descargable. Obtén más información aquí.
¿En qué se diferencian los planes de precios?
Ambos planes te permiten acceder por completo a la biblioteca y a todas las funciones de Perlego. Las únicas diferencias son el precio y el período de suscripción: con el plan anual ahorrarás en torno a un 30 % en comparación con 12 meses de un plan mensual.
¿Qué es Perlego?
Somos un servicio de suscripción de libros de texto en línea que te permite acceder a toda una biblioteca en línea por menos de lo que cuesta un libro al mes. Con más de un millón de libros sobre más de 1000 categorías, ¡tenemos todo lo que necesitas! Obtén más información aquí.
¿Perlego ofrece la función de texto a voz?
Busca el símbolo de lectura en voz alta en tu próximo libro para ver si puedes escucharlo. La herramienta de lectura en voz alta lee el texto en voz alta por ti, resaltando el texto a medida que se lee. Puedes pausarla, acelerarla y ralentizarla. Obtén más información aquí.
¿Es Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide un PDF/ePUB en línea?
Sí, puedes acceder a Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide de Reza Rad en formato PDF o ePUB, así como a otros libros populares de Informatica y Programmazione in SQL. Tenemos más de un millón de libros disponibles en nuestro catálogo para que explores.
Información
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Table of Contents
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Instant updates on new Packt books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Time for action – heading
What just happened?
Reader feedback
Customer support
Downloading the example code
Downloading color versions of the images for this book
Errata
Piracy
Questions
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 table
Types of dimensions
Slowly Changing Dimension
SCD type 0
SCD type 1
SCD type 2
Summary
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
What just happened?
Time for action – creating the first cube
What just happened?
Time for action – viewing the cube in the browser
What just happened?
Dimensions and measures
Time for action – using the Dimension Designer
What just happened?
Time for action – change the order of the Month attribute
What just happened?
Time for action – modifying the measure properties
What just happened?
Data Source View
Time for action – creating a Named Calculation
What just happened?
Time for action – using a Named Query
What just happened?
Using dimensions
Time for action – adding a Fact relationship
What just happened?
Hierarchies
Time for action – creating a hierarchy
What just happened?
Multidimensional eXpression, calculated members, and Named Sets
Time for action – writing an MDX query
What just happened?
Time for action – calculated members
What just happened?
Deploying and processing
Time for action – deploying an SSAS project
What just happened?
Time for action – processing the data
What just happened?
Summary
3. Tabular Model Development of SQL Server Analysis Services
Introducing SSAS Tabular
Developing a tabular project
Time for action – creating a tabular project
What just happened?
Time for action – creating measures
What just happened?
Creating hierarchies
Time for action – creating a hierarchy from a single table
What just happened?
Time for action – creating a hierarchy from multiple tables
What just happened?
Data Analysis eXpression, calculated columns, and measures
Time for action – using time intelligence functions in DAX
What just happened?
Securing the data
Time for action – security in tabular
What just happened?
Storage modes
Time for action – creating a model with the DirectQuery storage mode
What just happened?
Tabular versus Multidimensional SSAS
Summary
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
What just happened?
The Control Flow tab
Time for action – working with Control Flow tasks
What just happened?
The Data Flow tab
Time for action – loading customer information from a flat file into a database table with a Data Flow Task
What just happened?
Containers and dynamic packages
Time for action – looping through CSV files in a directory and loading them into a database table
What just happened?
Deploying and executing
Time for action – deploying an SSIS project
What just happened?
Time for action – executing an SSIS package from a catalog
What just happened?
Summary
5. Master Data Management
Understanding Master Data Management
Master Data Services
Time for action – configuring MDS
What just happened?
Comparing WebUI with the Excel Add-in
Time for action – installing Excel Add-in
What just happened?
Creating models and entities
Time for action – creating a model and an entity
What just happened?
Time for action – creating an entity with data from the Excel Add-in
What just happened?
Time for action – change tracking
What just happened?
The entity relationship
Time for action – creating a domain-based relationship
What just happened?
Business rules
Time for action – creating a simple business rule
What just happened?
Working with hierarchies
Time for action – creating a derived hierarchy
What just happened?
Security and permission
Time for action – permission walkthrough
What just happened?
Integration management
Time for action – a subscription view
What just happened?
Time for action – entity-based staging
What just happened?
Summary
6. Data Quality and Data Cleansing
Understanding data quality
Data Quality Services
Time for action – installing Data Quality Services
What just happened?
Knowledge Base Management
Time for action – creating a Knowledge Base
What just happened?
Knowledge discovery
Time for ...
Índice
- Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Estilos de citas para Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
APA 6 Citation
Rad, R. (2014). Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide (1st ed.). Packt Publishing. Retrieved from https://www.perlego.com/book/390596/microsoft-sql-server-2014-business-intelligence-development-beginners-guide-pdf (Original work published 2014)
Chicago Citation
Rad, Reza. (2014) 2014. Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide. 1st ed. Packt Publishing. https://www.perlego.com/book/390596/microsoft-sql-server-2014-business-intelligence-development-beginners-guide-pdf.
Harvard Citation
Rad, R. (2014) Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide. 1st edn. Packt Publishing. Available at: https://www.perlego.com/book/390596/microsoft-sql-server-2014-business-intelligence-development-beginners-guide-pdf (Accessed: 14 October 2022).
MLA 7 Citation
Rad, Reza. Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide. 1st ed. Packt Publishing, 2014. Web. 14 Oct. 2022.