尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
SAS
Statistical analysis system
SAS pronounced as Saas. Is a software suite
developed by sas institute for advance
analysis, Business Intelligence, predictive
analysis, data management which help
organization
to operate effectively in the competitive and
changing business conditions.
• In addition it helps in improving performance,
profitability and decisions.
• SAS provides a Enterprise software named,
SAS Intelligence Platform which consist of various
aspects i.e. Applications exist on Multiple
machines.
SAS Intelligence platform is a JAVA application.
SAS IP uses JDBC (JAVA DATA BASED
CONNECTION) technology from oracle
corporations.
SAS system
COMPONENTS OF THE SAS SYSTEM
REPORTING AND GRAPHICS.
ANALYTICS.
VISUALIZATION AND DISCOVERY.
DATA ACCESS AND MANAGEMENT.
BASE SAS. (Programming)
BUSINESS SOLUTIONS.
USER INTERFACES.
APPLICATION DEVELOPMENT.
WEB ENABLEMENT.
SAS_Architecture
• Client tier.
• Web tier.
• Server tier.
• Data tier.
• Client tier:-Client tier is where the application
is installed on a machine, where user sitting.
• Types of client application are:-
• Java application.
• Windows application.
• Web browser application.
• Web tier:- Web tier is where web application
resides and executes.
• Infrastructure that supports the execution of
the web browser application are:-
• Java application server.
• Java SDK(Software development Kit).
• Web DAV (Distributed Authoring &
Versioning)server
• Server Tier:-Server tier is one or more
machines where the SAS server are installed
and accessed by BI applications.
• The different types of server are:-
• Metadata server.
• Workspace server.
• Stored process server.
• OLAP server.
• Metadata server:- META data is a prefix in
information technology usually means
underlying definition or description.
• Meta data is data about data.
• Can be created manually or automated.
• Eg-size of a file , description of the file.
• Workspace server:- The SAS workspace server
is a single user server.
• There are two categories of server
configuration:-
• Default server configuration.
• Pooled server configuration.
• Stored processes server:-This server runs under a
single shared user identity and is a single process
shared by many clients.
• A stored processes is a SAS program that is stored on
a server and described by metadata.
• Stored processes can create new dataset, files and
reports output in a variety of formats.
Note:-I will try to explain SAS programs in next session of SAS
tutorials.
• OLAP server:- SAS OLAP server is a standard
complaint OLAP data source that retrieves
result for MDX queries.
• It quickly delivers summarized data to BI
application in a format that enables
processing , reporting and lowers the burden
on by simplifying adhoc reporting and data
summaries.
• Data tier:- The data tier contains the
enterprise data sources:-
• SAS data sets.
• RDBMS tables.
• OLAP cubes.
• SAS SPD server files.
• ERP data structures.
Desktop applications.
• SAS Intelligence platform consist of Applications-
• 1.SAS INFORMATION MAP STUDIO. (IMPS)
• 2.SAS OLAP CUBE STUDIO.(OLAP)
• 3.SAS DATA INTEGRATION STUDIO. (ETL)
• 4.SAS ADD_IN_FOR_MICROSOFT.
• 5.SAS ENTERPRISE GUIDE. (EG)
WEB Based Applications.
• 6.SAS WEB REPORT STUDIO. (WRS)
• 7.SAS INFORMATION DELIVERY PORTAL. (IDP)
• 8.SAS BI DASHBOARD.
• 9.SAS OLAP viewer for java.
Desktop based applications.
• INFORMATION MAP STUDIO:-
‘”Information Map studio is used to build
information Maps, which shield for business
users for the complexities of underlying data
by organizing and referencing data in business
terms”.
Note-Person who deals with business data are
called business users.
• OLAP CUBE STUDIO:- SAS OLAP cube studio
is used to create OLAP cubes.
• Cubes contains the data organized and
summarized into multidimensional structure.
• Cubes are created on Detailed table(Original
table) or star schema.
• Cube consist of Dimension, Level, Hierarchy.
• MDX expressions are used to query against a
Cube.
• SAS DATA INTEGREATION:- SAS DI is used in
ETL(Extract,Transform,load) process.
• SAS add_in_ for_Microsoft office:-Provides
you the ability to hardness the power of SAS
analytics and access SAS data sources.
• We use add_ins for adhoc reporting { creating
for particular purpose only} to execute stored
processes dynamically and embed the results
in your documents , spreadsheets and
slideshows.
• In general we do is,
• Access and view SAS data sources.
• Access and view any other data sources that is
available from your SAS server.
• Analyze SAS or Excel data using analytic tasks.
• Note:- Business users are very familiar with MS
office as a BI application , so its important and
user friendly in use.
• SAS ENTERPRISE GUIDE:- Enterprise guide is a querying and
reporting tool which is also used for conversion of source
data into SAS data files.
-Provides.
• An intuitive(easy to understand), visual interface.
• Access the power of SAS.
• Transparent access to data.
• Ready to use task for analysis and reporting.
• Easy exporting of data and results to other applications.
• Scripting and automation.
• Note:-SAS programming ,is a sequence of steps that the user
submits for execution. i.e.PROC step and DATA step.
Web based application
• Web Report studio (WRS):- WRS is a reporting
application, designed for business users to view,
author and share reports on Web.
• WRS is similar to Desktop application. viz.
Enterprise Guide.
• Note:- there is no need to install Web
applications, its zero download software. You just
need to check the services are running and
initialize the requried services.
Eg.Tomcat,Sas services.
• Information Delivery Portal :- (IDP) Enables
you to view and organize content on portal.
• Which are the pages and portlets surface all
types of information, including SAS
Information Maps, SAS WRS,SAS stored
processes.
• Portlet is a rectangular display components of
the portal in which content and links to
content are displayed.
• SAS BI Dashboard:-BI dashboard is used for
creating , maintaining and viewing dashboard.
• Is surfaced as portlet in the SAS IDP.
• SAS BI dashboard is an application that
represents the latest evolution of Dashboarding
using SAS. It enables the rapid creation and
deployment of dashboards that display data from
a wide variety of data sources and system.
• Dashboards is a way to represent numbers in
easily consumable , graphical form to display key
metrics within an organization.
• SAS OLAP viewer for java:- used for viewing
SAS OLAP cubes. Provides an easy-to-use
interface from which you can select a data
source , view the data , and customize your
view.
Thank you for watching

More Related Content

What's hot

Application of spss usha (1)
Application of spss usha (1)Application of spss usha (1)
Application of spss usha (1)
Rajat Kumar Pandeya
 
Spss
SpssSpss
Data, Distribution Introduction and Types - Biostatistics - Ravinandan A P.pdf
Data, Distribution  Introduction and Types - Biostatistics - Ravinandan A P.pdfData, Distribution  Introduction and Types - Biostatistics - Ravinandan A P.pdf
Data, Distribution Introduction and Types - Biostatistics - Ravinandan A P.pdf
Ravinandan A P
 
Statistical software
Statistical softwareStatistical software
Statistical software
Subramani Parasuraman
 
Introduction to SAS
Introduction to SASIntroduction to SAS
Introduction to SAS
izahn
 
SAS BASICS
SAS BASICSSAS BASICS
SAS BASICS
Bhuwanesh Rawat
 
SAS Programming For Beginners | SAS Programming Tutorial | SAS Tutorial | SAS...
SAS Programming For Beginners | SAS Programming Tutorial | SAS Tutorial | SAS...SAS Programming For Beginners | SAS Programming Tutorial | SAS Tutorial | SAS...
SAS Programming For Beginners | SAS Programming Tutorial | SAS Tutorial | SAS...
Edureka!
 
Introduction to R
Introduction to RIntroduction to R
Introduction to R
Ajay Ohri
 
SPSS software
SPSS software SPSS software
SPSS software
VinodBaithaVinodSir
 
Statistical Package for Social Science (SPSS)
Statistical Package for Social Science (SPSS)Statistical Package for Social Science (SPSS)
Statistical Package for Social Science (SPSS)
sspink
 
Introduction to clinical sas programming
Introduction to clinical sas programmingIntroduction to clinical sas programming
Introduction to clinical sas programming
ray4hz
 
SAS basics Step by step learning
SAS basics Step by step learningSAS basics Step by step learning
SAS basics Step by step learning
Venkata Reddy Konasani
 
Application of SPSS by umakant bhaskar gohatre
Application of SPSS by umakant bhaskar gohatre Application of SPSS by umakant bhaskar gohatre
Application of SPSS by umakant bhaskar gohatre
Smt. Indira Gandhi College of Engineering, Navi Mumbai, Mumbai
 
Basics Of SAS Programming Language
Basics Of SAS Programming LanguageBasics Of SAS Programming Language
Basics Of SAS Programming Language
guest2160992
 
SPSS.pptx
SPSS.pptxSPSS.pptx
Application of excel and spss programme in statistical
Application of excel and spss programme in statisticalApplication of excel and spss programme in statistical
Application of excel and spss programme in statistical
VeenaV29
 
Sas
SasSas
Basics of SAS
Basics of SASBasics of SAS
Basics of SAS
Taddesse Kassahun
 
Simple & Multiple Regression Analysis
Simple & Multiple Regression AnalysisSimple & Multiple Regression Analysis
Simple & Multiple Regression Analysis
Shailendra Tomar
 
Graphs(Biostatistics and Research Methodology) B.pharmacy(8th sem.)
Graphs(Biostatistics and Research Methodology) B.pharmacy(8th sem.)Graphs(Biostatistics and Research Methodology) B.pharmacy(8th sem.)
Graphs(Biostatistics and Research Methodology) B.pharmacy(8th sem.)
Pranjal Saxena
 

What's hot (20)

Application of spss usha (1)
Application of spss usha (1)Application of spss usha (1)
Application of spss usha (1)
 
Spss
SpssSpss
Spss
 
Data, Distribution Introduction and Types - Biostatistics - Ravinandan A P.pdf
Data, Distribution  Introduction and Types - Biostatistics - Ravinandan A P.pdfData, Distribution  Introduction and Types - Biostatistics - Ravinandan A P.pdf
Data, Distribution Introduction and Types - Biostatistics - Ravinandan A P.pdf
 
Statistical software
Statistical softwareStatistical software
Statistical software
 
Introduction to SAS
Introduction to SASIntroduction to SAS
Introduction to SAS
 
SAS BASICS
SAS BASICSSAS BASICS
SAS BASICS
 
SAS Programming For Beginners | SAS Programming Tutorial | SAS Tutorial | SAS...
SAS Programming For Beginners | SAS Programming Tutorial | SAS Tutorial | SAS...SAS Programming For Beginners | SAS Programming Tutorial | SAS Tutorial | SAS...
SAS Programming For Beginners | SAS Programming Tutorial | SAS Tutorial | SAS...
 
Introduction to R
Introduction to RIntroduction to R
Introduction to R
 
SPSS software
SPSS software SPSS software
SPSS software
 
Statistical Package for Social Science (SPSS)
Statistical Package for Social Science (SPSS)Statistical Package for Social Science (SPSS)
Statistical Package for Social Science (SPSS)
 
Introduction to clinical sas programming
Introduction to clinical sas programmingIntroduction to clinical sas programming
Introduction to clinical sas programming
 
SAS basics Step by step learning
SAS basics Step by step learningSAS basics Step by step learning
SAS basics Step by step learning
 
Application of SPSS by umakant bhaskar gohatre
Application of SPSS by umakant bhaskar gohatre Application of SPSS by umakant bhaskar gohatre
Application of SPSS by umakant bhaskar gohatre
 
Basics Of SAS Programming Language
Basics Of SAS Programming LanguageBasics Of SAS Programming Language
Basics Of SAS Programming Language
 
SPSS.pptx
SPSS.pptxSPSS.pptx
SPSS.pptx
 
Application of excel and spss programme in statistical
Application of excel and spss programme in statisticalApplication of excel and spss programme in statistical
Application of excel and spss programme in statistical
 
Sas
SasSas
Sas
 
Basics of SAS
Basics of SASBasics of SAS
Basics of SAS
 
Simple & Multiple Regression Analysis
Simple & Multiple Regression AnalysisSimple & Multiple Regression Analysis
Simple & Multiple Regression Analysis
 
Graphs(Biostatistics and Research Methodology) B.pharmacy(8th sem.)
Graphs(Biostatistics and Research Methodology) B.pharmacy(8th sem.)Graphs(Biostatistics and Research Methodology) B.pharmacy(8th sem.)
Graphs(Biostatistics and Research Methodology) B.pharmacy(8th sem.)
 

Viewers also liked

Spss lecture notes
Spss lecture notesSpss lecture notes
Spss lecture notes
David mbwiga
 
Advance SAS certificate
Advance SAS certificateAdvance SAS certificate
Advance SAS certificate
Pala Sravan
 
Currency Vol
Currency VolCurrency Vol
Currency Vol
pkguess34
 
Civil services
Civil servicesCivil services
Civil services
Srinivas Ssv
 
Hyrje ne matlab
Hyrje ne matlabHyrje ne matlab
Hyrje ne matlab
Fatjon Dashhana
 
15 New Technologies in 50 Minutes
15 New Technologies in 50 Minutes15 New Technologies in 50 Minutes
15 New Technologies in 50 Minutes
askacpl
 
online room booking system
online room booking systemonline room booking system
online room booking system
manuchinna
 
Bazat themelore te programit Matlab
Bazat themelore te programit MatlabBazat themelore te programit Matlab
Bazat themelore te programit Matlab
Besart Vllasa
 
Presentation on spss
Presentation on spssPresentation on spss
Presentation on spss
alfiyajamalcj
 
Base sas interview questions
Base sas interview questionsBase sas interview questions
Base sas interview questions
Dr P Deepak
 
SAS Presentation
SAS PresentationSAS Presentation
SAS Presentation
Kali Howard
 
Arrays Data Structure
Arrays Data StructureArrays Data Structure
Arrays Data Structure
student
 
Understanding SAS Data Step Processing
Understanding SAS Data Step ProcessingUnderstanding SAS Data Step Processing
Understanding SAS Data Step Processing
guest2160992
 
Class ppt intro to r
Class ppt intro to rClass ppt intro to r
Class ppt intro to r
JigsawAcademy2014
 
R programming
R programmingR programming
R programming
Shantanu Patil
 
Base SAS Exam Questions
Base SAS Exam QuestionsBase SAS Exam Questions
Base SAS Exam Questions
guestc45097
 
Introduction To SPSS
Introduction To SPSSIntroduction To SPSS
Introduction To SPSS
Phi Jack
 
Clinical data management
Clinical data managementClinical data management
Clinical data management
Upendra Agarwal
 
Clinical Data Management
Clinical Data ManagementClinical Data Management
Clinical Data Management
Shray Jali
 
Spss
SpssSpss
Spss
Tech_MX
 

Viewers also liked (20)

Spss lecture notes
Spss lecture notesSpss lecture notes
Spss lecture notes
 
Advance SAS certificate
Advance SAS certificateAdvance SAS certificate
Advance SAS certificate
 
Currency Vol
Currency VolCurrency Vol
Currency Vol
 
Civil services
Civil servicesCivil services
Civil services
 
Hyrje ne matlab
Hyrje ne matlabHyrje ne matlab
Hyrje ne matlab
 
15 New Technologies in 50 Minutes
15 New Technologies in 50 Minutes15 New Technologies in 50 Minutes
15 New Technologies in 50 Minutes
 
online room booking system
online room booking systemonline room booking system
online room booking system
 
Bazat themelore te programit Matlab
Bazat themelore te programit MatlabBazat themelore te programit Matlab
Bazat themelore te programit Matlab
 
Presentation on spss
Presentation on spssPresentation on spss
Presentation on spss
 
Base sas interview questions
Base sas interview questionsBase sas interview questions
Base sas interview questions
 
SAS Presentation
SAS PresentationSAS Presentation
SAS Presentation
 
Arrays Data Structure
Arrays Data StructureArrays Data Structure
Arrays Data Structure
 
Understanding SAS Data Step Processing
Understanding SAS Data Step ProcessingUnderstanding SAS Data Step Processing
Understanding SAS Data Step Processing
 
Class ppt intro to r
Class ppt intro to rClass ppt intro to r
Class ppt intro to r
 
R programming
R programmingR programming
R programming
 
Base SAS Exam Questions
Base SAS Exam QuestionsBase SAS Exam Questions
Base SAS Exam Questions
 
Introduction To SPSS
Introduction To SPSSIntroduction To SPSS
Introduction To SPSS
 
Clinical data management
Clinical data managementClinical data management
Clinical data management
 
Clinical Data Management
Clinical Data ManagementClinical Data Management
Clinical Data Management
 
Spss
SpssSpss
Spss
 

Similar to Sas Statistical Analysis System

resume
resumeresume
Presentation 1 - SSRS (1)
Presentation 1 - SSRS (1)Presentation 1 - SSRS (1)
Presentation 1 - SSRS (1)
Anurag Rana
 
UNC Chapel Hill Ctc Retreat 2014 SAS Visual Analytics and Business Intelligence
UNC Chapel Hill Ctc Retreat 2014 SAS Visual Analytics and Business IntelligenceUNC Chapel Hill Ctc Retreat 2014 SAS Visual Analytics and Business Intelligence
UNC Chapel Hill Ctc Retreat 2014 SAS Visual Analytics and Business Intelligence
Jonathan Pletzke
 
Microsoft Dynamics Ax 2012 extended architecture
Microsoft Dynamics Ax 2012 extended architectureMicrosoft Dynamics Ax 2012 extended architecture
Microsoft Dynamics Ax 2012 extended architecture
Johnkrish S
 
Building and Deploying Large Scale SSRS using Lessons Learned from Customer D...
Building and Deploying Large Scale SSRS using Lessons Learned from Customer D...Building and Deploying Large Scale SSRS using Lessons Learned from Customer D...
Building and Deploying Large Scale SSRS using Lessons Learned from Customer D...
Denny Lee
 
SAP BW BI BO Pereyaslov jun17_short
SAP BW BI BO Pereyaslov jun17_shortSAP BW BI BO Pereyaslov jun17_short
SAP BW BI BO Pereyaslov jun17_short
Stanislav Pereyaslov
 
Sas base programmer
Sas base programmerSas base programmer
Sas base programmer
Aspire Techsoft Academy
 
Hyperion essbase overview
Hyperion essbase overviewHyperion essbase overview
Hyperion essbase overview
Vishal Mahajan
 
SAP Hana Overview
SAP Hana OverviewSAP Hana Overview
SAP Hana Overview
Tomislav Milinović
 
SAP
SAPSAP
aparna_sas
aparna_sasaparna_sas
aparna_sas
Aparna Mishra
 
Enterprise Use Case Webinar - PaaS Metering and Monitoring
Enterprise Use Case Webinar - PaaS Metering and Monitoring Enterprise Use Case Webinar - PaaS Metering and Monitoring
Enterprise Use Case Webinar - PaaS Metering and Monitoring
WSO2
 
Azure Data Factory for Azure Data Week
Azure Data Factory for Azure Data WeekAzure Data Factory for Azure Data Week
Azure Data Factory for Azure Data Week
Mark Kromer
 
sap-bi.ppt
sap-bi.pptsap-bi.ppt
sap-bi.ppt
VasisterArun1
 
sap-bi-overview.ppt
sap-bi-overview.pptsap-bi-overview.ppt
sap-bi-overview.ppt
Hari Somanath
 
Oow2016 review--paas-microservices-
Oow2016 review--paas-microservices-Oow2016 review--paas-microservices-
Oow2016 review--paas-microservices-
Getting value from IoT, Integration and Data Analytics
 
Professional Portfolio
Professional PortfolioProfessional Portfolio
Professional Portfolio
MoniqueO Opris
 
Top 140+ Advanced SAS Interview Questions and Answers.pdf
Top 140+ Advanced SAS Interview Questions and Answers.pdfTop 140+ Advanced SAS Interview Questions and Answers.pdf
Top 140+ Advanced SAS Interview Questions and Answers.pdf
Datacademy.ai
 
Ra framework 0.1
Ra framework 0.1Ra framework 0.1
Ra framework 0.1
bibhudattatripathy
 
SAP performance testing & engineering courseware v01
SAP performance testing & engineering courseware v01SAP performance testing & engineering courseware v01
SAP performance testing & engineering courseware v01
Argos
 

Similar to Sas Statistical Analysis System (20)

resume
resumeresume
resume
 
Presentation 1 - SSRS (1)
Presentation 1 - SSRS (1)Presentation 1 - SSRS (1)
Presentation 1 - SSRS (1)
 
UNC Chapel Hill Ctc Retreat 2014 SAS Visual Analytics and Business Intelligence
UNC Chapel Hill Ctc Retreat 2014 SAS Visual Analytics and Business IntelligenceUNC Chapel Hill Ctc Retreat 2014 SAS Visual Analytics and Business Intelligence
UNC Chapel Hill Ctc Retreat 2014 SAS Visual Analytics and Business Intelligence
 
Microsoft Dynamics Ax 2012 extended architecture
Microsoft Dynamics Ax 2012 extended architectureMicrosoft Dynamics Ax 2012 extended architecture
Microsoft Dynamics Ax 2012 extended architecture
 
Building and Deploying Large Scale SSRS using Lessons Learned from Customer D...
Building and Deploying Large Scale SSRS using Lessons Learned from Customer D...Building and Deploying Large Scale SSRS using Lessons Learned from Customer D...
Building and Deploying Large Scale SSRS using Lessons Learned from Customer D...
 
SAP BW BI BO Pereyaslov jun17_short
SAP BW BI BO Pereyaslov jun17_shortSAP BW BI BO Pereyaslov jun17_short
SAP BW BI BO Pereyaslov jun17_short
 
Sas base programmer
Sas base programmerSas base programmer
Sas base programmer
 
Hyperion essbase overview
Hyperion essbase overviewHyperion essbase overview
Hyperion essbase overview
 
SAP Hana Overview
SAP Hana OverviewSAP Hana Overview
SAP Hana Overview
 
SAP
SAPSAP
SAP
 
aparna_sas
aparna_sasaparna_sas
aparna_sas
 
Enterprise Use Case Webinar - PaaS Metering and Monitoring
Enterprise Use Case Webinar - PaaS Metering and Monitoring Enterprise Use Case Webinar - PaaS Metering and Monitoring
Enterprise Use Case Webinar - PaaS Metering and Monitoring
 
Azure Data Factory for Azure Data Week
Azure Data Factory for Azure Data WeekAzure Data Factory for Azure Data Week
Azure Data Factory for Azure Data Week
 
sap-bi.ppt
sap-bi.pptsap-bi.ppt
sap-bi.ppt
 
sap-bi-overview.ppt
sap-bi-overview.pptsap-bi-overview.ppt
sap-bi-overview.ppt
 
Oow2016 review--paas-microservices-
Oow2016 review--paas-microservices-Oow2016 review--paas-microservices-
Oow2016 review--paas-microservices-
 
Professional Portfolio
Professional PortfolioProfessional Portfolio
Professional Portfolio
 
Top 140+ Advanced SAS Interview Questions and Answers.pdf
Top 140+ Advanced SAS Interview Questions and Answers.pdfTop 140+ Advanced SAS Interview Questions and Answers.pdf
Top 140+ Advanced SAS Interview Questions and Answers.pdf
 
Ra framework 0.1
Ra framework 0.1Ra framework 0.1
Ra framework 0.1
 
SAP performance testing & engineering courseware v01
SAP performance testing & engineering courseware v01SAP performance testing & engineering courseware v01
SAP performance testing & engineering courseware v01
 

More from Sushil kasar

Microsoft Power BI
Microsoft Power BIMicrosoft Power BI
Microsoft Power BI
Sushil kasar
 
ITIL- Service operations- Incident management
ITIL- Service operations- Incident management ITIL- Service operations- Incident management
ITIL- Service operations- Incident management
Sushil kasar
 
Data visualization
Data visualizationData visualization
Data visualization
Sushil kasar
 
Datawarehousing_Project_using_MS SQL server.
Datawarehousing_Project_using_MS SQL server.Datawarehousing_Project_using_MS SQL server.
Datawarehousing_Project_using_MS SQL server.
Sushil kasar
 
Android
Android Android
Android
Sushil kasar
 
Financial statements.
Financial statements.Financial statements.
Financial statements.
Sushil kasar
 
WEB MINING.
WEB MINING.WEB MINING.
WEB MINING.
Sushil kasar
 

More from Sushil kasar (7)

Microsoft Power BI
Microsoft Power BIMicrosoft Power BI
Microsoft Power BI
 
ITIL- Service operations- Incident management
ITIL- Service operations- Incident management ITIL- Service operations- Incident management
ITIL- Service operations- Incident management
 
Data visualization
Data visualizationData visualization
Data visualization
 
Datawarehousing_Project_using_MS SQL server.
Datawarehousing_Project_using_MS SQL server.Datawarehousing_Project_using_MS SQL server.
Datawarehousing_Project_using_MS SQL server.
 
Android
Android Android
Android
 
Financial statements.
Financial statements.Financial statements.
Financial statements.
 
WEB MINING.
WEB MINING.WEB MINING.
WEB MINING.
 

Recently uploaded

Bangalore Call Girls ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
Bangalore Call Girls  ♠ 9079923931 ♠ Beautiful Call Girls In BangaloreBangalore Call Girls  ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
Bangalore Call Girls ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
yashusingh54876
 
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
jasodak99
 
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
hanshkumar9870
 
🔥College Call Girls Kolkata 💯Call Us 🔝 8094342248 🔝💃Top Class Call Girl Servi...
🔥College Call Girls Kolkata 💯Call Us 🔝 8094342248 🔝💃Top Class Call Girl Servi...🔥College Call Girls Kolkata 💯Call Us 🔝 8094342248 🔝💃Top Class Call Girl Servi...
🔥College Call Girls Kolkata 💯Call Us 🔝 8094342248 🔝💃Top Class Call Girl Servi...
rukmnaikaseen
 
machine learning notes by Andrew Ng and Tengyu Ma
machine learning notes by Andrew Ng and Tengyu Mamachine learning notes by Andrew Ng and Tengyu Ma
machine learning notes by Andrew Ng and Tengyu Ma
Vijayabaskar Uthirapathy
 
IBM watsonx.data - Seller Enablement Deck.PPTX
IBM watsonx.data - Seller Enablement Deck.PPTXIBM watsonx.data - Seller Enablement Deck.PPTX
IBM watsonx.data - Seller Enablement Deck.PPTX
EbtsamRashed
 
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
9gr6pty
 
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
Call Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call GirlCall Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call Girl
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
sapna sharmap11
 
_Lufthansa Airlines MIA Terminal (1).pdf
_Lufthansa Airlines MIA Terminal (1).pdf_Lufthansa Airlines MIA Terminal (1).pdf
_Lufthansa Airlines MIA Terminal (1).pdf
rc76967005
 
一比一原版(heriotwatt学位证书)英国赫瑞瓦特大学毕业证如何办理
一比一原版(heriotwatt学位证书)英国赫瑞瓦特大学毕业证如何办理一比一原版(heriotwatt学位证书)英国赫瑞瓦特大学毕业证如何办理
一比一原版(heriotwatt学位证书)英国赫瑞瓦特大学毕业证如何办理
zoykygu
 
Call Girls In Tirunelveli 👯‍♀️ 7339748667 🔥 Safe Housewife Call Girl Service ...
Call Girls In Tirunelveli 👯‍♀️ 7339748667 🔥 Safe Housewife Call Girl Service ...Call Girls In Tirunelveli 👯‍♀️ 7339748667 🔥 Safe Housewife Call Girl Service ...
Call Girls In Tirunelveli 👯‍♀️ 7339748667 🔥 Safe Housewife Call Girl Service ...
wwefun9823#S0007
 
Fabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
Fabric Engineering Deep Dive Keynote from Fabric Engineering RoadshowFabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
Fabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
Gabi Münster
 
Health care analysis using sentimental analysis
Health care analysis using sentimental analysisHealth care analysis using sentimental analysis
Health care analysis using sentimental analysis
krishnasrigannavarap
 
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
mona lisa $A12
 
SAP BW4HANA Implementagtion Content Document
SAP BW4HANA Implementagtion Content DocumentSAP BW4HANA Implementagtion Content Document
SAP BW4HANA Implementagtion Content Document
newdirectionconsulta
 
saps4hanaandsapanalyticswheretodowhat1565272000538.pdf
saps4hanaandsapanalyticswheretodowhat1565272000538.pdfsaps4hanaandsapanalyticswheretodowhat1565272000538.pdf
saps4hanaandsapanalyticswheretodowhat1565272000538.pdf
newdirectionconsulta
 
AI WITH THE HELP OF NAGALAND CAN WIN. DOWNLOAD NOW
AI WITH THE HELP OF NAGALAND CAN WIN. DOWNLOAD NOWAI WITH THE HELP OF NAGALAND CAN WIN. DOWNLOAD NOW
AI WITH THE HELP OF NAGALAND CAN WIN. DOWNLOAD NOW
arash10gamer
 
❻❸❼⓿❽❻❷⓿⓿❼KALYAN MATKA CHART FINAL OPEN JODI PANNA FIXXX DPBOSS MATKA RESULT ...
❻❸❼⓿❽❻❷⓿⓿❼KALYAN MATKA CHART FINAL OPEN JODI PANNA FIXXX DPBOSS MATKA RESULT ...❻❸❼⓿❽❻❷⓿⓿❼KALYAN MATKA CHART FINAL OPEN JODI PANNA FIXXX DPBOSS MATKA RESULT ...
❻❸❼⓿❽❻❷⓿⓿❼KALYAN MATKA CHART FINAL OPEN JODI PANNA FIXXX DPBOSS MATKA RESULT ...
#kalyanmatkaresult #dpboss #kalyanmatka #satta #matka #sattamatka
 
Hyderabad Call Girls Service 🔥 9352988975 🔥 High Profile Call Girls Hyderabad
Hyderabad Call Girls Service 🔥 9352988975 🔥 High Profile Call Girls HyderabadHyderabad Call Girls Service 🔥 9352988975 🔥 High Profile Call Girls Hyderabad
Hyderabad Call Girls Service 🔥 9352988975 🔥 High Profile Call Girls Hyderabad
2004kavitajoshi
 
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts ServicePune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
vashimk775
 

Recently uploaded (20)

Bangalore Call Girls ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
Bangalore Call Girls  ♠ 9079923931 ♠ Beautiful Call Girls In BangaloreBangalore Call Girls  ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
Bangalore Call Girls ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
 
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
 
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
 
🔥College Call Girls Kolkata 💯Call Us 🔝 8094342248 🔝💃Top Class Call Girl Servi...
🔥College Call Girls Kolkata 💯Call Us 🔝 8094342248 🔝💃Top Class Call Girl Servi...🔥College Call Girls Kolkata 💯Call Us 🔝 8094342248 🔝💃Top Class Call Girl Servi...
🔥College Call Girls Kolkata 💯Call Us 🔝 8094342248 🔝💃Top Class Call Girl Servi...
 
machine learning notes by Andrew Ng and Tengyu Ma
machine learning notes by Andrew Ng and Tengyu Mamachine learning notes by Andrew Ng and Tengyu Ma
machine learning notes by Andrew Ng and Tengyu Ma
 
IBM watsonx.data - Seller Enablement Deck.PPTX
IBM watsonx.data - Seller Enablement Deck.PPTXIBM watsonx.data - Seller Enablement Deck.PPTX
IBM watsonx.data - Seller Enablement Deck.PPTX
 
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
 
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
Call Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call GirlCall Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call Girl
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
 
_Lufthansa Airlines MIA Terminal (1).pdf
_Lufthansa Airlines MIA Terminal (1).pdf_Lufthansa Airlines MIA Terminal (1).pdf
_Lufthansa Airlines MIA Terminal (1).pdf
 
一比一原版(heriotwatt学位证书)英国赫瑞瓦特大学毕业证如何办理
一比一原版(heriotwatt学位证书)英国赫瑞瓦特大学毕业证如何办理一比一原版(heriotwatt学位证书)英国赫瑞瓦特大学毕业证如何办理
一比一原版(heriotwatt学位证书)英国赫瑞瓦特大学毕业证如何办理
 
Call Girls In Tirunelveli 👯‍♀️ 7339748667 🔥 Safe Housewife Call Girl Service ...
Call Girls In Tirunelveli 👯‍♀️ 7339748667 🔥 Safe Housewife Call Girl Service ...Call Girls In Tirunelveli 👯‍♀️ 7339748667 🔥 Safe Housewife Call Girl Service ...
Call Girls In Tirunelveli 👯‍♀️ 7339748667 🔥 Safe Housewife Call Girl Service ...
 
Fabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
Fabric Engineering Deep Dive Keynote from Fabric Engineering RoadshowFabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
Fabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
 
Health care analysis using sentimental analysis
Health care analysis using sentimental analysisHealth care analysis using sentimental analysis
Health care analysis using sentimental analysis
 
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
 
SAP BW4HANA Implementagtion Content Document
SAP BW4HANA Implementagtion Content DocumentSAP BW4HANA Implementagtion Content Document
SAP BW4HANA Implementagtion Content Document
 
saps4hanaandsapanalyticswheretodowhat1565272000538.pdf
saps4hanaandsapanalyticswheretodowhat1565272000538.pdfsaps4hanaandsapanalyticswheretodowhat1565272000538.pdf
saps4hanaandsapanalyticswheretodowhat1565272000538.pdf
 
AI WITH THE HELP OF NAGALAND CAN WIN. DOWNLOAD NOW
AI WITH THE HELP OF NAGALAND CAN WIN. DOWNLOAD NOWAI WITH THE HELP OF NAGALAND CAN WIN. DOWNLOAD NOW
AI WITH THE HELP OF NAGALAND CAN WIN. DOWNLOAD NOW
 
❻❸❼⓿❽❻❷⓿⓿❼KALYAN MATKA CHART FINAL OPEN JODI PANNA FIXXX DPBOSS MATKA RESULT ...
❻❸❼⓿❽❻❷⓿⓿❼KALYAN MATKA CHART FINAL OPEN JODI PANNA FIXXX DPBOSS MATKA RESULT ...❻❸❼⓿❽❻❷⓿⓿❼KALYAN MATKA CHART FINAL OPEN JODI PANNA FIXXX DPBOSS MATKA RESULT ...
❻❸❼⓿❽❻❷⓿⓿❼KALYAN MATKA CHART FINAL OPEN JODI PANNA FIXXX DPBOSS MATKA RESULT ...
 
Hyderabad Call Girls Service 🔥 9352988975 🔥 High Profile Call Girls Hyderabad
Hyderabad Call Girls Service 🔥 9352988975 🔥 High Profile Call Girls HyderabadHyderabad Call Girls Service 🔥 9352988975 🔥 High Profile Call Girls Hyderabad
Hyderabad Call Girls Service 🔥 9352988975 🔥 High Profile Call Girls Hyderabad
 
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts ServicePune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
 

Sas Statistical Analysis System

  • 1. SAS Statistical analysis system SAS pronounced as Saas. Is a software suite developed by sas institute for advance analysis, Business Intelligence, predictive analysis, data management which help organization to operate effectively in the competitive and changing business conditions.
  • 2. • In addition it helps in improving performance, profitability and decisions. • SAS provides a Enterprise software named, SAS Intelligence Platform which consist of various aspects i.e. Applications exist on Multiple machines. SAS Intelligence platform is a JAVA application. SAS IP uses JDBC (JAVA DATA BASED CONNECTION) technology from oracle corporations.
  • 3. SAS system COMPONENTS OF THE SAS SYSTEM REPORTING AND GRAPHICS. ANALYTICS. VISUALIZATION AND DISCOVERY. DATA ACCESS AND MANAGEMENT. BASE SAS. (Programming) BUSINESS SOLUTIONS. USER INTERFACES. APPLICATION DEVELOPMENT. WEB ENABLEMENT.
  • 4. SAS_Architecture • Client tier. • Web tier. • Server tier. • Data tier.
  • 5. • Client tier:-Client tier is where the application is installed on a machine, where user sitting. • Types of client application are:- • Java application. • Windows application. • Web browser application.
  • 6. • Web tier:- Web tier is where web application resides and executes. • Infrastructure that supports the execution of the web browser application are:- • Java application server. • Java SDK(Software development Kit). • Web DAV (Distributed Authoring & Versioning)server
  • 7. • Server Tier:-Server tier is one or more machines where the SAS server are installed and accessed by BI applications. • The different types of server are:- • Metadata server. • Workspace server. • Stored process server. • OLAP server.
  • 8. • Metadata server:- META data is a prefix in information technology usually means underlying definition or description. • Meta data is data about data. • Can be created manually or automated. • Eg-size of a file , description of the file.
  • 9. • Workspace server:- The SAS workspace server is a single user server. • There are two categories of server configuration:- • Default server configuration. • Pooled server configuration.
  • 10. • Stored processes server:-This server runs under a single shared user identity and is a single process shared by many clients. • A stored processes is a SAS program that is stored on a server and described by metadata. • Stored processes can create new dataset, files and reports output in a variety of formats. Note:-I will try to explain SAS programs in next session of SAS tutorials.
  • 11. • OLAP server:- SAS OLAP server is a standard complaint OLAP data source that retrieves result for MDX queries. • It quickly delivers summarized data to BI application in a format that enables processing , reporting and lowers the burden on by simplifying adhoc reporting and data summaries.
  • 12. • Data tier:- The data tier contains the enterprise data sources:- • SAS data sets. • RDBMS tables. • OLAP cubes. • SAS SPD server files. • ERP data structures.
  • 13. Desktop applications. • SAS Intelligence platform consist of Applications- • 1.SAS INFORMATION MAP STUDIO. (IMPS) • 2.SAS OLAP CUBE STUDIO.(OLAP) • 3.SAS DATA INTEGRATION STUDIO. (ETL) • 4.SAS ADD_IN_FOR_MICROSOFT. • 5.SAS ENTERPRISE GUIDE. (EG)
  • 14. WEB Based Applications. • 6.SAS WEB REPORT STUDIO. (WRS) • 7.SAS INFORMATION DELIVERY PORTAL. (IDP) • 8.SAS BI DASHBOARD. • 9.SAS OLAP viewer for java.
  • 15. Desktop based applications. • INFORMATION MAP STUDIO:- ‘”Information Map studio is used to build information Maps, which shield for business users for the complexities of underlying data by organizing and referencing data in business terms”. Note-Person who deals with business data are called business users.
  • 16. • OLAP CUBE STUDIO:- SAS OLAP cube studio is used to create OLAP cubes. • Cubes contains the data organized and summarized into multidimensional structure. • Cubes are created on Detailed table(Original table) or star schema. • Cube consist of Dimension, Level, Hierarchy. • MDX expressions are used to query against a Cube.
  • 17. • SAS DATA INTEGREATION:- SAS DI is used in ETL(Extract,Transform,load) process.
  • 18. • SAS add_in_ for_Microsoft office:-Provides you the ability to hardness the power of SAS analytics and access SAS data sources. • We use add_ins for adhoc reporting { creating for particular purpose only} to execute stored processes dynamically and embed the results in your documents , spreadsheets and slideshows.
  • 19. • In general we do is, • Access and view SAS data sources. • Access and view any other data sources that is available from your SAS server. • Analyze SAS or Excel data using analytic tasks. • Note:- Business users are very familiar with MS office as a BI application , so its important and user friendly in use.
  • 20. • SAS ENTERPRISE GUIDE:- Enterprise guide is a querying and reporting tool which is also used for conversion of source data into SAS data files. -Provides. • An intuitive(easy to understand), visual interface. • Access the power of SAS. • Transparent access to data. • Ready to use task for analysis and reporting. • Easy exporting of data and results to other applications. • Scripting and automation. • Note:-SAS programming ,is a sequence of steps that the user submits for execution. i.e.PROC step and DATA step.
  • 21. Web based application • Web Report studio (WRS):- WRS is a reporting application, designed for business users to view, author and share reports on Web. • WRS is similar to Desktop application. viz. Enterprise Guide. • Note:- there is no need to install Web applications, its zero download software. You just need to check the services are running and initialize the requried services. Eg.Tomcat,Sas services.
  • 22. • Information Delivery Portal :- (IDP) Enables you to view and organize content on portal. • Which are the pages and portlets surface all types of information, including SAS Information Maps, SAS WRS,SAS stored processes. • Portlet is a rectangular display components of the portal in which content and links to content are displayed.
  • 23. • SAS BI Dashboard:-BI dashboard is used for creating , maintaining and viewing dashboard. • Is surfaced as portlet in the SAS IDP. • SAS BI dashboard is an application that represents the latest evolution of Dashboarding using SAS. It enables the rapid creation and deployment of dashboards that display data from a wide variety of data sources and system. • Dashboards is a way to represent numbers in easily consumable , graphical form to display key metrics within an organization.
  • 24. • SAS OLAP viewer for java:- used for viewing SAS OLAP cubes. Provides an easy-to-use interface from which you can select a data source , view the data , and customize your view.
  • 25. Thank you for watching
  翻译: