
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
- Use DAX and SSAS tabular for Data Modeling
- Manage Master Data with MDS
- Reveal Knowledge Driven Data Quality with DQS
- Understand prediction and Data Mining
- Identify data patterns and predictive models
- Design Dashboards with PerformancePoint and Power View
- Explore Power Query and Power Map as components of Power BI
- Create Reports with SQL Server Reporting Services and integrate them in applications
Who this book is for
More details
Other editions
Additional editions

Persons
Reza Rad has more than 10 years of experience in databases and soft ware applications. Most of his work experience is in data warehousing and business intelligence. He has worked with Microsoft technologies from SQL Server 7 and Visual Basic 6 to the latest versions of SQL Server and.NET. He has a Bachelor's degree in Computer Engineering. Reza is a DW/BI architect and consultant. He has worked with large enterprises around the world and delivered high-quality data warehousing and BI solutions for them. He has worked with industries in different sectors, such as Health, Finance, Logistics, Sales, Order Management, Manufacturing, Telecommunication, and so on.Reza has been awarded the Microsoft Most Valuable Professional in SQL Server from 2011 to 2014. He is an international speaker in SQL Server, BI, and DW conferences around the world. He speaks in SQL PASS Summits, Microsoft TechEd, SQL Saturdays, SQL Server user groups, and code camps.Reza has written books on SQL Server and databases. One of his most recent books is SQL Server 2012 Integration Services: An Expert Cookbook, Packt Publishing.Reza is a big fan of data-related technologies, his expertise is in EIM, ETL, Data governance, big data, data warehousing, BI, data visualizati on, Master Data Management, OLAP, and so on. He is the author of Webcast series on the RADACAD website (http://www.radacad.com). He writes articles and blog posts on his technical blog (http://www.rad.pasfu.com); he writes about most of the Microsoft technologies, such as SSIS, MDS, DQS, SSAS, Power BI, HDInsight, and so on. His blog contains the latest information on his presentations and publications.Reza is a Mentor and a Microsoft Certified Trainer. He has been in the professional training business for many years. He conducts extensive 400 handed-level training for many enterprises around the world via both remote and in-person training. He is an active member of MSDN forums, especially those on SQL Server and Power BI. He is also the leader of the New Zealand Data Warehousing and Business Intelligence user group, which is a registered chapter of PASS.
Content
- Intro
- 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 action - knowledge discovery
- What just happened?
- Data cleansing with Data Quality Projects
- Time for action - using Data Quality Project for cleansing
- What just happened?
- Domain and composite domain rules
- Time for action - composite domain rules
- What just happened?
- Synonyms and standardization
- Time for action - creating synonyms and setting standardization
- What just happened?
- Matching
- Time for action - matching policy
- What just happened?
- Time for action - matching projects
- What just happened?
- Integrating with MDS and SSIS
- Time for action - the DQS cleansing component in SSIS
- What just happened?
- DQS integration with MDS
- Summary
- 7. Data Mining - Descriptive Models in SSAS
- An introduction to data mining
- The Microsoft Decision Tree algorithm
- Time for action - creating a data mining solution with the Microsoft Decision Tree algorithm
- What just happened?
- Microsoft association rules
- Time for action - the Microsoft association rule
- What just happened?
- Algorithm parameters
- Summary
- 8. Identifying Data Patterns - Predictive Models in SSAS
- Finding the best algorithm
- Time for action - finding the best mining model with Lift Chart and Profit Chart
- What just happened?
- Predicting data with DMX
- Time for action - predicting prospective bike buyers
- What just happened?
- Microsoft Time Series
- Time for action - predicting future sales with Microsoft Time Series
- What just happened?
- Summary
- 9. Reporting Services
- The Reporting Services architecture
- Developing a basic report
- Time for action - creating our first report using SSRS
- What just happened?
- Extended report development
- Parameters
- Time for action - adding parameters to a report
- What just happened?
- Printing and page configuration
- Time for action - changing a page's properties
- What just happened?
- Sorting and grouping
- Time for action - applying ordering and grouping on the data rows
- What just happened?
- Expressions
- Time for action - changing the background color of data rows based on expressions
- What just happened?
- Adding charts
- Time for action - working with charts in Reporting Services
- What just happened?
- Deploying and configuring
- Time for action - deploying a report
- What just happened?
- Time for action - using Report Manager
- What just happened?
- Summary
- 10. Dashboard Design
- The PerformancePoint service
- Time for action - configuring PerformancePoint in SharePoint
- What just happened?
- The Dashboard Designer utility
- Time for action - creating your first dashboard with PerformancePoint Dashboard Designer
- What just happened?
- The dashboard pages
- Time for action - creating a dashboard page
- What just happened?
- PPS dashboard's on-the-fly features
- Time for action - exploring on-the-fly features
- What just happened?
- Filters
- Time for action - working with filters
- What just happened?
- PerformancePoint Wrap Up
- Power View
- Time for action - enabling Power View in Excel
- What Just Happened?
- Time for action - creating the first Power View dashboard
- What just happened?
- Map
- Time for action - geographical data visualization using Power View
- What just happened?
- Scatter chart
- Time for action - visualizing time-based information with a scatter chart
- What just happened?
- Filtering data
- Time for action - using Filter in Power View
- Wrapping up Power View
- Summary
- 11. Power BI
- Self-service ETL with Power Query
- Time for action - self-service ETL with Power Query
- What just happened?
- Power Map
- Time for action - data visualization with Power Map
- What just happened?
- Summary
- 12. Integrating Reports in Applications
- Designing .NET applications with reports
- Time for action - installing AdventureWorks SSRS sample reports
- What just happened?
- Developing reports in a web application
- Time for action - working with reports in web/Windows applications
- What just happened?
- Processing modes
- ReportViewer in Web and Windows
- The ReportViewer toolbar
- Developing reports in a Metro application
- Time for action - working with reports in Metro applications
- What just happened?
- Working with ReportViewer in a local processing mode
- Time for action - designing reports and working with the local processing mode
- What just happened?
- Passing parameters to a report
- Time for action - changing a report configuration with a ReportViewer Object through code behind
- What just happened?
- Using the results of a mining model in an application
- Time for action - running DMX queries from a .NET application
- What just happened?
- Summary
- Index
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.