Look inside
In this liveProject, you’ll create a Google Data Studio report that can visualise your datasets for the purpose of business intelligence. You’ll connect up numerous data sources using BigQuery to feed directly into your new BI dashboard. You’ll design and implement revenue and daily spend metrics and line graphs, and scorecards for top users.
This project is designed for learning purposes and is not a complete, production-ready application or solution.
book resources
When you start your liveProject, you get full access to the following books for 90 days.
project author
Mike Shakhomirov
Mike Shakhomirov is a lead data engineer at The World's Online Festival. He has an MBA and MIT diploma in big data and social analytics and is a Google Cloud Certified Professional Data Engineer. He is a passionate and digitally focused individual with an abundance of drive and enthusiasm, loving the challenges the full mix of digital marketing can offer. He is also an official writer for publications such as Towards Data Science and The Startup, with more than 20 published articles on various topics. He writes about data engineering, machine learning and AI in digital marketing.
prerequisites
This liveProject is for complete beginners to data engineering, with a basic understanding of cloud data pipelines you can develop through the other liveProjects in this series. To begin this liveProject you will need to be familiar with:
TOOLS
- BigQuery
- Data Studio
- Basics of SQL
TECHNIQUES
- Basics of cloud computing
- Basics of data visualization
you will learn
In this liveProject, you’ll learn how to utilize an effective cloud data warehouse as the heart of your data architecture.
- Connect a BigQuery table as a GDS data source
- Connect a custom data source as a BigQuery SQL query with date parameters
- Create a table chart in GDS using the data you have in your tables
- Create an area chart using BigQuery data to visualize user spend in GDS
- Add bar charts and slider controls to a GDS dashboard
- Use a custom dataset parameter with Input box control in GDS
features
- Self-paced
- You choose the schedule and decide how much time to invest as you build your project.
- Project roadmap
- Each project is divided into several achievable steps.
- Get Help
- While within the liveProject platform, get help from other participants and our expert mentors.
- Compare with others
- For each step, compare your deliverable to the solutions by the author and other participants.
- book resources
- Get full access to select books for 90 days. Permanent access to excerpts from Manning products are also included, as well as references to other resources.