Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Microstrategy bootcamp > Reporting Essentials > Flashcards

Reporting Essentials Flashcards

1
Q

What is Business Intelligence?

A

Using data to make better-informed decisions about your business

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is Big Data analytics?

A

Enable you to not only connect to the largest of datasets, but also intelligently transform and aggregate petabytes of data into gigabytes of in-memory data for agile data discovery.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

List the components of a business intelligence architecture using MicroStrategy

A

source systems, data warehouse, ETL Process, metadata database, data import and MicroStrategy applications

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What can you do with MicroStrategy applications?

A

MSTR Applications enable you to intuitively interact with your business intelligence system and enable you to do everything from rapid data discovery to predictive analysis. They also provide the ability to look at data from many different perspectives.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is MicroStrategy Software Development Kit (SDK)?

A

You can use MSTR SDK to customize thew interface that users see and the functionality available to them.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is MultiSource Option?

A

It enables you to define a single project schema that uses multiple data sources.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is MicroStrategy Web interface?

A

it is a single code base that provides BI functionality to all users, ranging from basic reporting functionality for novice users, to interface analysis functionality for analysis, to full report design functionality for power users and IT Professionals.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Mention the different interfaces used by MicroStrategy Web to deliver visualizations and dashboards.

A

Mobile devices, Web browsers, third-party enterprise portals and Microsoft Office (Excel, Word and PowerPoint using Web services)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Mention the two ways to host your MicroStrategy applications:

A

On premises

MicroStrategy Cloud

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Mention the advantages of using MicroStrategy as a platform-as-a-service

A

Reduces your infrastructure overhead, increases scalability and reduces costs, while continuing to provide access to MicroStrategy’s range of applications.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is Microstrategy’s metadata?

A

It stores MicroStrategy object definitions and maps MicroStrategy objects to the data source structures and content. All these is stored in a proprietary format.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How MicroStrategy applications use the metadata?

A

They translate user requests into queries and also translate the results of those queries back into Microstrategy objects like reports, documents and dashboards.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What kind of objects definition are stored in the metadata?

A

Definition of objects such as fiilters, reports, metrics, facts and so forth.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Mention the advantages of using a metadata repository

A

Enables the sharing of objects across MicroStrategy applications by providing a central repository for all object definitions. Since all of the interfaces share the same metadata, users can move from one interface to another without any re-configuration or administrator intervention.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How MicroStrategy Intelligent Server uses the metadata?

A

It uses it to evaluate the most efficient data retrieval scenario to guarantee optimal query performance.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Mention some data sources supported by MicroStrategy

A

User or departmental data (spreadsheets, small databases or text files)
ERP, CRM and Web Applications as SalesForce
Multidimensional data sources
Relational databases
Data warehouse appliances
Columnar databases
MapReduce databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Mention the structure of a traditional datawarehouse implementation:

A

A data source that may be a transaction source system that is optimized for recording sales, orders, inventory, withdrawals and deposits. This transactional system, in turn, feeds into a large relational database (data warehouse) that stores gigabytes of cleansed data across hundreds or thousands of tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is Data Import?

A

It is a tool that enables users to quickly and independently import data from spreadsheet, database or Web service into MicroStrategy with no modeling or coding. The data is stored into an In-memory Intelligent Cube that can be reused in reports and Report Services documents.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is MicroStrategy high-performance technology?

A

It is a technology that supports fast queries on large datasets (petabytes of data) like Hadoop or SAP Hana.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Mention the most important objects used on MicroStrategy

A 
Reports
Filters
Attributes
Facts
Metrics
Prompts
Hierarchies
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is a report?

A

It is a request for specific data that has a defined layout and format.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Mention the two ways to see the report results

A

Grid or graph format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What are attributes?

A

They are the descriptive data in your data warehouse that you want to be able to display on a report or document.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Mention some examples of attriibutes

A

Customers, account numbers, products, regions or employees

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What are attribute elements?

A

Individual items that display under each attribute header

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What are the uses of filtering?

A

Filtering is used to show only relevant information and improve performance.

27
Q

How is the level of a calculation defined?

A

Usually takes the lowest-level attribute on the report (this can be manipulated)

28
Q

What are facts?

A

Facts are numeric data in your data warehouse that can be used as the basis for calculations. They are typically numeric and they map directly to columns in fact tables in your data warehouse.

29
Q

Mention some examples of facts

A

sales, inventory, profit, costs, deposits, withdrawals or balances.

30
Q

Can you place facts directly onto reports?

A

No, you need tot use metrics which can be based on facts.

31
Q

What are metrics?

A

Metrics are calculations that you place directly in reports.

32
Q

What is the Metric Editor?

A

You can use it to display or edit the formulas used in defining metrics.

33
Q

What does { ~ } mean?

A

Indicates that the metric is to be aggregated at the report level.

34
Q

Which objects can be used to build a metric?

A

Facts, attributes and other metrics.

35
Q

What are filters?

A

They specify the conditions that the data must meet to be included in the report results or displayed on the report.

36
Q

What are prompts?

A

They enable the report user to interact with the report at run time.

37
Q

Mention another way to call the source systems.

A

OnLine Transaction Processing Systems (OLTP)

38
Q

Mention examples of source systems or OLTP.

A

databases, source files, web sources or mainframe that store transaction processing data.

39
Q

What is a data warehouse?

A

It is designed and optimized for analytical processing. This type of system involves manipulating transaction records to calculate sales trends, growth patterns, percent to total contributions, trend reporting, profit analysis and so forth.

40
Q

What is an ETL process?

A

It contains information that facilitates the transfer of the data from the source systems to the data warehouse.

41
Q

Mention the tools included on MicroStrategy Developer

A

MicroStrategy Developer
MicroStrategy Architect
Administrative functions (including tools to manage users, implement security and configure and maintain MicroStrategy Intelligence Server)

42
Q

What is MicroStrategy Developer?

A

It is a next-generation business intelligence environment designed to meet today’s sophisticated business intelligence requirements. It brings integrated querying and reporting, powerful collaborative analytics, and investigative workflow to every Developer.

43
Q

What is MicroStrategy Architect?

A

It is the innovative development environment designed to meet today’s sophisticated business intelligence requirements. Unique techniques of mapping the business model to the underlying data structures make MicroStrategy Architect the most flexible tool in the industry.

44
Q

List the most important administrative functions available trough MicroStrategy Developer.

A

User Management
Comprehensive Security Model
Intelligence Server Administration

45
Q

What is a Project Source?

A

It represents the highest-level object in the MicroStrategy environment. A project source represents a connection to a metadata database or a MicroStrategy Intelligence Server.

46
Q

What can you do trough a Project source?

A

You can create, manipulate and administer MicroStrategy projects. One project source might have one or more projects.

47
Q

What is a two-tier project source?

A

The first tier is MSTR Developer and the second tier is the metadata. This kind of project points directly to a MicroStrategy metadata database.

48
Q

What is a three tier project source?

A

The first tier is MSTR Developer, the second tier is Intelligence Server and the third tier is the metadata database. This type of project source points to an Intelligence Server that is, in turn, connected to a MicroStrategy metadata database.

49
Q

Provides the core analytical processing and job management for all reporting, analysis, job management and monitoring in implementations in which it is used.

A

Intelligence Server

50
Q

Mention the activities that you can do using the Intelligence Server

A

Establish connectivity to MicroStrategy Web
Establish connectivity to MicroStrategy Mobile
Run reports to specific Microsoft Office applications via MicroStrategy Office
Send reports via email to a file server or to a print server using MicroStrategy Distirbution Services
Produce Pixel-perfect documents and dashboards using MicroStrategy Report Services
Manage and monitor system usage in MicroStrategy Developer using the Administration icon and menu
Improve report performance using caching
Automate report generation using schedules
Increase processing power using clustering
Manage project security at multiple levels
Manage, monitor and maintain the project as its data volume and user base grows

51
Q

What type of icons do you find under project source?

A
  • Administration (gearwheels)

- Project icons (one or many)

52
Q

What is the Administration Icon?

A

Provides access to all of the administrative functions for a project source.

53
Q

Who has access to the Administration icon?

A

Only users with administrative privileges

54
Q

Without Intelligence Server, which options are available to use?

A

System Monitors
Configuration Managers
Delivery Managers
User manager

55
Q

What are System Monitors?

A

They enable the access only to the Change Journaling Transactions monitor

56
Q

What are Configurations Managers?

A

They enable you to access several manages where you create configuration objects such as database instances, schedules, events, security roles and languages

57
Q

What are Delivery Managers?

A

They enable you to access the managers to create and manage transmitters and devices.

58
Q

What is User Manager?

A

Enable you to create and manage users and groups.

59
Q

What is a project?

A

It is the intersection of a data warehouse, a metadata database, and a user community. It contains objects such as reports, filters, templates and metrics.

60
Q

Mention the default structure of a Project

A

History: Retrieve scheduled reports (only with IS)
My Personal Objects: Objects only available to you
Public objects: Contains objects that may be viewed by all users depending on their permissions.
Schema Objects: Contains objects that represent the business data model.
Data Explorer: Contains hierarchies to navigate the warehouse.

61
Q

What are three main areas in MSTR Developer?

A

Folder List, Object Viewer and Shortcut Bar.

62
Q

What is in the Folder List?

A

It shows all the project sources, projects, application and schema object folders, as well as the administrative functions for the business intelligence system.

63
Q

What is the Object Viewer?

A

You navigate through the folder structure in the Folder List and the ibjects caontained in the folders are displayed in the Object Viewer.

Microstrategy bootcamp (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions