
As an Amazon Associate and affiliate partner, Menrva Books earns from qualifying purchases. Learn more
Get to grips with Microsoft Business Intelligence and Data Warehousing technologies using this practical guide Key Features: Discover the Dimensional Modeling concept while designing a data warehouse Learn Data Movement based on technologies such as SSIS, MDS, and DQS Design dashboards and reports with Microsoft BI technologies Book Description: Take advantage of the real power behind the BI components of SQL Server 2014, Excel 2013, and SharePoint 2013 with this hands-on book. This book will give you a competitive advantage by helping you to quickly learn how to design and build BI system with Microsoft BI tools. This book starts with designing a data warehouse with dimensional modeling, and then looks at creating data models based on SSAS multidimensional and Tabular technologies. It will illustrate how to use SSIS for ETL, and MDS and DQS for data governance and data quality. The book is packed with real-world examples that will give you a good understanding of the BI and DW components of SQL Server 2014, Excel 2013, and SharePoint 2013. What You Will Learn: Perform Data Modeling with SSAS Multidimensional and MDX 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
This guide provides a practical approach to designing and building Business Intelligence (BI) systems using Microsoft's SQL Server 2014, Excel 2013, and SharePoint 2013. The book begins by explaining dimensional modeling for data warehouse design, then moves to creating data models with SSAS multidimensional and Tabular technologies. It covers ETL processes using SSIS, and data governance and quality with MDS and DQS. Real-world examples are integrated throughout to ensure a thorough understanding of the BI and DW components.
The book is structured as a practical guide, focusing on hands-on application of Microsoft BI technologies. Its approach emphasizes learning by doing, with a clear progression from foundational concepts like dimensional modeling to advanced topics such as data mining and dashboard design. The inclusion of real-world examples suggests a focus on practical implementation rather than theoretical exploration. The content appears geared towards individuals seeking to develop proficiency in SQL Server 2014's BI capabilities.
Page Count:
350
Publication Date:
2014-01-01
Publisher:
Packt Publishing, Limited
ISBN-10:
1849688885
ISBN-13:
9781849688888
No comments yet. Be the first to share your thoughts!