Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
eBook - ePub

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

Reza Rad

  1. 350 Seiten
  2. English
  3. ePUB (handyfreundlich)
  4. Über iOS und Android verfĂŒgbar
eBook - ePub

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

Reza Rad

Angaben zum Buch
Buchvorschau
Inhaltsverzeichnis
Quellenangaben

Über dieses Buch

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.

HĂ€ufig gestellte Fragen

Wie kann ich mein Abo kĂŒndigen?
Gehe einfach zum Kontobereich in den Einstellungen und klicke auf „Abo kĂŒndigen“ – ganz einfach. Nachdem du gekĂŒndigt hast, bleibt deine Mitgliedschaft fĂŒr den verbleibenden Abozeitraum, den du bereits bezahlt hast, aktiv. Mehr Informationen hier.
(Wie) Kann ich BĂŒcher herunterladen?
Derzeit stehen all unsere auf MobilgerĂ€te reagierenden ePub-BĂŒcher zum Download ĂŒber die App zur VerfĂŒgung. Die meisten unserer PDFs stehen ebenfalls zum Download bereit; wir arbeiten daran, auch die ĂŒbrigen PDFs zum Download anzubieten, bei denen dies aktuell noch nicht möglich ist. Weitere Informationen hier.
Welcher Unterschied besteht bei den Preisen zwischen den AboplÀnen?
Mit beiden AboplÀnen erhÀltst du vollen Zugang zur Bibliothek und allen Funktionen von Perlego. Die einzigen Unterschiede bestehen im Preis und dem Abozeitraum: Mit dem Jahresabo sparst du auf 12 Monate gerechnet im Vergleich zum Monatsabo rund 30 %.
Was ist Perlego?
Wir sind ein Online-Abodienst fĂŒr LehrbĂŒcher, bei dem du fĂŒr weniger als den Preis eines einzelnen Buches pro Monat Zugang zu einer ganzen Online-Bibliothek erhĂ€ltst. Mit ĂŒber 1 Million BĂŒchern zu ĂŒber 1.000 verschiedenen Themen haben wir bestimmt alles, was du brauchst! Weitere Informationen hier.
UnterstĂŒtzt Perlego Text-zu-Sprache?
Achte auf das Symbol zum Vorlesen in deinem nÀchsten Buch, um zu sehen, ob du es dir auch anhören kannst. Bei diesem Tool wird dir Text laut vorgelesen, wobei der Text beim Vorlesen auch grafisch hervorgehoben wird. Du kannst das Vorlesen jederzeit anhalten, beschleunigen und verlangsamen. Weitere Informationen hier.
Ist Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide als Online-PDF/ePub verfĂŒgbar?
Ja, du hast Zugang zu Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide von Reza Rad im PDF- und/oder ePub-Format sowie zu anderen beliebten BĂŒchern aus Informatica & Programmazione in SQL. Aus unserem Katalog stehen dir ĂŒber 1 Million BĂŒcher zur VerfĂŒgung.

Information

Verlag
Packt Publishing
Jahr
2014
ISBN
9781849688895
Auflage
1
Thema
Informatica
Thema
Programmazione in SQL

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

Inhaltsverzeichnis

  1. Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Zitierstile fĂŒr 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.