Posts

Showing posts with the label SAS

Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Beginner's Tutorial on SaS Visual Analytics

Image
SAS visual analytics is a completely new architecture from SAS. It has the capability to manage large amounts of data and bring it into memory to analyze it, explore it and publish reports.  Although the data amounts are massive — up to 1.1 billion rows of data, the SAS LASR Analytic Server, to use its full name, was designed to be intuitive to users without an advanced degree in computer science. A report from Simply hired. All about SAS analytics Server - The SAS Analytic Server begins with an eight-blade server with 96 processor cores, 768 gigabytes memory and 4.8 terabytes (TB) of disk storage.  The upper end of the reference configurations is 96 blades with 1,152 cores, 9.2 TB memory and 57.6 TB of disk storage, enough disk space to store the entire Library of Congress six times. Where to Learn SAS Visual Analytics Also read:    Modelling with SAS a detailed video course to get instant benefit  The real SAS Visual analytics benefits The speed of in-me

Here are 5 Skills You need to Become SAS Data Analyst

Image
Want to know what will happen in the future? Find the most lucrative opportunities? Get insights into impending outcomes? No problem. With our SAS data mining software, you can: SAS Data Analyst. Simplify data preparation. Interact with your data quickly and intuitively using dynamic charts and graphs to understand key relationships. Quickly and easily create better models. Take the guesswork out of building models that are both stable and accurate using proven techniques and a drag-and-drop interface that's both easy-to-use and powerful. Put your best models into service. Fast. Spend less time and effort scoring new data using automated, interactive processes that work in both batch and real-time environments. The requirement varies from company to company. I am giving here the basic skills you need for a SAS data analyst Experience in SAS or R analytics Scripting languages of Python/JavaScript/VB Script SQL and PL/SQL Databases knowledge in Oracle, DB2, SQL Server Hadoop and Big

SAS Visual Analytics top features useful to your project

Image
You may already know that SAS is king in visual analytics. The real features that SAS provide you can learn here. I have collected some features on SAS analytics.  SAS Visual Analytics is an easy to use, web-based product that leverages SAS high performance analytic technologies and empowers organizations to explore huge volumes of data very quickly in order to see patterns and trends, and to identify opportunities for further analysis.  "SAS Visual Data Builder enables users to summarize data, join data, and enhance the predictive power of their data. Users can prepare data for exploration and mining quickly and easily." The highly visual, drag and drop data interface of SAS Visual Analytics Explorer combined with the speed of the SAS LASR Analytic Server accelerates analytic computations and enables organizations to derive value from massive amounts of data.  This creates an unprecedented ability to solve difficult problems, improve business performance, and m

SAS- Get the Right Training, Go get the Job

Image
sas career options Many people think analytics is about gathering data using software tools and creating dashboards and reports. However, analytics is much more. Analytics goes beyond data; its primary goal is to enable business decisions based on that data. This involves working with stakeholders to understand the gaps in the business and using this knowledge as a guide to manipulate data, derive useful insights, and make recommendations – all key actions to increase revenue and lower costs. Wherever you sit in your organization, what’s most important is the bottom line. And so whether you lead business or IT units or are in the trenches, the analytics profession has likely crossed your mind. What does it entail? Who are true analysts? How does one become an analyst? Those of you specifically in a data management, data warehousing or business intelligence role may wonder how to further develop your analytics career. On the surface, an “analytics career” can be quite broadly d

SAS career these are different job roles

Image
What is SAS? Originating in 1966 at North Carolina State University, SAS is a proprietary 4th generation programming language specifically designed for data analysis. Data analysis includes data management, ETL, descriptive statistics, plots and graphics, inferential statistics, data mining, forecasting, etc.. In addition to the SAS programming language, SAS Institute, its parent company, also sells solutions built on top of the SAS language. Many people assumptions about SAS: Some people confuse SAS with the common database query language called “SQL”, thinking that both languages manage data in some way. While SAS may be used for database querying (reading/writing data to databases), this is only a tiny fraction of SAS’s capabilities. To give some scope, the entire SQL language is available in SAS as but one “procedure” (think of a procedure as a bundle of functionality). SKILL Set: What It Is: Pronounced “sass,” this software helps workers perform a variety of tasks, in

Data analytics popular free video course on SAS

Image
The Introduction to Analytics course is a set of 12 videos that take you through the basics of data analytics and the language of SAS.You should do this course if you are interested in data analytics and would like to pursue it as a career or if you have heard about the buzz it is creating and just want to know what it is all about. Each video is 5 to 30 minutes in length. If done in one go, it should take you about two hours to cover the course. The course is divided into three sections. The first section 'Introduction to Analytics' is a set of 6 videos. Here is a snapshot of the 6 videos: 1. What is analytics? This module explains the basis of analytics. 2. Why is analytics popular? This module talks about why analytics has become a big buzzword in business circles and the advantages of analytics. 3. Analytics applications? Here you will be introduced to the various analytics applications popularly used today. 4. Analytics technology Link to free course L

Retail Analytics Solution from Leader in Data Science SAS

Image
Retail market is changed now. So many companies now open shops across the world. Every business owner tries to increase sales. This is possible with analytics. Retail Analytics The study also includes an in-depth look at how best-in-class retailers use analytics, as well as the business analytics software vendor landscape. Walmart started retail business in India. So the real use of data analytics started now. References Download here

5 Key Ideas on SAS Banking Analytics

Image
SAS is providing solutions for banking. Getting away with financial crime just got harder. The latest SAS Financial Crimes Suite arms institutions to detect potential suspicious activity more efficiently than ever. A new customer due diligence solution within the suite more accurately detects changes in a customer’s risk profile. Enhanced anti-money laundering and case management capabilities also make it easier to have a complete view of threats across an institution’s financial crimes investigation unit. “A comprehensive view of potential threats will help in efforts to thwart criminals from successful attempts of hiding illicit funds,” says James Wester, global payments research director at IDC Financial Insights.  “A technology infrastructure with customer risk rating and high-performance analytics will help speed detection and investigation in all channels.”. SAS Analytics Suite for Banking Crimes Today’s rigorous regulatory environment requires banks to move quickly

A Powerful Video to Import MS Excel into SAS (Part-1)

Image
#A Powerful Video to Import MS Excel into SAS: SAS is a Statistical Analytical Software. The below video shows how MS-EXCEL data import into SAS for analysis.