SAS Business Intelligence (BI) is a collection of tools for planning and presenting data for statistical analysis, predictive analytics, data mining, text mining, and forecasting. Interactive visualizations with analytics are provided by the tools. SAS Business Intelligence is a cloud-based enterprise research platform that allows users to handle interactive reports and track metrics. The platform's features include a personalized dashboard, marketing reports, prediction, data source connectors, ad-hoc evaluation, and more. It's built for large firms. In this blog we are going to discuss an overview of SAS Business products and then will explore all these tools used by the BI clients in information technology, information consumers, power users. We will also cover the SAS Display Manager and SAS Enterprise Guide at the end of this blog.
Overview of SAS Business Product
SAS Enterprise Business Intelligence (BI) is a collection of tools for preparing and presenting results. Here's a brief summary of the SAS BI product names and their functions.
Prepare Data
It's conceivable that your data is stored in a relational database (Oracle, Teradata, MySQL, etc). The data is then stored in OLAP cubes, information maps, or, in some cases, SAS datasets so that it can be displayed in BI software. Some users use SAS Data Integration (DI) Studio, which is another SAS product, to build their extract transform load (ETL) operation.
SAS OLAP Cube Studio
Display and Use Data
Data can be joined, variables can be renamed, and the data can be presented in a business-friendly format using information maps.
SAS Web Report Studio
Reports can be generated using OLAP Cubes, Info Maps, or SAS datasets. End-users can easily review reports and drill down to other reports using a simple, easy-to-use interface.
SAS Add-In for Microsoft Office
SAS BI Dashboard
Build dials, maps, and even moving indicators with the summarised data.
SAS Information Delivery Portal
In one place, you can access all of your Web Report Studio reporting, archiving procedures, and publishing platforms, as well as external web pages.
Helpers
SAS Enterprise Guide
SAS Prompt Framework
SAS Enterprise Guide and stored processes are also included. Users may be prompted or answered questions using prompts, and data can be returned depending on their responses.
SAS Stored Processes
Build SAS systems to transfer data around, produce reports, or simply ensure prompts are accessible in information maps.
Administration
SAS Management Console
You may use it to manage the system and restrict data access. You may use it to manage the system and restrict data access.
BI Clients Used by Information Technology
1. SAS Management Console
SAS Management Console is a platform that can be used to enable a number of plug-ins. A plug-in is an interface module that generates and preserves metadata for a particular resource class. The Server Manager plug-in, for instance, is used to identify SAS servers by creating and updating metadata. Additional features are included in some plug-ins. The Server Manager plug-in, for instance, allows you to interrupt, pause, and restart servers as well as track their operation.
Plug-ins can only be accessed and used by those people. Access to plug-ins is determined by the functions to which a user is assigned and the skills assigned to those roles. Initial Roles, Groups, and Users Overview. The Plug-ins tab appears in the left pane when you open SAS Management Console and connect to a metadata server and are allowed to use plug-ins, as seen in this example:
2. SAS Information Map Studio
SAS Information Maps are business-oriented metadata that define a data warehouse. This gives you the opportunity to surface data from a ubiquitous data warehouse to business users in the sense of how they operate. SAS Information Map Studio serves as a link between your data warehouse and the end-user creating reports from it.
The SAS Metadata Server is responsible for metadata management and protection, while the SAS Web Report Studio product allows users to generate reports. SAS Information Map Studio is a Java software for creating, editing, and handling SAS Information Maps. The framework is compatible with the various Windows operating systems such as Windows NT, Windows 2000, Windows XP.
3. SAS ETL Studio
SAS ETL Studio is a Java client for handling ETL processes. Several “ease-of-use” features are included in the interface such as:
Toolbars and pull-down menus are used extensively in SAS ETL Studio. The icons on the toolbar change depending on which interface window is active. The new process-driven functionality is one of SAS ETL Studio's most important features. A Shortcut bar on the far left side of the main SAS ETL Studio window provides access to processes. The SAS ETL Studio Tree View displays various views or "trees" of the current metadata repository and allows you to view the metadata associated with it.
The Process Designer window is where ETL processes are developed. In the Process Designer wizard, the Process Designer view appears as the last phase. The Process Designer view is filled with icons that reflect the chosen processes once the process has been identified. You may use the Process Designer window to:
The Overview window shows the entire process from the process view. From the Overview window, you can see which part of the process is visible in the Process View window.
4. SAS Web Report Studio
Anyone can display, communicate with, build, and distribute public and private reports using SAS Web Report Studio. Simply open an existing report and work with the data according to the specific requirements. A report, for example, maybe viewed, replied to, or comments added to. Report authors can conveniently query central data sets by pointing and clicking. Alternatively, you can use drag and drop to construct a well-formatted report by inserting prompts and creating the arrangement of tables, graphs, and text. Any of this is done by the use of a web browser. You are not supposed to understand any programming languages. Periodic updates may be programmed to run on a recurring basis, unattended, and then sent out by email.
The following are the prerequisites for SAS Web Report Studio:
BI Clients Used by Power Users
1. SAS Add-In for Microsoft Office
SAS is a Microsoft Office Component Object Model (COM) add-in. SAS data access, analysis, and tracking are all built directly into Microsoft Office software like Outlook, Excel, Word, and PowerPoint. To see how SAS affects these programs, go to the SAS tab or menu.
The SAS Add-In for Microsoft Office 4.3 and 4.305 is compatible with the applications mentioned below:
2. SAS OLAP Cube Studio
SAS OLAP Cube Studio is a GUI that allows cube designers to create SAS OLAP cubes quickly and easily. SAS OLAP cubes can be developed, edited, incrementally updated, aggregations tuned, and other changes made to existing cubes. The SAS OLAP Server: User's Guide describes how to use the various roles and functions of the SAS OLAP Server to build SAS OLAP cubes.
SAS OLAP Cube Studio provides a range of resources and functions for making, changing, and preserving OLAP cubes. The Cube Designer wizard, in particular, takes you through the cube-building process. You should define the data used to create the cube, its composition, and the measures and aggregations that would be used to process cube queries. You will see a quick display of your cube after you've designed it in the Cube Designer wizard and double-check your cube data and structure. You will see a quick display of your cube after you've designed it in the Cube Designer wizard and double-check your cube data and structure.
SAS OLAP Cube Studio also includes software for updating and handling cubes. You will make various improvements and modifications to a cube after it has been installed. After a cube has been formed, you can perform the following functions on it:
3. SAS Enterprise Guide
SAS Enterprise Guide is a client program for Microsoft Windows that allows you to use SAS in a directed way. SAS Enterprise Guide handles a set of relevant data, activities, code, and outcomes through projects. You may use projects to execute several tasks on the same set of data files and to generate dynamic or ad hoc reports.
SAS Enterprise Guide offers a wide range of report activities and reporting services that SAS IT Resource Management can use to produce analysis and knowledge about the IT capital. You can run the provided reports interactively using the provided IT Resource Management EG projects, or you can build your own.
The SAS Information Map Studio, SAS ETL Studio, and SAS Web Report Studio tools were also used by the Power users.
BI Clients Used by Information Consumers
SAS Information Delivery Portal
The SAS Information Delivery Portal is a web-based user interface that allows users to browse and access a large amount of data. Reports, maps, online apps, articles, and connections to internal and external websites are all part of this data. You should set up encryption so that users can only view the details they've been given permission to see.
Portlets are used in the portal to organize information about websites. Here's an example of a gateway with links to websites with industry or world news:
SAS Information Delivery Portal 4.4
The SAS Add-In for Microsoft Office and SAS Web Report Studio tools were also used by the information consumers.
SAS Display Manager
The Display Manager produces a range of windows, screens, and dialogue boxes to help SAS, the Operating System, and the user interact more effectively. Options for controlling the content, display, and level of interaction are available for each of the five primary windows, as well as the dozens of secondary windows. Options have defaults, but most of them can be modified to meet your needs.
The Display Manager can be fully customised. Many of the potential customizations are excessive, but there are a few that are extremely useful. Almost every option has a default value that can be altered. Customize the toolbars and drop-down menus. With the Enhanced Editor, you can run programs with a single keystroke and build shortcuts and editing tools. Most of these customizations are simple, and they only involve a little creativity in terms of what you'd like to change about your workplace.
SAS Enterprise Guide
SAS Enterprise Guide is a menu and wizard-driven tool that allows users to analyse data and publish their findings with a simple point-and-click interface. It enables rapid data audits, generates code for increased efficiency, and speeds up the deployment of evaluations and predictions.
It saves time and money by leveraging SAS investments already in place. With SAS Enterprise Guide, developers can easily build stored processes that can be executed on demand by management and ported to Microsoft Excel using programs they already have. SAS Enterprise Guide is suitable for statisticians, programmers, and analysts – even those with little SAS experience – due to the efficiencies obtained from a workflow environment.
Conclusion
Improved visualisation tools take into account improved versatility, allow us to explore greater volumes of data, and promise to assist companies in evaluating the past, comprehending the current, and forecasting the future in order to make smarter, more profitable decisions. Organizations often construct overviews of their key metrics and build dashboards to monitor their progress. SAS supports both conventional and big data environments throughout the analytics life cycle. SAS BI tools offer market analytics as well as the ability to build dashboards for reliable performance assessment.
Batch starts on 3rd Jun 2023, Weekend batch
Batch starts on 7th Jun 2023, Weekday batch
Batch starts on 11th Jun 2023, Weekend batch