What you’ll learn
-
Write Advanced SQL queries and analyze database
-
Learn TEMPORARY TABLES and SUBQUERIES to handle complex multistep data problem
-
Analyze data for eCommerce real-world case where you can solve tasks
-
Mastering JOIN statements across multiple tables
-
Get life time access to resources and videos
COURSE OUTLINES :
- Introduction from downloading SQL server to connect the database
In this section we will take about how to install MySQL workbench and connect the database to the server plus creating a connection, after watching this part make sure you have the relevant skills including SELECT statements, Aggregate Functions and tables joins.
- Analyzing Traffic source
In this section we will warm up and do some review for some queries, then we will analyze where our traffic source coming from, how different sources perform in terms of traffic volume, calculate conversion rates, analyzing bids and optimize it, trend analysis
- Analyzing website performance
In this section we will analyze website pageviews and use TEMPORAY TABLE, calculate bounce rate, analyzing landing page, and use SUBQUERIES
- Analyzing Channel portfolio management
In this section we will compare channels and do multi channel bidding , also analyzing bid changes impact, traffic breakdown.
- Analyzing Business Patterns and Seasonality
In this section we will dig deeper into traffic analysis and explore more about organic and paid campaign, also seasonality and business patterns analysis
- Product Analysis
In this section we will break down sales on product level, conversion rates and cross-selling patterns and refund rates analysis to keep quality
- User Analysis
In this section we deep analyze user behavior and analyze the repeated sessions to identify most valuable customers and explore which channels they are coming from
Who this course is for:
- SQL users looking to develop advanced skills and master data analysis with Advanced SQL queries
- Anyone looking to pursue a career in data analysis or business intelligence
- Data analysts excel users looking to shift into business intelligence and optimize data analysis skills
- Data Analyst or Business Analyst with SQL, BI professionals looking to analyze data in a real-world case database
Can I download Data analysis & Business Intelligence | Advanced MySQL course?
You can download videos for offline viewing in the Android/iOS app. When course instructors enable the downloading feature for lectures of the course, then it can be downloaded for offline viewing on a desktop.Can I get a certificate after completing the course?
Yes, upon successful completion of the course, learners will get the course e-Certification from the course provider. The Data analysis & Business Intelligence | Advanced MySQL course certification is a proof that you completed and passed the course. You can download it, attach it to your resume, share it through social media.Are there any other coupons available for this course?
You can check out for more Udemy coupons @ www.coursecouponclub.comDisclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.