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...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham :
Packt Publishing,
2014.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | 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. |
| Beschreibung: | 1 online resource |
| ISBN: | 9781782170891 1782170898 |
Internformat
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn873807103 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 140318s2014 enk o 000 0 eng d | ||
| 040 | |a N$T |b eng |e rda |e pn |c N$T |d YDXCP |d OCLCQ |d AGLDB |d ICA |d OCLCQ |d D6H |d OCLCF |d VTS |d AU@ |d UKMGB |d M8D |d UKAHL |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO | ||
| 015 | |a GBB6J0032 |2 bnb | ||
| 016 | 7 | |a 018005518 |2 Uk | |
| 019 | |a 900417249 | ||
| 020 | |a 9781782170891 |q (electronic bk.) | ||
| 020 | |a 1782170898 |q (electronic bk.) | ||
| 020 | |z 9781782170884 | ||
| 020 | |z 178217088X | ||
| 035 | |a (OCoLC)873807103 |z (OCoLC)900417249 | ||
| 037 | |a 9781782170891 |b Packt Publishing Pvt. Ltd | ||
| 050 | 4 | |a QA76.73.S67 | |
| 072 | 7 | |a BUS |x 082000 |2 bisacsh | |
| 072 | 7 | |a BUS |x 041000 |2 bisacsh | |
| 072 | 7 | |a BUS |x 042000 |2 bisacsh | |
| 072 | 7 | |a BUS |x 085000 |2 bisacsh | |
| 082 | 7 | |a 658.4038011 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Braak, Paul te, |e author. | |
| 245 | 1 | 0 | |a Microsoft Tabular Modeling cookbook / |c Paul te Braak. |
| 264 | 1 | |a Birmingham : |b Packt Publishing, |c 2014. | |
| 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 | ||
| 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. | |
| 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. | ||
| 650 | 0 | |a Business intelligence |x Computer programs. | |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 0 | |a Microsoft software. |0 http://id.loc.gov/authorities/subjects/sh94005975 | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Logiciels Microsoft. | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Industrial Management. |2 bisacsh | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Management. |2 bisacsh | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Management Science. |2 bisacsh | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Organizational Behavior. |2 bisacsh | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Microsoft software |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Braak, Paul te. |t Microsoft Tabular Modeling cookbook |z 9781782170884 |w (OCoLC)870650427 |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=679964 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26849677 | ||
| 938 | |a EBSCOhost |b EBSC |n 679964 | ||
| 938 | |a YBP Library Services |b YANK |n 11465211 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn873807103 |
|---|---|
| _version_ | 1816882264684888064 |
| adam_text | |
| any_adam_object | |
| author | Braak, Paul te |
| author_facet | Braak, Paul te |
| author_role | aut |
| author_sort | Braak, Paul te |
| author_variant | p t b pt ptb |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.73.S67 |
| callnumber-search | QA76.73.S67 |
| callnumber-sort | QA 276.73 S67 |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | 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. 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. 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. 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. 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. |
| ctrlnum | (OCoLC)873807103 |
| dewey-full | 658.4038011 |
| dewey-hundreds | 600 - Technology (Applied sciences) |
| dewey-ones | 658 - General management |
| dewey-raw | 658.4038011 |
| dewey-search | 658.4038011 |
| dewey-sort | 3658.4038011 |
| dewey-tens | 650 - Management and auxiliary services |
| discipline | Wirtschaftswissenschaften |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05721cam a2200673 i 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn873807103</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">140318s2014 enk o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">N$T</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="e">pn</subfield><subfield code="c">N$T</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AGLDB</subfield><subfield code="d">ICA</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">D6H</subfield><subfield code="d">OCLCF</subfield><subfield code="d">VTS</subfield><subfield code="d">AU@</subfield><subfield code="d">UKMGB</subfield><subfield code="d">M8D</subfield><subfield code="d">UKAHL</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB6J0032</subfield><subfield code="2">bnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018005518</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">900417249</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781782170891</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1782170898</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781782170884</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">178217088X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)873807103</subfield><subfield code="z">(OCoLC)900417249</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">9781782170891</subfield><subfield code="b">Packt Publishing Pvt. Ltd</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.73.S67</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">082000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">041000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">042000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">085000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">658.4038011</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Braak, Paul te,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Microsoft Tabular Modeling cookbook /</subfield><subfield code="c">Paul te Braak.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2014.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="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.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Business intelligence</subfield><subfield code="x">Computer programs.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Microsoft software.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh94005975</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Logiciels Microsoft.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Industrial Management.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Management.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Management Science.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Organizational Behavior.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Microsoft software</subfield><subfield code="2">fast</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Braak, Paul te.</subfield><subfield code="t">Microsoft Tabular Modeling cookbook</subfield><subfield code="z">9781782170884</subfield><subfield code="w">(OCoLC)870650427</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=679964</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26849677</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">679964</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">11465211</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn873807103 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-27T13:25:51Z |
| institution | BVB |
| isbn | 9781782170891 1782170898 |
| language | English |
| oclc_num | 873807103 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource |
| psigel | ZDB-4-EBA |
| publishDate | 2014 |
| publishDateSearch | 2014 |
| publishDateSort | 2014 |
| publisher | Packt Publishing, |
| record_format | marc |
| spelling | Braak, Paul te, author. Microsoft Tabular Modeling cookbook / Paul te Braak. Birmingham : Packt Publishing, 2014. 1 online resource text txt rdacontent computer c rdamedia online resource cr rdacarrier Print version record. 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. 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. 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. 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. 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. 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. Business intelligence Computer programs. Database management. http://id.loc.gov/authorities/subjects/sh85035848 Microsoft software. http://id.loc.gov/authorities/subjects/sh94005975 Bases de données Gestion. Logiciels Microsoft. BUSINESS & ECONOMICS Industrial Management. bisacsh BUSINESS & ECONOMICS Management. bisacsh BUSINESS & ECONOMICS Management Science. bisacsh BUSINESS & ECONOMICS Organizational Behavior. bisacsh Database management fast Microsoft software fast Print version: Braak, Paul te. Microsoft Tabular Modeling cookbook 9781782170884 (OCoLC)870650427 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=679964 Volltext |
| spellingShingle | Braak, Paul te Microsoft Tabular Modeling cookbook / 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. 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. 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. 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. 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. Business intelligence Computer programs. Database management. http://id.loc.gov/authorities/subjects/sh85035848 Microsoft software. http://id.loc.gov/authorities/subjects/sh94005975 Bases de données Gestion. Logiciels Microsoft. BUSINESS & ECONOMICS Industrial Management. bisacsh BUSINESS & ECONOMICS Management. bisacsh BUSINESS & ECONOMICS Management Science. bisacsh BUSINESS & ECONOMICS Organizational Behavior. bisacsh Database management fast Microsoft software fast |
| subject_GND | http://id.loc.gov/authorities/subjects/sh85035848 http://id.loc.gov/authorities/subjects/sh94005975 |
| title | Microsoft Tabular Modeling cookbook / |
| title_auth | Microsoft Tabular Modeling cookbook / |
| title_exact_search | Microsoft Tabular Modeling cookbook / |
| title_full | Microsoft Tabular Modeling cookbook / Paul te Braak. |
| title_fullStr | Microsoft Tabular Modeling cookbook / Paul te Braak. |
| title_full_unstemmed | Microsoft Tabular Modeling cookbook / Paul te Braak. |
| title_short | Microsoft Tabular Modeling cookbook / |
| title_sort | microsoft tabular modeling cookbook |
| topic | Business intelligence Computer programs. Database management. http://id.loc.gov/authorities/subjects/sh85035848 Microsoft software. http://id.loc.gov/authorities/subjects/sh94005975 Bases de données Gestion. Logiciels Microsoft. BUSINESS & ECONOMICS Industrial Management. bisacsh BUSINESS & ECONOMICS Management. bisacsh BUSINESS & ECONOMICS Management Science. bisacsh BUSINESS & ECONOMICS Organizational Behavior. bisacsh Database management fast Microsoft software fast |
| topic_facet | Business intelligence Computer programs. Database management. Microsoft software. Bases de données Gestion. Logiciels Microsoft. BUSINESS & ECONOMICS Industrial Management. BUSINESS & ECONOMICS Management. BUSINESS & ECONOMICS Management Science. BUSINESS & ECONOMICS Organizational Behavior. Database management Microsoft software |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=679964 |
| work_keys_str_mv | AT braakpaulte microsofttabularmodelingcookbook |