The definitive guide to DAX: business intelligence with Microsoft Excel, SQL server analysis services, and Power BI
This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'...
Gespeichert in:
| Beteiligte Personen: | , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
Redmond, Washington
Microsoft Press
[2015]
|
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/9780735698383/?ar |
| Zusammenfassung: | This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX's remarkable power and flexibility, this no-compromise "deep dive" is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio. |
| Beschreibung: | Includes index. - Online resource; title from title page (Safari, viewed November 2, 2015) |
| Umfang: | 1 Online-Ressource (1 volume) illustrations |
| ISBN: | 9780735698383 0735698384 |
Internformat
MARC
| LEADER | 00000cam a22000002 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-047504501 | ||
| 003 | DE-627-1 | ||
| 005 | 20240228115953.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 191023s2015 xx |||||o 00| ||eng c | ||
| 020 | |a 9780735698383 |9 978-0-7356-9838-3 | ||
| 020 | |a 0735698384 |9 0-7356-9838-4 | ||
| 035 | |a (DE-627-1)047504501 | ||
| 035 | |a (DE-599)KEP047504501 | ||
| 035 | |a (ORHE)9780735698383 | ||
| 035 | |a (DE-627-1)047504501 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.756 |2 23/eng/20230216 | |
| 100 | 1 | |a Russo, Marco |d 1969- |e VerfasserIn |4 aut | |
| 245 | 1 | 4 | |a The definitive guide to DAX |b business intelligence with Microsoft Excel, SQL server analysis services, and Power BI |c Marco Russo and Alberto Ferrari |
| 246 | 3 | 3 | |a Business intelligence with Microsoft Excel, SQL Server analysis services, and Power BI |
| 264 | 1 | |a Redmond, Washington |b Microsoft Press |c [2015] | |
| 264 | 4 | |c ©2015 | |
| 300 | |a 1 Online-Ressource (1 volume) |b illustrations | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 500 | |a Includes index. - Online resource; title from title page (Safari, viewed November 2, 2015) | ||
| 520 | |a This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX's remarkable power and flexibility, this no-compromise "deep dive" is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio. | ||
| 630 | 2 | 0 | |a Microsoft PowerPivot (Computer file) |
| 630 | 2 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 2 | 0 | |a SQL server |
| 650 | 0 | |a Query languages (Computer science) | |
| 650 | 0 | |a Business intelligence | |
| 650 | 4 | |a Microsoft Excel (Computer file) | |
| 650 | 4 | |a Microsoft PowerPivot (Computer file) | |
| 650 | 4 | |a SQL server | |
| 650 | 4 | |a Langages d'interrogation | |
| 650 | 4 | |a Business intelligence | |
| 650 | 4 | |a Query languages (Computer science) | |
| 700 | 1 | |a Ferrari, Alberto |d 1966- |e VerfasserIn |4 aut | |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9780735698383/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 912 | |a ZDB-30-ORH | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Datensatz im Suchindex
| DE-BY-TUM_katkey | ZDB-30-ORH-047504501 |
|---|---|
| _version_ | 1821494892942065665 |
| adam_text | |
| any_adam_object | |
| author | Russo, Marco 1969- Ferrari, Alberto 1966- |
| author_facet | Russo, Marco 1969- Ferrari, Alberto 1966- |
| author_role | aut aut |
| author_sort | Russo, Marco 1969- |
| author_variant | m r mr a f af |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)047504501 (DE-599)KEP047504501 (ORHE)9780735698383 |
| dewey-full | 005.756 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.756 |
| dewey-search | 005.756 |
| dewey-sort | 15.756 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03187cam a22005172 4500</leader><controlfield tag="001">ZDB-30-ORH-047504501</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228115953.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">191023s2015 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780735698383</subfield><subfield code="9">978-0-7356-9838-3</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0735698384</subfield><subfield code="9">0-7356-9838-4</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)047504501</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP047504501</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9780735698383</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)047504501</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.756</subfield><subfield code="2">23/eng/20230216</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Russo, Marco</subfield><subfield code="d">1969-</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="4"><subfield code="a">The definitive guide to DAX</subfield><subfield code="b">business intelligence with Microsoft Excel, SQL server analysis services, and Power BI</subfield><subfield code="c">Marco Russo and Alberto Ferrari</subfield></datafield><datafield tag="246" ind1="3" ind2="3"><subfield code="a">Business intelligence with Microsoft Excel, SQL Server analysis services, and Power BI</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Redmond, Washington</subfield><subfield code="b">Microsoft Press</subfield><subfield code="c">[2015]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2015</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (1 volume)</subfield><subfield code="b">illustrations</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">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index. - Online resource; title from title page (Safari, viewed November 2, 2015)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX's remarkable power and flexibility, this no-compromise "deep dive" is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio.</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">Microsoft PowerPivot (Computer file)</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">SQL server</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Query languages (Computer science)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Business intelligence</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft PowerPivot (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL server</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Langages d'interrogation</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business intelligence</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Query languages (Computer science)</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Ferrari, Alberto</subfield><subfield code="d">1966-</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/9780735698383/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-047504501 |
| illustrated | Illustrated |
| indexdate | 2025-01-17T11:21:36Z |
| institution | BVB |
| isbn | 9780735698383 0735698384 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource (1 volume) illustrations |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2015 |
| publishDateSearch | 2015 |
| publishDateSort | 2015 |
| publisher | Microsoft Press |
| record_format | marc |
| spelling | Russo, Marco 1969- VerfasserIn aut The definitive guide to DAX business intelligence with Microsoft Excel, SQL server analysis services, and Power BI Marco Russo and Alberto Ferrari Business intelligence with Microsoft Excel, SQL Server analysis services, and Power BI Redmond, Washington Microsoft Press [2015] ©2015 1 Online-Ressource (1 volume) illustrations Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Includes index. - Online resource; title from title page (Safari, viewed November 2, 2015) This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX's remarkable power and flexibility, this no-compromise "deep dive" is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio. Microsoft PowerPivot (Computer file) Microsoft Excel (Computer file) SQL server Query languages (Computer science) Business intelligence Langages d'interrogation Ferrari, Alberto 1966- VerfasserIn aut |
| spellingShingle | Russo, Marco 1969- Ferrari, Alberto 1966- The definitive guide to DAX business intelligence with Microsoft Excel, SQL server analysis services, and Power BI Microsoft PowerPivot (Computer file) Microsoft Excel (Computer file) SQL server Query languages (Computer science) Business intelligence Langages d'interrogation |
| title | The definitive guide to DAX business intelligence with Microsoft Excel, SQL server analysis services, and Power BI |
| title_alt | Business intelligence with Microsoft Excel, SQL Server analysis services, and Power BI |
| title_auth | The definitive guide to DAX business intelligence with Microsoft Excel, SQL server analysis services, and Power BI |
| title_exact_search | The definitive guide to DAX business intelligence with Microsoft Excel, SQL server analysis services, and Power BI |
| title_full | The definitive guide to DAX business intelligence with Microsoft Excel, SQL server analysis services, and Power BI Marco Russo and Alberto Ferrari |
| title_fullStr | The definitive guide to DAX business intelligence with Microsoft Excel, SQL server analysis services, and Power BI Marco Russo and Alberto Ferrari |
| title_full_unstemmed | The definitive guide to DAX business intelligence with Microsoft Excel, SQL server analysis services, and Power BI Marco Russo and Alberto Ferrari |
| title_short | The definitive guide to DAX |
| title_sort | definitive guide to dax business intelligence with microsoft excel sql server analysis services and power bi |
| title_sub | business intelligence with Microsoft Excel, SQL server analysis services, and Power BI |
| topic | Microsoft PowerPivot (Computer file) Microsoft Excel (Computer file) SQL server Query languages (Computer science) Business intelligence Langages d'interrogation |
| topic_facet | Microsoft PowerPivot (Computer file) Microsoft Excel (Computer file) SQL server Query languages (Computer science) Business intelligence Langages d'interrogation |
| work_keys_str_mv | AT russomarco thedefinitiveguidetodaxbusinessintelligencewithmicrosoftexcelsqlserveranalysisservicesandpowerbi AT ferrarialberto thedefinitiveguidetodaxbusinessintelligencewithmicrosoftexcelsqlserveranalysisservicesandpowerbi AT russomarco businessintelligencewithmicrosoftexcelsqlserveranalysisservicesandpowerbi AT ferrarialberto businessintelligencewithmicrosoftexcelsqlserveranalysisservicesandpowerbi AT russomarco definitiveguidetodaxbusinessintelligencewithmicrosoftexcelsqlserveranalysisservicesandpowerbi AT ferrarialberto definitiveguidetodaxbusinessintelligencewithmicrosoftexcelsqlserveranalysisservicesandpowerbi |