Data analysis with SQL and Google Data Studio

GENERAL CONTENT TUITION FEE TRAINERS PHOTOS

Today, many companies are pursuing a "data-driven" trend, in which every decision, big or small, is made mostly through data analysis. This trend has led to an increase in data, both in quantity (Big Data) and diversity. However, traditional tools such as Microsoft Excel are not powerful enough to meet the needs, so it is increasingly important to learn more powerful analytical tools. Along with that, the role of skilled individuals and big data analytical thinking skills is also being promoted.

To support those who wish to grasp the above trend, BAC has joined experts in the field of data analysis to build a course "Data analysis with SQL and Google Data Studio".

Who are entirely suitable for the training course?

Agencies want to enhance and automate their customer reports
The SMEs managers want to wants to find a solution in research, data analysis and reporting
People who work in marketing want to easily analyze the performance of their communication channels
Accountant
Career-oriented students involved in data processing, business analysis
Anyone who wants to work fluently with digital data analytics

tham-gia-khoa-hoc-ba

Why should I take the course?

The course helps students understand the importance of data in business operations and provides knowledge of the SQL query language and how to use the visual reporting tool Google Data Studio.
The course will provide essential skills and mindset to work with database.
This course is led by our experienced instructors who will share with you tips and tricks from their experience working on SQL and Google Data Studio.
The course will provide many examples and practical cases that you can easily understand and apply the knowledge you have learned.
The course focuses on practice. During the course, students will practice case studies from simple to complex with the guidance of lecturers.

What will you achieve after the course?

To apply knowledge of SQL language in sorting and retrieving data
To use proficiently in SQL to analyze data from database
To know how to build reports and dashboards automatically with Google Data Studio
To design the dashboard is clear and concise, yet visually appealing
To save time for reporting while ensuring accuracy and completeness
To be confident handle different data sources with SQL and Data Studio

Course Benefits

EXCELLENT TEACHING

All BAC trainers are strictly selected and internationally certified trainers who come from a multitude of operational and professional environments. They are, therefore, able to provide a wealth of up to date experiences and competencies.

CURRICULUM WAS SERIOUS-MINDED

All training activities are tailored upon the specific requirements of the applying organisation and upon the specific types of activity.

DOCUMENTATION

The participant will be received:

Slides, Workbook
Case-Study based approach to classes
Reference Articles
Useful links

CERTIFICATE

At the end of the course, the official certificate will be awarded.

How are courses designed?

The Data analysis with SQL and Google Data Studio course will be designed for 6 sessions in 18 hours (3 hours/session). The curriculum will focus on practice, whereby students will be exposed to practical problems of the business, and apply the knowledge & skills of SQL learned to solve. Classes will be equipped with real-life data samples and online platforms so students can directly compose and execute their commands.

Apply knowledge to real problems:

Practical theory
Practice with sample data
Practice based on real projects.

Class Information

Place: 6th Floor, Thien Phuoc 01 Building, 244 Cong Quynh Street, Pham Ngu Lao, District 1, HCM.
Teaching Language: Vietnamese
Materials: English
Issued Materials: Hard-copy (NO Softcopy), BAC/IIBA Practical Templates

Student Requirements

Join course at right place, on time and right schedule.
Comply with class rules.
Spirit of cooperation, working in group with members of the class and trainers.

Contact detail

Điện thoại tư vấn If you have any question, please feel free to contact us via:
Phone: (84) 909 310 768 | (84) 903 746 294
Email: info@bacs.vn | bac.trainingba@gmail.com

Course's content:

Session 1: Introduction to Data analysis & SQL

Understand the importance of data analysis in businesses
The basic concepts of a database
Practice basic SQL statements (SELECT FROM WHERE GROUP BY ORDER BY)

Session 2: Essential SQL for analysis on a single table

Practice handling string and time data types
Practice using CASE WHEN to group data
Practice using SUBQUERY and WITH for complex analysis

Session 3: Working with multiple tables & windows function

Practice using JOINs to join data tables together
Practice using UNION to join data tables together
Practice using WINDOW FUNCTION for special analysis

Session 4: Data Visualization with Google Data Studio

Introduction to Google Data Studio tool
Practice connecting external data sources to Google Data Studio
Practice building an automated report with Google Data Studio

Session 5-6: Case study

Practice a series of simple to complex analytics for a DVD rental business, then present the report on Google Data Studio to help business owners track business results and come up with necessary decisions.

FULL TUITION FEE: 3,100,000 VND

The tuition fee includes materials and certification.
Materials are included notebook or/and pen.
Tuition fee IS EXEMPT from value added tax (VAT).

DISCOUNT POLICY

10% of tuition fee for those who register and pay before the opening session before 10 days.

PAYMENT

Students can choose 1 of the following payment methods:

Payment in cash

BAC TRAINING AND CONSULTANCY JOINT STOCK COMPANY

Headquarter: 6th Floor, Thien Phuoc 01 Building, 244 Cong Quynh Str., Pham Ngu Lao, District 1, HCMC.
Branch: 11th floor, 39B Truong Son street, Ward 4, Tan Binh District, HCMC,
Email: info@bacs.vn or bac.trainingba@gmail.com
Hotline: (84) 909 310 768 | (84) 903 746 294

Payment by ATM, Visa, MasterCard

Using ATM, Visa, MasterCard directly at BAC's headquarter or branch.
Fee: The payer have to pay the transaction fee when using card.

No.	TYPE	TRANSACTION FEE
1	Domestic ATM Card	0.6% payment value
2	Visa, MasterCard	1.7% payment value

Payment by Transfer

Account 1: Tien Phong Bank
- Account number: 01236879001
- Account name: Cong ty CP Dao Tao va Tu Van BAC
- Tân Bình Branch
Account 2: Vietcombank
- Account number: 0721000571818
- Account name: CT CP DAO TAO VA TU VAN BAC
- Kỳ Đồng Branch

NOTES:

Students must complete the payment before course started, and latest at the opening session. BAC does not accept the payment after the opening day.
Exceptions: In cases of faulty payment process or students have committed to pay tuition fee after the opening day, BAC will accept as exceptions.

OTHER PROVISIONS

Reserve registered courses

After register and pay the tuition fee for the course, if students can not join the course, they should have official notification to BAC before the opening session. In this case, students will be reserved tuition and join the next course or switch to another BAC’s course in suitable requirements.

Opening Schedule Changes

In case of course could not start on schedule, BAC will send email to inform student the expected opening day.
If the new opening schedule is suitable for students' needs, BAC will reserve tuition fee. Students will continue to participate in the course.
If the new opening schedule does not meet students' needs, BAC will refund tuition fee.

Refund Policy

Tuition fees ARE NOT REFUNED.
If the new opening schedule does not meet students' needs, BAC will refund the tuition fee as followed processes:
- Students can receive refund by transfer or in cash.
- After the two sides have officially confirmed the cancellation of the course, the entire tuition will be refunded to students by BAC within a maximum of 3 working days.
- Students must return the receipt of tuition to BAC to complete the refund procedure.

Any information or support related to payment - PLEASE CONTACT US VIA:

Hotline: 0903 746 294 or Email: phungtran@bacs.vn.

Thach Vinh Khuong

Mr. Khuong is currently Data Scientist at The Coffee House. With 5 years of experience working in data processing and analysis, Mr. Khuong applied his data skills to help The Coffee House (TCH) and Seedcom's management team make strategic decisions.

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Mr.Nhat and Ms.Thuy are sharing how to be a good Business Analyst.

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Trainees change positions to start an interesting conversation.

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Congratulation! You has graduated.

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Memorable graduation day. Your life could be changed from now.

Nguyen Thi Mai Binh

Business Analyst

For an outsider like me, the topics on "techniques" of BA are very important. Examples include using diagrams to model the requirement, write User Story / Use case, etc.

At the course of Fundamental Business Analysis, I met Mr. Loc, a very enthusiastic and caring person. In addition to sharing practical experiences in class, he also takes the time to advise, support, and comment on my CV. Besides, the Center and Phung also support sending CVs, connecting students to the network of quality partner companies, which helps students like themselves find the most suitable job. Thanks, BAC.
View detail +
Pham Que

Business Analyst

The BAC Product Design course has provided me with a lot of useful knowledge and background. The lecturers are very enthusiastic, infusing us with a flame of passion and enthusiasm in the industry. At the same time, share the necessary knowledge and skills in lectures in a more understandable way. The number of students is not too much, so the quality of teaching is excellent. Instructors correct the exercises 1-1, so the lesson will be more in-depth.
View detail +
Nguyen Van Long

Specialist in accounting mode & Professional solution of Finance and Accounting in IT application - Vietnam Electricity (EVN)

I participated in Fundamental Business Analysis at BAC. At this place, the training material provides a lot of useful content and is easy to understand. The lecturers are very enthusiastic additionally the content of the curriculum, they also share many practical experiences, questions of the students are answered right in the classroom, and with illustrations from real projects. After all, Thanks to BAC and Teacher Thai Son.
View detail +