Submit your inspiring success story or innovative use case to the 2022 Dataiku Frontrunner Awards! ENTER YOUR SUBMISSION

Core Designer Certificate

Solved!
Data_Optimist
Level 2
Level 2
Core Designer Certificate

Hi Experts,

 

I am new in DataIku, just passed 101, 102, 103 learning passes, and am already fascinated by unlimited capabilities, which the platform gives to non-coding analysts. It`s gorgeous!

Now I am passing Core Designer Certificate exercise and stuck on Hands-On instructions step 5 :

"Some columns ( Oil production (Etemad & Luciana) (terawatt-hours), meat_prod_tonnes, and Food Balance Sheets: Eggs - Production (FAO (2017)) (tonnes) ) report country total data. Transform these three columns into per-capita data."   

I applied  formula: "numval("Oil production (Etemad & Luciana) (terawatt-hours)") / numval("Population), but it`s not correct.

I tried to find correct formula to apply for this task, checked the materials, provided on the "Formula page" reference, but cannot work out right formula.

Can you please help me to resolve this formula?

Many thanks.

Respectfully,

Vyacheslav

0 Kudos
2 Solutions
tgb417
Neuron
Neuron

@Data_Optimist 

when you say your formula is not correct.  What do you mean

- the formula is producing a error message.  If so what is the error message.  
- or are the numeric results incorrect.

In the example above I notice an extra quote mark “ before the formula.  I also note you are missing a quote mark “ after population and before the closing parenthesis ). 

--Tom

View solution in original post

0 Kudos
tgb417
Neuron
Neuron

@Data_Optimist 

Regarding univariate analysis, I’m not clear exactly what type of data you are working with or which type(s) of univariate analysis you are trying to do.  

That being said there are a bunch of tools built into Dataiku for exploratory data analysis that might be useful to you. As a starting point you might find the statistical worksheets to be useful. Here is a knowledge base article on the use.

https://knowledge.dataiku.com/latest/courses/statistics/univariate-bivariate/perform-univariate-anal... 

Here is a link to the documentation.

https://doc.dataiku.com/dss/latest/statistics/index.html 

You can do all sorts of other types of analysis with Dataiku and then even more type using R Jupiter notebooks and Python.  

Have fun with your data.

--Tom

View solution in original post

8 Replies
tgb417
Neuron
Neuron

@Data_Optimist 

when you say your formula is not correct.  What do you mean

- the formula is producing a error message.  If so what is the error message.  
- or are the numeric results incorrect.

In the example above I notice an extra quote mark “ before the formula.  I also note you are missing a quote mark “ after population and before the closing parenthesis ). 

--Tom
0 Kudos
Data_Optimist
Level 2
Level 2
Author

Good day, Tom,

@tgb417 

Thanks a lot for your feedback and suggestions.

I adjusted the formula syntax details as was recommended and it worked out well. 

Your help is highly appreciated.

Now could you please advise where I can find explicit instructions how to create an univariate analysis?

Thanks in advance,

Vyacheslav 

tgb417
Neuron
Neuron

@Data_Optimist 

Regarding univariate analysis, I’m not clear exactly what type of data you are working with or which type(s) of univariate analysis you are trying to do.  

That being said there are a bunch of tools built into Dataiku for exploratory data analysis that might be useful to you. As a starting point you might find the statistical worksheets to be useful. Here is a knowledge base article on the use.

https://knowledge.dataiku.com/latest/courses/statistics/univariate-bivariate/perform-univariate-anal... 

Here is a link to the documentation.

https://doc.dataiku.com/dss/latest/statistics/index.html 

You can do all sorts of other types of analysis with Dataiku and then even more type using R Jupiter notebooks and Python.  

Have fun with your data.

--Tom
Data_Optimist
Level 2
Level 2
Author

Tom,

Thank you very much for prompt response.

I find it very useful!

Cheers

Data_Optimist
Level 2
Level 2
Author

@tgb417 

Dear Tom,

I want to share with you my Core Designer Certificate : https://verify.skilljar.com/c/oa9qsjrrc5o7.

Thanks a lot again for your kind contribution in my very 1st DSS mastering achievement.

There is more to come.

Respectfully,

Vyacheslav 

tgb417
Neuron
Neuron

@Data_Optimist 

Excellent to see your achievement.

What studies do you plan to take on next?

--Tom

--Tom
0 Kudos
Data_Optimist
Level 2
Level 2
Author

@tgb417 tgb

Hi Neuron,

Thank you very much for your endorsement, motivates me well! 🙂

My next target is ML Practitioner Certificate!

Respectfully.

umesh_shukla
Level 1

Congratulations buddy,

I am also trying to complete this certification and stuck on same step.

Could you help me out

0 Kudos