107 Data Studio courses

Register on the Google Data Studio today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Google Data Studio is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! WHAT YOU GET WITH THE GOOGLE DATA STUDIO  * Receive a e-certificate upon successful completion of the course * Get taught by experienced, professional instructors * Study at a time and pace that suits your learning style * Get instant feedback on assessments  * 24/7 help and advice via email or live chat * Get full tutor support on weekdays (Monday to Friday) COURSE DESIGN The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of * Video lessons * Online study materials CERTIFICATION Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. WHO IS THIS COURSE FOR: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. REQUIREMENTS: The online training is open to all students and has no formal entry requirements. To study the Google Data Studio, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. COURSE CONTENT Google Data Studio Module 01: Introduction to GDS 00:36:00 Module 02: Data Visualization 01:29:00 Module 03: Geo-visualization 00:16:00 Module 04: A Socio-Economic Case Study 00:20:00 FREQUENTLY ASKED QUESTIONS Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

COURSE OVERVIEW: According to the World Economic Forum, data analysts will be among the most in-demand professions by 2025. This Basic Google Data Studio course takes you on an enlightening journey, illuminating the intricate world of Google Data Studio from the ground up. The Basic Google Data Studio course is your stepping stone into data visualisation, geo-visualization, and in-depth socio-economic analysis. With four comprehensive modules, this curriculum is crafted to impart the foundational principles and techniques of Google Data Studio, ensuring learners possess the proficiency to translate raw data into meaningful insights. Enrol Today and Start Learning! -------------------------------------------------------------------------------- KEY FEATURES OF THE COURSE: The Basic Google Data Studio course boasts an array of appealing features, including a CPD certificate upon completion, marking your journey into mastering Google Data Studio. 24/7 Learning Assistance ensures you can absorb the course material at your own pace, whenever it suits you best. Expect exciting learning materials that make mastering data visualisation a stimulating and enjoyable endeavour. -------------------------------------------------------------------------------- WHO IS THIS COURSE FOR? This Basic Google Data Studio course is designed for anyone inclined towards data and interested in visual storytelling. Whether you're a business owner looking to make informed decisions, a student eyeing a future in data analysis, or a data enthusiast, this course could be the perfect fit. -------------------------------------------------------------------------------- WHAT YOU WILL LEARN: * Introduction to Google Data Studio and its features. * Navigation and interface overview of Google Data Studio. * Creating reports using different data sources. * Converting data into visually appealing graphs and charts. * Exploring geographic data visualisation techniques. * Uncovering hidden geographic trends through data visualisation. * Applying the learned skills to real-world socio-economic case studies. -------------------------------------------------------------------------------- WHY ENROL IN THIS COURSE: This Basic Google Data Studio course consistently receives top reviews from its participants. Recently updated with the latest trends and practices in data visualisation, this course ensures you stay on top of industry shifts. By enrolling in this course, you will develop indispensable skills in data analysis and visual storytelling. -------------------------------------------------------------------------------- REQUIREMENTS: This course requires a fundamental understanding of data analysis concepts. Internet access is required to practise Google Data Studio and access course materials. -------------------------------------------------------------------------------- CAREER PATH: Upon completing this Basic Google Data Studio course, you can look forward to opportunities in various data-focused professions. Such as * Data Analyst * Business Intelligence Developer * Marketing Analyst * SEO Specialist * Data Scientist * Data Visualisation Specialist * Report Analyst In the UK, these roles offer attractive salary packages ranging from £25,000 for entry-level positions to over £60,000+ for more advanced roles. -------------------------------------------------------------------------------- CERTIFICATION: Upon successful completion of the Basic Google Data Studio course, you will be awarded a CPD certificate as proof of your proficiency in Google Data Studio. -------------------------------------------------------------------------------- COURSE CURRICULUM 1 sections • 4 lectures • 02:41:00 total length •Module 01: Introduction to GDS: 00:36:00 •Module 02: Data Visualization: 01:29:00 •Module 03: Geo-visualization: 00:16:00 •Module 04: A Socio-Economic Case Study: 00:20:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

OVERVIEW This comprehensive course on Google Data Studio: Data Analytics will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Google Data Studio: Data Analytics comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. HOW WILL I GET MY CERTIFICATE? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. WHO IS THIS COURSE FOR? There is no experience or previous qualifications required for enrolment on this Google Data Studio: Data Analytics. It is available to all students, of all academic backgrounds. REQUIREMENTS Our Google Data Studio: Data Analytics is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. CAREER PATH Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- * Open doors of opportunities * Increase your adaptability * Keep you relevant * Boost confidence And much more! COURSE CURRICULUM 4 sections • 17 lectures • 02:32:00 total length •Course Overview: 00:01:00 •Format Data in Google Sheets: 00:08:00 •Sheet Functions 1: Query & Import Range: 00:07:00 •Sheets Function 2: Vlookup & Defined Range: 00:10:00 •Sheets Function 3: Cross Table Calculations: 00:09:00 •Connect Data to Google Data Studio: 00:04:00 •GDS Calculated Fields: 00:08:00 •GDS Theme Customization: 00:07:00 •GDS Page Layout Design: 00:17:00 •GDS Charts: Scorecards: 00:12:00 •GDS Charts: Time Series Graphs: 00:09:00 •GDS Blending and Joining Data Tables: 00:07:00 •GDS Charts: Bar, Donut, and Treemap: 00:17:00 •GDS Charts: Interactive Filters: 00:08:00 •GDS Project Page Completion: 00:17:00 •GDS Client Page Completion: 00:11:00 •Additional Resources - Google Data Studio: Data Analytics: 00:00:00

Register on the Google Data Studio: Data Analytics today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Google Data Studio: Data Analytics is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! WHAT YOU GET WITH THE GOOGLE DATA STUDIO: DATA ANALYTICS  * Receive a e-certificate upon successful completion of the course * Get taught by experienced, professional instructors * Study at a time and pace that suits your learning style * Get instant feedback on assessments  * 24/7 help and advice via email or live chat * Get full tutor support on weekdays (Monday to Friday) COURSE DESIGN The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of * Video lessons * Online study materials CERTIFICATION Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. WHO IS THIS COURSE FOR: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. REQUIREMENTS: The online training is open to all students and has no formal entry requirements. To study the Google Data Studio: Data Analytics, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. COURSE CONTENT Section 01: Introduction Course Overview 00:01:00 Section 02: Google Sheets Format Data in Google Sheets 00:08:00 Sheets Function 2: Vlookup & Defined Range 00:10:00 Sheets Function 3: Cross Table Calculations 00:09:00 Section 03: Google Data Studio Connect Data to Google Data Studio 00:04:00 GDS Calculated Fields 00:08:00 GDS Theme Customization 00:07:00 GDS Page Layout Design 00:17:00 GDS Charts: Scorecards 00:12:00 GDS Charts: Time Series Graphs 00:09:00 GDS Blending and Joining Data Tables 00:07:00 GDS Charts: Bar, Donut, and Treemap 00:17:00 GDS Charts: Interactive Filters 00:05:00 GDS Project Page Completion 00:17:00 GDS Client Page Completion 00:11:00 FREQUENTLY ASKED QUESTIONS Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

OVERVIEW This comprehensive course on Interactive Dashboards with Data Studio will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Interactive Dashboards with Data Studio comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. HOW WILL I GET MY CERTIFICATE? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. WHO IS THIS COURSE FOR? There is no experience or previous qualifications required for enrolment on this Interactive Dashboards with Data Studio. It is available to all students, of all academic backgrounds. REQUIREMENTS Our Interactive Dashboards with Data Studio is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. CAREER PATH Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. COURSE CURRICULUM 2 sections • 5 lectures • 02:41:00 total length •Module 01: Introduction to GDS: 00:36:00 •Module 02: Data Visualization: 01:29:00 •Module 03: Geo-visualization: 00:16:00 •Module 04: A Socio-Economic Case Study: 00:20:00 •Assignment - Interactive Dashboards with Data Studio: 00:00:00

Boost Your Career By Enrolling In This Google Analytics & Google Data Studio Bundle To Overcome Your Challenges! 6 in 1 Google Analytics & Google Data Studio Bundle Improve your knowledge and enhance your skills to succeed with this Google Analytics & Google Data Studio bundle. This Google Analytics & Google Data Studio bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow. This Google Analytics & Google Data Studio Bundle Contains 6 of Our Premium Courses for One Discounted Price: * Course 01: Google Analytics Beginners and Advanced Course * Course 02: Google Analytics for Everyone * Course 03: Google Data Studio: Data Analytics * Course 04: Learn MySQL from Scratch for Data Science and Analytics * Course 05: Business and Data Analytics for Beginners * Course 06: Introduction to Data Analytics with Tableau All the courses under this Google Analytics & Google Data Studio bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the Google Analytics & Google Data Studio bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want. With this comprehensive Google Analytics & Google Data Studio bundle, you can achieve your dreams and train for your ideal career. This Google Analytics & Google Data Studio bundle covers essential aspects in order to progress in your chosen career. Why Prefer Us for Google Analytics & Google Data Studio? * All-in-one package of 6 premium courses' Google Analytics & Google Data Studio bundle * Earn a certificate accredited by CPDQS. * Get a free student ID card! (£10 postal charge will be applicable for international delivery) * Globally Accepted Standard Lesson Planning * Free Assessments with this Google Analytics & Google Data Studio Bundle * 24/7 Tutor Support available with this Google Analytics & Google Data Studio Bundle Start your learning journey straightaway! This Google Analytics & Google Data Studio's curriculum has been designed by Google Analytics & Google Data Studio experts with years of Google Analytics & Google Data Studio experience behind them. The Google Analytics & Google Data Studio course is extremely dynamic and well-paced to help you understand Google Analytics & Google Data Studio with ease. You'll discover how to master the Google Analytics & Google Data Studio skill while exploring relevant and essential topics. Assessment Process Once you have completed all the courses in the Google Analytics & Google Data Studio bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 60 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? This Google Analytics & Google Data Studio bundle is suitable for everyone. REQUIREMENTS You will not need any prior background or expertise. CAREER PATH This Google Analytics & Google Data Studio bundle will allow you to kickstart or take your career in the related sector to the next stage. CERTIFICATES DIGITAL CERTIFICATE Digital certificate - Included HARD COPY CERTIFICATE Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

COURSE OVERVIEW Google Data Studio is the leading tool for turning data into easily readable and shareable dashboard and reports. It is ideal for small-medium size companies who are looking for simple collaboration solutions. The Basic Google Data Studio course is perfect for beginners who are looking to learn how to carry out data visualisation tasks using this tool.  In this course, you will learn best practices for carrying out data visualisation tasks in Data Studio. It will guide you through key procedures such as creating new reports and dashboards, adding charts, configuring report control, using report templates, and sharing your reports. On successful completion of this course, you will be able to visualise and present data efficiently. You will have the core industry skills needed to become a top Data Analyst, with the knowledge required to ensure smooth and effective reporting.  This best selling Basic Google Data Studio has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Basic Google Data Studio is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Basic Google Data Studio is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Basic Google Data Studio is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Basic Google Data Studio, you will be awarded a certificate of completion  as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Basic Google Data Studio will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Basic Google Data Studio to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

COURSE OVERVIEW Make your critical data easier to follow with dashboards displaying the main insights when you train to use Data Analytics with Google Data Studio. Sometimes analysts find that their collated information on Google Sheets is not viewed subjectively by clients or that they take unexpected conclusions from it.  You can learn to eliminate this possibility by utilising the functions of Google Data Studio (GDS), the premier online tool for converting data into customisable informative reports and dashboards for easy perusal. This Data Analytics training provides a total learning curve for GDS and how to get the very best results from it. You will be taught the basic functions of Google Sheets, including queries and calculations. Following this, you will be given a masterclass on GDS itself, from its field calculation abilities to its layout design and accommodating a client's page requirements. With this expert tuition, you will be able to effortlessly format data and underline all of the key findings with a simple click or touch of the screen. Make your data speak volumes with this valuable course. This best selling Data Analytics with Google Data Studio has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Data Analytics with Google Data Studio is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Data Analytics with Google Data Studio is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Data Analytics with Google Data Studio is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Data Analytics with Google Data Studio, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Data Analytics with Google Data Studio will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Data Analytics with Google Data Studio to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Duration 3 Days 18 CPD hours This course is intended for Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform Overview This course teaches students the following skills: Derive insights from data using the analysis and visualization tools on Google Cloud Platform Interactively query datasets using Google BigQuery Load, clean, and transform data at scale Visualize data using Google Data Studio and other third-party platforms Distinguish between exploratory and explanatory analytics and when to use each approach Explore new datasets and uncover hidden insights quickly and effectively Optimizing data models and queries for price and performance Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course! This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing performance, query pricing, and data visualization. This specialization is intended for the following participants: Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform To get the most out of this specialization, we recommend participants have some proficiency with ANSI SQL. INTRODUCTION TO DATA ON THE GOOGLE CLOUD PLATFORM * Highlight Analytics Challenges Faced by Data Analysts * Compare Big Data On-Premises vs on the Cloud * Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud * Navigate Google Cloud Platform Project Basics * Lab: Getting started with Google Cloud Platform BIG DATA TOOLS OVERVIEW * Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools * Demo: Analyze 10 Billion Records with Google BigQuery * Explore 9 Fundamental Google BigQuery Features * Compare GCP Tools for Analysts, Data Scientists, and Data Engineers * Lab: Exploring Datasets with Google BigQuery EXPLORING YOUR DATA WITH SQL * Compare Common Data Exploration Techniques * Learn How to Code High Quality Standard SQL * Explore Google BigQuery Public Datasets * Visualization Preview: Google Data Studio * Lab: Troubleshoot Common SQL Errors GOOGLE BIGQUERY PRICING * Walkthrough of a BigQuery Job * Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs * Optimize Queries for Cost * Lab: Calculate Google BigQuery Pricing CLEANING AND TRANSFORMING YOUR DATA * Examine the 5 Principles of Dataset Integrity * Characterize Dataset Shape and Skew * Clean and Transform Data using SQL * Clean and Transform Data using a new UI: Introducing Cloud Dataprep * Lab: Explore and Shape Data with Cloud Dataprep STORING AND EXPORTING DATA * Compare Permanent vs Temporary Tables * Save and Export Query Results * Performance Preview: Query Cache * Lab: Creating new Permanent Tables INGESTING NEW DATASETS INTO GOOGLE BIGQUERY * Query from External Data Sources * Avoid Data Ingesting Pitfalls * Ingest New Data into Permanent Tables * Discuss Streaming Inserts * Lab: Ingesting and Querying New Datasets DATA VISUALIZATION * Overview of Data Visualization Principles * Exploratory vs Explanatory Analysis Approaches * Demo: Google Data Studio UI * Connect Google Data Studio to Google BigQuery * Lab: Exploring a Dataset in Google Data Studio JOINING AND MERGING DATASETS * Merge Historical Data Tables with UNION * Introduce Table Wildcards for Easy Merges * Review Data Schemas: Linking Data Across Multiple Tables * Walkthrough JOIN Examples and Pitfalls * Lab: Join and Union Data from Multiple Tables ADVANCED FUNCTIONS AND CLAUSES * Review SQL Case Statements * Introduce Analytical Window Functions * Safeguard Data with One-Way Field Encryption * Discuss Effective Sub-query and CTE design * Compare SQL and Javascript UDFs * Lab: Deriving Insights with Advanced SQL Functions SCHEMA DESIGN AND NESTED DATA STRUCTURES * Compare Google BigQuery vs Traditional RDBMS Data Architecture * Normalization vs Denormalization: Performance Tradeoffs * Schema Review: The Good, The Bad, and The Ugly * Arrays and Nested Data in Google BigQuery * Lab: Querying Nested and Repeated Data MORE VISUALIZATION WITH GOOGLE DATA STUDIO * Create Case Statements and Calculated Fields * Avoid Performance Pitfalls with Cache considerations * Share Dashboards and Discuss Data Access considerations OPTIMIZING FOR PERFORMANCE * Avoid Google BigQuery Performance Pitfalls * Prevent Hotspots in your Data * Diagnose Performance Issues with the Query Explanation map * Lab: Optimizing and Troubleshooting Query Performance ADVANCED INSIGHTS * Introducing Cloud Datalab * Cloud Datalab Notebooks and Cells * Benefits of Cloud Datalab DATA ACCESS * Compare IAM and BigQuery Dataset Roles * Avoid Access Pitfalls * Review Members, Roles, Organizations, Account Administration, and Service Accounts