Зарегистрироваться
Восстановить пароль
FAQ по входу

Collie Rob, Jelen Bill. Power Pivot Alchemy: Patterns and Techniques for Excel

  • Файл формата pdf
  • размером 16,13 МБ
  • Добавлен пользователем
  • Описание отредактировано
Collie Rob, Jelen Bill. Power Pivot Alchemy: Patterns and Techniques for Excel
Holy Macro! Books, 2014. — 223 p. — ISBN: 1615470212, 9781615470211.
PowerPivot is an amazing new add-in for Excel 2013 that allows business intelligence pros to process large amounts data.
Although it is simple to use in a demo environment, analysts are likely to run into real-life scenarios that are difficult to solve.
This guide, dedicated solely to the PowerPivot tool, provides techniques and solutions to real-world problems, including showing the Top N customers by using slicer filters, comparing budget to actuals, drilling across data instead of through data, and joining data from two different sources in a single analysis.
  • Чтобы скачать этот файл зарегистрируйтесь и/или войдите на сайт используя форму сверху.
  • Регистрация

Смотри также

Подробнее

Alexander M., Decker J., Wehbe B. Microsoft Business Intelligence Tools for Excel Analysts

  • pdf
Wiley, 2014. — 384 p. in color. — Kindle Edition — ASIN: B00JSPNXNE — ISBN: 1118821521, 9781118821527 Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now...
  • 85,26 МБ
  • добавлен
  • описание отредактировано
Подробнее

Bosco R. PowerPivot for Advanced Reporting and Dashboards: Leverage the capabilities of the Microsoft Excel PowerPivot add-on to create advanced BI solutions

  • pdf
Packt Publishing, 2014. — 150 p. — ISBN: 9781849698689 Business intelligence technology gives an organization the power to make decisions using large volumes of data. By obtaining an adequate amount of data and integrating data from a variety of sources, a user can get a comprehensive knowledge of their business and business strategies. PowerPivot is a free add-in to the 2010...
  • 2,83 МБ
  • добавлен
  • описание отредактировано
Подробнее

Collie R. DAX Formulas for PowerPivot: A Simple Guide to the Excel Revolution

  • pdf
Holy Macro! Books, 2012. — 239 p. — ISBN: 1615470158, 9781615470150 Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the...
  • 11,09 МБ
  • добавлен
  • описание отредактировано
Подробнее

Collie Robert, Singh Avichal. Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016

  • pdf
Holy Macro! Books, 2016. — 564 p. — ISBN: 978-1-61547-039-6, 978-1-61547-226-0, 978-1-61547-349-6, 978-1-61547-126-3. True PDF Microsoft Power BI, including Power Pivot and Power Query, are a set of free add-ons to Excel that allow users to produce new kinds of reports and analyses that were simply impossible before. This book, printed in full-gorgeous color, gives you an...
  • 14,79 МБ
  • добавлен
  • описание отредактировано
Подробнее

Ferrari A., Russo M. Microsoft Excel 2013: Building Data Models with PowerPivot

  • pdf
Microsoft Press, 2013. — 512 pages. — ISBN10: 0735676348, ISBN13: 978-0735676343. На англ. языке. Your guide to quickly turn data into results. Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a...
  • 61,99 МБ
  • добавлен
  • описание отредактировано
Подробнее

Puls Ken, Escobar Miguel. M is for (DATA) MONKEY: The Excel's Pro's Definitive Guide to Power Query

  • pdf
Holy Macro! Books, 2015. — 307 p. — ISBN: 978-1-61547-034-1. Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and “M” is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this...
  • 20,21 МБ
  • добавлен
  • описание отредактировано
Наверх