Section outline

    • You’ll learn how to use formulas, functions, and SQL queries as you conduct your analysis. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.

      Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary. By the end of this course, learners will:

      • Learn how to organize data for analysis.
      • Understand the processes for formatting and adjusting data.
      • Explore how to aggregate data in spreadsheets and by using SQL.
      • Use formulas and functions in spreadsheets to make data calculations.
      • Learn how to complete calculations using SQL queries.
    • In this course you will complete the first half of a large scale project developing a comprehensive plan for a complex website by defining the strategy and scope of the site, as well as developing its information architecture and overall structure. Along the way we will also discuss:

      • Different job descriptions in the web design industry and where UX and UI skills fall within this spectrum
      • The difference between native apps and websites
      • The difference of agile vs. waterfall approaches
      • User personas and site personas