If you want to switch to the old version Click Here

Data Analytics

  • 5.0 Rate

  • 18 Lecture

  • 36 hours

  • 9 Weeks

It can be said that today's world stands on data. For most companies, data is their most important asset, but data without analytics is just numbers that cannot bring any added value. The role of a data analyst is precisely to translate large amounts of raw information into insights that push companies to take valuable and significant steps.

During the course, we will cover the full cycle of data analysis: formulating a business problem as an analytical problem, finding relevant data, cleaning and processing it using SQL, analyzing and visualizing data using Power BI, communicating the findings, and making decisions based on analytics.

Outcome

Skills Acquired: SQL, Power BI

  • Correctly analyze a business task and translate it into an analytical/technical task

  • Determine what type and complexity of analytics is needed for different business problems

  • Understand how data is stored, managed, and made accessible to the business in organizations of different sizes and types

  • Distinguish between different types and formats of data

  • Independently extract, clean, and process data using SQL

  • Write effective and optimized code in SQL

  • Prepare data for analysis using Power BI

  • Visualize data and perform analytics needed for business goals using Power BI

  • Present findings to stakeholders and deliver effective presentations

Nov 26 1700₾

Wed 20:00-22:00, Sat 12:00-14:00

Jan 10 1700₾

Tue 20:00-22:00, Sat 12:00-14:00

Feb 07 1700₾

Tue 20:00-22:00, Sat 12:00-14:00

Split your payment
TBC installment
BOG installment

Who is this course for?

If you actively process data

Those who work in reporting, financial or business analytics, actively process data using Excel and want to learn new tools to work with data more efficiently and quickly.

If you have analytical thinking

Someone who has never been in contact with data before, but has a well-developed analytical mindset and wants to start a career in data analytics.

If you have contact with the data

Anyone who wants to integrate data analytics in their current activities - it can be a marketer, Product Owner, Product Manager, or someone who has some kind of contact with data and wants to develop in this regard;

Program includes

Alumni Club

After successfully completing the final exam, graduates will be automatically enrolled in the Alumni Club. This membership grants them access to exclusive events, content, and special offers from our partner companies.

Bilingual Certification

Upon successful completion of the course, students will receive a bilingual certificate.

Work Based Learning

The course includes practice-based learning, including assignments/exercises and individual projects.

Graduate feedback

5.0 Rate

Syllabus

Why data analytics is important
The role of analytics in organizations of different sizes and team structures
Data analysis cycle
Correctly analyzing business tasks and translating them into analytical/technical tasks
Data sources, formats, and types
SQL installation and environment setup
Databases, objects, tables, table records
Primary key and Foreign key
Types of relations and connections between tables
SQL environment explanation
Creating and loading information into a database
Database explanation and table identification
SQL syntax
SQL writing style
Where statement
Alias
Create/Alter/Drop
Practical assignment
Inner join
Left join/Right join
Full join/Cross join
Union/Intersect/Except/Exists
Practical assignment
Common Table Expressions (CTE)
SQL String Functions
SQL Numeric Functions
SQL Date Functions
SQL Window Functions
Nested/Subquery
Optimization techniques
Stored procedures/Functions
Practical Assignment

Pick your suitable time

Lecturers

Nata Javakhishvili

Data Analytics

Nata Javakhishvili

Data Analytics

Nata is a Microsoft Certified Power BI Data Analyst with 7 years of experience working in the banking sector. She has worked in several large financial institutions. At various times, she has been involved in solving tasks such as preparatory analytical work for building DWH, analysis of information migration and smooth operation of the reporting process, preparation and presentation of important reports. Currently, she holds the position of Senior Data Analyst in the Data Analytics Department at Bank of Georgia.

Linkedin

Nini Modebadze

Data Analytics

Nini Modebadze

Data Analytics

Nini has 5 years of experience in data analytics. During this time, she has worked in Georgian companies in fintech and finance, as well as with companies from various fields - sports, healthcare, logistics, and others - on the international platform Upwork. As a data analyst, she has participated in more than 30 projects, working on processing diverse databases, interpreting complex data, and identifying insights that ultimately help companies determine business strategy and work effectively. Nini currently holds the position of Head of Corporate and Investment Banking Data Analytics Group at TBC Bank.

Linkedin

Lela Gaikharashvili

Data Analytics

Lela Gaikharashvili

Data Analytics

Lela has been working in the field of data analytics since 2015 and has worked for companies such as Ori Nabiji, Magticom, and Adjarabet. Currently, she is a Senior Reporting Developer at TNET, where she has been working since 2022. In addition to her bachelor's degree in Computer Science, Lela holds certificates in tools such as Power BI, MySQL, and others.

Linkedin

Khatia Shakaia

Data Analytics

Khatia Shakaia

Data Analytics

Khatia has 5 years of experience working in data analytics in both public and private sectors. During this period, she has worked on tasks such as developing recommendation systems, interpreting Big Data, and developing model monitoring schemes. For the last few years, Khatia has been working in the machine learning team in the banking sector. She holds Microsoft's Power BI Data Analyst and Azure Data Scientist certificates. Currently, she holds the position of Data Scientist in the Data Analytics department at Bank of Georgia.

Linkedin

FAQs for this course

A: You need to fill out an application form on our website. For this, you will need to upload an updated resume and a brief description of why you want to enroll in the course. Please note that the course has prerequisites, which are provided in the program description above.
A: You can apply for two types of grant programs with us - Nika Gujejiani's 50% grant for startup entrepreneurs, which operates within the framework of strategic communications, and a grant for socially vulnerable talents. Also, we recommend that you familiarize yourself with your company's policy regarding personnel development.

Your search Digital Designer did not match any documents

Unable to locate relevant information?

Get Free consultation

You may interest

Relevant Resources

Show More