This conference will now be recorded.
Hi, everyone, good morning.
Welcome back.
OK.
So many of whom have installed or tablet desktops, I want one volunteer who wants to share the screen.
Because I'm feeling some issue in my system, I'm not able to install the Tableau desktop, the trial
version, because it says I have already used that version of
my machine.
Oh, puja, right, OK.
Yeah.
I will make it pleasant.
I'm not sure if I can figure control.
But let's see.
I need to present and you can start sharing your.
I think there will be some option where they can take control of your system.
Let me see.
Yeah.
OK, so what I'm doing would open that door, open that I'm no, not public one.
The other one.
You have opened the public, OK?
This is amazing.
The.
You.
Since this iconic does not Tableau desktop.
Let's throw this one.
Yeah, that I clicked on it.
But when it opens shows it should look like he understood that it expires in 12 at the top.
OK.
Yeah, this is the one I want.
OK, no.
No.
But I'm requesting for keyboard and mouse control off the system.
Let's see if you get any pop up, just click on OK, OK, OK.
Did you get anything on?
No.
Well, give control, I got out of control.
OK, now let me take the control one second.
Yeah.
OK, I got the.
OK now.
Oh, see, everyone would have installed the Tableau desktop, so the one which we have been working
so far is the time loop public and which doesn't require the license, but there are some things which
are not available in Tableau public.
OK, so that's why we have installed this Tableau desktop and you can do the hands on you have two weeks
time.
And after that, you can download it with some other really lady and you can get the trial version for
the next two weeks and so on.
That is the trick you can follow.
Not everything will be same.
So on the left hand side, under the Connect, you see all these, you will see lot of options are available
now.
Previously, a lot of these options were not available if I go to more.
See, in Tableau Desktop, it offers all these options, and you can, you know, basically connect
to any kind of database.
Here and there should be Oracle, see, Oracle and this should be in our data as well.
OK.
All these are the databases where you can look and there will be a lot of options for big data.
Nowadays people are talking about Hadoop and all that right include there is Hive, so you can connect
to Hive also.
I have a database.
So basically where the data is, I will make sure that, OK, you know, we have all the options present
for these users to load the data from that they want.
That's why in Canada, so you see a lot of these options.
Now we are can you do the controlling load or what you do is you have that sample superstore, right?
Can you yeah.
Can you go to file?
I think, OK, you should do have it saved right to open.
There's one samples of the on the dashboard, Amy.
You must have created a dashboard, right, that W public and have saved somewhere, you must have downloaded
that from the Google Drive.
Is that available yet?
Yes.
And you must have downloaded and I can download it from the public is let that define.
This is superstar Bush.
OK, OK, OK, let's do one thing left one thing.
Mm hmm.
OK, let's load, let's load the data from the scratch, let's go to that time of talk.
We know that the samples of the Soviet you see on the screen samples of the so click on that.
Yeah, and then say no, but this is your opening night.
Right?
And all this.
Let's say that she thought of.
People also need to know when you are done.
OK, now let me take the country OK?
No, the orders dataset we have loaded here now at the start, and there are two connections.
And if you see these two connections and what's available in the tabloid public, it's OK.
No, if I go to sheet one, I go to sheet one.
You see the same interface.
Nothing has changed, isn't it?
Nothing has changed in terms of public versus desktop.
No.
On the left hand side, whenever we load any data, there is the zeigen cylindrical item.
Yes, it is cylindrical like them.
Now what these connections are.
Life means now you have loaded this altered data.
So what will happen if there is any data just changed in the orders, you would have that question,
right?
Do I need to load that data again, or dashboard will automatically loaded those kinds of questions
you would have because now puja has dragged on this or this today.
But let's say in Excel, if there is any change in the data tomorrow, right on this data, there is
some change.
The question is, OK, will the time you know the data automatically or I need to import the data again,
Reigate and build it?
That is the question.
So this life is like life connection, real time connection that needs.
We'll put a live connection, whatever it is, the lead investigator present in any of the files or
sheets.
Any of the files or sheets, it will load the data automatically, so like you can think as if you know
you're watching a live cricket match, you're watching a live cricket match, right?
So, you know, whatever happens on the ground, you will be seeing it instantly.
So this is this applies to the details or documents, what data it is available at that point of time.
That means whenever you are opening the dashboard at that point of time, whatever data is there, you
will see the same data.
That is the use of the so this life, the nations are mostly used to have the real time data, so let's
say you are using some data which gets used in every five minutes.
So think about like stock market data where you know the data gets changed in minutes or seconds.
But when I think of the users of that dashboard, the stock market data and you've created some dashboard
and some people are using it.
You want those people to see the latest data, right?
It should not happen that give the stock prices of a particular stock.
Your story, you're know, making it visible on the dashboard, but it was the older to do it with.
The stock price was off last one.
The one hour, one hour back stock data are showing up.
It will not be accurate.
Right?
So what is life connection is if there's any change in the data.
It will automatically make it when you open the dashboard.
OK, now what is this exact?
And whenever there is, let me show that whenever they did leave, they will be one cylindrical shape
and look at the cylindrical like and they will be one cylindrical like.
So this means that the connection which you have opted for this dashboard is alive.
Now let me go and click on this extract.
Now what it says, Extract will include all data, so extract be will have an Excel budget and a system.
Can you open the actual?
OK, now let me.
She knew you were going to use it.
Yeah, I have to think for one second, huh?
Yeah.
So life is what you understood is for real pain, right?
Now what this exact is exact is like a copy.
All the data so.
But let me put this here.
Now let me.
OK, now you have the data, you have the data behind the scenes.
And whenever there is any change in the language, we get automatically loaded.
That's why I'm saying we know what the extract is.
You have the data.
And now the time is 746 in our system, right, so seven, forty six a.m. and I'm creating a copy.
OK, so this exact.
Whatever data you have, you're creating a copy, and it all depends on when did you create that copy?
So that copy, let's say I'm creating it today, 7:46 AM not after creating that copy.
If there is any change in the data, if there is any change in the data.
So today is like ninth fair, but you know, when the juices are opening, then the fame, they want
some little detail because the underlying data got changed.
Right.
So what we have to do when the user, this is the user.
And they are opening the dashboard, whatever dashboard we have created them.
And if the connection in that is extracted, what it will do, it will go and fetch the data from that
copy.
And when was that properly created at 7:46 a.m.?
If there's any change in the data, still that user would see their copy of data only.
So.
This exact is not a real thing, everyone would agree it's not real time because it is wrestling.
It is creating basically a copy and that copy of data is being used.
Now the question you would have is OK, since the user would.
Look at that copy.
If there's any change, how do I refresh your trade?
How do I refresh it?
Now, let me cool.
Let me go here.
OK, now have this extract, and I went to seat one and see, as I said, that is the poppy right?
It will ask you to save that poppy.
So let's see.
And the extension is look at this tableau data extract.
When you do this extract option, it's Tableau data extract, and this is the name of that population.
And in this folder, let me do save.
I don't change the location.
The copy got saved.
OK, now if I go to sheet one, what do you see the change in the lichen?
Do you see the silk cylindrical I can smell?
Do cylindrical items now that tells us that this is the exact data that says this is the copy data.
So basically, you don't have to always go and look at this live index option to verify a little label.
So by looking at these cylinders, cylindrical items, you can do that.
Now, how do we do it if it is?
One cylinder, it is like with this two cylinder, the one cylinder at the back.
That means we are creating a copy of that data.
Now the question is OK.
Real time life connection is good.
Real life connection is good.
I don't have to worry about it, but cop illusion is if I put if I shared this dashboard to the users,
they will see the old it.
I know a few techniques.
What we have is if you right click and do a refresh of data, you can do this from there are able to
extract and say refresh.
So this refresh, what it will do is
refresh.
What it will do is.
The copy, which you have created at 7:46 now after creating that copy, there has been changing the
date that now let's say it's seven fifty right now when you do a refresh at seven fifty.
Now, this copy of the extract would get replaced with the latest extract.
That means latest data, which is available as on 750.
Now, whether users will be opening the dashboard, they would see the latest right, because they have
overridden that, so that is how the refresh work.
But you would say, OK, but this will be manual, right?
This will be manual every time I want to manually and refresh it.
Now when you start, who are fired or whether you can automated this, you can schedule this.
So then you will put this dashboard onto the said over there, we have an option where you can scan
using that every day.
This copy, this extract needs to refresh at so-and-so time or it could be a weekly audit, could be
a monthly.
I will talk about those things.
So that is the kid using these extracts to get refreshed.
Understood.
Any questions with this policy in the real time, we will be working on the extract part, I think because
then you make your delivery.
No.
So this extraction life depends on the situation on your dashboard.
So something you might think that looks the same since we don't have to worry about the dashboard when
it is life.
Yeah, so it really leave.
But what happens is if the data is very huge.
If the data is very huge, whenever the user will open the dashboard, what will happen?
It will go through that data.
And it will load the data to the user and write it so there will be no slowness while opening the dashboard,
then the users are clicking on any of the freedom that they are doing.
It will be, you know, if the data is used, it will be slow.
Now these users might come to you saying that, you know, whenever we are opening the dashboard, it
is opening slower.
When I'm clicking on a particular filter or that barometer, you know, it is taking a lot of time to
show the data they can blame.
The reason is whenever it is life, it's like you're watching a live match.
If there is any delay in the match, they will be, you know, you will see that delay in that match
in the similar way.
When you have a life that take some time to load the data right every time you go and filter something,
it means you are hitting that level of data every time.
So there is some latency, but when you have an extract, extract is not a right exact use a copy of
it.
That means whenever the user would open the dashboard, it is not going and pulling from the actual
data it is pulling from the copy, which we have created.
If you do very fast.
So but it all depends on the requirement.
As I said, the stock market in the stock market dashboard, right?
So it should be realtime within minutes, everything gets changed.
The prices of it changed or stocks.
We don't want to create a copy.
And after one hour, we will show the latest the stock prices that will not work there.
So the ideal for that use case would be okay, let's have it be thing.
But in your project, if there's not much a dependency on the data.
So let's say you have a dashboard and you have the data and that data not gets.
Updated very frequently, let's say, every morning at a particular time and daily basis, the data
gets updated now over the years, you have the flexibility, right?
To schedule it.
Instead of going for the life, you know that in these data every day, this time it will get updated
in the back and.
Database not after do, after back time, after maybe some time I will put the schedule on the dashboard.
Which will refresh that extracts so that users, when they will be opening it would see the latest data.
So it depends on the requirement.
Got it.
Any questions from anyone on this?
Understood the concern.
So this is very important concept, and in the interview they might ask, OK, what is the difference
between the living next extract?
When do you use live?
When do you expect everyone got it when they use live and extract?
If there is any real time data need, you want to show the real time data on the dashboard always go
for life.
But the problem with life is if the huge data, every time the user opening it, it'll be slow.
If you have the flexibility to, you know.
Kid, you it, then you can go for that, expect.
There is one question.
Can I extract?
OK, can I extract something out of all fields?
In a dataset.
OK.
And there's one more, how can we how can we make a copy of data now?
This copy of data when I went and selected when I went and selected the extract option.
When I went and selected the the exact option and when I went to seat one, it bobbed up a message a
box and asked me to save.
So that is how you will save you will create a copy of it.
But you have to click on this exact radio button to get that option.
Life will not ask you to create a copy because it is a real life.
Got it.
Now we're now.
The question is, you know, we have all of these columns and we don't want all these columns.
So let's say what is this?
Oh.
This is all it.
Right now, we don't want some of the columns to be visible in this sheet one.
So you don't want some of the columns to be visible in the shade one.
So having size, you must have learned about no keep and drop.
If you want to keep certain columns over will just keep if you want to drop certain columns, you will
drop the similarly, it will not be exactly similar, but time will by default and load all.
Look, you don't have options to unload some of the columns directly, but.
Here if you go.
That's all right, if you can.
There should be something called a hotel, so you can hide here.
All it's gone.
Now, if I go to sheet one, which we will not see that already, you can hide those columns.
Got it.
Now there's one more option.
You see those filters actually filters.
No, let me try this.
Filters I've checked on and and I'm seeing ad here.
And let's say AMC and Guy Thuggery is a call to arms selecting technology.
I'm doing OK.
And I'm doing OK now, what do you see in this pretty section?
There is one fatal.
Which got added.
Now, what this finger does is, you know, insides you must have learned about, you know, the if
statement of individual loading, any Excel file or the as required.
We just want to load only that data.
We don't want entire data to get imported.
It could be an import or in file and input data into a data step.
So basically what we're trying to do is we don't want to import all the data nor all the data.
It should only load the data, which I have favored right now if I go back.
Now, if I go back to the sheet and if I go back to the category because our friend told, on the contrary,
what do you?
See?
So this.
US that the data which we have loaded.
Is only for technology.
But in this order, ActionScript, we had data for everything, right?
But in bad law, we have unloaded only the technology data.
Now, one question you might have is what is the difference?
Let me ask the question what is the difference between adding a filter?
We do this right.
Track this two filters.
They all.
What can?
And.
And so.
What is the difference between applying a filter in the data sources that.
Applying a filter in the data sources that.
This showing the freezer in the sheet.
What is the difference anyone can guess?
See, OK.
If I remove.
Applying reading data sources will fetch only those rules, which satisfy the condition perfect.
That means when we end up lying in the data sources, meaning this one, OK, so don't get confused
data sources page.
And whenever you apply because this is the page, this is the data sources page where we import the
data.
So during that place, if you are presenting something that you are importing, only that data they
will only import, which satisfies this condition.
So you imagine this as if in fact you would have written something like if.
Category is equal to technology and semicolon in the dataset.
It will only lower the bad data, not if I remove this.
And we have gone from that in the sheet, it was only showing technology.
I removed this.
What happened?
OK.
And I removed that filter, and then I'm going to shoot.
Now what do you see?
What is the change?
The thing here in the category only we were only using technology, but now all this happened is if
there is no filter in the data sources while importing, it will load entire data.
And that's what we see like in at the baby, we see technology fall off of that furniture.
Understood.
OK, now.
But.
Now, let us go and look at some of the questions you all have, so I will open it for questions.
So anything you have put us into sharing.
Well, I don't know.
She thought she knew that the Nazis.
This one sales and marketing this we haven't started.
We discussed that we will discuss it, but then you started.
Yeah, so I have.
Yeah.
So this story you're saying they did this time?
Yes.
I mean, the.
Got invited to this is a little bit different.
This is a story in the dashboard, OK, that is one thing.
OK.
Let me take the control, OK, now.
If I go back with the dashboard, this is the dashboard right now.
There's something called these three icons you see here.
This is a sheet.
New worksheet, so you will get the same options when you write, you can see a new worksheet, three
options you should be comfortable with.
New worksheet is nothing, but worksheet is a sheet.
Dashboard.
Is the dashboard where you will try?
There's something called the story, this is the third one.
Now, if I speak on this story, I click on this story and you see something different here.
On the left hand side, you see all the sheets similar to a dashboard and it led to a dashboard.
And here we were, getting that entire space to drag in the lines of things.
But in the story, it sees some add caption at the top and a sheet here.
Now let's let me.
Let me drag.
This.
Yeah.
And in the attic action, I would say sales.
By supply.
Now I'm.
Thing blank.
And here again, I have to drag something sales by customer segment.
No, I'm seeing sales by.
Sales by customer segment now.
This.
Tory is allows us to create a menu kind of a thing at the top.
You see, this will be a menu that means if you want to give the users to select something and on the
sea at the same place, it will change change based on the selection.
Let's see if they're interested in sales.
I supplier and this page, you know it is showing the sales by supplier if they're interested in.
So it's like a menu based.
And would require it all depends on you, like you can show everything together, they will not be any
manager that will be saying all the all the things at one time or audience.
You can have this story.
And allows the user to select what they want now, if they wanted to add my people, I would go to hear
a new story point and it would insert a blank one and then I will drag the sheet.
But I want to give some meaningful name to that.
So let's say by state something like this.
So this.
Schools want a story, so in the sales and marketing, the last attack is the story and how do you identify
the difference between the dashboard and the dashboard using the table?
You see this.
Will kind of icon.
But I just told you, you have this, I can see this item.
So this is how you can differentiate.
So this is basically in a different way of showing the things showing your sheets because intangible,
you don't have this feature to show this manual kind of a thing.
Look.
And the one which we were looking for is in marketing, that was that all those are stories is audited,
the dashboard.
So there's one way to do it is the story, but everyone is, I think, a dashboard only.
So if I go and look at.
You see all these are like a table.
I cannot.
This is a bad ball, this is a dashboard, this is a dashboard, but this is a different item.
This is a story item.
If I go here, you see these menus.
If I click on light duty.
Basically issuing one sheet, if I click on this, it will.
So based on this election, how this helps this, if I don't have this, I have to align all these sheaths
at one place, right?
But it allows them to see what they are interested in.
I'm interested in looking at fine and I'll go and click on finance and see the finance chart on me like
this.
I think we can do that and I would have.
But in that world.
We really have to clean all the sheets, right?
So we have to drag it is wildly different things, we have to drag these same sorts of profits when
I visit government, everything at one place you will see.
So just like how great is that is so Crystal.
You see here all these other shoots, correct?
This is one she is the second assistant, everything we are claiming inadvisable.
But in a story, you will not expose all these things at one go.
You will give the user manual.
OK, they want to go for their supply deal.
Click on it.
They will see that they want to see the segment or they want to see this man.
Then only it will show that particular sheet.
That is the difference.
OK.
Yeah.
So how many of you have seen is this president even had any other question seen or heard the question
raised last month starting?
All beyond that calculation, you.
Hello.
Yes, it's got that final layer.
So let me look at the Formula One, she like the model.
I will look today.
I'll get some time, I'll let you know.
So the calculations I leave it to me, I will come back to.
What is the formula?
Because we were not able to find that column, which they were using right necessary.
But I think they might have been allowed not remembering what we did.
Yeah, I'll come back to you on that formula.
Anything else, anything else anyone wants to share?
You know what?
So far, let me add that so far when we started from the demo still here, did you all get that confidence?
We're not previously.
You are not aware of that.
What is that change you're seeing in yourself?
Can someone talk like I, you know, it will take some time to get a lot of hands on it requires.
But you would agree that how simple it is if you follow the steps.
No, holding nothing.
What is your experience?
Then I want to hear from everyone.
So then at 50 percent of confidence.
Taser.
Yeah, I have a daughter in sales and marketing.
Yeah, sir, once I heard the shoot after it will come to shifts, but in the days and the.
Oh.
Had the3 had been visiting, Australia actually didn't handle that confusing here, like why they're
creating this headlines is to create these stuff.
And I think when I was having that question, so once you once you opened up your sales and marketing.
I am sharing my screen, can you see which one your sales and marketing?
Yeah, here, she said.
Why do they do research and marketing ones?
I how the food industry industry.
Mm-Hmm.
Yeah, it's empty because this year we are creating just to create this had this design, which they
are using and this top.
Just for this design.
But that is not a good method of doing it.
Even, you know, some of those phasing that issue.
So what you do is don't create these headers.
OK, now how do we get this similar thing?
That is the question.
How do we get this stimulus thing like, Okay, this color that dissolve and then some empty space,
then some again?
Heather, we have this text.
This is one of the good features, which is already that we don't have to create now.
If I was to do it right, what I will do is just see here what I do.
Can.
Let me.
Do automatic like mental floating.
And that is that this one, right?
That's the sales and marketing and corporate.
Next.
I'm going here, so I have this text option right now.
You know, you must have did that my the Zoom thing.
So if I drag this lot of text, we have put in my resume now I can drag this.
I can make it like this.
And to this, and I can make it, senator.
Right, and right click on it for my next object.
This is on the alignment.
Now.
Want to do the former thing of it's not giving the shade an option on.
I'm not giving that shaving option currently, or you it.
Now.
So what was?
This one is.
Background, right?
So you can choose basically any color selecting that.
So.
Select and then go to the auction.
Otherwise, we will not see those auctions enabled.
So I'll go here and let's say I'm selecting this.
And you're going to have the borders as well.
Let's do that.
Yeah.
Well, this is the better way of doing it, so why do we want to create the headers?
But they have created this headers to use this to ensure that what you all do is this entire thing.
You bring one text here and make it like this below, then give some space and drag this.
Then you drive these filters.
It will be, you know, all these filters and sheets.
Because someone was not able to, you know, when they have created this headers, they were not able
to change the background color.
So don't worry about that.
Do like this.
OK, Amy, and the question from anyone.
You were saying yesterday that you will talk about the loser.
That's so yeah, right?
So anybody has any other question.
I will make a huge job presenter once again.
So.
We have to do.
We are.
Before we go to the time, we have to create the credential and all that stuff that we make to present
Abuja.
So that means everyone is ready with those solar powered credentials part.
But you.
And share your screen.
OK.
OK, fine.
I needed to watch it.
Yeah.
No, let me see if I'm able to take the control for all.
OK, OK.
I can take the control, yeah.
No tool.
Look, it's everything you look at, yes, this is a very important step.
I'm going to the Tableau desktop.
The trial version one.
And.
OK.
You see this server menu here for women.
So into the public, we will not have this a lot of money.
Now.
We have to go to this server and click on signing.
Keep on fighting.
But we have to create the online network, so as I said in the beginning, we have to protect safe Tableau
desktop and the tablet.
So this is what tablet desktop, but we want to pay the Tab NewsHour online.
So there is an online server which is available.
We can make use of that for the practice.
Now how do we create our site?
Basically, that server is click on this tablet online.
Follow the steps.
Click on this tablet online.
And it will ask for it, sail into Tableau online.
It's not signing to five new public accounts, so the one which you are using and saving your dashboard
was Tableau public that the public is different online.
A different online is the silver plan.
Now we have to create the credentials.
Click on Sign Up.
I hope everyone is following the steps.
Now through that, can you end up with all the details?
Yeah.
She know this a lot is also always just about online.
We can make our own servers on servers.
Yeah, so in the company's the soul will already be there.
They will just give you the usual, OK, this is the third one name you have to connect.
They will you the credentials.
Right.
So here we are learning how from the very basics, like how do we set up the servers?
And what are the things we need to do before we go and use the servers right?
But in the companies, the servers will already be there, if the target is already there using it,
they will tell you, Okay, this is the Third World which you want to connect with and they will give
access to your credentials.
But here what we are doing in this, that we are setting up our own server.
Those understand like that.
Now, yeah, here I need to use a real phone number or I can give the dummy what I can do anything on
the that's fine.
Request free trial, no, don't click on that, don't click on that.
No, no, no, because you already have desktop, right?
Don't click on that request.
Free trial request returns.
No, it's.
No, just hold on.
Don't click on an event like that, come.
I hope everyone is also following the steps, which was actually.
Yeah, now it's a great check your email for your confirmation.
Now, can you go?
To that email, you should receive
an email, maybe you can differentiate.
Yeah, now activate so you get this email to activate your site.
Now, let that happen.
They're saying change.
OK, I need to give some credentials.
So in the previous step, you have not given the credentials, right, because the server which you
are creating puja is useful.
It should be secured.
So you should give some security by specifying some passports will give any password.
And remember that password?
OK.
Yeah.
Name your site over there, we can do any so this is the server name which we're getting, let's say
Booyah.
You can see.
So this is your side.
You can have the location not let it be.
You ought to let it be of the.
Yeah, go read and click on activity to my side.
Yes.
The site by there there is already there, it looks like skinny jeans, bruja underscore that you.
Enter the password again.
Yeah.
Click on the checkbox and factor with my sites.
I.
OK.
Yeah.
Cancel the cake on their side and that window closed it.
They are.
So this is the side of the cell wall, which we have created.
Now let us stop here and let me ask everyone.
So everyone came down here.
Everyone should come clear.
Yesterday, Shaker is done, what about others?
This is a very important part of this time you OK?
So far, we have loved the title of this job, but no matter how many dashboards you will create, you
won't be able to share it with someone.
If you are not aware of this, we're fine because we want to put our stuff on the server.
We want to provide the permissions.
To these users, this is very critical.
Judy, now we are by Remy, she shifted, does she know when good one she is?
He.
OK.
OK, let me.
Vented one, she.
What about you?
OK.
Yeah, but you all got the steps, I guess, right?
So you have to enter those credentials, give the site the server name and activate it.
You will get the name, will activate it, choose the password.
You should get this.
OK, so so what I'm thinking is we may continue with the over part on Monday.
The model, what I want everyone to do is so on Monday and Tuesday, we will be able to finish this
so far and I hope we able to see Lance clean.
So what the plan next is if you go to this interview questions.
So this weekend, I want everyone to spend first time on those projects just, you know, have hands
on.
And no down any questions, if you freeze and go through this interview question, that is the next
step, I want everyone to do it.
OK.
So on Monday, we will look it up and deal with that.
So upon a fabulous hour apart.
And then on Tuesday, you know, maybe I'll take that interview questions and we will see.
Interview will not be in total one hour, but half an hour or so.
And you know, all these three days we will see for 10 15 minutes if you all have any other questions.
Will try to see my last day on 13th.
I will talk about.
The CV part, you know, the CV part, maybe a little in light rum on that day, maybe on Wednesday.
So I will upload some series today.
Let me shortlist some of the series where the those would have bought the fastest debut.
So you can pick up any of those things, any of those buying those and put it in your CV.
I discussed that on Wednesday.
Yeah, but now the priority should be.
Spend as much time as possible on working on those projects.
Do the hands on, right?
Then you go for that interview questions and then you don't really connect on Monday.
OK.
As you know, wanting to ask.
Yesterday at arms, your one opening in the gym, the third was the size of two to three years of experience
was required.
No, but I was thinking in my look.
In my case, I have many years of experience.
So how to showcase if I want to go there for interviews or how to showcase that?
So it was only for SARS-CoV-2.
That's this time.
I think is true.
Its size and tableau will be there and just distance.
It's hard, it's just mentioned stressful grandmother, two to three unions and a full year on campaign
management and management will be part of that.
W-, that would be the part of that.
LANSING, Mich. No company management is just a concert like you can do.
The company management in any domain mean, let's say, telecom when you want to do the Cavs and the
campaigns for any particular marketing strategy, right?
So campaign management is the context where we want to target specific customers, whom do we want to
target to sell certain things?
That is what campaign management is now.
How?
So did he during those sessions?
Did they also you he must have talked about certain subjects.
They did it off on certain projects.
Analytical thought they.
One project we discussed that audiences know that audiences and I think that show for that would be,
for example, we can reach that in a few minutes isn't.
So what I intend to leave that students like, I've no.
What you can tell is, see, the very first thing, you should be very comfortable in answering whatever
they ask in fast, OK?
But that is the first step to revise all the things.
If you want to go for that and revise on the table size along with the sin taxes and everything, we
should be very confident in that.
That is a first step.
Now, the second step is think about your own work in whichever domain you are OK in whichever domain
you are now.
If someone asks you, OK, what you do.
You knew would be very comfortable in talking what you are doing today.
Let you know what kind of data you're working on.
Let's see if you're working on Excel or something or some reports.
If I ask you now, also you will tell me, OK, this is what we do.
These are the data, right?
Correct.
Not what I would say is OK in terms of those lines only.
Now you can say that in a company, you don't I don't know like what kind of tools are using if you're
using some databases or actually in large, some kind of creating records.
And actually what you can say is, you know, from last one year earlier, we used to do like this into
action.
We used to pull them and really and you do the combining of data in Excel.
But you know, we were facing a lot of issues because of the size of the data.
And every time we have to go and manually do it now, the management has taken a decision to implement
size in our company.
No one will come and, you know, cross-check pollution using or not, right?
But yeah, what you can do is you can quested them.
Like this thing?
OK, for some part of the work, you know, from last one year, we have been collecting all the databases.
We were loading some Excel files and creating fast data sets by writing complex logic and you know very
well about your data.
So you can listen to them and going, and look, these are the columns.
These are the things from this.
This is where I am getting the data.
So we have streamlined that entire process of scores by writing SAS code, and we have created several
reports, several analysis for the management.
That is how you can twist it.
OK.
Now when you say that, expect some questions regarding that.
OK, so they might ask you talk about the data.
What kind of data?
You know the data which you are working on, right?
So what I would say is, you know, seeing some dummy thing, everyone can relate it to their work.
Yeah.
If anybody is not having experience or leave the faces, they can use some dummy projects, right?
But since you have the experience and that experience will not go anywhere right, you can still utilize
that experience and twist it.
Twist the interview saying one thing more that says if you for the banking projects only or the use
of other domain, the dominant media domain below and now then moving to something home automation kind
of thing.
And that is the how do relate that one because I have done that now.
I have been for the last seven years.
I worked in the media domain.
There were then that was another testing project, but we were pulling their data and we are doing dashboards
and the different.
There were other different all over the world and inside of the totally new concept is only for the
banking project, not for the well, not for the other domains.
Is that true or not, in every domain is being used?
Maybe you take pharmaceutical telecom domain.
All the word off will enable the use.
As pharmaceutical major pharmaceutical companies all of the banks use have given the retail industry.
You won't believe like these gave in the airline industry large to all industries you size.
Even what they heard from within you are the intermediaries.
I heard even these new channels like and the new channels like ABC News and all those channels also
use SAS for doing analytics because the media media houses, they want to look for priorities and all
that right.
So they do a lot of analysis on, you know, which what do we see seem?
Which programs I have in highest regard, please?
What time do we have to manage those things and advertisements?
And so even I heard.
So what do you do, pujan if I want to understand, like you said and to me, the right media on what
do you see?
What do you do generally, no work shoots a testing profile.
I'm working over testing lead over there and our job is to test applications and websites on different
platforms like mobile app, mobiles, iOS, Android platform or connected device.
Then that's inside the building.
It'll all be things we noticed.
And these days from last week of last two or three days, I joined a new project, which is home automation.
So here we would me.
We would use the word Do we do protocol testing?
And that is just beyond and all their different protocol, which we will use to test home automation
things.
Light bulbs automatically light up when the president, when we control it through the mobile app,
on the phone or through the Google Alexa or Google Assistant or Alexa.
So this is what I'm doing currently.
So how can I relate it to the Southern and that getting all this data from?
In the case of that media domain, I won't be getting all this data from another company, which declined
on the day.
We are working on different new and different brands like CNN, Cartoon Network and you went right over
the BBC and there are different shows on that.
So we were doing testing of those videos and the content available on the sites and mobile apps.
So so what we can do, what you can tell all the data which you are looking at, the testing we should
do, OK, this is working or not.
So you can talk about the bag of data they used to send those in some raw data files.
And then, you know, coming out and testing a few things on that data like, OK, how is this particular
product so working from then on from the mobile phones when we get away from the election?
So all individual talking about to think in terms of you were getting all those fields, all those data
points in some kind of a file.
Right?
And then you were loading that into SAS and think in terms of some of the challenges, like why we went
to SAS looking at the data, we can definitely also like doing this.
We can you think in terms of, OK, what are the differential once they send the data know, like they
will not send the data, but you project it as with those kinds of data, those domain data descending
into some kind of files.
But after getting that file, you think of yourself, what are the things we do on that?
How you can twist that, OK?
We get to enter data.
We think this is our learnings.
We all for the same product.
We have some other information stored in some other files on tables.
We have to bring them together and then we have to do some analysis of things that if this project,
how many, you might also be looking at the defects, right?
Defects.
All right.
It is working or not.
So we used to do all that analysis on all those products if they are working well or not and all those
things we are desiring.
So you can say that OK at all, you can first talk about the business side.
What is the business of there?
Then you can talk about, you know, we have this one symbol for the management of Google, and this
is about gas projects.
OK, let's take some time this week and think in terms of come up with some story points, some bullets,
right, and we can connect later.
Also, once you have that clarity.
OK, well, just come on with those bullets and then we can take a frame of story.
Now, one of the good thing again, as the I'm realizing, is that is the saddest part which we will
twist right now after doing all that analysis, after creating all that data together.
Next is if senior management wants to look at, OK, this is a ball.
Can you show the trend?
Like how with my sales overall and how many defects are issues we found, right?
A lot of things you can do and you can tell them, OK, once we have all that data data insights we
use to create dashboards for the senior management to look at end to end about their portfolio, you
know.
And there are a lot many things you can show up in Tableau, right?
It would be difficult, in my opinion, how we as a sales, how is the revenue, what kind of different
products are there in last one year, which are the products which are having higher defects or issues,
which are the products, top end products where the revenue is good?
Right, so if you think right, you just noted on Facebook and no known human, you know, related to
that time, so there are a lot, many things.
It all starts with that question.
So think in terms of who you are, the CEO of that company.
What are the things you will be interested in to see on the dashboard?
Then start plotting those questions, once you have those questions, you have the data and you know
how to create these shots.
You lazy?
OK, OK, we can go from idea to come up with those bullet points.
Maybe we can talk later, those the ones that have that clarity.
But I would say, you know, it's lot since you have a good experience, you can make use of that experience,
right?
Instead of talking the things that you don't know, you can talk about the other work also, right?
But we have to do with it.
And then we twist it, and you will expect some questions that say, you say, OK, we'll go there live
and try to judge you.
OK, how did you input the data?
If they asked, you should be there to answer things aggregating the data, write file input or we use
blocking both for doing this.
They might ask, Okay, how do you create the report and said, we should be ready?
How do you do the calculation inside?
Mm-Hmm.
Yeah.
I can you can find you can apply it on any domain, but you should be able to convince them those things.
OK, you've got to feel like this team all connected to it more vividly, we are basically taking the
what we are doing and we are digging logs of the sites and mobile labs in the jars and my I don't know
what you might have heard of child or not.
It's used to dig the logs.
Well, OK, but what I'm saying is forget about long for no one will come and ask your opinion.
What I do is like, I just tell that you can also tell them that all that data is stored in a secure
database.
Simply.
Mm hmm.
Headaches.
Freeloading off the blogs, although we will ask you to show the long side you say all that data is
stored in a database tables and we used to connect to that database loaded in size.
Do all that data preparation analysis stuff, create a final table that finds that Google will add new
for creating the dashboard.
OK.
Yeah.
OK.
So what we will do is it's already eight 15.
So we will end for two then.
So I hope everyone is aware of, okay, let me quickly share my screen two minutes on.
See, this individual question is one thing, and I'm not sure if you all at this books.
Also, I have loaded both with you have some time to go through these as well and recorded session.
I'm not sure how many of you are going and watching these videos I have been uploading or do look at
those and series.
I will upload it like that today or tomorrow.
So the plan is on Monday.
We'll be having session tomorrow.
On Monday, we will be looking at entire thing on the fabulous hour five.
Please don't miss the section.
That is very important.
We will see end to end of the tablet server on Monday.
On Tuesday, I will have the interview section right on Wednesday.
We will have just a opening to discuss about what is the way forward.
How do you update will see news and all that stuff I really like as I'm always on that day?
Yeah.
OK, so we will enter today.
Have a great weekend.
We will connect back on Monday.
I will send a new meeting link.
OK, you will get an e-mail or an email from me and you.
Thank you.