Cargando…
Microsoft Tabular Modeling Cookbook.
This book follows a cookbook style with recipes explaining the steps for developing analytic data using Business Intelligence Semantic Models. This book is designed for developers who wish to develop powerful and dynamic models for users as well as those who are responsible for the administration of...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Packt Publishing,
2013.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a22000007a 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn867076335 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr |n||||||||| | ||
| 008 | 140103s2013 xx o 000 0 eng d | ||
| 040 | |a IDEBK |b eng |e pn |c IDEBK |d EBLCP |d E7B |d MHW |d S4S |d OCLCQ |d MEAUC |d DEBSZ |d OCLCO |d OCLCQ |d COO |d OCLCF |d OCLCQ |d COCUF |d CNNOR |d MOR |d CCO |d PIFAG |d ZCU |d MERUC |d OCLCQ |d U3W |d STF |d NRAMU |d ICG |d INT |d VT2 |d OCLCQ |d WYU |d G3B |d TKN |d OCLCQ |d DKC |d OCLCQ |d TUHNV |d OCLCO |d QGK |d OCLCQ |d OCLCO | ||
| 019 | |a 961628015 |a 962641317 |a 994456756 |a 1259221077 | ||
| 020 | |a 1306270030 |q (ebk) | ||
| 020 | |a 9781306270038 |q (ebk) | ||
| 020 | |a 9781782170891 | ||
| 020 | |a 1782170898 | ||
| 020 | |a 9781782170884 | ||
| 020 | |a 178217088X | ||
| 029 | 1 | |a AU@ |b 000062512895 | |
| 029 | 1 | |a CHNEW |b 000643068 | |
| 029 | 1 | |a CHNEW |b 000899890 | |
| 029 | 1 | |a CHVBK |b 403397545 | |
| 029 | 1 | |a DEBBG |b BV044065984 | |
| 029 | 1 | |a DEBSZ |b 405568924 | |
| 029 | 1 | |a NZ1 |b 15912176 | |
| 035 | |a (OCoLC)867076335 |z (OCoLC)961628015 |z (OCoLC)962641317 |z (OCoLC)994456756 |z (OCoLC)1259221077 | ||
| 037 | |a 558254 |b MIL | ||
| 050 | 4 | |a QA76.73.S67 |b B73 2013eb | |
| 082 | 0 | 4 | |a 005.7585 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Te Braak, Paul. | |
| 245 | 1 | 0 | |a Microsoft Tabular Modeling Cookbook. |
| 260 | |b Packt Publishing, |c 2013. | ||
| 300 | |a 1 online resource | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 520 | |a This book follows a cookbook style with recipes explaining the steps for developing analytic data using Business Intelligence Semantic Models. This book is designed for developers who wish to develop powerful and dynamic models for users as well as those who are responsible for the administration of models in corporate environments. It is also targeted at analysts and users of Excel who wish to advance their knowledge of Excel through the development of tabular models or who wish to analyze data through tabular modeling techniques. We assume no prior knowledge of tabular modeling. | ||
| 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: Getting Started with Excel; Introduction; Creating the model; Managing the appearance of tables and fields; Using tabular relationships to filter data; Adding fields to tables; Linking fields between tables; Creating model calculations; Chapter 2: Importing Data; Introduction; Importing data as text; Importing data from databases; Managing connections and tables; Using data feeds; Chapter 3: Advanced Browsing Features; Introduction; Sorting data. | |
| 505 | 8 | |a Creating hierarchies for drilldown interactionSumming aggregates and row iteration; Parent-child hierarchies; Creating and using Key Performance Indicators; Role playing dimensions and relationships; Building ratios; Chapter 4: Time Calculations and Date Functions; Introduction; Calculating running totals -- totals to date; Month, quarter, and year to date aggregations; 445 dates and irregularities; Last year and prior period values; Relative Time -- pivoting around measures; Moving averages and last N averages; Chapter 5: Applied Modeling; Introduction. | |
| 505 | 8 | |a Grouping by binning and sorting with ranksDefining many-to-many relationships; Using the last non-empty function for stock data; Performing currency calculations; Allocating data at different levels; Chapter 6: Programmatic Access via Excel; Introduction; Connecting pivot tables and Slicers; Using cube functions; Working with worksheet events and VBA; Managing the Slicer through VBA; Chapter 7: Enterprise Design and Features; Introduction; Restoring a workbook to Analysis Services; Importing models into SQL Server Data Tools; Developing models in SQL Server Data Tools. | |
| 505 | 8 | |a Securing data with rolesImplementing dynamic security; Creating perspectives; Chapter 8: Enterprise Management; Introduction; Deploying models from SSDT; Deploying models with the Deployment Wizard; Creating and managing partitions; Processing the data; DirectQuery and real-time solutions; Chapter 9: Querying the Tabular Model with DAX; Introduction; Retrieving data from a single table; Using projection to combine data from different tables; Restricting data with filters and where conditions; Deriving tables and selecting top n records; Chapter 10: Visualizing Data with Power View. | |
| 505 | 8 | |a IntroductionCreating a Power View report; Creating and manipulating charts; Using tiles (parameters); Using and showing images; Automating the table fields with default field sets; Working with table behavior and card control; Using maps; Using multiples (Trellis Charts); Appendix: Installing Power Pivot and Sample Databases; Installing Power Pivot; Creating the Database; Index. | |
| 546 | |a English. | ||
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 650 | 0 | |a Client/server computing. | |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a Relational databases. | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 7 | |a Client/server computing |2 fast | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 776 | 0 | 8 | |i Print version: |z 9781306270038 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1593866 |z Texto completo |
| 936 | |a BATCHLOAD | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL1593866 | ||
| 938 | |a ebrary |b EBRY |n ebr10825537 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis27169527 | ||
| 994 | |a 92 |b IZTAP | ||