HOT
blank

Business Intelligence Development using Python 3

Business

Business Intelligence Development using Python 3, available at Free, has an average rating of 4.05, with 44 lectures, based on 82 reviews, and has 8313 subscribers.

Rating4.1
Free Enroll Now

You will learn about Understand a Data Pipeline, Marketing Analytics, Data Automation and the basics of Data Engineering. Learn how to use Python Libraries to create your data automation process. How to make powerful analysis. Create strong added value to your business. This will help you for your next job interview or your Performance Review and salary negotiations. This course is ideal for individuals who are Anyone interested in Data automation. or Anyone who is not that comfortable with coding but who is interested in programming with Python. The course has been created with the beginner in mind. or Intermediate programmers can learn the Business Intelligence side of the course. or Any students in college who want to start a career in Data Intelligence. or Any people who want to create added value to their business by automating work. It is particularly useful for Anyone interested in Data automation. or Anyone who is not that comfortable with coding but who is interested in programming with Python. The course has been created with the beginner in mind. or Intermediate programmers can learn the Business Intelligence side of the course. or Any students in college who want to start a career in Data Intelligence. or Any people who want to create added value to their business by automating work.

Enroll now: Business Intelligence Development using Python 3

Summary

Title: Business Intelligence Development using Python 3

Price: Free

Average Rating: 4.05

Number of Lectures: 44

Number of Published Lectures: 44

Number of Curriculum Items: 44

Number of Published Curriculum Objects: 44

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

  • Understand a Data Pipeline, Marketing Analytics, Data Automation and the basics of Data Engineering.
  • Learn how to use Python Libraries to create your data automation process.
  • How to make powerful analysis.
  • Create strong added value to your business. This will help you for your next job interview or your Performance Review and salary negotiations.

Who Should Attend

  • Anyone interested in Data automation.
  • Anyone who is not that comfortable with coding but who is interested in programming with Python. The course has been created with the beginner in mind.
  • Intermediate programmers can learn the Business Intelligence side of the course.
  • Any students in college who want to start a career in Data Intelligence.
  • Any people who want to create added value to their business by automating work.

Target Audiences

  • Anyone interested in Data automation.
  • Anyone who is not that comfortable with coding but who is interested in programming with Python. The course has been created with the beginner in mind.
  • Intermediate programmers can learn the Business Intelligence side of the course.
  • Any students in college who want to start a career in Data Intelligence.
  • Any people who want to create added value to their business by automating work.

Interested in automating your marketing pipeline or your business intelligence? Then this is your course! Learn how to relieve yourself of repetitive work by programming it. All this in less than 2 hours!

There are many Business Intelligence, Python beginners or Data Analytics courses out there. I combine these subjects to create a course that connects and automates your Data tracking tools to your Business Intelligence tool.

We will Extract real-life data from Google Analytics and Facebook with Python and Transform these data points into a useful format and then Load them to Google Sheets => ETL (Extract, Transform, Load)

Python is the best language to automate these processes and will be used in this course. This course is truly step-by-step as we made the course so you can code along with us. We extract data from 4 different sources and then use those data points to be able to decide on our future business strategy. And all is done through live examples. I am using my previous teaching experience as a lecturer to create this easy to understand course.

As a bonus, this course includes all the Python code templates we created for you to download and use on your own projects.

I and my team are constantly available to support you in your learning and to answer questions.

I’ll see you on the inside!

Yours sincerely,

Christoph Odermatt

What are the requirements?

  • A minimum understanding of any computer language and some marketing experience.
  • Any computer running Mac, Windows, or Linux, all is shown on a Mac.
  • All the tools used in the course are free, except for your Marketing you are using.
  • Preferably you already have data from your Marketing on Facebook or Google AdWords.
  • And passion to learn.

What am I going to get from this course?

  • Understand a Data Pipeline, Marketing Analytics, Data Automation and the basics of Data Engineering.
  • Learn how to use Python Libraries to create your data automation process.
  • How to make powerful analysis.
  • Create strong added value to your business. This will help you for your next job interview or your Performance Review and salary negotiations.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Download Python

Chapter 2: Let's get started

Lecture 1: Marketing KPIs

Lecture 2: Create accounts

Lecture 3: Install libraries with PIP

Chapter 3: Access Google Analytics data

Lecture 1: Simple GA data access

Lecture 2: GA data access with active GA account

Lecture 3: Data access on Jupyter Notebook

Lecture 4: Add ISO-week function

Lecture 5: Add extract unsegmented data function

Lecture 6: Add extract segmented data function

Lecture 7: Checking for errors in the first part of the code

Lecture 8: Get the correct date for your function

Lecture 9: Checking for errors in the extracting data functions

Lecture 10: Transform extracted totals data to Pandas DataFrame

Lecture 11: Transform extracted details data to Pandas DataFrame

Lecture 12: Add initialise Google Drive function

Lecture 13: Add download worksheet function

Lecture 14: Add loop function for totals data

Lecture 15: Authenticate Google Drive API

Lecture 16: Check for errors in the loop totals function

Lecture 17: Add loop function for details data

Lecture 18: Load data to Google Spreadsheet

Lecture 19: More checks for errors in the loop totals function

Lecture 20: Add sort index function

Lecture 21: Make a Python file with complete code

Chapter 4: Access Facebook data

Lecture 1: Create a Facebook app and get the code template

Lecture 2: Simple Facebook data access

Lecture 3: Move code to Jupyter Notebook

Lecture 4: Copy functions from GA Jupyter Notebook and add extract data function

Lecture 5: Check for errors by printing the extracted data

Lecture 6: Transform extracted totals data to Pandas DataFrame

Lecture 7: Transform extracted details data to Pandas DataFrame

Lecture 8: Add sorting function and loop totals function

Lecture 9: Add loop function for details data

Lecture 10: Add sleep to API query function

Lecture 11: Make a Python file with complete code

Lecture 12: Test the Python file

Chapter 5: Finish assigning data and automate scripts

Lecture 1: Assignment worksheet totals

Lecture 2: Assignment worksheet details

Lecture 3: Crontab automation

Chapter 6: Final code

Lecture 1: Google Analytics code

Lecture 2: Facebook code

Lecture 3: JSON template

Instructors

Rating Distribution

  • 1 stars: 8 votes
  • 2 stars: 3 votes
  • 3 stars: 16 votes
  • 4 stars: 29 votes
  • 5 stars: 26 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024