-
SQL Fundamentals
16 Lessons -
-
Recreating GA4 Standard Reports in BigQuery
14 Lessons -
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.
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. "