top

  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.

  Info

  • Utilizzare questo link per rimuovere la selezione effettuata.
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
Opac: Controlla la disponibilità qui
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
Opac: Controlla la disponibilità qui
DAX formulas for PowerPivot : the Excel pro's guide to mastering DAX / / Rob Collie
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
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
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
Opac: Controlla la disponibilità qui
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
Opac: Controlla la disponibilità qui
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
Opac: Controlla la disponibilità qui