Sign In

Nikhil Naik

BI consultant

Nikhil Naik is an experienced Data Research Analyst with a strong background in the online media industry. He is highly skilled in R, Tableau, Data Science, Market Research, and Management.

He holds a Master of Business Administration (MBA) degree with a focus on Marketing from Savitribai Phule Pune University. Additionally, he completed a Bachelor of Engineering (BE) in Information Technology from the University of Mumbai.

Nikhil has worked in various roles including being a BI consultant at Tata Consultancy Services, a Tableau Developer at Future Focus Infotech Private Limited, a Data Analyst at Ziff Davis, and an Assistant Concept Manager at Landmark.

Highlights

Sep 27 · linkedin

Weekly #Tableau Challenge - 3 Tag your Friends or Colleagues who are up for the challenge Scenario - Week Starting Day should be Wednesday and show the last N previous Weeks Sales including the Current Week. The no of Previous weeks should be based on user selection

Viz. link : https://lnkd.in/gU5awbfF

Method:

  1. Edit date properties by right clicking the date sources and changing the start of the week to Wednesday.
  2. Create parameter for previous no. of weeks.
  3. Create calculated field for previous no. of weeks: DATEDIFF('week',[Order Date],{max([Order Date])}) <= [No. of previous weeks]
  4. Create another calculated field to identify current and previous weeks: if DATEPART('week', [Order Date]) = {max(DATEPART('week', [Order Date]))} then 'Current Week' else 'Previous Week' END
  5. Filter the year to 2021.
  6. Drag order date to column and change it to year.
  7. Again drag order date to column, right click and change datepart to week number.
  8. Again drag order date to column, convert it exact date and discrete.
  9. Again drag order date to column, right click and convert it to weekday.
  10. Drag 'Week type' calculated field to the column.
  11. And lastly drag sales.

Rajeswar Rayapati, Kalpana Rayapati, @SRIKANTH T #Tableausoftware #datavisualization #businessintelligence

N
Add to my network

Location

Pune, Maharashtra, India