Big Data Analysis to a Slide Presentation Reviews

Hemanth P. · Reviewed about 6 years ago

Lee N. · Reviewed about 6 years ago

Michel J. · Reviewed about 6 years ago

Shamik c. · Reviewed about 6 years ago

Anders N. · Reviewed about 6 years ago

Ban N. · Reviewed about 6 years ago

A bit too fast all of a sudden with the JavaScript programming. Nonetheless, still great!

Lugas Raka A. · Reviewed about 6 years ago

Ha L. · Reviewed about 6 years ago

Huong L. · Reviewed about 6 years ago

Vivienne W. · Reviewed about 6 years ago

Wow, It´s new to those resources about scripting and sheet and slides avaliables on a Google account.

Esteban G. · Reviewed about 6 years ago

Adolfo G. · Reviewed about 6 years ago

Etsuko K. · Reviewed about 6 years ago

Guys, this is the second time i do this lab and it's really bad bad written and super confusing lab. To start, it may be necessary to access gScript settings to turn on BQ API (i had to spend a lot time trying here and there until i find this was OFF). Then, it's really super super confusing all this wording. You guys may, for instance, take code lines to provide instructions as they move forward (place this code at line x because it will bla bla bla), or sketch where things goes in a map so people can figure it out the where things go and the why they need to be done that way. I place it amongst top 3 most frustrating labs i've ever done. Thanks. ---- Gosh, i can't do a decent score in Next 20 with this lab. More inputs: This is where things start to get out of track. What the hell do you guys mean with "tweak app"??? 2. Return spreadsheet: In the above code, createColumnChart() needs the spreadsheet object, so tweak app to return spreadsheet object so it can pass it to createColumnChart(). After logging the successful creation of the Google Sheet, return the object at the end of runQuery(). Replace the last line (starts with Logger.log) with the following: --- Isn't logical segregation so fancy and cute??? 3. Drive createBigQueryPresentation() function: Logically segregating the BigQuery and chart-creation functionality is a great idea. Create a createBigQueryPresentation() function to drive the app, calling both and createColumnChart(). --- What log line? No one read about a "log" immediately previously to this to be written. Why not include this instruction a couple paragraphs before, where changes already affects the logger.log line? To make runQuery() more digestible for general use, move that log line. The best place to move it? If you guessed createBigQueryPresentation(), you'd be correct! --- At this moment in time, there are 2 createColumnChart() functions: one at createBigQueryPresentation() function (Runs a BigQuery query, adds data and a chart in a Sheet) and another one in the createColumnChart(spreadsheet) function (Uses spreadsheet data to create columnar chart)... where it goes? All of the work on the slide deck takes place in the createSlidePresentation() function, which you add to bq-sheets-slides.gs right after the createColumnChart()function code. --- When i land here: 2. Add data table: The next step in createSlidePresentation() is to import the cell data from the Google Sheet into our new slide deck. Add this code snippet to the createSlidePresentation()function: I'm so damn furious of this lab that i just wanna puke ! --- On this one, you guy have a closing parenthesis: 3. Import chart: The final step in createSlidePresentation() is to create one more slide, import the chart from our spreadsheet, and return the Presentation object. Add this final snippet to the function: But you don't have an opening one :)))) --- on this instruction: 5. Update createBigQueryPresentation(): Since createColumnChart() returns the chart, you need to save that chart to a variable then pass both the spreadsheet and the chart to createSlidePresentation(). It funny because it's an instruction that operates over a previous instruction (the one to add the Logger.log). You guys are genious of this world. Can't this be simplified???

Américo A. · Reviewed about 6 years ago

Pujan T. · Reviewed about 6 years ago

Linh V. · Reviewed about 6 years ago

great but I have problems with the server

Rebeca P. · Reviewed about 6 years ago

Excellent introduction to appscript and gsuite services.

Ramakrishna R. · Reviewed about 6 years ago

Kamalesh N. · Reviewed about 6 years ago

Tahir M. · Reviewed about 6 years ago

Michel J. · Reviewed about 6 years ago

Roberto M. · Reviewed about 6 years ago

Jonathan S. · Reviewed about 6 years ago

Mohamed Y. · Reviewed about 6 years ago

Andrey T. · Reviewed about 6 years ago