DAX formulas for PowerPivot [[electronic resource] ] : the Excel pro's guide to mastering DAX / / Rob Collie |
Autore | Collie Rob |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, c2013 |
Descrizione fisica | 1 online resource (255 p.) |
Soggetto topico | Business intelligence - Computer programs |
Soggetto genere / forma | Electronic books. |
ISBN |
1-61547-112-X
1-61547-212-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910453819303321 |
Collie Rob
![]() |
||
Uniontown, OH, : Holy Macro! Books, c2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
DAX formulas for PowerPivot [[electronic resource] ] : the Excel pro's guide to mastering DAX / / Rob Collie |
Autore | Collie Rob |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, c2013 |
Descrizione fisica | 1 online resource (255 p.) |
Soggetto topico | Business intelligence - Computer programs |
ISBN |
1-61547-112-X
1-61547-212-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910790510403321 |
Collie Rob
![]() |
||
Uniontown, OH, : Holy Macro! Books, c2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
DAX formulas for PowerPivot : the Excel pro's guide to mastering DAX / / Rob Collie |
Autore | Collie Rob |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, c2013 |
Descrizione fisica | 1 online resource (255 p.) |
Disciplina | 005.54 |
Soggetto topico | Business intelligence - Computer programs |
ISBN |
1-61547-112-X
1-61547-212-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Intro -- _GoBack -- Preface/Forward/Intro -- First Chapter -- Copyright page -- Index -- Acknowledgements -- Supporting Workbooks and Data Sets -- A Note on Hyperlinks -- Introduction -- 1- A Revolution Built on YOU -- 2- What Version of PowerPivot Should You Use? -- 3- Learning PowerPivot "The Excel Way" -- 4- Loading Data Into PowerPivot -- 5- Intro to Calculated Columns -- 6- Introduction to DAX Measures -- 7- The "Golden Rules" of DAX Measures -- 8- CALCULATE() - Your New Favorite Function -- 9- ALL() - The "Remove a Filter" Function -- 10- Thinking in Multiple Tables -- 11- "Intermission" - Taking Stock of Your New Powers -- 12- Disconnected Tables -- 13- Introducing the FILTER() Function, and Disconnected Tables Continued -- 14- Introduction to Time Intelligence -- 15- IF(), SWITCH(), BLANK(), and Other Conditional Fun -- 16- SUMX() and Other X ("Iterator") Functions -- 17- Multiple Data Tables -- 18- Time Intelligence with Custom Calendars: Advanced Use of FILTER() -- 19- Performance: How to keep things running fast. -- 20- Advanced Calculated Columns -- 21- The Final Transformation: One Click That Will Change Your Life Forever -- A1- Further Proof That the Game is Changing -- A2- So Much Power, So Little Space: Further Capabilities -- A3- Four Common Error Messages -- A4- People: The Most Powerful Feature of PowerPivot -- Index. |
Record Nr. | UNINA-9910810319403321 |
Collie Rob
![]() |
||
Uniontown, OH, : Holy Macro! Books, c2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Power Pivot alchemy : patterns and techniques for Excel / / Rob Collie and Bill Jelen ; cover design, Jocelyn Hellyer ; indexing, Nellie J. Liwam |
Autore | Collie Rob |
Pubbl/distr/stampa | Uniontown, Ohio : , : Holy Macro! Books, , 2014 |
Descrizione fisica | 1 online resource (257 p.) |
Disciplina | 005.54 |
Soggetto topico | Electronic spreadsheets - Computer programs |
Soggetto genere / forma | Electronic books. |
ISBN | 1-61547-214-2 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Title page; Copyright; Table of Contents; Dedications; A Note on Hyperlinks; Acknowledgements; Foreword; Introduction; Chapter 1: Dashboard Tricks and Visualization Techniques; Adding a "Last Refreshed Date" Readout; Normalizing Your Measures to First/Average/Max Values for Charts; Bubbling Up Exceptions with "Sarah Problem"; Ranks and Exceptions That Bubble Up to Subtotals; Chapter 2: Slicers: The Gateway to Interactivity; "Initializing" Slicers That Contain Too Many Values to Scroll; Wingdings and Other Symbolic Fonts in Slicers; Using Macros to Change Slicer Fonts
A Simple Trick for Combatting "Stale" SlicersUser-Friendly Report Sorting with Slicers; Adding State Alpha Sorting to the Sort-by-Slicer Trick; Conditional Formatting Controlled via Slicers; Catching Slicer Selections in a Formula; Chapter 3: Conquering Common Calculated Column Conundrums; An Excel Pro's Primer on Calculated Columns; Subtotaling Calc Columns and the EARLIER() Function; Referencing the Previous Row and Similar Calcs; Referencing Rows "Within Range" of the Current Row; Totaling Data Table Values in Lookup Tables; CONTAINSX: Finding Matching Values in Two Tables CONTAINSX Revisited: What Is the Match?Common Calendar Conundrums; Custom Calendar Conundrums; Chapter 4: Modeling and Portable Formulas; Integrating Data of Different "Grains"; A Mystifying and Awesome Solution for the Many-to-Many Problem; Calculating Same-Store Sales in Power Pivot; Same-Store Sales Continued: Using Store Open/Close Dates; Campaign Analysis: Seasonally Adjusted Measures; A/B Campaign Analysis with Start and End Date Slicers; Customers and Website Visitors: Percentage Who Return; Calculating Average Customer Age; Moving Averages, Sums, etc Moving Averages Controlled by a SlicerChapter 5: Power Query; Combining Multiple Worksheets or Workbooks into a Single Power Pivot Table; Using Power Query to Merge CSV Files; Using Power Query to "Unpivot" a Table; Using Power Query to Create a Lookup Table from a Data Table; Creating a Calendar Table: Advanced Usage of Power Query; Chapter 6: Power View; How to Use Power View; Chapter 7: Power Map; Thank you; Index; More from Holy Macro! Books |
Record Nr. | UNINA-9910458278803321 |
Collie Rob
![]() |
||
Uniontown, Ohio : , : Holy Macro! Books, , 2014 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Power Pivot alchemy : patterns and techniques for Excel / / Rob Collie and Bill Jelen ; cover design, Jocelyn Hellyer ; indexing, Nellie J. Liwam |
Autore | Collie Rob |
Pubbl/distr/stampa | Uniontown, Ohio : , : Holy Macro! Books, , 2014 |
Descrizione fisica | 1 online resource (257 p.) |
Disciplina | 005.54 |
Soggetto topico | Electronic spreadsheets - Computer programs |
ISBN | 1-61547-214-2 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Title page; Copyright; Table of Contents; Dedications; A Note on Hyperlinks; Acknowledgements; Foreword; Introduction; Chapter 1: Dashboard Tricks and Visualization Techniques; Adding a "Last Refreshed Date" Readout; Normalizing Your Measures to First/Average/Max Values for Charts; Bubbling Up Exceptions with "Sarah Problem"; Ranks and Exceptions That Bubble Up to Subtotals; Chapter 2: Slicers: The Gateway to Interactivity; "Initializing" Slicers That Contain Too Many Values to Scroll; Wingdings and Other Symbolic Fonts in Slicers; Using Macros to Change Slicer Fonts
A Simple Trick for Combatting "Stale" SlicersUser-Friendly Report Sorting with Slicers; Adding State Alpha Sorting to the Sort-by-Slicer Trick; Conditional Formatting Controlled via Slicers; Catching Slicer Selections in a Formula; Chapter 3: Conquering Common Calculated Column Conundrums; An Excel Pro's Primer on Calculated Columns; Subtotaling Calc Columns and the EARLIER() Function; Referencing the Previous Row and Similar Calcs; Referencing Rows "Within Range" of the Current Row; Totaling Data Table Values in Lookup Tables; CONTAINSX: Finding Matching Values in Two Tables CONTAINSX Revisited: What Is the Match?Common Calendar Conundrums; Custom Calendar Conundrums; Chapter 4: Modeling and Portable Formulas; Integrating Data of Different "Grains"; A Mystifying and Awesome Solution for the Many-to-Many Problem; Calculating Same-Store Sales in Power Pivot; Same-Store Sales Continued: Using Store Open/Close Dates; Campaign Analysis: Seasonally Adjusted Measures; A/B Campaign Analysis with Start and End Date Slicers; Customers and Website Visitors: Percentage Who Return; Calculating Average Customer Age; Moving Averages, Sums, etc Moving Averages Controlled by a SlicerChapter 5: Power Query; Combining Multiple Worksheets or Workbooks into a Single Power Pivot Table; Using Power Query to Merge CSV Files; Using Power Query to "Unpivot" a Table; Using Power Query to Create a Lookup Table from a Data Table; Creating a Calendar Table: Advanced Usage of Power Query; Chapter 6: Power View; How to Use Power View; Chapter 7: Power Map; Thank you; Index; More from Holy Macro! Books |
Record Nr. | UNINA-9910791025603321 |
Collie Rob
![]() |
||
Uniontown, Ohio : , : Holy Macro! Books, , 2014 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Power Pivot alchemy : patterns and techniques for Excel / / Rob Collie and Bill Jelen ; cover design, Jocelyn Hellyer ; indexing, Nellie J. Liwam |
Autore | Collie Rob |
Pubbl/distr/stampa | Uniontown, Ohio : , : Holy Macro! Books, , 2014 |
Descrizione fisica | 1 online resource (257 p.) |
Disciplina | 005.54 |
Soggetto topico | Electronic spreadsheets - Computer programs |
ISBN | 1-61547-214-2 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Title page; Copyright; Table of Contents; Dedications; A Note on Hyperlinks; Acknowledgements; Foreword; Introduction; Chapter 1: Dashboard Tricks and Visualization Techniques; Adding a "Last Refreshed Date" Readout; Normalizing Your Measures to First/Average/Max Values for Charts; Bubbling Up Exceptions with "Sarah Problem"; Ranks and Exceptions That Bubble Up to Subtotals; Chapter 2: Slicers: The Gateway to Interactivity; "Initializing" Slicers That Contain Too Many Values to Scroll; Wingdings and Other Symbolic Fonts in Slicers; Using Macros to Change Slicer Fonts
A Simple Trick for Combatting "Stale" SlicersUser-Friendly Report Sorting with Slicers; Adding State Alpha Sorting to the Sort-by-Slicer Trick; Conditional Formatting Controlled via Slicers; Catching Slicer Selections in a Formula; Chapter 3: Conquering Common Calculated Column Conundrums; An Excel Pro's Primer on Calculated Columns; Subtotaling Calc Columns and the EARLIER() Function; Referencing the Previous Row and Similar Calcs; Referencing Rows "Within Range" of the Current Row; Totaling Data Table Values in Lookup Tables; CONTAINSX: Finding Matching Values in Two Tables CONTAINSX Revisited: What Is the Match?Common Calendar Conundrums; Custom Calendar Conundrums; Chapter 4: Modeling and Portable Formulas; Integrating Data of Different "Grains"; A Mystifying and Awesome Solution for the Many-to-Many Problem; Calculating Same-Store Sales in Power Pivot; Same-Store Sales Continued: Using Store Open/Close Dates; Campaign Analysis: Seasonally Adjusted Measures; A/B Campaign Analysis with Start and End Date Slicers; Customers and Website Visitors: Percentage Who Return; Calculating Average Customer Age; Moving Averages, Sums, etc Moving Averages Controlled by a SlicerChapter 5: Power Query; Combining Multiple Worksheets or Workbooks into a Single Power Pivot Table; Using Power Query to Merge CSV Files; Using Power Query to "Unpivot" a Table; Using Power Query to Create a Lookup Table from a Data Table; Creating a Calendar Table: Advanced Usage of Power Query; Chapter 6: Power View; How to Use Power View; Chapter 7: Power Map; Thank you; Index; More from Holy Macro! Books |
Record Nr. | UNINA-9910814810603321 |
Collie Rob
![]() |
||
Uniontown, Ohio : , : Holy Macro! Books, , 2014 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|