Saved in:
| Main Authors: | , |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
[Place of publication not identified]
Published with the authorization of Microsoft Corporation by Pearson Education
[2020]
|
| Edition: | Second edition. |
| Subjects: | |
| Links: | https://learning.oreilly.com/library/view/-/9780134865867/?ar |
| Summary: | Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert 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, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX's remarkable capabilities? This no-compromise "deep dive" is exactly what you need. Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel · Master core DAX concepts, including calculated columns, measures, and calculation groups · Work efficiently with basic and advanced table functions · Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions · Perform time-based calculations · Use calculation groups and calculation items · Use syntax of variables (VAR) to write more readable, maintainable code · Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters · Master advanced optimization techniques, and improve performance in aggregations · Optimize data models to achieve better compression · Measure DAX query performance with DAX Studio and learn how to optimize your DAX |
| Item Description: | Includes index. - Online resource; title from title page (Safari, viewed July 30, 2019) |
| Physical Description: | 1 Online-Ressource (1 volume) illustrations |
| ISBN: | 9780134865867 0134865863 |
Staff View
MARC
| LEADER | 00000cam a22000002c 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-048538051 | ||
| 003 | DE-627-1 | ||
| 005 | 20240228120835.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 191206s2020 xx |||||o 00| ||eng c | ||
| 020 | |a 9780134865867 |9 978-0-13-486586-7 | ||
| 020 | |a 0134865863 |9 0-13-486586-3 | ||
| 035 | |a (DE-627-1)048538051 | ||
| 035 | |a (DE-599)KEP048538051 | ||
| 035 | |a (ORHE)9780134865867 | ||
| 035 | |a (DE-627-1)048538051 | ||
| 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 Power BI, SQL server analysis services, and Excel |c Marco Russo and Alberto Ferrari |
| 246 | 3 | 3 | |a Business intelligence with Microsoft Power BI, SQL server analysis services, and Excel |
| 250 | |a Second edition. | ||
| 264 | 1 | |a [Place of publication not identified] |b Published with the authorization of Microsoft Corporation by Pearson Education |c [2020] | |
| 264 | 4 | |c ©2020 | |
| 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 July 30, 2019) | ||
| 520 | |a Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert 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, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX's remarkable capabilities? This no-compromise "deep dive" is exactly what you need. Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel · Master core DAX concepts, including calculated columns, measures, and calculation groups · Work efficiently with basic and advanced table functions · Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions · Perform time-based calculations · Use calculation groups and calculation items · Use syntax of variables (VAR) to write more readable, maintainable code · Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters · Master advanced optimization techniques, and improve performance in aggregations · Optimize data models to achieve better compression · Measure DAX query performance with DAX Studio and learn how to optimize your DAX | ||
| 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 | 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 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/-/9780134865867/?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 | ||
Record in the Search Index
| DE-BY-TUM_katkey | ZDB-30-ORH-048538051 |
|---|---|
| _version_ | 1835903168523796480 |
| 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)048538051 (DE-599)KEP048538051 (ORHE)9780134865867 |
| 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 |
| edition | Second edition. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03569cam a22005052c 4500</leader><controlfield tag="001">ZDB-30-ORH-048538051</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228120835.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">191206s2020 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780134865867</subfield><subfield code="9">978-0-13-486586-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0134865863</subfield><subfield code="9">0-13-486586-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)048538051</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP048538051</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9780134865867</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)048538051</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 Power BI, SQL server analysis services, and Excel</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 Power BI, SQL server analysis services, and Excel</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Second edition.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[Place of publication not identified]</subfield><subfield code="b">Published with the authorization of Microsoft Corporation by Pearson Education</subfield><subfield code="c">[2020]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2020</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 July 30, 2019)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert 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, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX's remarkable capabilities? This no-compromise "deep dive" is exactly what you need. Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel · Master core DAX concepts, including calculated columns, measures, and calculation groups · Work efficiently with basic and advanced table functions · Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions · Perform time-based calculations · Use calculation groups and calculation items · Use syntax of variables (VAR) to write more readable, maintainable code · Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters · Master advanced optimization techniques, and improve performance in aggregations · Optimize data models to achieve better compression · Measure DAX query performance with DAX Studio and learn how to optimize your DAX</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="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">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/-/9780134865867/?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-048538051 |
| illustrated | Illustrated |
| indexdate | 2025-06-25T12:14:59Z |
| institution | BVB |
| isbn | 9780134865867 0134865863 |
| 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 | 2020 |
| publishDateSearch | 2020 |
| publishDateSort | 2020 |
| publisher | Published with the authorization of Microsoft Corporation by Pearson Education |
| record_format | marc |
| spelling | Russo, Marco 1969- VerfasserIn aut The definitive guide to DAX business intelligence with Microsoft Power BI, SQL server analysis services, and Excel Marco Russo and Alberto Ferrari Business intelligence with Microsoft Power BI, SQL server analysis services, and Excel Second edition. [Place of publication not identified] Published with the authorization of Microsoft Corporation by Pearson Education [2020] ©2020 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 July 30, 2019) Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert 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, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX's remarkable capabilities? This no-compromise "deep dive" is exactly what you need. Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel · Master core DAX concepts, including calculated columns, measures, and calculation groups · Work efficiently with basic and advanced table functions · Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions · Perform time-based calculations · Use calculation groups and calculation items · Use syntax of variables (VAR) to write more readable, maintainable code · Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters · Master advanced optimization techniques, and improve performance in aggregations · Optimize data models to achieve better compression · Measure DAX query performance with DAX Studio and learn how to optimize your DAX Microsoft PowerPivot (Computer file) Microsoft Excel (Computer file) SQL server Query languages (Computer science) Langages d'interrogation Ferrari, Alberto 1966- VerfasserIn aut |
| spellingShingle | Russo, Marco 1969- Ferrari, Alberto 1966- The definitive guide to DAX business intelligence with Microsoft Power BI, SQL server analysis services, and Excel Microsoft PowerPivot (Computer file) Microsoft Excel (Computer file) SQL server Query languages (Computer science) Langages d'interrogation |
| title | The definitive guide to DAX business intelligence with Microsoft Power BI, SQL server analysis services, and Excel |
| title_alt | Business intelligence with Microsoft Power BI, SQL server analysis services, and Excel |
| title_auth | The definitive guide to DAX business intelligence with Microsoft Power BI, SQL server analysis services, and Excel |
| title_exact_search | The definitive guide to DAX business intelligence with Microsoft Power BI, SQL server analysis services, and Excel |
| title_full | The definitive guide to DAX business intelligence with Microsoft Power BI, SQL server analysis services, and Excel Marco Russo and Alberto Ferrari |
| title_fullStr | The definitive guide to DAX business intelligence with Microsoft Power BI, SQL server analysis services, and Excel Marco Russo and Alberto Ferrari |
| title_full_unstemmed | The definitive guide to DAX business intelligence with Microsoft Power BI, SQL server analysis services, and Excel Marco Russo and Alberto Ferrari |
| title_short | The definitive guide to DAX |
| title_sort | definitive guide to dax business intelligence with microsoft power bi sql server analysis services and excel |
| title_sub | business intelligence with Microsoft Power BI, SQL server analysis services, and Excel |
| topic | Microsoft PowerPivot (Computer file) Microsoft Excel (Computer file) SQL server Query languages (Computer science) Langages d'interrogation |
| topic_facet | Microsoft PowerPivot (Computer file) Microsoft Excel (Computer file) SQL server Query languages (Computer science) Langages d'interrogation |
| work_keys_str_mv | AT russomarco thedefinitiveguidetodaxbusinessintelligencewithmicrosoftpowerbisqlserveranalysisservicesandexcel AT ferrarialberto thedefinitiveguidetodaxbusinessintelligencewithmicrosoftpowerbisqlserveranalysisservicesandexcel AT russomarco businessintelligencewithmicrosoftpowerbisqlserveranalysisservicesandexcel AT ferrarialberto businessintelligencewithmicrosoftpowerbisqlserveranalysisservicesandexcel AT russomarco definitiveguidetodaxbusinessintelligencewithmicrosoftpowerbisqlserveranalysisservicesandexcel AT ferrarialberto definitiveguidetodaxbusinessintelligencewithmicrosoftpowerbisqlserveranalysisservicesandexcel |