| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Week 9

Page history last edited by Malko Neznaikov 14 years, 5 months ago

Учебна година 2009-2010, Зимен семестър

 

Дисциплина "Информатика"

 

Девета учебна седмица

 

PIVOT и Consolidate

 

 

Използвайте следната таблица (Office 2007) за изучаване на PIVOT (a от тук - за Office 2003).

 

Научете съвременните технологии за обработка на икономическа инфоормация.

 

Какво е Business Intelligence (BI)?  Beyond ERP with BI

View more presentations from Dhiren Gala.

 

AI or Automated Intelligence® is a new concept for functionality introduced to Dynamic AI

to address exactly these kinds of requests - Dynamic AI automatically analyzes a data-source simply by clicking the AI button available on all reports.

More /Повече информация за  Dynamic AI

 

PowerPivot for Excel: What's New

PowerPivot for Excel 2010, a free Microsoft tool to enhance your Excel capabilities, provides ground-breaking technology, such as fast manipulation on large data sets (often in millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through SharePoint 2010. Gain business insight and make better decisions using the software you already know and love – Microsoft Office.

 

1

Build powerful analytical applications

PowerPivot combines native Excel 2010 functionality with its in-memory engine to allow users to interactively explore and perform calculations on large data sets.

It streamlines the process of integrating data from multiple sources – including corporate databases, spreadsheets, reports, and data feeds.

You can access PivotTables, slicers, and other familiar analysis features in Excel to create reports.

2

Share and collaborate with confidence

PowerPivot enables you to publish your analyses to SharePoint 2010 to make them available to others in the organization.

It allows other users to enjoy the same slicer and fast-query capabilities when working on your Excel Services reports.

Applications and reports can be refreshed automatically while also maintaining version control and tracking.

3

Manage user-generated analytical applications

Using PowerPivot for SharePoint 2010 provides a single management tool through Microsoft Office SharePoint that gives IT administrators the ability to monitor user-generated activities and content.

You can track patterns of resources usage to help ensure that user-generated solutions are continuously available, up-to-date, and guarded with security enhancements.

Опитайте работа с PowerPivot

 

Comments (0)

You don't have permission to comment on this page.