-
SQL Fundamentals
16 Lessons-
StartFirst SQL statement
-
StartNarrowing down result set with WHERE
-
StartUsing multiple conditions in WHERE with AND and OR
-
StartExcluding Columns from the result set
-
StartSelecting unique values e.g. list of events
-
StartCounting the records e.g. count of events
-
StartDealing with Records or Arrays - Unnest statement
-
StartJoin
-
StartUsing alias
-
StartOuter Join
-
StartCalculating Totals
-
StartSorting the result set
-
StartSub Queries
-
StartRolling Up the Result Set a various levels
-
StartCommon Table Expressions (CTEs)
-
StartRanking The Values in the Result Set
-
-
Recreating GA4 Standard Reports in BigQuery
14 Lessons-
StartIntroduction
-
StartAcquisition Report
-
StartAll traffic drivers for the users - Building block of the attribution model
-
StartLast Touch Traffic Source
-
StartFirst Touch Traffic Source
-
StartFirst Touch and Last Touch
-
StartAll Touchpoint
-
StartOrdering Each Customers Touchpoints -Build Attributions
-
StartUser acquisition: First user default channel grouping
-
StartTraffic acquisition: Session default channel group
-
StartEngagement: Events: Event name
-
StartConversions: Event name
-
StartPages and screens: Page title and screen class
-
StartPurchases
-
Coupon invalid
BigQuery & SQL for Marketers and Marketing Analysts with GA4 and More...
Unleash the power of GA4 data with BigQuery & SQL
What is BigQuery and SQL
BigQuery is a database system by Google. It is a server-less platform that allows you to store the data in the cloud.
Since organizations are now looking to integrate all sort of data such as Web Analytics, Digital Marketing, CRM, Email marketing data etc., Digital Analytics solutions such as GA4 are now enabling the businesses to send the data directly to such databases.
SQL is standard programming language used to access, query and manipulate the data in the Databases such as BigQuery .
Hence BigQuery and SQL skills are becoming a skill that Digital Analysts need to have.
Since programming does not come naturally to marketers and marketing analysts, I created this simple to understand course for marketers and marketing analysts to get handle of SQL and BigQuery.
This is a course that will take you through the journey of learning and mastering BigQuery and SQL.
Why You Should Join This Course?
BigQuery + GA4 is What Organization Are Looking For
- Allow you to get unsampled GA4 data
- Data Studio has enforced API limits so your GA4 reports will be broken frequently. Using BigQuery by passes that limitation.
- SQL allows you to conduct deeper analysis of your data
- You can combined multiple data sources to get a complete view of a customer/user
- Use 3rd party data along with 1st party data.
- GA4 data has a direct pipeline into BigQuery so you can go beyond canned reports
- Any organization dealing with GA4 will be using BigQuery .
How Will This Course Help You
- You will learn what BigQuery
- You will learn how to send GA4 data to BigQuery for free
- You will learn how to understand GA4 data in BigQuery (will also help you with your understanding of GA4
- You will learn SQL step-by step, a programing language that helps with any database not just BigQuery
- You will grasp and learn how to get data and reports better than what GA4 interface provides.
- You will learn how to build GA4 reports in BigQuery and visualize in Looker Studio
- You will learn what other SQL other organizations are using
- This course can be your ticket to not only Digital Marketing and Analytics career but also to Product Management, Data Science and Data Engineering roles.
What do you get
- Video lessons
- SQL cheat sheet that you can use right away
- Use cases that you can apply to your business or organization.
- Member to member support via exclusive community.
- Support from Optizent to help you make progress when you are stuck.
This one course can open up a lot of new career options for you.
Each student's success is what we strive for.
Jamila Rabo, Teacher to Digital Analyst
" I am from Nigeria west Africa. My coming across Anil changed my entire life. I am a primary school teacher almost completely analog. Though I studied marketing in a higher institution, I didn’t know a thing about Digital Marketing nor Analytics. I started thinking outside the box in my life because of the meager pay I was getting as a teacher in Nigeria. Meeting Anil was the game-changer. When he tags his courses "Zero to Hero", I completely attest it to be so because it was literally so in my case. Like a father, he walked me through baby steps till I got to my feet. What amazes me about him is his humility and generosity with his time and support, he creates time for everyone. He is indeed an amazing mentor; he believes so much that I can make it. Optizent academy provided a platform for meeting with other Analysts, wonderful guys who acted as siblings on my journey. They were my “superiors” on a lot of fronts. I am standing tall and strong because I chose to hang out with the right guys. It is only in Optizent that you enroll for a course and you get much more, the course content and a family. Though I am not there yet, I am very far from where I started. Now I can confidently work on GA4, GTM, Google Data Studio, and more plus I am setting up my site all on my own. "
Tanisha Sabhaney, Product Marketing Analyst
"I currently work as a Product Marketing Analyst. I joined the Web and Digital Analyst course to understand the nuances of digital marketing analytics and implement it at work. Unfortunately, I was always lost in the analytics ecosystem and found resources that taught me how to implement solutions theoretically but never gave me the personalized real-life problem-solving answers I needed. Anil is a guru in everything digital analytics. He has managed to find a brilliant way to teach one the fundamentals and make them experts in weeks. The weekly calls help break down everything you need to help solve your specific problems. You leave the course with a practical understanding of digital analytics and implementation as if your job required you to be the mastermind behind creating the entire Digital Analytics function for your business. Not only do you gain great experience, but you leave with a mentor and a community that can help sustain your ever-growing analytical expertise and needs. I would strongly recommend this course to anyone who is seeking to enter the marketing analytics space. "
Antoine Müller started his career after completing this program.
"In terms of impact, I would not have found my first internship without this online workshop. In the company I chose, a demo dashboard made a strong impression. "
Charles Mendelson Started his career after completing this program.
He found his first analytics job within 3 months of completing the program.
"Anil has been an outstanding mentor to me in addition to helping me get my first job in analytics he has been a constant source of career advice"
"He has been an outstanding friend I can honestly say he is a large part of my income quadrupling over the last three years just by helping me identify how I want to develop my career "
Abi Sonpar, SEO To Digital Analyst.
Found his first Web Analytics Jobs within a month of completing the program.
"I was looking to swap my specialization from SEO and get into full-time analytics. It's an incredible program and I learned so much from it. There are other analytics training programs out there but Anil has a lifetime of knowledge stored in the program and the level of depth and support offered in the program is unmatched. What I loved the most about it is how much practicality there is in the topics covered. This course has opened my eyes to the world of web analytics. "
Roberto Parez, Digital Analyst
"I have been working with Marketing Analytics since 6 years ago, and if you are here looking for understanding the work for Digital Analytics, how to connect all the dots and how to analyze data this is the course. Most of the courses and instructors talk about tools, programming languages, reporting and the value of the data but no one talks about the processes you need to follow, and how to add insights to the business, how to become an advisor for other departments and add more value to the business. That's one of the biggest things I learned here. Anil not only helped with tools etc. but also the process, insights, role of an analyst and how to add value across the organization. Another thing I liked about the “Become a Digital & Web Analyst” course is the practical nature of the course and Live session with Anil, who has more than 20 years of experience in the area, he can help with what you need to do."
Syed Ali
"It is one of the best course available to learn Digital Analytics. I like how Mr Anil has made us understand hard concepts in such a simplified manner. He has provided quality and relevant information which can make anyone start as a beginner and become an expert as an digital analyst, using this course and the easily accessible membership. I also like that Mr Anil is very concerned about his students and provides great support, this is the best part and he answers all questions. Overall I am happy with my investment in this course. "
Munira Miyaziwala Senior Marketing Manager and Business Owner
"Web and Digital Analytics course by Optizent taught by the instructor Anil Batra was very helpful and informative course. Training materials were well organized and provided good case studies. The training was clear and detailed. I liked Anil’s style of teaching. He set up by explaining what he was going to teach us, summarized, and proceeded to teach, providing relevant real-life examples and case studies from his years of experience in the field. He provided enough opportunity for the student to ask questions and went out of his way to support the learning of the subject matter. He was very easy to communicate and friendly. This course has helped me understand the bolts and nuts of digital analytics and has benefited my business by its application of it. I attribute this primarily to the instructor and secondarily to the quality materials. I would highly recommend this course to anyone wanting to be digital analyst to work for a company or to manage their own company. "
