Multi-Channel Marketing Project
Learn how to set up data pipelines for multiple marketing data sources, build a data warehouse and create combined reports
Knowing how to bring together all of the valuable data from multiple marketing channels into one place for analysis is a problem faced by most businesses. After studying this course, you will...
Be familiar with 2 different data hubs to be able to access and extract data from various marketing channels
Be able to build a data warehouse using Google Cloud Platform's BigQuery to store the extracted data in a single place
Connect your data warehouse to Microsoft's Power BI tool to build interactive dashboards and reports
Earn valuable skills to add to your CV and a data analyst project to add to your portfolio that will wow your boss or any potential employers
No subscriptions or course expiration date, just a single payment gives you unlimited, lifetime access to the course.
We offer a free preview so you can test drive the course before you buy.
Any questions? Please contact us from the site menu.
Get the Power BI bundle for less when purchasing this project
$159.00
Power BI Course & Project Bundle
Other courses available from Learn BI
Using a combination of CSV and Google Sheets data and equipped with a client brief, you have been tasked to build interactive dashboards to help a call centre monitor performance and improve agent training.
$49
A busy hotel needs you to upgrade their existing Excel reporting. Your job is to design and create a SQL database then write SQL queries to create data sources for the dashboards the client has asked for.
$49
Your new client is opening a new pizzeria and has asked you to set up the ‘back-end’ by designing and building a SQL database for orders, staff and inventory data. You'll then need to create 3 different dashboards so Ben can monitor performance.
$9
Designed to take you from zero to BI Analyst in just 12 weeks
Although not essential, as all the SQL code will be shown during the project, it is recommended that you have at least a basic knowledge of SQL querying.
You will need to have access to an instance of MySQL. If you do not, you can easily download and install one on your computer.
You will also need a database management tool like MySQL Workbench (free download) and a BI tool. This project uses Power BI but feel free to build the dashboards in whatever tool you prefer.
If you have any questions, comments or feedback, you can contact your instructor directly here.