首頁 > 計(jì)算機(jī)網(wǎng)絡(luò) >
編程語言與程序設(shè)計(jì)
> Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide最新章節(jié)目錄
舉報(bào) 
會(huì)員
Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
最新章節(jié)：
Index
Writteninaneasy-to-follow,example-drivenformat,thereareplentyofstepbystepinstructionstohelpgetyoustarted!Thebookhasafriendlyapproach,withtheopportunitytolearnbyexperimenting.IfyouareaBIandDataWarehousedevelopernewtoMicrosoftBusinessIntelligence,andlookingtogetagoodunderstandingofthedifferentcomponentsofMicrosoftSQLServerforBusinessIntelligence,thisbookisforyou.It’sassumedthatyouwillhavesomeexperienceindatabasessystemsandT-SQL.ThisbookiswillgiveyouagoodupshotviewofeachcomponentandscenariosfeaturingtheuseofthatcomponentinDataWarehousingandBusinessIntelligencesystems.
目錄(185章)
倒序
- coverpage
- 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
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Time for action – heading
- Reader feedback
- Customer support
- Chapter 1. Data Warehouse Design
- Understanding Business Intelligence
- The architecture and components of a BI system
- Building the data warehouse
- Summary
- Chapter 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
- Time for action – creating the first cube
- Time for action – viewing the cube in the browser
- Dimensions and measures
- Time for action – using the Dimension Designer
- Time for action – change the order of the Month attribute
- Time for action – modifying the measure properties
- Data Source View
- Time for action – creating a Named Calculation
- Time for action – using a Named Query
- Using dimensions
- Time for action – adding a Fact relationship
- Hierarchies
- Time for action – creating a hierarchy
- Multidimensional eXpression calculated members and Named Sets
- Time for action – writing an MDX query
- Time for action – calculated members
- Deploying and processing
- Time for action – deploying an SSAS project
- Time for action – processing the data
- Summary
- Chapter 3. Tabular Model Development of SQL Server Analysis Services
- Introducing SSAS Tabular
- Developing a tabular project
- Time for action – creating a tabular project
- Time for action – creating measures
- Creating hierarchies
- Time for action – creating a hierarchy from a single table
- Time for action – creating a hierarchy from multiple tables
- Data Analysis eXpression calculated columns and measures
- Time for action – using time intelligence functions in DAX
- Securing the data
- Time for action – security in tabular
- Storage modes
- Time for action – creating a model with the DirectQuery storage mode
- Tabular versus Multidimensional SSAS
- Summary
- Chapter 4. ETL with Integration Services
- Understanding ETL and data consolidation
- SQL Server Integration Services
- Integration Service projects and packages
- Time for action – creating your first SSIS project
- The Control Flow tab
- Time for action – working with Control Flow tasks
- The Data Flow tab
- Time for action – loading customer information from a flat file into a database table with a Data Flow Task
- Containers and dynamic packages
- Time for action – looping through CSV files in a directory and loading them into a database table
- Deploying and executing
- Time for action – deploying an SSIS project
- Time for action – executing an SSIS package from a catalog
- Summary
- Chapter 5. Master Data Management
- Understanding Master Data Management
- Master Data Services
- Time for action – configuring MDS
- Comparing WebUI with the Excel Add-in
- Time for action – installing Excel Add-in
- Creating models and entities
- Time for action – creating a model and an entity
- Time for action – creating an entity with data from the Excel Add-in
- Time for action – change tracking
- The entity relationship
- Time for action – creating a domain-based relationship
- Business rules
- Time for action – creating a simple business rule
- Working with hierarchies
- Time for action – creating a derived hierarchy
- Security and permission
- Time for action – permission walkthrough
- Integration management
- Time for action – a subscription view
- Time for action – entity-based staging
- Summary
- Chapter 6. Data Quality and Data Cleansing
- Understanding data quality
- Data Quality Services
- Time for action – installing Data Quality Services
- Knowledge Base Management
- Time for action – creating a Knowledge Base
- Knowledge discovery
- Time for action – knowledge discovery
- Data cleansing with Data Quality Projects
- Time for action – using Data Quality Project for cleansing
- Domain and composite domain rules
- Time for action – composite domain rules
- Synonyms and standardization
- Time for action – creating synonyms and setting standardization
- Matching
- Time for action – matching policy
- Time for action – matching projects
- Integrating with MDS and SSIS
- Time for action – the DQS cleansing component in SSIS
- Summary
- Chapter 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
- Microsoft association rules
- Time for action – the Microsoft association rule
- Summary
- Chapter 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
- Predicting data with DMX
- Time for action – predicting prospective bike buyers
- Microsoft Time Series
- Time for action – predicting future sales with Microsoft Time Series
- Summary
- Chapter 9. Reporting Services
- The Reporting Services architecture
- Developing a basic report
- Time for action – creating our first report using SSRS
- Extended report development
- Time for action – adding parameters to a report
- Printing and page configuration
- Time for action – changing a page's properties
- Sorting and grouping
- Time for action – applying ordering and grouping on the data rows
- Expressions
- Time for action – changing the background color of data rows based on expressions
- Time for action – working with charts in Reporting Services
- Deploying and configuring
- Time for action – deploying a report
- Time for action – using Report Manager
- Summary
- Chapter 10. Dashboard Design
- The PerformancePoint service
- Time for action – configuring PerformancePoint in SharePoint
- Time for action – creating your first dashboard with PerformancePoint Dashboard Designer
- Time for action – creating a dashboard page
- Time for action – exploring on-the-fly features
- Time for action – working with filters
- Power View
- Time for action – enabling Power View in Excel
- Time for action – creating the first Power View dashboard
- Time for action – geographical data visualization using Power View
- Time for action – visualizing time-based information with a scatter chart
- Time for action – using Filter in Power View
- Summary
- Chapter 11. Power BI
- Self-service ETL with Power Query
- Time for action – self-service ETL with Power Query
- Power Map
- Time for action – data visualization with Power Map
- Summary
- Chapter 12. Integrating Reports in Applications
- Designing .NET applications with reports
- Time for action – installing AdventureWorks SSRS sample reports
- Developing reports in a web application
- Time for action – working with reports in web/Windows applications
- Developing reports in a Metro application
- Time for action – working with reports in Metro applications
- Working with ReportViewer in a local processing mode
- Time for action – designing reports and working with the local processing mode
- Passing parameters to a report
- Time for action – changing a report configuration with a ReportViewer Object through code behind
- Using the results of a mining model in an application
- Time for action – running DMX queries from a .NET application
- Summary
- Index 更新時(shí)間：2021-08-13 17:56:03
推薦閱讀
- Apache Oozie Essentials
- R語言數(shù)據(jù)可視化之美：專業(yè)圖表繪制指南
- Bootstrap 4：Responsive Web Design
- PLC編程與調(diào)試技術(shù)（松下系列）
- Integrating Facebook iOS SDK with Your Application
- Learning Material Design
- Python入門很輕松（微課超值版）
- 動(dòng)手打造深度學(xué)習(xí)框架
- MongoDB Cookbook（Second Edition）
- Mastering OAuth 2.0
- Access數(shù)據(jù)庫應(yīng)用教程（2010版）
- Java Web動(dòng)態(tài)網(wǎng)站開發(fā)（第2版·微課版）
- Mastering Object：Oriented Python（Second Edition）
- Splunk Essentials
- Python深度學(xué)習(xí)與項(xiàng)目實(shí)戰(zhàn)
- JavaScript+jQuery交互式Web前端開發(fā)（第2版）
- HTML5+CSS3網(wǎng)頁布局項(xiàng)目化教程
- VB語言程序設(shè)計(jì)實(shí)驗(yàn)教程
- 超簡(jiǎn)單：用Python讓Excel飛起來·核心模塊語法詳解篇
- Building Android Games with Cocos2d-x
- Arduino Essentials
- Building Web Applications with Python and Neo4j
- Java程序設(shè)計(jì)案例教程（第三版）
- 大話設(shè)計(jì)模式
- C＃程序設(shè)計(jì)教程
- JSP網(wǎng)絡(luò)程序設(shè)計(jì)與案例開發(fā)教程
- 孩子趣味學(xué)編程之Scratch篇
- Java Web動(dòng)態(tài)網(wǎng)站開發(fā)（微課版）
- 程序員2007精華本（下）
- 高可用可伸縮微服務(wù)架構(gòu)：基于Dubbo、Spring Cloud和Service Mesh
