This is the second of four courses in the Google Business Intelligence Certificate. In this course, you'll explore data modeling and how databases are designed. Then youâll learn about extract, transform, load (ETL) processes that extract data from source systems, transform it into formats that enable analysis, and drive business processes and goals.
Google employees who currently work in BI will guide you through this course by providing hands-on activities that simulate job tasks, sharing examples from their day-to-day work, and helping you build business intelligence skills to prepare for a career in the field. Learners who complete the four courses in this certificate program will have the skills needed to apply for business intelligence jobs. This certificate program assumes prior knowledge of foundational analytical principles, skills, and tools covered in the Google Data Analytics Certificate. By the end of this course, you will: -Determine which data models are appropriate for different business requirements -Describe the difference between creating and interacting with a data model -Create data models to address different types of questions -Explain the parts of the extract, transform, load (ETL) process and tools used in ETL -Understand extraction processes and tools for different data storage systems -Design an ETL process that meets organizational and stakeholder needs -Design data pipelines to automate BI processes
PA
well presented and easy to understand for beginners
DA
Awesome from the theory point, however lacking when it comes to tools usage.
OK
Course materials [check], delivery [check], testing knowledge [check]. Thanks, Edđ
OK
A good well explained introduction to Data modelling.
RD
wonderful course with proper curriculum in structure to gain the fullest knowledge
RR
Excellent topics, Excellent instuctors, Hands on practise
MA
This course slightly depends on the first course in the Google Certificate, so there must be an announcement or hint for this point.
RJ
very informative and will be useful to my practice.
MM
Some Videos had the low recording sound that I cannot hear clearly
JS
I think google cloud pictures were outdated. The class was fun I struggled with the GCP tools but plan to keep using them I want to learn this.
SB
Mr. Ed is a superb thought provoking Instructor. Love him and enjoyed a lot while attending the course with a thorough in depth approach while delivering all the concerned lectures.
DR
It is an excellent course with practical exercises; even non-IT persons can understand and complete the tasks. Good tutorials.
æŸç€șïŒ20/132
you really need to show us steps of making pipelines good explanation about the ETL but poor illustration of how to create one not even asingle video shows this.
Content was good, but it was NOT CLEAR that you are billed for all Google Cloud usage. There was a free trial period, no notice, and then charges started to rack up. What a disappointment! This cost makes completion of the certificate program too expensive!
i didn't find this course as good as the others, found it very dry and not very hands on
I have taken all the Data Analytic courses to get prepared for this course, all the content so far on the concepts, it's great. However, WHEN IT COMES TO THE HANDS ON PRACTICES TO BUILD UP THE PORTFOLIO, THAT IS THE END OF COURSE PROJECTS, AND THE SIMILAR PREPS LIKE IT ALONG THE WAY, they have glitches, data is inconsistent, and there is NO HELP whatsoever. One cannot just go into a "BI chat" somewhere, and ask questions, if there are Materials missing, outdated, or incorrect to accomplish the real hands on project practices and end of course projects. Therefore, going into Course 3, my expectations are low. This was not the case for the Data Analytics certificate, but for Course 2 of this BI certificate. Course one was fine, only because the End of Course Projects were documents. Here in course 2, the SQL queries to follow and the data to access, are not aligned or updated.
Too abstract, Data validation just sql queries and manual checks, almost zero useful information, rules and examples not consistent, for example recommendation for table and columns naming can be randomly followed in provided tasks and example and can be not followed.
Actually disappointed in this course. Doesn't really teach you anything beside a lot of theory. Lacks the practice side.
Not nearly enough hands-on examples. This is all just theoretical.
Regarding Data Pipeline i wish i had more than overview approach means more of hands-on experience.
My main issue with this course, and why I'm giving two stars is because the Google Fiber end-of-course project is poorly developed and doesn't offer any challenge beyond what was already covered in the Google Data Analytics course. The tasks that we are asked to perform to complete it are wildly simple and don't match at all what was covered in the course. Downloading CSVs, manually uploading them into Big Query, merging them with some UNION ALL statements, and then downloading the resulting table is not a data pipeline. The project needs to be heavily developed or outright pulled from the course, as it's a major disappointment. The rest of the course content was much higher quality, and gave me a lot of new concepts to consider for how to ensure data quality. Now, as to how we actually perform those data quality checks, schema validations, and actually set up a proper pipeline, that doesn't actually exist in this course. It's all theory and no application.
When it came to using tools, instructions were poorly given (i.e. screenshots too small to read. Videos of the process would have been better)
Needs more exercises on actually building Data Pipelines.
The Google Business Intelligence Certificate is a comprehensive program that offers in-depth training in various aspects of business intelligence. It covers essential topics such as Power BI, SQL spreadsheet, dashboard and report creation. The course emphasizes hands-on learning, providing participants with practical experience in data modeling, visualization, and analysis. The inclusion of a capstone project allows learners to apply their knowledge and skills to real-world scenarios. By completing this certificate, individuals gain the expertise needed to excel in the field of business intelligence and make data-driven decisions.
The Path to Insights: Data Models and Pipelines is a great course that provides a comprehensive overview of data modeling and ETL pipelines. The course is well-structured and easy to follow, and the instructors do a great job of explaining the concepts. I would highly recommend this course to anyone who is interested in learning more about data modeling and ETL pipelines.
The lecturer, Ed, was very professional and brought a high degree of solid confidence, and authority over the module topics.
The course was well designed and has easy flow between topics.
Overall, a good learning program about Data models, Pipelinea, ETL & ELT, Google Dataflow, Databases and related content. I enjoyed this course.
Very informative for an explanation of data models in relations to multi dimensional data models, data validation, schema validation and ETL, ELT Pipeline.
I think google cloud pictures were outdated. The class was fun I struggled with the GCP tools but plan to keep using them I want to learn this.
Thanks for google guru,m this is not about the course but about problem-solving and training the logic
Course materials [check], delivery [check], testing knowledge [check]. Thanks, Edđ
A course which everybody should get
Engaging and insightful