Profile

Cover photo
Prazval Ks
254 followers|632,090 views
AboutPostsPhotosVideos

Stream

Prazval Ks

Shared publicly  - 
 
Conditional Bump Chart in Tableau
On Bettings data (Click to Download) :- Create below bump chart of SUM( Daily amount bet) over continuous month of Bet date segmented by User group and Gender that meets the following conditions: ·          If the current month is greater than the same mont...
On Bettings data(Click to Download):- Create below bump chart of SUM(Daily amount bet) over continuous month of Bet date segmented by User group and Gender that meets the following conditions: · If the current month...
1
Add a comment...

Prazval Ks

Shared publicly  - 
 
Finding Renewal of subscriptions
Design a view to see all of my customers who have returned and bought again over time.(Renewals). Step 1:-  Add quarters to columns (right click and drag for dialogue box to open)  Step 2:- Add Customer Name to rows  Step 3:- Count customers who have renewe...
Design a view to see all of my customers who have returned and bought again over time.(Renewals). Step 1:- Add quarters to columns (right click and drag for dialogue box to open) Step 2:- Add Customer Name...
1
Add a comment...

Prazval Ks

Shared publicly  - 
 
Cohort Analysis
Find out how many of our customers are coming back after their first purchase. We need to group the customers by when the made their first purchase as well as where they made their first purchase. Step 1:  Find the first Order Date for each Customer by find...
Find out how many of our customers are coming back after their first purchase. We need to group the customers by when the made their first purchase as well as where they made their first purchase. Step 1: Find the firs...
1
Add a comment...

Prazval Ks

Shared publicly  - 
 
Labelling the last week in a series above threshold
How to label the last week in the series with the total "extra" sales above the threshold for those n weeks in a row as below. Step 1:  Find running sum of sales less the threshold. Step 2:  Create a calculation that says if the running sum of weeks is grea...
How to label the last week in the series with the total "extra" sales above the threshold for those n weeks in a row as below. Step 1: Find running sum of sales less the threshold. Step 2: Create a calculation...
1
Add a comment...

Prazval Ks

Shared publicly  - 
 
Customer purchase frequency
Identify how often on average  customers shop. How many customers shop once a month, shop once every 2 months, etc.? Step 1:  Find the first and last purchase dates of every customer        Step 2:  Count how many times the customer has purchased in between...
Identify how often on average customers shop. How many customers shop once a month, shop once every 2 months, etc.? Step 1: Find the first and last purchase dates of every customer Step 2: Count how...
1
Add a comment...

Prazval Ks

Shared publicly  - 
 
Iris Chart in Tableau
Create an iris chart segmented by Year showing distribution of  SUM(Sales)  and SUM(Profit) for each user in superstore. What advantage does this chart provide over Scatterplot and bubble chart? Background:- What is an Iris Chart?. Iridology, and Iridology
...
Create an iris chart segmented by Year showing distribution of SUM(Sales) and SUM(Profit) for each user in superstore. What advantage does this chart provide over Scatterplot and bubble chart? Background:- What is an...
2
Add a comment...

Prazval Ks

Shared publicly  - 
 
Variable Size Bump Chart
Using Gambling Data (Click to download) Create Following bump chart showing each Gambling product 's rank based on AVG( Daily number of bets) over time (quarter of Bet date ). Size the lines by the number of distinct Gambling products in each quarter Step1:...
Using Gambling Data(Click to download) Create Following bump chart showing each Gambling product</i>'s rank based on AVG(Daily number of bets) over time (quarter of Bet date). Size the lines by the number of distinct Gambling...
1
Amar Kumar's profile photo
 
Hi Prazval iam Amar batch 24 Prazval pls guide me on one my requirement I need to create a dashboard which contains 64 fields as tableau limitation we can show only 16 fields in a sheet but the requirement is need to show 16 fields in a sheet and rest of the fields need to display after exporting to CSV and they need to be displayed orderly in CSV file as we place the fields in tableau example filed 1 should be in a sheet and second filed should be displayed in CSV file in 2nd place and 3 filed should be displayed in sheet and should be in 3rd place after exporting to CSV and so on i have placed field 1 in sheet and field 2 in tooltip and 3rd field agian in sheet but when I export to CSV file field 1 is first place and field 3 is in second place and filed 2 is in 3rd place when I export to CSV can u guid me how to get the required order plese 
Add a comment...

Prazval Ks

Shared publicly  - 
 
Sorting on Table Calc
How to Sort  Order Date quarters based on a table calculation. This puts the chronology of the dates out of order, but allows us to see which dates had the largest changes. Also Dynamically  choose the department to sort the difference calculation on. Note...
How to Sort Order Date quarters based on a table calculation. This puts the chronology of the dates out of order, but allows us to see which dates had the largest changes. Also Dynamically choose the department to sort the d...
1
Add a comment...

Prazval Ks

Shared publicly  - 
 
Weeks over Threshold
Highlight all of the weeks that are above a given threshold. Then for all of the weeks in a row above that given threshold, label the last week in the series with the number of weeks in a row. Step 1:- Create a parameter so that the end user can enter a thr...
Highlight all of the weeks that are above a given threshold. Then for all of the weeks in a row above that given threshold, label the last week in the series with the number of weeks in a row. Step 1:- Create a paramete...
1
Add a comment...

Prazval Ks

Shared publicly  - 
 
Identifying Record Breaking Months.
In a bar chart time series of year and month,highlight each bar every time when a new max is reached in the sales as below. Solution:- Step 1:- Create Calculation that finds each new maximum starting from the first value. Then check to see if that value equ...
In a bar chart time series of year and month,highlight each bar every time when a new max is reached in the sales as below. Solution:- Step 1:- Create Calculation that finds each new maximum starting from the first v...
1
Add a comment...

Prazval Ks

Shared publicly  - 
 
Trellis Chart in Tableau with Pie Chart Grids
  Design  a  trellis chart with   7x7 grid of  pie charts  for Category and Sales for all states in Superstore as Below. Step 1:  Create X and Y axes Calculated Fields to Get 7x7 Grid.         Above X-Axis logic will combine every 7 Values together in a row...
Design a trellis chart with 7x7 grid of pie charts for Category and Sales for all states in Superstore as Below. Step 1: Create X and Y axes Calculated Fields to Get 7x7 Grid. Above X-Axis logic will combine...
1
Add a comment...
Story
Tagline
Life Is a Beautiful Thing and there is so much to smile about. Keep Smiling
Introduction

  • I am Prazval , Oracle Certified Fusion Consultant and Trainer,Author.One of my main hobbies is tinkering about with latest Technologies. Making an attempt to cope with unknown and think positively has always been my attitude towards life. 
Links
YouTube
Basic Information
Gender
Male