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

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

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

PIVOT и Consolidate

6plus4u Pivot and Consolidate

View more presentations from LogMan Knowledge Community.

Използвайте следната таблица (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.

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.

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.

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.

Week 9