Posts

Showing posts from August, 2016

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

Write and Read Excel files into SAS Studio

Image
The point is how to import an excel file into SAS. Step by step process given on reading Excel file into SAS and writing Excel file from SAS. SAS vs Excel Files Reading an Excel file into SAS Suppose that you have an Excel spreadsheet called auto.xlsx. The data for this spreadsheet is shown below: MAKE MPG WEIGHT PRICE AMC Concord 22 2930 4099 AMC Pacer 17 3350 4749 AMC Spirit 22 2640 3799 Buick Century 20 3250 4816 Buick Electra 15 4080 7827 Import Wizard Using the Import Wizard is an easy way to import data into SAS. The Import Wizard can be found on the drop-down file menu. Although the Import Wizard is easy it can be time-consuming if used repeatedly. The very last screen of the Import Wizard gives you the option to save the statements SAS uses to import the data so that they can be used again. The following is an example that uses common options and also shows that the file was imported correctly. PROC IMPORT OUT= WORK.auto1 DATAFILE= "C:\auto.xl" D

Excel: 10 Key Topics You Need to Learn

Image
The below-listed topics help you get a solid footing in Excel Analytics. Just practice these 10 topics step by step and by completing all, you will be an expert in Excel. 10 Top Excel Topics Tables in Excel  Grabbing data from external sources  Cleaning data with functions  Working with Pivot tables  Writing Formulae for Pivot tables  Pivot Charts  How to use database functions  How to use statistics  Inferential Statistics  Descriptive statistics Also Read : 5 Tips why macros need in Excel

IoT real concept for auto insurance

Image
IoT in insurance is a connected car which helps transforming how insurance premiums can be calculated. With the help of a small wireless device that plugs into the diagnostic port, Metromile offers a “per-mile” usage-based insurance. Often, low-mileage drivers overpay for insurance because they’re subsidizing those who drive the most. Insurance Calculation But since the number one risk indicator for drivers is time on the road, Metromile can offer insurance pro-rata by tracking the miles driven. #Mile-based insurance an application of IoT: According to wiki: Usage-based insurance (UBI) -also known as pay as you drive (PAYD) and pay how you drive (PHYD) and mile-based auto insurance   is a type of vehicle insurance whereby the costs are dependent upon the type of vehicle used, measured against time, distance, behavior, and place. This differs from traditional insurance, which attempts to differentiate and reward "safe" drivers, giving them lower premiums and/or a

IoT In Healthcare Top Skills You Need

Image
IoT and multimedia technologies have made their entrance into the healthcare field thanks to ambient-assisted living and telemedicine. ... Role of Smart Devices Smart devices, mobile Internet, and Cloud services contribute to the continuous and systematic innovation of Healthcare and enable cost-effective, efficient, timely, and high-quality ubiquitous medical services. Skills You  Need  Data Analytics  Cloud Computing  Security  Smart Device "Pervasive healthcare applications generate a vast amount of sensor data that have to be managed properly for further analysis and processing." The adoption of Cloud in this scenario leads to the abstraction of technical details, eliminating the need for expertise in, or control over, the technology infrastructure, and it represents a promising solution for managing healthcare sensor data efficiently. It further makes mobile devices suited for health information delivery, access, and communication, also on the go, enhancing medical

Quick Guide: Machine Learning Examples and Uses

Image
I want to share with you the best real-time examples on machine learning.  Because of new computing technologies, machine learning today is not like machine learning of the past.  While many machine learning algorithms have been around for a long time, the ability to automatically apply complex mathematical calculations to big data – over and over, faster and faster – is a recent development. Machine learning use cases The heavily hyped, self-driving Google car? The essence of machine learning.  Online recommendation offers like those from Amazon and Netflix? Machine learning applications for everyday life.  Knowing what customers are saying about you on Twitter? Machine learning combined with linguistic rule creation.  Fraud detection? One of the more obvious, important uses in our world today. Best example : "pattern recognition" is best example for Machine Learning Related: Take Quiz on Machine Learning Where can you apply machine learning. 

IT Skills you need to get top jobs in e-commerce

Image
Technology and digital marketing-related skills are in huge demand as e-commerce companies have got big-ticket investments. IT Skills for e-comm jobs Technologies in Demand Domestic consumption of technology, especially in mobile telephony, is on the rise.  The traditional IT services sector is likely to see a spurt in hiring as demand revives in Europe, along with expected economic turnaround at home. Hot in Demand IT areas According to Teamlease, this category will provide opportunities for a wide range of people: beginning with IT infrastructure managers mobile developers on IOS, Android, and Windows languages like Python, Ruby on Rails, HTML, and CSS  IT security cloud computing professionals. Experience developing applications using technologies such as Java, Node.js, HTML5, JavaScript, SpringBoot, Tomcat, and Selenium.