Posts

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

13 Cloud Computing Terminology Quick Read

Image
Cloud computing is a big ocean. Due to increased services, a developer must know the glossary ( keywords) involved. 1) AWS Amazon Web services 2) Content delivery network (CDN) It is a distributed system. Servers are located in remote locations. Customers feel that they are accessing the servers. 3) Cloud A global network to access the resources. 4) Cloud portability The feature to move data from one Cloud provider to another provider. 5)  Cloudsourcing Moving traditional IT operations to Cloud computing. 6) Cloud storage It is a service providing to users to store data using the internet or other private networks. 7) Cloudware It is Software that helps to run user applications in cloud computing. Terminology 8) Cluster A group of small computers connected together to form a Single big computer. High availability and load balancing are the main benefits. 9) Consumer cloud The cloud provider offers services to individual users. You can call it a consumer cloud. 10) Consumption-bas

Python String Comparison Top Ideas

Image
In Python, you can compare two strings how you would do on numbers. Python is stricter on string comparison. It identifies any small differences in strings. So Python is case sensitive while comparing it checks for identical ones.    Python follow-suite other languages. It compares strings for exact equals. Else, treat them as different strings. Python String Comparison  Extra spaces Uppercase or Lowercase #1 Example >>> a = " V irginia" >>> b = " v irginia" >>> a == b False  The strings a and b are looking similar. But there is case sensitive difference. Python checks for extra white spaces as well as Upper or Lowe case letters. #2 Example >>> greet1 = "Hello " >>> greet2 = "Hello" >>> greet1   == greet2 False The greet1 has space at the end whereas greet2 does not. Python looks at whitespace when comparing strings, so the two aren’t considered equal.

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.