Cargando…
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide.
Written 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 looki...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
2014.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | EBSCO_ocn880826831 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 140531s2014 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d IDEBK |d N$T |d E7B |d DEBSZ |d OCLCQ |d OCLCO |d COO |d OCLCF |d YDXCP |d OCLCQ |d TEFOD |d OCLCQ |d FEM |d AGLDB |d OCLCQ |d OCLCO |d ICA |d OCLCQ |d OCLCO |d ZCU |d XFH |d MERUC |d OCLCQ |d OCLCO |d D6H |d VTS |d ICG |d OCLCQ |d OCLCO |d STF |d DKC |d OCLCQ |d CNCEN |d OCLCQ |d OCLCO |d AJS |d TOH |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 881869007 |a 968096631 |a 969075497 |a 994505021 |a 1105768064 |a 1235777290 | ||
| 020 | |a 9781849688895 |q (electronic bk.) | ||
| 020 | |a 1849688893 |q (electronic bk.) | ||
| 020 | |a 1306823285 | ||
| 020 | |a 9781306823289 | ||
| 020 | |z 9781849688888 | ||
| 020 | |z 1849688885 | ||
| 024 | 8 | |a 9781849688888 | |
| 029 | 1 | |a AU@ |b 000055980228 | |
| 029 | 1 | |a AU@ |b 000067103103 | |
| 029 | 1 | |a CHNEW |b 000691143 | |
| 029 | 1 | |a CHNEW |b 000691145 | |
| 029 | 1 | |a CHNEW |b 000887416 | |
| 029 | 1 | |a CHVBK |b 374463336 | |
| 029 | 1 | |a DEBBG |b BV043608832 | |
| 029 | 1 | |a DEBSZ |b 407732683 | |
| 029 | 1 | |a DEBSZ |b 484723502 | |
| 035 | |a (OCoLC)880826831 |z (OCoLC)881869007 |z (OCoLC)968096631 |z (OCoLC)969075497 |z (OCoLC)994505021 |z (OCoLC)1105768064 |z (OCoLC)1235777290 | ||
| 037 | |a 83B762A1-7F5F-4734-A5C9-5895F88E3403 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.9.C55 .R384 2014 | |
| 072 | 7 | |a COM |x 061000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.7585 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Rad, Reza. | |
| 245 | 1 | 0 | |a Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide. |
| 260 | |a Birmingham : |b Packt Publishing, |c 2014. | ||
| 300 | |a 1 online resource (350 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a Cover; 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. | |
| 505 | 8 | |a The 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. | |
| 505 | 8 | |a Time 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. | |
| 505 | 8 | |a Chapter 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. | |
| 505 | 8 | |a Time 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. | |
| 505 | 8 | |a Time for action -- looping through CSV files in a directory and loading them into a database table. | |
| 520 | |a Written 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. | ||
| 546 | |a English. | ||
| 542 | |f Copyright © 2014 Packt Publishing | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 630 | 0 | 0 | |a SQL server. |
| 630 | 0 | 7 | |a SQL server |2 fast |
| 650 | 0 | |a Client/server computing. | |
| 650 | 0 | |a Relational databases. | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 7 | |a COMPUTERS |x Client-Server Computing. |2 bisacsh | |
| 650 | 7 | |a Client/server computing |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Rad, Reza. |t Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide. |d Birmingham : Packt Publishing, 2014 |z 9781849688888 |
| 856 | 4 | 0 | |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=783552 |z Texto completo |
| 938 | |a EBL - Ebook Library |b EBLB |n EBL1674850 | ||
| 938 | |a ebrary |b EBRY |n ebr10875456 | ||
| 938 | |a EBSCOhost |b EBSC |n 783552 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis28430887 | ||
| 938 | |a YBP Library Services |b YANK |n 11830273 | ||
| 994 | |a 92 |b IZTAP | ||