The third course in this specialization is Achieving Advanced Insights with BigQuery. Here I build on my growing knowledge of SQL as I dive into advanced functions and how to break apart a complex query into manageable steps. They also covered the internal architecture of BigQuery (column-based sharded storage) and advanced SQL topics like nested and repeated fields through the use of Arrays and Structs. Lastly I dive into optimizing your queries for performance and how you can secure your data through authorized views.

The SQL gets pretty advanced in this stage of the specialization and there's a sneak preview of integrating BiqQuery with Jupyter notebooks and Pandas in the GCP. I'm starting to feel confident that I'll be able to make use of the GCP for my own work. Can't wait for the final course in the specialization which is on Machine Learning!

The instructor for this and the previous 2 courses is BY FAR the BEST instructor from Google so far. he took the time to pause while speaking to allow the student to absorb the concept (too many other instructors are just reading and not teaching).

Course is actually very helpful on understand BigQuery.I learned

Advanced Insights with cloud data lab,Visualization with Google Data Studio,Schema Design and Nested Data Structure and Advanced Functions and clause.

Thank you for teaching.

Excellent course on BigQuery, Dataprep, DataStudio and Dataset Secure Access topics. Hoped to have more on Datalab and Bigquery, and also more difficult labs, but it's ok.

Overall this was a great course with great material.

Thanks!

Useful practical course, especially about performance optimization. Window functions have many options, it would be nice to add window size description with practical examples or links to them.

I really appreciated all of the labs that went along with this course. They were detailed and thorough and led us through some advanced concepts in a digestible, understandable fashion.

It's a very hands on material and the part I like the best is that everything that you learn is something that you can use on your daily basis if you work as a data analyst or similar.

Excellent course; I only wish there were a much longer and more robust lab on optimizing query performance, after all the tips we learned in the corresponding lessons.

Lots of in-depth material covered in this course, including nesting of data structures. Also provides high-level introductions to Google Data Studio and Cloud DataLab.

I learned lots about the structs and arrays and how it could be used to improve performance by creating parent child relationships instead of doing expensive joins

Cloud Datalab, BigQuery and Data studio are pretty impressive as they could all be use to help with marketing datasets and analytics. Now forward we go!

Learnt so much from the course especially how bigquery works, how data sharding is done and assigned to workers and how they work on that parallel.

This course summed up everything that I learned from the previous two courses. It was very helpful to understand the architecture behind BigQuery.

Absolutely important topics such as handling nested fields, query optimization techniques and advanced functions are covered. Excellent content!

Very informative and valuable learning. Enjoyed both the Google specific content as well as the general data analyst content.

Excellent course, material and labs. Congrats for Google professionals and Coursera staff. Keep rockking, cheers!

It was my favorite course. This course is very useful to learn how to join tables and to create a lot of tables.

Very useful cpurse, thank you. Best insights: Data types (Struct, Array), BigQuery architecture and advantages.

Thanks for the course, the lab practices are very useful, would be great if there are any project assignments

This course by Google is just awesome and I keep telling people at work, "No one teaches like Google!"

Very amazing content. Though assignments need to be more challenging. They were very simple.

Very helpful to know advanced SQL querying even if I don't really have to do it myself.

Super GREAT job Evan! This is the most valuable BigQuery courses I've ever learned!

Excelente curso!!!! ... Me gustaría que incrementaran la cantidad de laboratorios.