Boston Computer School

Starting Interactive Reporting.

• Starting Interactive Reporting.

Opening and Saving a Sample File.

• Opening and Saving a Sample File.

Creating a sample query

• Creating a sample query

Viewing Database Tables.

• Viewing Database Tables.

Adding Topics to query

• Adding Topics to query

Viewing Results.

• Reordering Columns.
• Sorting Columns
• Filtering Data.
• Calculating Data.
• Pivoting Data.
• Drilling Down.
• Hiding Data.
• Adding Color.

Charting data.

• Sorting Charts.
• Inserting Text Labels.

Designing Reports.

• Creating smart Reports.
• Sorting Columns.
• Setting up a Report page.

Inserting Sections and Breaks.

• Inserting Sections and Breaks.

Changing Views.

• Changing Views.

Formatting Text and other elements.

• Formatting Text and other elements.

Setting interactive reporting options.

• Setting interactive reporting options.

Exporting document as web page.

• Exporting document as web page.

Export to HTML Wizard.

• Export to HTML Wizard.

Spot lighter.

• Spot lighter.

Querying

• Query Section.
• Building queries.
• Processing Queries
• Saving Queries
• Derived Tables.
• Working with query section data.

Results

• Results section.
• Enhancing your results set.
• Working with results table.
• Saving Results set.
• Exporting Results set

Working with Tables.

• Table Section.
• Creating Tables.
• Manipulating Table Data.
• Working with Table Components.

Querying Multidimensional Databases

• Olap Query Section
• Defining OLAP Query Options
• Building OLAP Queries.
• Refining OLAP Query data.
• Processing OLAP Queries.
• Applying Filters.

Cube query:

• Cube Query Catalog.
• Member selection.
• Query options.
• Showing as Chart.
• Exporting a Cube query.

Analyzing Data with Pivot Tables.

• Creating Pivot Table.
• Charting a Pivot table.
• Working with Pivot table.
• Pivoting Data.

Report Designer.

• Report Section.
• Creating a custom report.
• Working with a report page.
• Formatting report items.

Computed Items.

• About Computed Items.
• Adding Computed items.
• Common computed item example.

Applying Sorts.

• Sorting Data.
• Simple Sort.
• Sort lines.
• Complex Sorting.
• Nested Sorting.

Understanding Connectivity in Interactive Reporting.

• About IR Database connection files.
• Working with interactive reporting connection.
• Connecting to database.

Data Modeling.

• About Modeling.
• Building a data model.
• Understanding joins.
• Working with Data Models.

Security for Interactive reporting.

• Security for Interactive reporting.

Introduction to dashboards.

• Introduction to dashboards.

Migrating reports with dashboards

• Migrating reports with dashboards