Extreme DAX : Take Your Power BI and Microsoft Data Analytics Skills to the Next Level
Saved in:
| Title: | Extreme DAX : Take Your Power BI and Microsoft Data Analytics Skills to the Next Level |
|---|---|
| Description: | Discover the true power of DAX and build advanced DAX solutions for practical business scenariosKey FeaturesSolve complex business problems within Microsoft BI tools including Power BI, SQL Server, and ExcelDevelop a conceptual understanding of critical business data modeling principlesLearn the subtleties of Power BI data visualizations, evaluation context, context transition, and filteringBook DescriptionThis book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of Microsoft Business Intelligence tools. Extreme DAX will first teach you the principles of business intelligence, good model design, and how DAX fits into it all. Then, you'll launch into detailed examples of DAX in real-world business scenarios such as inventory calculations, forecasting, intercompany business, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with Power BI models and common mistakes to look out for as you build advanced data aggregations. You'll deepen your understanding of DAX functions, filters, and measures, and how and when they can be used to derive effective insights. You'll also be provided with PBIX files for each chapter, so that you can follow along and explore in your own time.What you will learnUnderstand data modeling concepts and structures before you start working with DAXGrasp how relationships in Power BI models are different from those in RDBMSesSecure aggregation levels, attributes, and hierarchies using PATH functions and row-level securityGet to grips with the crucial concept of contextApply advanced context and filtering functions including TREATAS, GENERATE, and SUMMARIZEExplore dynamically changing visualizations with helper tables and dynamic labels and axesWork with week-based calendars and understand standard time-intelligenceEvaluate investments intelligently with the XNPV and XIRR financial DAX functionsWho this book is forExtreme DAX is written for analysts with a working knowledge of DAX in Power BI or other Microsoft analytics tools. It will help you upgrade your knowledge and work with analytical models more effectively, so you'll need practical experience with DAX before you can get started. |
| Authors: | Michiel Rozema, Henk Vlootman |
| Resource Type: | eBook. |
| Subjects: | Business intelligence--Computer programs, Query languages (Computer science) |
| Categories: | COMPUTERS / Data Science / Data Modeling & Design, COMPUTERS / Business & Productivity Software / Business Intelligence, COMPUTERS / Data Science / General |
| Database: | eBook Collection (EBSCOhost) |
| FullText | Links: – Type: ebook-pdf – Type: ebook-epub Text: Availability: 0 |
|---|---|
| Header | DbId: nlebk DbLabel: eBook Collection (EBSCOhost) An: 3139475 RelevancyScore: 1110 AccessLevel: 6 PubType: eBook PubTypeId: ebook PreciseRelevancyScore: 1109.74133300781 |
| IllustrationInfo | |
| ImageInfo | – Size: thumb Target: https://rps2images.ebscohost.com/rpsweb/othumb?id=NL$3139475$PDF&s=r – Size: medium Target: https://rps2images.ebscohost.com/rpsweb/othumb?id=NL$3139475$PDF&s=d |
| Items | – Name: Title Label: Title Group: Ti Data: Extreme DAX : Take Your Power BI and Microsoft Data Analytics Skills to the Next Level – Name: Abstract Label: Description Group: Ab Data: Discover the true power of DAX and build advanced DAX solutions for practical business scenariosKey FeaturesSolve complex business problems within Microsoft BI tools including Power BI, SQL Server, and ExcelDevelop a conceptual understanding of critical business data modeling principlesLearn the subtleties of Power BI data visualizations, evaluation context, context transition, and filteringBook DescriptionThis book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of Microsoft Business Intelligence tools. Extreme DAX will first teach you the principles of business intelligence, good model design, and how DAX fits into it all. Then, you'll launch into detailed examples of DAX in real-world business scenarios such as inventory calculations, forecasting, intercompany business, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with Power BI models and common mistakes to look out for as you build advanced data aggregations. You'll deepen your understanding of DAX functions, filters, and measures, and how and when they can be used to derive effective insights. You'll also be provided with PBIX files for each chapter, so that you can follow along and explore in your own time.What you will learnUnderstand data modeling concepts and structures before you start working with DAXGrasp how relationships in Power BI models are different from those in RDBMSesSecure aggregation levels, attributes, and hierarchies using PATH functions and row-level securityGet to grips with the crucial concept of contextApply advanced context and filtering functions including TREATAS, GENERATE, and SUMMARIZEExplore dynamically changing visualizations with helper tables and dynamic labels and axesWork with week-based calendars and understand standard time-intelligenceEvaluate investments intelligently with the XNPV and XIRR financial DAX functionsWho this book is forExtreme DAX is written for analysts with a working knowledge of DAX in Power BI or other Microsoft analytics tools. It will help you upgrade your knowledge and work with analytical models more effectively, so you'll need practical experience with DAX before you can get started. – Name: Author Label: Authors Group: Au Data: <searchLink fieldCode="AR" term="%22Michiel+Rozema%22">Michiel Rozema</searchLink><br /><searchLink fieldCode="AR" term="%22Henk+Vlootman%22">Henk Vlootman</searchLink> – Name: TypePub Label: Resource Type Group: TypPub Data: eBook. – Name: Subject Label: Subjects Group: Su Data: <searchLink fieldCode="DE" term="%22Business+intelligence--Computer+programs%22">Business intelligence--Computer programs</searchLink><br /><searchLink fieldCode="DE" term="%22Query+languages+%28Computer+science%29%22">Query languages (Computer science)</searchLink> – Name: SubjectBISAC Label: Categories Group: Su Data: <searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Data+Science+%2F+Data+Modeling+%26+Design%22">COMPUTERS / Data Science / Data Modeling & Design</searchLink><br /><searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Business+%26+Productivity+Software+%2F+Business+Intelligence%22">COMPUTERS / Business & Productivity Software / Business Intelligence</searchLink><br /><searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Data+Science+%2F+General%22">COMPUTERS / Data Science / General</searchLink> |
| PLink | https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=nlebk&AN=3139475 |
| RecordInfo | BibRecord: BibEntity: Classifications: – Code: 005.74 Scheme: ddc Type: prePub Languages: – Code: eng Text: English Subjects: – SubjectFull: Business intelligence--Computer programs Type: general – SubjectFull: Query languages (Computer science) Type: general Titles: – TitleFull: Extreme DAX : Take Your Power BI and Microsoft Data Analytics Skills to the Next Level Type: main BibRelationships: HasContributorRelationships: – PersonEntity: Name: NameFull: Michiel Rozema – PersonEntity: Name: NameFull: Henk Vlootman – PersonEntity: Name: NameFull: Michiel Rozema – PersonEntity: Name: NameFull: Henk Vlootman IsPartOfRelationships: – BibEntity: Dates: – D: 01 M: 01 Type: published Y: 2022 – D: 03 M: 03 Type: profile Y: 2022 Identifiers: – Type: isbn-print Value: 9781801078511 – Type: isbn-electronic Value: 9781801073035 Titles: – TitleFull: Extreme DAX : Take Your Power BI and Microsoft Data Analytics Skills to the Next Level Type: main |
| ResultId | 1 |
