eBook - ePub
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Reza Rad
This is a test
- 350 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Reza Rad
Book details
Book preview
Table of contents
Citations
About This Book
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.
Frequently asked questions
How do I cancel my subscription?
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide an online PDF/ePUB?
Yes, you can access Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide by Reza Rad in PDF and/or ePUB format, as well as other popular books in Computer Science & Programming in SQL. We have over one million books available in our catalogue for you to explore.
Information
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 ...