Pro DAX and data modeling in Power BI : creating the perfect semantic layer to drive your dashboard analytics /
Develop powerful data models that bind data from disparate sources into a coherent whole. Then extend your data models using DAX–the query language that underpins Power BI–to create reusable measures to deliver finely-crafted custom calculations in your dashboards. This book starts off teaching you...
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
New York, NY :
Apress,
[2022]
|
| Edition: | [First edition]. |
| Subjects: | |
| Online Access: | Full text (Wentworth users only) |
MARC
| LEADER | 00000nam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | 9f76d089-e29c-4eeb-a601-72cac093c91e | ||
| 005 | 20240722000000.0 | ||
| 008 | 221129s2022 nyua o 001 0 eng d | ||
| 019 | |a 1352448367 | ||
| 020 | |a 1484289943 | ||
| 020 | |a 9781484289945 | ||
| 035 | |a (OCoLC)1351986727 |z (OCoLC)1352448367 | ||
| 035 | |a (OCoLC)on1351986727 | ||
| 037 | |a 9781484289952 |b O'Reilly Media | ||
| 040 | |a ORMDA |b eng |e rda |e pn |c ORMDA |d EBLCP |d GW5XE |d YDX |d OCLCF | ||
| 049 | |a WENN | ||
| 049 | |a WENN | ||
| 050 | 4 | |a HD30.213 | |
| 072 | 7 | |a UMP |2 bicssc | |
| 072 | 7 | |a COM051380 |2 bisacsh | |
| 072 | 7 | |a UMP |2 thema | |
| 082 | 0 | 4 | |a 658.4/038011 |2 23/eng/20221129 |
| 100 | 1 | |a Aspin, Adam, |e author. | |
| 245 | 1 | 0 | |a Pro DAX and data modeling in Power BI : |b creating the perfect semantic layer to drive your dashboard analytics / |c Adam Aspin. |
| 250 | |a [First edition]. | ||
| 264 | 1 | |a New York, NY : |b Apress, |c [2022] | |
| 300 | |a 1 online resource (xxiii, 465 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 500 | |a Includes index. | ||
| 505 | 0 | |a 1. Using Power BI Desktop to Create a Data Model -- 2. Extending The Data Model -- 3. The Semantic Layer -- 4. Calculated Columns -- 5. Calculating Across Tables -- 6. DAX Logical Functions -- 7. Date and Time Calculations in Columns -- 8. Introduction to Measures -- 9. Filtering Measures -- 10. CALCULATE() Modifiers -- 11. The Filter() Function -- 12. Iterators -- 13. Creating and Applying a Date Dimension -- 14. Time Intelligence -- 15. DAX Variables -- 16. Table Functions -- 17. Extending the Data Model -- 18. Evaluation Context -- Appendix A: Sample Data. | |
| 520 | |a Develop powerful data models that bind data from disparate sources into a coherent whole. Then extend your data models using DAX–the query language that underpins Power BI–to create reusable measures to deliver finely-crafted custom calculations in your dashboards. This book starts off teaching you how to define and enhance the core structures of your data model to make it a true semantic layer that transforms complex data into familiar business terms. You’ll learn how to create calculated columns to solve basic analytical challenges. Then you’ll move up to mastering DAX measures to finely slice and dice your data. The book also shows how to handle temporal analysis in Power BI using a Date dimension. You will see how DAX Time Intelligence functions can simplify your analysis of data over time. Finally, the book shows how to extend DAX to filter and calculate datasets and develop DAX table functions and variables to handle complex queries. | ||
| 630 | 0 | 0 | |a Microsoft Power BI (Computer file) |
| 650 | 0 | |a Dashboards (Management information systems) | |
| 650 | 0 | |a Business intelligence |x Computer programs. | |
| 650 | 0 | |a Information visualization |x Computer programs. | |
| 650 | 0 | |a Visual analytics. | |
| 655 | 0 | |a Electronic books. | |
| 776 | 0 | 8 | |c Original |z 1484289943 |z 9781484289945 |w (OCoLC)1346537507 |
| 856 | 4 | 0 | |t 0 |u https://go.oreilly.com/wentworth-institute-of-technology/library/view/-/9781484289952/?ar |y Full text (Wentworth users only) |
| 999 | 1 | 0 | |i 9f76d089-e29c-4eeb-a601-72cac093c91e |l w2948078 |s US-MBWI |m pro_dax_and_data_modeling_in_power_bicreating_the_perfect_semantic_lay_____2022_______apresa________________________________________aspin__adam________________________e |
| 999 | 1 | 1 | |l w2948078 |s ISIL:US-MBWI |i Wentworth |t BKS |a Ebooks |c Safari |d Other scheme |p UNLOANABLE |