eBook - ePub
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Reza Rad
This is a test
- 350 pagine
- English
- ePUB (disponibile sull'app)
- Disponibile su iOS e Android
eBook - ePub
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Reza Rad
Dettagli del libro
Anteprima del libro
Indice dei contenuti
Citazioni
Informazioni sul 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.
Domande frequenti
Come faccio ad annullare l'abbonamento?
È semplicissimo: basta accedere alla sezione Account nelle Impostazioni e cliccare su "Annulla abbonamento". Dopo la cancellazione, l'abbonamento rimarrà attivo per il periodo rimanente già pagato. Per maggiori informazioni, clicca qui
È possibile scaricare libri? Se sì, come?
Al momento è possibile scaricare tramite l'app tutti i nostri libri ePub mobile-friendly. Anche la maggior parte dei nostri PDF è scaricabile e stiamo lavorando per rendere disponibile quanto prima il download di tutti gli altri file. Per maggiori informazioni, clicca qui
Che differenza c'è tra i piani?
Entrambi i piani ti danno accesso illimitato alla libreria e a tutte le funzionalità di Perlego. Le uniche differenze sono il prezzo e il periodo di abbonamento: con il piano annuale risparmierai circa il 30% rispetto a 12 rate con quello mensile.
Cos'è Perlego?
Perlego è un servizio di abbonamento a testi accademici, che ti permette di accedere a un'intera libreria online a un prezzo inferiore rispetto a quello che pagheresti per acquistare un singolo libro al mese. Con oltre 1 milione di testi suddivisi in più di 1.000 categorie, troverai sicuramente ciò che fa per te! Per maggiori informazioni, clicca qui.
Perlego supporta la sintesi vocale?
Cerca l'icona Sintesi vocale nel prossimo libro che leggerai per verificare se è possibile riprodurre l'audio. Questo strumento permette di leggere il testo a voce alta, evidenziandolo man mano che la lettura procede. Puoi aumentare o diminuire la velocità della sintesi vocale, oppure sospendere la riproduzione. Per maggiori informazioni, clicca qui.
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide è disponibile online in formato PDF/ePub?
Sì, puoi accedere a Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide di Reza Rad in formato PDF e/o ePub, così come ad altri libri molto apprezzati nelle sezioni relative a Informatica e Programmazione in SQL. Scopri oltre 1 milione di libri disponibili nel nostro catalogo.
Informazioni
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 ...
Indice dei contenuti
- Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Stili delle citazioni per 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.