Wednesday, August 5, 2020

Answer for New questions

https://365datascience.com/dwqa-answer/answer-for-new-questions-4/ -

one more




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for New questions

https://365datascience.com/dwqa-answer/answer-for-new-questions-3/ -

yet, again.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Starting a Career in Data Science: Project Portfolio, Resume, and Interview Process

https://365datascience.com/courses/starting-a-career-in-data-science-project-portfolio-resume-and-interview-process/ -

This course provides you with invaluable insights directly from a top-level data scientist with first-hand experience in recruiting data scientists for his team. You will learn everything you need to get a competitive edge over other job candidates and start a career in data science: how to create your data science project portfolio, build your resume, get an interview through networking, succeed during the phone interview, solve the take-home test, and ace the behavioral and technical questions. The course also offers you resume templates, downloadable materials, helpful infographics, as well as a section on how to optimize your LinkedIn, Github, and Kaggle profiles for recruitment purposes.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for New questions

https://365datascience.com/dwqa-answer/answer-for-new-questions-2/ -

hmmm




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

New questions

https://365datascience.com/question/new-questions/ -

This is just to test the sending of answers and response emails.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Bonus Downloadable Materials

https://365datascience.com/courses-section/bonus-downloadable-materials/ -

This bonus section comprises a variety of valuable downloadable resources: resume and cover letter templates and samples, reach-out templates and examples, a networking guide, as well as a complete guide with real data science interview questions and answers.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Bonus Content: Interview with Successful Data Scientists

https://365datascience.com/courses-section/bonus-content-interview-with-successful-data-scientists/ -

Here, you will get an inside look into the mind of successful candidates and how the interview process actually works. The section involves exclusive mock-interviews and 1-on-1 conversations with professionals who have successfully landed data science positions – an invaluable shortcut to a career in data science.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

The Take-Home Test

https://365datascience.com/courses-section/the-take-home-test/ -

This section gives you insight into the three types of take-home tests you can be given at this stage of the interview process. You will find out how to deal with data sets assignments, solve coding quizzes, and master the written test.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

The Phone Interview

https://365datascience.com/courses-section/the-phone-interview/ -

Here, you will learn what to expect in data science phone interviews and discover some of the proven techniques on how to prepare for and succeed through this phase.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Get an Interview

https://365datascience.com/courses-section/get-an-interview/ -

This section gives you a succinct overview of how candidates get selected, how networking can increase your chances, and how to leverage your existing resources into a data science interview opportunity.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

The Resume

https://365datascience.com/courses-section/the-resume/ -

Here, you will learn how to organize your resume, both virtual and hard copy, as well as what you should include to make a lasting impression on prospective employers. The section also includes a downloadable resume template – a great starting point if you haven’t created a data science resume yet.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

The Project Portfolio

https://365datascience.com/courses-section/the-project-portfolio/ -

In this section, you will understand what makes a good data science project, what types of data science projects you should do, and how to organize your projects into a portfolio on Kaggle or GitHub to make them appealing to employers.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Course Intro: What Is Data Science

https://365datascience.com/courses-section/course-intro-what-is-data-science/ -

An overview of the whole data science job market. The section covers the technical and non-technical skills you need, types of roles in data science, the interview process structure, as well as what employers look for in a candidate.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

The In-Person Interview

https://365datascience.com/courses-section/the-in-person-interview/ -

A detailed walk-through of the three different types of interviews – the behavioral, the in-person assessment, and the technical questions. This section comprises the best tips on how to ace the in-person interview and introduces you to the Briefcase Method – an interviewing technique that will certainly set you apart.




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Reduce video quality

https://365datascience.com/dwqa-answer/answer-for-reduce-video-quality/ -

Hi Hamza,

Unfortunately, at this point, our system does not support the choice of video quality.

Best,

Iliya




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Tuesday, August 4, 2020

Answer for Koreee

https://data365.test/dwqa-answer/answer-for-koreee-3/ -

Bagaaa




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for How to Write SQL Subqueries

https://data365.test/dwqa-answer/answer-for-how-to-write-sql-subqueries/ -

sdf sdfsd f




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for MySQL Trigger - ROLLBACK not working

https://365datascience.com/dwqa-answer/answer-for-mysql-trigger-rollback-not-working/ -

Hi Maros J!

Thanks for reaching out.

Can you please check if the Autocommit button has been pressed while you have been working with these queries?


This will mean the autocommit mode will have been disabled.

Once you do that, you can retry running your queries.

Hope this helps.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Video problems - delays or pauses

https://365datascience.com/dwqa-answer/answer-for-video-problems-delays-or-pauses/ -

Hi Simon!

Thanks for reaching out.

We are sorry for this inconvenience. Can you please try using another browser? If you’ve tried that, does the issue persist? Thank you.

Hope this helps.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Printing strings using "Print" function

https://365datascience.com/dwqa-answer/answer-for-printing-strings-using-print-function/ -

Hi Archisman!

Thanks for reaching out.

In such a situation, we may want to help ourselves by using a backslash.


print('I\'m "OK".')

Hope this helps.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Advanced Excel - Personal Question

https://365datascience.com/dwqa-answer/answer-for-advanced-excel-personal-question/ -

Hi Pablo!

Thanks for reaching out.

If I understand your goal correctly, I think that you can perhaps have an extra sheet where you can store this entire information (by referencing the different sheets that represent different markets), and then filter by market.

Then, having a formula that displays the name of the Sheet (I think it may depend on the version of Excel you are using, but INDEX(SheetName, cell-reference) should be displaying the correct output.

In any case, this is a great idea for an exercise, so thank you very much for asking this question!

Hope this helps.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for F5+ENTER

https://365datascience.com/dwqa-answer/answer-for-f5enter/ -

Hi Mohd!

Thanks for reaching out.

Can you please show us the formula written in the relevant code cells, so that we can explore if the references are correct?

In the meantime, please double-check that you have un-ticked Allow editing directly in cells from File/Excel Options/Advanced. Thank you.

Hope this helps.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Monday, August 3, 2020

Answer for Python bootcamp - Dictionaries

https://365datascience.com/dwqa-answer/answer-for-python-bootcamp-dictionaries/ -

Hi there,

It seems to me that the script is working correctly.

It is counting all the lower letters ‘i’, rather than all letters ‘I’. 

Let me know if I am missing something!

Iliya




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Multiple Linear Regression

https://365datascience.com/dwqa-answer/answer-for-multiple-linear-regression/ -

Hi Kannan,

Multiple linear regression is indeed in the scope of the program, therefore we will be addressing it.

How can we help you?

Iliya




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Oluwabunmi

https://365datascience.com/dwqa-answer/answer-for-oluwabunmi/ -

Hi there,

Thanks for reaching out.

Could you please elaborate on ‘videos are not playing’? If you could provide a screenshot that would be great!

Regarding the payments, we provide a subscription service. Therefore, to have access to the courses you’ll be making a payment each month, or once per year (which provides a 20% discount). 

At the end, once you have completed all courses, you will receive a certificate of completion that could be verified on accredible.com. 

Best,

The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Friday, July 31, 2020

Answer for Quiz: Null vs Alternative (Question 1)

https://365datascience.com/dwqa-answer/answer-for-quiz-null-vs-alternative-question-1/ -

Hi Harold,

Thanks for reaching out.

There is one more important consideration. The equality sign is always included in the null hypothesis. That is why they are reversed!

Best,

The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for ValueError

https://365datascience.com/dwqa-answer/answer-for-valueerror/ -

Hi there,

Well, the function is expecting a 2D array. 

Therefore, to achieve the desired result, please write: reg.predict([[3200]]).

Best,

The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Wednesday, July 29, 2020

Answer for Accuracy of the model exercise

https://365datascience.com/dwqa-answer/answer-for-accuracy-of-the-model-exercise/ -

Hi Lisa,

Absolutely correct – this is an omission on our side!

We have now reworked the resources and reuploaded them!

Best,

The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Do we use z-score or t-score when we have a large number of data with unknown population variance?

https://365datascience.com/dwqa-answer/answer-for-do-we-use-z-score-or-t-score-when-we-have-a-large-number-of-data-with-unknown-population-variance/ -

Hi Harold,

Thanks for reaching out.

When we have unknown population variance we normally use the T-statistic.

However, after 100 degrees of freedom (when the sample is bigger than approximately 100), the T-table and the Z-table practically coincide. Therefore, it doesn’t really matter which one you use. 

The T distribution is developed to mimic the Normal distribution for small sample sizes. Therefore, it is no surprise that with more than 100 observations (when the sample becomes large enough) the two coincide (the T-distribution perfectly mimics the Normal distribution).

Best,

The 365 Team 




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Statistic

https://365datascience.com/dwqa-answer/answer-for-statistic/ -

Hi Archisman,

Thanks for this question.

We are rounding the numbers up, because if we get a confidence interval from (2,5.4), this would be mathematically rounded to 5, right? 

However, anything from 5.0 until 5.4 would require 6 pairs of shoes. Therefore, it makes sense to round the number of pairs up!

Best,

The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Data science future in Manufacturing Industry

https://365datascience.com/dwqa-answer/answer-for-data-science-future-in-manufacturing-industry/ -

Hi there,

Unfortunately, we cannot really give you great insight on the topic as this is a rather specific case. However, after researching for a bit I think I found these useful links:


  1. Pivoting My Career from Mechanical Engineer to Data Scientist

  2. Advice From A Mechanical Engineer Considering Data Science

  3. How a mechanical engineer transitioned to a data analyst role.

Best,

The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for How to create a histogram chart in Excel with numerical intervals?

https://365datascience.com/dwqa-answer/answer-for-how-to-create-a-histogram-chart-in-excel-with-numerical-intervals/ -

Hi Gergely,

Please refer to the course notes available with this lecture: https://365datascience.teachable.com/courses/233979/lectures/3710927

There, you will find detailed instructions on how to achieve that.

Best,
The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Students T statistic

https://365datascience.com/dwqa-answer/answer-for-students-t-statistic/ -

Hi Archisman,

This is the standard error for a case, where we’ve got pooled variance.

Best,
The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Couldn't install VSCode with Anaconda

https://365datascience.com/dwqa-answer/answer-for-couldnt-install-vscode-with-anaconda/ -

Hi Jason,

Have you considered using pip?


pip install vscode-dl

should do the trick!

The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for How many nodes should exist within a hidden layer of a neural network?

https://365datascience.com/dwqa-answer/answer-for-how-many-nodes-should-exist-within-a-hidden-layer-of-a-neural-network/ -

Hi John,

Thanks for reaching out.

The number of nodes in a hidden layer can vary. There is no “rule” to determine it.

There is one big consideration though! If you have 5 input nodes and you have 2 nodes in the consequent hidden layer, you are not creating information, you are decreasing the dimensionality of the problem (thus losing information). Therefore, in general, we want to have more hidden nodes in the hidden layers than there are nodes in the input layer. 

This is also the reason why in all pictures we represent the hidden layers with more nodes than the input layer.

Best,

Iliya




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for How do dummy variables meet the linearity assumption?

https://365datascience.com/dwqa-answer/answer-for-how-do-dummy-variables-meet-the-linearity-assumption/ -

Hi Varun, Thanks for reaching out. First of all, price-size is obviously alright, so I won\’t comment on it. Second, you can use a parameter called \’alpha\’ when plotting and set it to a number between 0 and 1, e.g. alpha = 0.5 to see the actual density of the points. Third, when we have a relationship like price and view. Since view is a dummy variable, the linearity assumption does not need to hold. It is included in the regression in a different way (that is why it is called a \’dummy\’ / indicator it is not a real variable and does not need to be treated like one). So linearity is fine. Finally, we\’ve got year. You have correctly identified that it behaves strangely. It behaves more like a dummy rather than a continuous variable, right? And that is precisely the case. If we had the interval from 1900 to 2010 then it would have looked linear. However, if you have just a couple of years like in this example, then you could treat it as a categorical variable (and create several dummies). This is not uncommon practice! Iliya  




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Unable to load packages on R studio

https://365datascience.com/dwqa-answer/answer-for-unable-to-load-packages-on-r-studio/ -

Hi Abdul, 

thanks for reaching out! Did you install the packages prior to loading them?

If you’re using a package for the first time in R, you should install it prior to using it. You can do so, by running the following code either in your console or from your script:

install.packages(“psych”)

to install the psych package and same procedure for any remaining package which you’re using for the first time.

Keep in mind that you only need to install the package one time before you can start using it. After that you can just refer to the library(“psych”) without the need for installing it every time.

 

 

Best, 

365 Eli 




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Matrix multiplication

https://365datascience.com/dwqa-answer/answer-for-matrix-multiplication/ -

Hi Lisa, 

to be honest with you, the phrasing on the question could be a bit more precise. 

What is meant in b) is: You multiply two incompatible matrices. 

Because of course, matrix multiplication of matrices A * B, requires A to have dimensions of (mxn) and B to be of size (nxm) for them to be compatible. This of course means that if m and n are not equal, the matrices are of different sizes, multiplying them however, requires no recycling.

In addition, the answer in a) should read : You multiple a matrix by a vector, when the two are incompatible

For instance, multiplying a mxn matrix by a nx1 vector requires no recycling.


Thanks for asking the question and sorry for the confusion!


 

Best, 

365 Eli




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Frequency Distribution Table

https://365datascience.com/dwqa-answer/answer-for-frequency-distribution-table/ -

Hi Mark,

Thanks for reaching out.

First of all, if you want to attach a screenshot, you can always use a service such as Imgur: https://imgur.com/. Other than that, as a ‘Super learner’ you should be able to upload directly, too.

When you copy-paste the formula, you should make sure that the references are correct. Could you please provide a screenshot of the formula here?

Iliya




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for How to Install TensorFlow 2 in Anaconda

https://365datascience.com/dwqa-answer/answer-for-how-to-install-tensorflow-2-in-anaconda/ -

Hi Lawal,

Have you tried running both:


conda install tensorflow

and 


pip install tensorflow

Sometimes the distribution is not found in one place, but is at the other. Generally, if you can find a package on https://pypi.org/ you can then install it with pip.

Best,

Iliya




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for English subtitles

https://365datascience.com/dwqa-answer/answer-for-english-subtitles/ -

Hi Claudio,

Thanks for reaching out.

At this point we have placed subtitles only under some of the videos. Note that we are actively working on updating our learning management system and we will aim to have subtitles for all videos then.

Best,
Iliya




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Creating a Table - Problem with de sheet

https://365datascience.com/dwqa-answer/answer-for-creating-a-table-problem-with-de-sheet/ -

Hello, Kendell !

First, you have to make sure that you have the “Clened with Data Interpreter” box ticked:


Then, you must change the Period field to “String” before typing the formula.

Hope this helps!

Best,

The 365 Team 




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Tuesday, July 28, 2020

Answer for further steps in learning DS after this course

https://365datascience.com/dwqa-answer/answer-for-further-steps-in-learning-ds-after-this-course/ -

Hi Emin!

Thanks the very kind words and reaching out.

Thank you also for asking us about such an important subject – the future steps to make in your career as a Data Scientist.

I must say that what I will say will only be my personal idea and will perhaps help as a few guidelines or, rather, things to consider as next steps or while making your next steps. Regardless of that, any final decision will be yours and I am sure will depend on multiple factors such as the precise syllabus of the courses you are about to do or the reputation of the institution you intend to go to.

Let me first say that studying CS is a great material and skill set to build on should you wish to become a Data Scientist. This will give strong fundamentals in writing your own code at a higher level.

DS and ML are disciplines that are also extremely needed today and being proficient in them is a huge advantage. However, to be able to excel in your work in DS or ML, it is best for you to have decided to focus more on the quantitative and analytic part of Data Science, as opposed to the programming one. 

So, it rather is up to you, and I’d say wherever you feel more confident and willing to improve, perhaps that should be the area to approach.

Regarding the 365 Program – that’s exactly why we created it! We wanted to provide a centralised Program that can always help you to set on the right track. Therefore, completing the topics or even just checking on most of the topics will help you obtain a better idea on what to do text.

Furthermore, please don’t forget that we are always aiming to import more content in the Program. So, while you are moving forward, there will always be some new content added on our list, helping you to further enrich your skillset.

Hope this helps.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for If Python of the library has enormous packages, why we still need to use R, SQL, Tableau, and Power BI?

https://365datascience.com/dwqa-answer/answer-for-if-python-of-the-library-has-enormous-packages-why-we-still-need-to-use-r-sql-tableau-and-power-bi/ -

Hi Yanhao!

Thanks for reaching out.

Please accept my apologies for the delayed response.

This is a great question indeed. 

Usually, each tool has its advantages and disadvantages, as well as areas where it is strong and such where it is not that applicable.

An advantage (and theoretically sometimes a disadvantage) for R and Python is the fact that they are open-source. Therefore, they are accessible to millions of people and allow you to do analysis and analytics and practically no cost.

They are not the tools that are best for working with relational database management systems. In fact, SQL is the language that has been designed to do that. This means it has greater capacity to deliver specific parts of the given data set when the tables in it have been related in a specific way.

Power BI and Tableau join the picture with another very strong ability – they can very quickly interrelate and integrate the work of several software tools, as well as provide you with a very large set of visualisations that you can quickly and efficiently create.

Therefore, each software can be used for obtaining a different goal. Moreover, sometimes different software tools can be integrated to solve more complicated tasks. As a matter of fact – that’s what we’ll do later in the Program – we’ll show you later how to integrate Python, SQL, and Tableau to solve a certain business task.

Hope this helps.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for question with the the part of SQL+tableau in chart 2

https://365datascience.com/dwqa-answer/answer-for-question-with-the-the-part-of-sqltableau-in-chart-2/ -

Hi Yanhao!

Thanks for reaching out.

I am sorry to have missed answering your question earlier. Please accept my apologies for the delayed response. 

The reason is sticking to best practices. In this example, the primary key of t_departments is the dept_no column, not dept_name

The idea is that theoretically, the same department names may have been used for different department numbers (although this is not logical, is highly unlikely, and is not what what happens in the t_employees database, it might happen by mistake and our code can be prepared for sorting the problem in such a scenario). That’s why GROUP BY the primary key column , which is dept_no.

To prove this, please feel free to refer to the DDL tab of the t_departments table.


CREATE TABLE `t_departments` (
`dept_no` char(4) NOT NULL,
`dept_name` varchar(40) NOT NULL,
PRIMARY KEY (`dept_no`),
UNIQUE KEY `dept_name` (`dept_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

Hope this helps.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Functions, dictionaries & while

https://365datascience.com/dwqa-answer/answer-for-functions-dictionaries-while/ -

Hi Andre!

Thanks for reaching out.

The function returns a single value. So, if you execute Price_while(5), you will be referring to the “lasagna” as you say. It is the only meal whose price is greater than or equal to 5, therefore we have 5*10=50 currency units spent.

Then, if you execute Price_while(4), you will be referring to the price spent for a box of spaghetti, which will be 4*6=24.

To obtain the result from the lecture, please use the code provided there. Thank you.

Hope this helps but please feel free to get back to us should you need further assistance. Thank you.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for SQL Stored Procedures OUT, User-Defined Functions - Question regarding Query

https://365datascience.com/dwqa-answer/answer-for-sql-stored-procedures-out-user-defined-functions-question-regarding-query/ -

Hi Maros!

Thanks for reaching out.

Since the data in our database has been organised perfectly well, your intuition should be perfectly correct. 

We’ve written the query this way because it is supposed to work even if the salaries table contains employee numbers that have not been present in the employees table. 

Therefore, please feel free to share your query with the Community since in our case, your query is expected to deliver identical results.

Hope this helps.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Question of certificate

https://365datascience.com/dwqa-answer/answer-for-question-of-certificate/ -

Hi Elegbede,

The certificate is typically awarded at the end of the course. 

You can find full information regarding that here: https://365datascience.com/certificate/

Best,

The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for Loan_Data CSV files do not contain data needed for exercises (Credit Risk Modeling)

https://365datascience.com/dwqa-answer/answer-for-loan_data-csv-files-do-not-contain-data-needed-for-exercises-credit-risk-modeling/ -

Hi Don,

You can find all necessary files at this location: https://www.dropbox.com/sh/7oslws1xhsm1zbf/AABkdWDKqpdcGmY1NbXAnkrBa?dl=0

Best,

The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

Answer for problem while installing tensorflow 2.0

https://365datascience.com/dwqa-answer/answer-for-problem-while-installing-tensorflow-2-0/ -

Hi there,

Please try updating all conda and all conda packages.

To achieve that, please write:


conda update conda

and then


conda update --all

Let us know if it worked for you!

Best,

The 365 Team




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy