35. Data Analytics - Google Data Analytics Capstone Case Study - Week 3

 Sharing your portfolio and case study.


Definitions:

Elevator pitch // a short statement describing an idea or concept


Tips:

Remember your audience and what they're interested in.

In portfolio, focus on process more than results.

Use case studies to highlight your skills.

Build a network.


Interview process:

    1. Introduction (resume and portfolio) // assess your background

    2. The skill test interview (case study) // test SQL and programming skills on a case study

    3. The compatibility interview (optional) // checks if you can work with team members

    4. Decision-making // hiring decision step. takes 4-6 weeks.


Tips for interview success:

        1. Find connections between the job listing and your resume

        2. Focus on data // use PAR (problem, action, result) and XYZ (accomplished, measured by, by

            doing)

        3. Look back at past work experiences // understand what you do to answer experience questions

        4. Come ready with questions


Interview questions examples:

    Technical questions

            “What are your preferred tools for analysis?”  This is a chance to demonstrate that you are well-

            versed in data analysis, with proficiency in SQL, Excel, and R programming.


            “How do you maintain integrity in your data?”  Reliability and accuracy are essential parts of

            good data analysis, and any issues with your data can have a major impact on data-driven 

            business decisions. Be prepared to discuss the methods you use for error checking and

            validation.


            “Do you understand different SQL functions and the roles they play?”  SQL is arguably one of

            the most important skills for you to have as a data analyst. This is an opportunity to demonstrate

            your understanding of different types of SQL functions and their value or result.


    Personal experience questions

            “Was there a time when you took initiative during a project and what was the outcome?” This

            question can come in many forms with slightly different wording, but the goal is to understand

            your leadership abilities and how you have used them in the past. 


            “What was the most challenging project you have ever been faced with?” This question is

            usually meant to assess your problem-solving and interpersonal skills. Come to the interview

            prepared with several different examples of how you successfully navigated a difficult project

            or situation in the past. 


            “How would you explain a complex topic to a stakeholder who was unfamiliar with it?” This

            question helps your interviewer get a sense of how skilled you are at communicating effectively

            in high-pressure or sensitive circumstances.


            “How do you cope when things don’t go according to plan?” It is important to be adaptable,

            especially when things don’t go the way you expected. This question provides a great

            opportunity for you to explain how you coped with unexpected changes and adapted quickly to

            a different course of action.

Comments

Post a Comment

Popular posts from this blog

2. FreeCodeCamp - Dynamic Programming - Learn to Solve Algorithmic Problems & Coding Challenges

Dynamic Programming - Parts      PART 1 - Memoization     P ART 2 - Tabulation Dynamic Programming with Fibonacci Example Recursion: Slow because time complexity is O(2^n) func fibR (x int ) int {     if x <= 2 {         return 1     }     return fibR (x- 1 ) + fibR (x- 2 ) } Dynamic Way Example Recursion with Stored Value:  // Fast because it removes duplicate processes by checking map. // Tail recursion-ish // Results are hitchhiking each recursive call func fibR2 (x int , y map [ int ] int ) int {     if _ , ok := y[x]; ok {         return y[x]     }     if x <= 2 {         return 1     }     y[x] = fibR2 (x- 1 , y) + fibR2 (x- 2 , y)     return y[x] }
Read more

20. Data Analytics - Analyze Data to Answer Questions - Week 1

Goal of analysis is to identify trends and relationships within data so you can accurately answer the questions you're asking. Most data is organized in tables, always have data in the right format. Definition : Analysis // process used to make sense of the data collected Sorting // involves arranging data into a meaningful order to make it easier to understand, analyze, visualize Outliers // data points that are very different from similarly collected data and might not be reliable values Filtering // extracting specific data that meet certain criteria while hiding the rest Customized sort order // when you sort data in a spreadsheet using multiple conditions The 4 phases of analysis:          1. Organize data // getting the right data in the right size and order                     - Sorting : arrange data in meaningful order                     - Filtering : can help find errors or outliers          2. Format and adjust data // filtering or sorting or compiling data in a better
Read more

3. Algorithms - Selection Sort

Selection sort sorts an array by finding the lowest value element and appending it to an empty array. The algorithm will shrink the unsorted array and repeat the process recursively until all unsorted elements are used up. package main func selectionSort (list *[] int ) {     sorted := make ([] int , 0 , len (*list))     unSorted := *list     for i := 0 ; i < len (*list); i++ {         min := unSorted[ 0 ]         index := 0         for i , e := range unSorted {             if e <= min {                 min = e                 index = i             }         }         sorted = append (sorted, (unSorted)[index])         if index == 0 {             unSorted = unSorted[ 1 :]         } else if index == ( len (*list) - 1 ) {             unSorted = unSorted[:index]         } else {             unSorted = append (unSorted[ 0 :index], unSorted[index+ 1 :]...)         }     }     * list = sorted } /*func main() {     x := []int{4, 6, 3, 2, 9, 7, 3, 5}     fmt.Print
Read more