首頁 > 計算機網絡 > 編程語言與程序設計 > Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
舉報 
會員
Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
最新章節：
Index
Writteninaneasy-to-follow,example-drivenformat,thereareplentyofstepbystepinstructionstohelpgetyoustarted!Thebookhasafriendlyapproach,withtheopportunitytolearnbyexperimenting.IfyouareaBIandDataWarehousedevelopernewtoMicrosoftBusinessIntelligence,andlookingtogetagoodunderstandingofthedifferentcomponentsofMicrosoftSQLServerforBusinessIntelligence,thisbookisforyou.It’sassumedthatyouwillhavesomeexperienceindatabasessystemsandT-SQL.ThisbookiswillgiveyouagoodupshotviewofeachcomponentandscenariosfeaturingtheuseofthatcomponentinDataWarehousingandBusinessIntelligencesystems.
最新章節
- Index
- Summary
- Time for action – running DMX queries from a .NET application
- Using the results of a mining model in an application
- Time for action – changing a report configuration with a ReportViewer Object through code behind
- Passing parameters to a report
品牌：中圖公司
上架時間：2021-08-13 16:39:45
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Index 更新時間：2021-08-13 17:56:03
- Summary
- Time for action – running DMX queries from a .NET application
- Using the results of a mining model in an application
- Time for action – changing a report configuration with a ReportViewer Object through code behind
- Passing parameters to a report
- Time for action – designing reports and working with the local processing mode
- Working with ReportViewer in a local processing mode
- Time for action – working with reports in Metro applications
- Developing reports in a Metro application
- Time for action – working with reports in web/Windows applications
- Developing reports in a web application
- Time for action – installing AdventureWorks SSRS sample reports
- Designing .NET applications with reports
- Chapter 12. Integrating Reports in Applications
- Summary
- Time for action – data visualization with Power Map
- Power Map
- Time for action – self-service ETL with Power Query
- Self-service ETL with Power Query
- Chapter 11. Power BI
- Summary
- Time for action – using Filter in Power View
- Time for action – visualizing time-based information with a scatter chart
- Time for action – geographical data visualization using Power View
- Time for action – creating the first Power View dashboard
- Time for action – enabling Power View in Excel
- Power View
- Time for action – working with filters
- Time for action – exploring on-the-fly features
- Time for action – creating a dashboard page
- Time for action – creating your first dashboard with PerformancePoint Dashboard Designer
- Time for action – configuring PerformancePoint in SharePoint
- The PerformancePoint service
- Chapter 10. Dashboard Design
- Summary
- Time for action – using Report Manager
- Time for action – deploying a report
- Deploying and configuring
- Time for action – working with charts in Reporting Services
- Time for action – changing the background color of data rows based on expressions
- Expressions
- Time for action – applying ordering and grouping on the data rows
- Sorting and grouping
- Time for action – changing a page's properties
- Printing and page configuration
- Time for action – adding parameters to a report
- Extended report development
- Time for action – creating our first report using SSRS
- Developing a basic report
- The Reporting Services architecture
- Chapter 9. Reporting Services
- Summary
- Time for action – predicting future sales with Microsoft Time Series
- Microsoft Time Series
- Time for action – predicting prospective bike buyers
- Predicting data with DMX
- Time for action – finding the best mining model with Lift Chart and Profit Chart
- Finding the best algorithm
- Chapter 8. Identifying Data Patterns – Predictive Models in SSAS
- Summary
- Time for action – the Microsoft association rule
- Microsoft association rules
- Time for action – creating a data mining solution with the Microsoft Decision Tree algorithm
- The Microsoft Decision Tree algorithm
- An introduction to data mining
- Chapter 7. Data Mining – Descriptive Models in SSAS
- Summary
- Time for action – the DQS cleansing component in SSIS
- Integrating with MDS and SSIS
- Time for action – matching projects
- Time for action – matching policy
- Matching
- Time for action – creating synonyms and setting standardization
- Synonyms and standardization
- Time for action – composite domain rules
- Domain and composite domain rules
- Time for action – using Data Quality Project for cleansing
- Data cleansing with Data Quality Projects
- Time for action – knowledge discovery
- Knowledge discovery
- Time for action – creating a Knowledge Base
- Knowledge Base Management
- Time for action – installing Data Quality Services
- Data Quality Services
- Understanding data quality
- Chapter 6. Data Quality and Data Cleansing
- Summary
- Time for action – entity-based staging
- Time for action – a subscription view
- Integration management
- Time for action – permission walkthrough
- Security and permission
- Time for action – creating a derived hierarchy
- Working with hierarchies
- Time for action – creating a simple business rule
- Business rules
- Time for action – creating a domain-based relationship
- The entity relationship
- Time for action – change tracking
- Time for action – creating an entity with data from the Excel Add-in
- Time for action – creating a model and an entity
- Creating models and entities
- Time for action – installing Excel Add-in
- Comparing WebUI with the Excel Add-in
- Time for action – configuring MDS
- Master Data Services
- Understanding Master Data Management
- Chapter 5. Master Data Management
- Summary
- Time for action – executing an SSIS package from a catalog
- Time for action – deploying an SSIS project
- Deploying and executing
- Time for action – looping through CSV files in a directory and loading them into a database table
- Containers and dynamic packages
- Time for action – loading customer information from a flat file into a database table with a Data Flow Task
- The Data Flow tab
- Time for action – working with Control Flow tasks
- The Control Flow tab
- Time for action – creating your first SSIS project
- Integration Service projects and packages
- SQL Server Integration Services
- Understanding ETL and data consolidation
- Chapter 4. ETL with Integration Services
- Summary
- Tabular versus Multidimensional SSAS
- Time for action – creating a model with the DirectQuery storage mode
- Storage modes
- Time for action – security in tabular
- Securing the data
- Time for action – using time intelligence functions in DAX
- Data Analysis eXpression calculated columns and measures
- Time for action – creating a hierarchy from multiple tables
- Time for action – creating a hierarchy from a single table
- Creating hierarchies
- Time for action – creating measures
- Time for action – creating a tabular project
- Developing a tabular project
- Introducing SSAS Tabular
- Chapter 3. Tabular Model Development of SQL Server Analysis Services
- Summary
- Time for action – processing the data
- Time for action – deploying an SSAS project
- Deploying and processing
- Time for action – calculated members
- Time for action – writing an MDX query
- Multidimensional eXpression calculated members and Named Sets
- Time for action – creating a hierarchy
- Hierarchies
- Time for action – adding a Fact relationship
- Using dimensions
- Time for action – using a Named Query
- Time for action – creating a Named Calculation
- Data Source View
- Time for action – modifying the measure properties
- Time for action – change the order of the Month attribute
- Time for action – using the Dimension Designer
- Dimensions and measures
- Time for action – viewing the cube in the browser
- Time for action – creating the first cube
- Time for action – creating an Analysis Services project
- Developing your first cube
- Understanding the SQL Server Analysis Services engine
- Why is OLAP required?
- Chapter 2. SQL Server Analysis Services Multidimensional Cube Development
- Summary
- Building the data warehouse
- The architecture and components of a BI system
- Understanding Business Intelligence
- Chapter 1. Data Warehouse Design
- Customer support
- Reader feedback
- Time for action – heading
- Conventions
- Who this book is for
- What you need for this book
- What this book covers
- Preface
- Support files eBooks discount offers and more
- www.PacktPub.com
- About the Reviewers
- About the Author
- Credits
- Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
- coverpage
- 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 更新時間：2021-08-13 17:56:03
