Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
DAX formulas for PowerPivot [[electronic resource] ] : the Excel pro's guide to mastering DAX / / Rob Collie
| 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 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DAX formulas for PowerPivot [[electronic resource] ] : the Excel pro's guide to mastering DAX / / Rob Collie
| 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 | ||
| Materiale a stampa | ||
| 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
| 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 | ||
| Materiale a stampa | ||
| 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
| 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 | ||
| Materiale a stampa | ||
| 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
| 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 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||