Ikusei Private Limited

New Tableau batch details by Mr Mridul Sharma

Hello everyone, hope you are doing well

Please find below the details of our upcoming Tableau batch:

Start Date - 29th Oct
Duration - 2 months
Timings - 6 to 8 PM (Weekends only)
Batch Size - 10 people maximum

For details on course curriculum & pricing, please WhatsApp on +91-9560095330 directly.

A 50% discount on the course fee would be applicable due to festive season.

No pre-requisites (technical or quantitative) required for the course.

Professional backgrounds for some of our past & present participants:

1. Qualified dentist
2. Statistics faculty
3. Prod Ops Associate
4. Economics Student
5. Engineering Student
6. MBA (Fin), ex-Banker
7. B Com Graduate
8. MSc (Ops Research)
9. Associate at Bain
10. Dev Ops Engineer
11. ML Engineer

Please note that Mridul Sharma will be taking all sessions for this course. Following are his credentials:

1. Tableau Desktop Specialist - https://www.credly.com/badges/7c55c51e-b348-4141-aa04-6773c557386f

2. Tableau Desktop Certified Associate - https://www.credly.com/badges/67f782cf-b527-4cb0-960e-abe833b5311b

Price Elasticity of Demand is the change in demand of a product or service with respect to its change in price. Mathematically, it is a % change in quantity demanded divided by a % change in price.

Goods can be elastic or inelastic. For example, any essential items such as medicines can be extremely inelastic whereas cereals & soft drinks can be very elastic.

Suppose the prices of Apples decrease by 10% & as a result, the demand increased by 25% then price elasticity of demand would be 0.25 / 0.1 = 2.5

A clustered index stores data rows in a sorted manner based on its key values.

Each table has just one clustered index because rows can be sorted only in one order.

The table that has a clustered index is called a clustered table.

When you create a table with primary key, SQL Server automatically creates a corresponding clustered index based on field(s) that are part of primary key.

A non-clustered index sorts & stores data separately from the table's rows.

It is a copy of selected columns of data from table with links to the underlying table.

A table can have one or more non-clustered indexes and each of them can include one or more table columns.

If you add a primary key constraint to an existing table with clustered index, SQL Server will enforce the constraint using a non-clustered index.

In case a table does not have primary key (which is very rare), you can define a clustered index on the table.

Hello everyone. Hope you are well.

We are starting with a new weekend batch for our flagship Tableau course from 20th August. This would be a live, instructor-led, online program with a total duration of 2 months. Class schedule will be 2 hours on Saturday & Sunday each.

Please find the list of topics covered at https://ikusei.tech/visual-analytics-with-tableau/

In case you would like to attend a free demo session, kindly message us directly on WhatsApp at +91-9560095330.

Kindly note that recordings are provided immediately after every session (excluding the demo).

An object oriented programming language contains code typically organized around objects & classes. Such languages are broadly classified into four pillars:

1) Encapsulation: both the programming code & data on which the code runs are part of the same block of code

2) Abstraction: no need to show technical details to users as they're mostly concerned with working software

3) Inheritance: functionality & properties of a class are inherited by another class. Can be of multiple types

4) Polymorphism: a given object can exist in multiple forms & can perform multiple, even unrelated functions

In statistics, histograms are used to plot the count of a continuous field with equal interval ranges of the same value.

For example, salaries of all employees in a company can be divided into brackets & then the count of employees in every salary bracket can be plotted to better visualize compensation trends.

In Tableau, a histogram is typically created from continuous measures or numeric dimensions.

To create a histogram, the first step is defining the interval or bin size.

Right click the continuous field, select create -> bins & specify the bin size.

Drag the continuous bin field to columns shelf and convert it to continuous.

Drag the continuous field to rows shelf and change the aggregation type to count.

Select all marks in the view and on hover, select keep only.

It can also be created by selecting the continuous field, clicking on "Show Me" at top right & selecting histogram.

In statistics, a type I error (false-positive) happens if a null hypothesis that is actually true gets rejected; whereas a type II error (false-negative) happens if a null hypothesis that is actually false fails to get rejected.

Let us understand this with an example.

Suppose that a test for COVID-19 is conducted. The following adverse outcomes are possible:

1. Test report positive, actual person healthy – Type I error
2. Test report negative, actual person infected – Type II error

Logical operators in SQL test the validity of a condition & return the result in boolean form i.e. TRUE or FALSE.

Some of the most popular logical operators used in SQL Server are as follows:

1. ANY - Compares a single column value with any dataset value. Condition must be true for any matching values.

2. ALL - Compares a single column value with all dataset values. Condition must be true for all matching values.

3. BETWEEN - Helps retrieve the value between a given maximum and minimum range

4. EXISTS - Helps search a row which meets a certain condition in a data table

5. LIKE - Compares a value to other similar values using wildcard operators

6. IN - Finds if a value is part of given data set specified in parentheses

7. NOT - It negates or reverses the usage of all other logical operators

8. AND - It lets us apply multiple conditions along with WHERE clause

9. OR - It lets us combine multiple conditions along with WHERE clause

Sequence in SQL is a unique object defined as a sorted list of numbers. By default, it is of BIGINT type & cannot have zero as incremental value.

The statement SELECT * FROM sys.sequences can be used to get detailed information of all sequences in SQL server.

Sequence can be defined by the create statement e.g. CREATE SEQUENCE IKUSEI_SEQ AS INT START WITH 10 INCREMENT BY 10

To increase the value of our sequence by 10, we run this statement - SELECT NEXT VALUE FOR IKUSEI_SEQ

Sequence can also be used to define the default constraint or primary key in a create table statement.

e.g. CREATE TABLE IKUSEI_TABLE (UNIQUE_ID INT PRIMARY KEY DEFAULT (NEXT VALUE FOR IKUSEI_SEQ), DOB DATE NOT NULL)