LEADER 05656nam 2200685 450 001 9910791198503321 005 20230919153154.0 010 $a1-84968-889-3 035 $a(CKB)2550000001307893 035 $a(EBL)1674850 035 $a(SSID)ssj0001294985 035 $a(PQKBManifestationID)11731516 035 $a(PQKBTitleCode)TC0001294985 035 $a(PQKBWorkID)11336971 035 $a(PQKB)10066951 035 $a(Au-PeEL)EBL1674850 035 $a(CaPaEBR)ebr10875456 035 $a(CaONFJC)MIL613579 035 $a(OCoLC)880826831 035 $a(CaSebORM)9781849688888 035 $a(MiAaPQ)EBC1674850 035 $a(PPN)228023815 035 $a(EXLCZ)992550000001307893 100 $a20140606h20142014 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aMicrosoft SQL Server 2014 business intelligence development beginner's guide $eget to grips with Microsoft Business Intelligence and data warehousing technologies using this practical guide /$fReza Rad ; cover image by Artie Ng 205 $aFirst edition 210 1$aBirmingham, England :$cPackt Publishing Ltd,$d2014. 210 4$dİ2014 215 $a1 online resource (350 pages) 225 1 $aLearn by doing: less theory, more results. 300 $aIncludes index. 300 $a"Learn by doing: less theory, more results."--Cover. 311 $a1-84968-888-5 311 $a1-306-82328-5 327 $aCover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 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 327 $aThe Factless Fact table - The Bridge tableTypes of dimensions; Slowly Changing Dimension; SCD type 0; SCD type 1; SCD type 2; 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 327 $aTime for action - modifying the measure propertiesData 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 327 $aChapter 3: Tabular Model Development of SQL Server Analysis ServicesIntroducing 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 327 $aTime for action - creating a model with the DirectQuery storage modeTabular versus Multidimensional SSAS; Summary; Chapter 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; 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 327 $aTime for action - looping through CSV files in a directory and loading them into a database table 330 $aWritten in an easy-to-follow, example-driven format, there are plenty of step-by-step instructions to help get you started! The book has a friendly approach, with the opportunity to learn by experimenting.If you are a BI and Data Warehouse developer new to Microsoft Business Intelligence, and looking to get a good understanding of the different components of Microsoft SQL Server for Business Intelligence, this book is for you.It's assumed that you will have some experience in databases systems and T-SQL. This book is will give you a good upshot view of each component and scenarios featuring th 606 $aDatabases$xDevelopment 606 $aDatabase management$xComputer programs 615 0$aDatabases$xDevelopment. 615 0$aDatabase management$xComputer programs. 676 $a005.74 700 $aRad$b Reza$0894816 702 $aNg$b Artie 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910791198503321 996 $aMicrosoft SQL Server 2014 business intelligence development beginner's guide$93818153 997 $aUNINA