Skip to content
Acinta Documentation
93 Glossary
Initializing search
Acinta Documentation
01 Introduction
01 Introduction
1.0 The Acinta Intelligence Suite
1.1 About Datashop
1.2 Launching Datashop for the First Time
1.3 Opening Your First Workbook
1.4 Your First Analysis Exploring a Workbook
1.5 Getting Help and Learning More
02 nikolAI
02 nikolAI
2.1 What is nikolAI
2.2 Getting Started with nikolAI
2.3 What nikolAI Can Do
2.4 How to Communicate with nikolAI
2.5 Understanding Responses
2.6 Limitations
2.7 Tips for Best Results
2.8 Example Requests
2.9 Right-Click Commands
2.10 AI Consent and Data Policies
03 Understanding Data Models
03 Understanding Data Models
3.1 Why Dimensional Models
3.2 Core Concepts
3.3 How Dimensions Work Together
3.4 Exploring Your Data Model
3.5 Real World Complexity
04 The Datashop Main Window
04 The Datashop Main Window
4.1 Signing In and Choosing a Project
4.2 The Main Window
4.3 Searching Favorites and the Startup Workbook
4.4 Creating and Managing Objects
4.5 Your User Settings
05 Working with Workbooks
05 Working with Workbooks
5.1 What is a Workbook
5.2 Opening and Navigating Workbooks
5.3 The Ribbon
5.4 Sheets and Tabs
5.5 The Filter Panel
5.6 Side Panels
5.7 Formula Bar Status Bar and Calculator
06 Exploring and Analyzing
06 Exploring and Analyzing
6.1 Exploring Data in a Workbook
6.2 Drilling Down and Drilling Through
6.3 Filtering from the Data
6.4 Sorting Rotating and New Windows
6.5 View Dataset Statistics and Errors
07 Designing Workbooks
07 Designing Workbooks
7.1 Creating a New Workbook
7.2 Workbook Types
7.3 Page Types
7.4 Inserting and Arranging Visuals
7.5 Element Structure and Appearance
7.6 Workbook Properties
7.7 Configuring the Filter Panel
7.8 Themes and Templates
7.10 Workbook Design Best Practices
08 Visual Types
08 Visual Types
8.1 Visual Types Overview
8.2 Tables Cross-tabs and Pivot Tables
8.3 Charts
8.4 Gauges
8.5 Rose Diagrams
8.6 Text and Pictures
8.7 Buttons
8.8 Filter Visuals
09 Filters
09 Filters
9.1 Filter Concepts
9.2 Building Filters
9.3 Dynamic Dates
9.4 Filter Modifiers and Ignoring Filters
9.5 Master Filter and Migrating
10 Metrics and Transformations
10 Metrics and Transformations
10.1 Understanding Metrics
10.2 Using Existing Metrics
10.3 Creating and Editing Metrics
10.4 Quick Transformations
10.5 Combining Metrics
10.6 Targets
10.7 Classic Transformations
11 Formatting and Styles
11 Formatting and Styles
11.1 How Formatting Works
11.2 Formatting from the Ribbon
11.3 Number and Date Formats
11.4 Table Styles
11.5 Style Objects and the Style Editor
12 Rules and Conditional Formatting
12 Rules and Conditional Formatting
12.0 Quick Conditional Formatting
12.1 What are Rules
12.2 Rule Conditions and Styles
12.3 Conditional Rules
12.4 Sequential Rules
12.5 System Rules
12.6 Creating Global Rules
13 Actions and Interactivity
13 Actions and Interactivity
13.1 Actions Overview
13.2 Adding Actions
13.3 Opening Workbooks and Passing Filters
13.4 SQL Script and Program Actions
13.5 Drill Settings for Designers
14 Segmentations
14 Segmentations
14.1 What are Segmentations
14.2 Segmentation Types
14.3 How To Create A Segmentation
14.4 Top N and Bottom N Rankings
14.5 Pareto Analysis
14.6 ABC Analysis
14.7 Quartiles and Percentiles
14.8 Custom Segmentations
14.9 Using Segmentations in Visuals
14.10 Using Segmentations as Filters
15 Consolidations
15 Consolidations
15.1 What are Consolidations
15.2 Creating and Editing Consolidations
15.3 Using Consolidations
15.4 Histograms
16 Input Tables and Your Own Data
16 Input Tables and Your Own Data
16.1 What are FlexTables
16.2 Creating FlexTables
16.3 The FlexTable Editor
16.4 Using FlexTables in Visuals
17 Printing Exporting and Sharing
17 Printing Exporting and Sharing
17.1 Printing and Page Setup
17.2 PDF and Email
17.3 Exporting to Excel
17.4 Copying and Other Exports
17.5 Sharing Workbooks and Objects
18 Distributions
18 Distributions
18.1 What Distributions Are
18.2 Creating a Distribution
18.3 Recipients and Personal Reports
18.4 Email Content and Merge Fields
18.5 Attachments and Collated Emails
18.6 AI Commentary
18.7 Schedules
18.8 Status Reports and Troubleshooting
18.9 Testing a Distribution
19 Datashop Tools
19 Datashop Tools
19.1 SQL Explorer
19.2 Job Monitor and Performance
19.3 Project Cleanup
19.4 Translations
19.5 Change Log and Other Tools
20 Getting Started with Modeller
20 Getting Started with Modeller
20.1 What Modeller Is For
20.2 Starting Modeller and Opening a Project
20.3 The Modeller Window
20.4 Saving and Working Together
21 Data Sources and Connections
21 Data Sources and Connections
21.1 Data Sources
21.2 Connecting to a Database
21.3 When the Source Database Changes
22 Tables Dynamic Views and Joins
22 Tables Dynamic Views and Joins
22.1 Tables in the Warehouse
22.2 Dynamic Views
22.3 Joins and Table Relations
23 Dimensions Units and Hierarchies
23 Dimensions Units and Hierarchies
23.1 Dimensions and Units
23.2 Linking Units to Tables
23.3 Hierarchies
23.4 Advanced Unit Settings
24 Facts and Transformations
24 Facts and Transformations
24.1 Facts
24.2 Transformations
25 Translations
25 Translations
25.1 Translating the Data Model
26 Validation Options and Repair
26 Validation Options and Repair
26.1 Validating the Project
26.2 Project Options
26.3 Repair
26.4 Backup Restore and Moving a Project
27 Performance
27 Performance
27.1 Performance Tuning
27.2 Materialized Dynamic Views and Caching
30 Installation and Updating
30 Installation and Updating
30.1 Installing Acinta
30.2 Configuration Files and Project Registrations
30.3 Updating Acinta
31 Enterprise Manager
31 Enterprise Manager
31.1 Enterprise Manager Overview
32 Users and Security
32 Users and Security
32.1 Users
32.2 Security and Data Access
32.3 The Audit Log
33 Acinta Server
33 Acinta Server
33.1 Acinta Server
34 Email Delivery
34 Email Delivery
34.1 Email Delivery
35 Command-line Reference
35 Command-line Reference
35.1 Command-Line Reference
36 Datashop Web and the Excel Connector
36 Datashop Web and the Excel Connector
36.1 Datashop Web
36.2 The Excel Connector
90 Troubleshooting
90 Troubleshooting
90.1 Troubleshooting Guide
91 Best Practices
91 Best Practices
91.1 Best Practices
92 Keyboard Shortcuts
92 Keyboard Shortcuts
92.1 Keyboard Shortcuts
93 Glossary
93 Glossary
93.1 Glossary
index
93 Glossary
¶
This chapter covers:
93.1 Glossary
Select a topic from the sidebar to get started.
Back to top