Customized BigQuery Training
Take advantage of Google Cloud Platform and BigQuery for data integration and analysis beyond the Google Analytics user interface.
As the core of Google Cloud Platform, BigQuery offers tremendous opportunities for data integration, data modeling, and analysis. With BigQuery, Google has made its powerful internal technology available to us, offering tremendous processing power at very low cost.
While Google Analytics focuses on the common features of all websites and provides reports that answer important questions, BigQuery is the best big data platform to go beyond what Google Analytics offers. You can model the data differently, according to your business rules. You can combine Google Analytics data sets with other data sets, such as CRM, media, mobile analytics, and social analytics. And you can do so much more.
Meet Your Instructor
Cloud and Data Architect
Hazem is motivated by science and experimentation and equally motivated by helping individual teams implement working solutions to real data engineering challenges. With the ever-growing amount of data, extensive preparation is needed before analysis & reporting can occur to reveal insights and guide decision making. That’s where data engineering shines and Hazem holds that torch high by architecting expert solutions.
Hazem received a Bachelor of Science in Electronics and Computer Engineering from Cairo University and holds several industry certifications, most recently Google Certified Professional Data Engineer.
In the first phases of his career, Hazem worked on software development in various environments, technologies, and roles. That experience gave him a great headstart when he narrowed down his focus to data engineering about 6 years ago.
But how can we really use BigQuery to gain insight and take action for improvement?
It all starts with understanding what BigQuery is, what it is not, and building on this basic foundation with intermediate through advanced skills and techniques.
All of E-Nor’s training programs are designed and delivered by technical experts who also have broad experience in designing impactful training across a broad range of industries. The instructors have years of industry experience and early access to the most recent tool updates and techniques.
Our focus is to empower your team to make better, more data-informed decisions, and use BigQuery to gain a real competitive advantage.
Choose Delivery: In-Person, Online or Blended Learning
Is your corporate analytics program growing? Are you trying to build a culture of analytics excellence? Do you need to break down silos between teams to go to the next level in your analytics maturity? We can design an effective plan for in-person or online training or a combination of the two.
Live Instructor-Led Training at Your Location
Live, instructor-led training is still the most effective type of learning for teams. Face-to-face communication allows the learning experience to not only be heard but also seen and felt. We can conduct highly interactive training sessions at your location, with groups ranging from just 2 or 3 to as many as would benefit from participating.
Remote participants are welcome to join the live sessions through web conferencing.
Live Online Training
Online delivery is another option for our training. This might be the best option for remote teams. We can plan multiple sessions to accommodate different time zones.
E-Nor is glad to provide the conferencing or to use your system. By default, we provide recordings of the online sessions.
Duration: Get Multiple Days of High-Impact Learning
Most of our training programs span two days. We offer one-day programs for streamlined training and three days or more for deeper dives into specialized topics. We’ll work with you to identify the schedule that’s right for your team.
Training days typically start at 8:00-9:30 AM and conclude at 4:00-5:30 PM. The instructor is normally available for open-ended Q&A during breaks and after the final session of the day. We are flexible in accommodating the scheduling needs of your team as well as one-on-one discussions.
For online training, we recommend multiple shorter sessions, typically 2 hours per session and not exceeding 4.
Address Your Business Needs with Technical Foundations
We design the training to directly address your business requirements and the technical challenges of the tools you’re using.
To the greatest extent possible, we use your own data in the training, and we frame each session to be fully relevant for the participants.
Meeting the Needs of Adult Learners
Relevance to your organization’s needs – and to individual performance outcomes – is an essential element of effective instruction for adults. Our training is designed to help participants solve real problems and gain the satisfaction that comes from increased competence, achievement, and team success.
In addition to deep technical expertise in analytics, E-Nor’s instructors apply these adult learning principles and draw on years of classroom and online training experience to create a meaningful and actionable experience for training your team.
Agenda Planning: How It Works
3-6 weeks prior to the training date, the instructor will schedule a call, typically one hour long, with one or more of your training organizers to plan the agenda. We are glad to schedule additional calls before the training as is helpful: thorough preparation is key for successful training outcomes.
Training typically covers one day but may require additional days for exploration of advanced topics.
Broadly speaking, the agenda can cover the following areas:
- Introduction to Google Cloud Platform and BigQuery
- Basics of BigQuery and differences from relational databases
- Google Analytics data in BigQuery
- Firebase Analytics data in BigQuery
- Other Google Cloud Platform components: Cloud Storage, Cloud SDK, and briefly Dataflow and PubSub
- Cross session and cross device analysis
- Combining various data sets: CRM, media, mobile analytics, social analytics
- Applying different business rules, different data modeling
- Troubleshooting Google Analytics data in BigQuery using hit level granularity
- Interacting with BigQuery through the Web UI and SDKs
- Avoiding typical roadblocks and pitfalls in BigQuery
For the Google Analytics dataset in BigQuery, we focus on the following topics:
- Linking Google Analytics to BigQuery
- When to use GA data in BigQuery
- Multi-session Analysis
- Hit-level sequencing
- How Google Analytics differs in BigQuery vs. the UI or API
- Google Analytics schema in BigQuery
Advanced topics can include:
- Nested repeated records
- BQ Views, saving query vs saving result
- Partitioned tables vs Dated (Sharded) tables
- Loading data into BigQuery
- Exporting data from BigQuery
- Window functions
- GA BigQuery schema
- Query scheduling
We can also survey participants for potential topics to incorporate into the agenda.
After gathering your requirements, we build a customized agenda that meets core training needs as well as areas of special interest. We can also break out an overview at the beginning or end of the agenda, suitable for executives or any other stakeholders who would benefit from a higher-level summary.
We submit the final agenda for your signoff, and also provide a basic logistical checklist for classroom setup or online participation.
We always encourage active participation in the training, and we’re glad to adjust the agenda live on the training days; our highest concern is to provide your team with the most worthwhile learning experience.
Prep work may be assigned to participants prior to the course dates as suitable based on your objectives for the training.
Training Across Departments
Our training sessions often include participants representing multiple departments and functions in your organization:
- data team
- product managers
- web and mobile app developers
- IT admins
Participants often find it informative to attend the sessions that are not directly aligned with their roles, but we can also structure the agenda into self-contained sessions for attendance by specific teams.
Throughout the training, your team will have the opportunity to query live data in BigQuery. Whenever it’s feasible, we prefer to use your own data, but if that is not feasible for any reason, we can take advantage of demo data and publicly available BigQuery datasets.
Testing and Certification: Validate Your Knowledge
As part of your training program, E-Nor can build one or more tests to help participants retain the training material and to assess competency.
We can deliver testing on the platform we use or deploy to your internal learning management system (LMS).
Coaching and Follow-Up Support: Apply the Skills and Continue Learning
Depending on the curriculum, we can provide customized follow-up guides, job aids, queries, scripts, and utilities to support the skills learned in the training.
E-Nor is committed to your long-term success. You have access to your instructor for ad hoc email and phone support and even 60-minute follow-up webinars for a minimum of 6 months following the training dates.
The E-Nor Data Engineering team has had the opportunity to work with a wide spectrum of clients, including: