Skip to content
Home » Google Career Certificates » Google Business Intelligence Professional Certificate » Decisions, Decisions: Dashboards and Reports » Module 5: Course 3 end-of-course project

Module 5: Course 3 end-of-course project

You’ll finish working on your portfolio project by building a BI dashboard. You’ll refer to key BI documents to create a low-fidelity mockup, design charts, and organize your dashboard. Your portfolio artifacts will include a mockup and a working dashboard, which will be ready to present to stakeholders.

Learning Objectives

  • Present a end-to-end business intelligence case study through a complete portfolio
  • Apply knowledge of business intelligence, data pipelines, and dashboards
  • Develop a dashboard in Tableau

Apply your skills to a workplace scenario


Welcome to module 5

This course will help you complete your end-of-course project by loading reporting tables into a visualization software to create a BI dashboard. You will track your approach, methods, accomplishments, and transferable skills so that you can add this information to your portfolio. When you finish this step of the project, you will have a complete end-to-end business intelligence case study. This will help you demonstrate your BI knowledge during interviews and networking opportunities.

Throughout this program you’ve developed essential
skills in business intelligence. You also learned about the importance of building a portfolio that
demonstrates your abilities and accomplishments. Now it’s time to return to
your end-of-course project. In earlier courses, you worked on a BI project that you can
showcase in your portfolio. You created key BI documents and a data pipeline to
practice producing deliverables for a business scenario. From these projects, you now have fully usable data that you can visualize in a dashboard. In this course you learned how to plan,
build, and present dashboards. Equipped with these new skills, you can now complete your
end-of-course project. Now, you’ll load those reporting tables into a visualization software to highlight important
insights with a BI dashboard. You’ll continue to track
your approach, methods, accomplishments, and transferable skills so that you can add this
information to your portfolio. When you finish this step of the project you will have a complete
end-to-end business intelligence case study. This will help you
demonstrate your BI knowledge during interviews and
networking opportunities which will be essential to
landing your first BI job. Future employers and business contacts
will understand how hard you worked to develop your skills. As you begin this project, know that you can go at your own pace. You can always refer to
the lessons and resources in this program if you face
a challenge or need help. And remember, collaborating with others in the discussion forums is a great way to brainstorm solutions. Get ready for the next and final step of your
end-of-course project!

Video: Complete your end-of-course project

This course is the final step in your business intelligence end-of-course project. You will use your reporting tables to create a BI dashboard in a visualization tool like Tableau. The project is structured in three steps: mockup, chart creation, and dashboard organization. You can work at your own pace and in the order that best suits your learning style. The readings in this section will provide you with the scenario, business questions, and visualization instructions. Once you complete this course, you will have a complete BI case study to showcase your skills to potential employers.

Hello! Now it’s time to wrap up your business intelligence
end-of-course project. So far, you’ve completed your key BI documents, data pipeline, and reporting tables
from previous courses. If you haven’t finished these, you can take some time to wrap up your work on those deliverables to be ready for this next stage. Otherwise, you can use
the exemplars provided for these projects to build your upcoming visualizations. With your reporting tables ready to load into a visualization
tool, such as Tableau, you’re ready to move
forward on your project. You’ll start with creating a mockup, then you’ll create your charts and organize them into a dashboard. Finally, you’ll develop your
unique presentation style you can use when sharing the
dashboard in your portfolio. The project is structured in this order, but as always, you can go at your own pace and in the way you choose. You can read through the materials, and then go straight from
a mockup to a dashboard and then return to chart design specifics. You can even alternate back and forth between each step of the process. Work in a way that fits your style. Your dashboard artistry
is completely your own. If you did the activities in this course, you’ve already completed
each of these steps. None of this material will be new to you, and if you get stuck, you
can review previous lessons. This project continues the work that you started in previous courses. You’ll use the skills you
mastered along the way to guide you through the process. This will allow you to
make your own BI decisions and develop your skills independently so that you’ll be ready when you encounter BI
projects in the workplace. Once again, the readings in this section will contain the scenario
for the case study, the business questions you need to answer, and the instructions for what kind of visualizations
you’ll need to build. Now, it’s time to get started. Read through the case study materials, decide how to best design your dashboard, and create your project and presentation in the visualization tool you choose. When you finish, you’ll have your very
own completed case study to show off to prospective employers. Enjoy working on your portfolio.

Reading: Explore Course 3 end-of-course workplace scenarios

Reading

Cyclistic scenario


Reading: Course 3 end-of-course project overview: Cyclistic

Reading

Practice Quiz: Activity: Build a dashboard for Cyclistic

Reading

Reading: Activity Exemplar: Build a dashboard for Cyclistic

Reading

Google Fiber scenario


Reading: Course 3 End-of-course project overview: Google Fiber

Reading

Practice Quiz: Activity: Build a dashboard for Google Fiber

Reading

Reading: Activity Exemplar: Build a dashboard for Google Fiber

Reading

End-of-course project wrap-up


Video: Course wrap-up

Congratulations on completing the last part of your end-of-course project! This significant achievement reflects your dedication and hard work throughout the program. By independently finishing this project, you’ve effectively applied your knowledge in business intelligence, data pipelines, and dashboard creation, showcasing your growth as a BI professional. The completed project can now be a valuable addition to your portfolio, serving as a tangible representation of your skills that you can share with potential employers and discuss in interviews. Whether you choose to share the presentation materials, the dashboard itself, or a detailed write-up about your process and choices, each component contributes to illustrating your BI journey. This marks the completion of the first step toward your BI career, and there’s a special message waiting for you in the next section to help you celebrate!

Congratulations, you’ve
completed the last component of your end-of-course project! This is a huge accomplishment
that demonstrates all your hard work in this program. You finished this project on your own. You applied your knowledge
of business intelligence, data pipelines, and
dashboards to create something that truly demonstrates your
growth as a BI professional. You can now include this
presentation in your portfolio, share it with potential employers, and discuss it during interviews. Share the presentation materials you made, the dashboard itself, or the
writeup about the process you used and the choices you made. Ideally, you’ll show all of the above! Each component illustrates
your BI journey. Now, you’ve completed
the first step toward your BI career and reached
the end of this program. And don’t miss the next section, which has a special message
from some familiar faces to help you celebrate!

Video: Tony: Career-building strategies

Tony, a finance program manager at Google, shares his insights on what makes financial analysts stand out in interviews. He emphasizes the importance of strong communication skills and storytelling ability, especially when candidates lack direct work experience in the field.

Tony suggests taking advantage of open-ended questions to showcase one’s knowledge and problem-solving skills. He encourages candidates to connect their learnings from the certificate program to the job they’re applying for, even without relevant professional experience.

Tony also highlights the importance of controlling the interview environment to minimize distractions and promote confidence. He recommends preparing well-structured examples of projects and analyses from the certificate program to demonstrate one’s ability to apply their knowledge.

Tony concludes by encouraging candidates to be confident in their learnings and seize the opportunity to showcase their skills during the interview.

my name is Tony and I’m a finance
program manager here at google for the last five years. I interviewed financial analysts and a lot of financial assets with a specific
focus towards business intelligence and the thing that makes someone really stand
out for me is someone that has really strong communication skills and has got
a really good ability to tell their story when you’re in an interview and you
don’t have the previous work experience that demonstrates that you know how to
use the tools that you may have learned in your data certificate of your
business intelligence certificate. This is where as an interview where
you really have to just take charge of the interview. So take advantage of questions that
leave you the opportunity to dive in and really explain what you’ve learned and how you would apply it a lot of
times an interviewer like myself, I’ll open up a very generalized question
to see where the interview we will go. Whether they want to work with hard
numbers for financial standpoint or whether they want to take their response
and start to talk about how they would use sequel or python or
r as a solution tool and maybe even carry me through some parts
of that process of how they would go through putting that in place to solve
the problem that we’re talking about. That is one really good way to say. I’m connecting the dots between what I’ve
learned recently in the job that I’m applying for without having the professional
experience right there on your resume. One thing that Absolutely and strongly recommend someone not do is
put themselves in a scenario where they cannot control the environment that
is around them in an interview. So a lot of our interviews right
now are being conducted virtually. It’s very important that you’re
intentional about where you take your interview. I had one person one time taking interview
out on a street corner outside of a cafe. Very wrong, having the best as much
control about your space as you can. It’s not just for me as the interview
were, but it’s also for you as the interview we where you can
feel comfortable and confident and know that you’re not going to
get distracted in that setting. One of the things I would really encourage
you do is that in advance of the interview you take a look at all of the different
projects and the analysis that you did through the certificate process, organize
a few of them that can be used for generalized questions now from my
perspective as someone who’s looking at entry level folks and I’m really not
concerned about the previous experience. I want to see how you can
articulate what you’ve learned. And so for me it would be if we can
get into a little bit more technical question in the interview that you
lean in on what you’ve learned during the certificate program process. Be confident in what you’ve learned and
know that you’ve done enough to put you in the room, so
take advantage of that moment.