One of the most useful and powerful tasks in Control Flow is Data Flow Task. The importance of this task is mostly because it functions as the major part of ETL, which extracts data from different sources, transforms it, and loads it into the destination. As this task plays an important role in an SSIS package and in real-world scenarios, there are few packages that don't contain Data Flow task; SSDT has a special designer for Data Flow, and the SSIS toolbox's items are different in the Data Flow designer.
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
By :
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
By:
Overview of this book
Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Data Warehouse Design
SQL Server Analysis Services Multidimensional Cube Development
Tabular Model Development of SQL Server Analysis Services
ETL with Integration Services
Master Data Management
Data Quality and Data Cleansing
Data Mining – Descriptive Models in SSAS
Identifying Data Patterns – Predictive Models in SSAS
Reporting Services
Dashboard Design
Power BI
Integrating Reports in Applications
Index
Customer Reviews