Data analytics: SQL, Power Bi + artificial intelligence (AI) - evenings

Planned training:

May 8
June 12
July 10
August 7
September 11
October 9
November 6
December 4

Price: 950€
(When paying the full amount, a 10% discount is applied immediately)

Registruotis

ALL LECTURES LIVE: lectures are held LIVE - IN REAL TIME WITH THE LECTURER (+ soft skill and AI lecture recordings)

Blended learning: study and from home ir from the class. Ability to change the format during training

Runtime: 90 hours, 8 weeks - 23 lessons

Time: 3 times a week, from 18.00:22 - 00:XNUMX

Course repetition: possibility to return to repeat the course for FREE during the year

Training for companies: all programs can be adapted to your needs

12
.

Data analytics: SQL, Power Bi + artificial intelligence (AI) - evening training

LECTURES ARE LIVE, IN REAL TIME WITH THE LECTURER
There is no selection for training - everyone can learn!

This advanced business intelligence (BI) and SQL application enables you to analyze data and turn it into actionable insights. The program includes advanced SQL database management s...system, integrated data analysis tools and dynamic reports. Users can enjoy intuitive information visualization dashboards, customizable reports and trend analysis. The program is designed to increase operational efficiency, identify market trends and promote strategic business planning. Upon graduation, students will be able to work in data analytics, business intelligence, database administration, and system analysis.

More...

What will I learn?

Database architecture and how to build it

advanced SQL, including windows functions and procedures and functions

Provide insights from data

PowerBI reporting

Process automation

What will I be able to do after the training?

Create your own database

Write data queries, create procedures, functions and so on for data ETLS

Provide a variety of insights from data

Streamline processes by automating steps

What after training?

After these trainings, students are invited to continue participating in the school's mentoring program free of charge: for a whole month, if questions arise, they can both contact the school's lecturer and use the school's classrooms for independent study.

For our students who want to start a career in the IT field, the Career Center will help them search for an internship or job, provide all the necessary information about job interviews, help them prepare a strong and attractive CV and LinkedIn profile, which will distinguish you from other candidates during the selection process. We constantly share job and internship offers and advise on all issues related to employment. You will not be alone during your job search, our professional team of consultants and mentors will provide comprehensive assistance to achieve your goal of successfully starting a career in the IT field.

Vilnius Coding School cooperates with more than 250 companies - partners that can provide career opportunities for graduates of our school. Even 85 percent everyone who has finished school and applied for a job is successfully employed.

Possible job positions after training:

Possible job positions after training: Junior Data Analyst Junior Business Analyst Health Insurance Analyst Data Administration Specialist Business Intelligence (BI) Specialist Business Intelligence (BI) Analyst Financial Analyst Financial Reporting Analyst System Analyst IT Analyst

Training program

Introduction to Databases
Basic SQL Queries
Connectors and Subqueries
Data Manipulation

Indexing and Optimization
Store Procedures and Functions
Triggers and Transactions

Introduction to PowerBI
Connecting to Data Sources

Data Modeling and Communications
DAX (Data Analysis Expressions)

Development of Reports and Websites
Interactivity and User Experience

Power Query and M Language
Advanced DAX Techniques
PowerBI Service and Installation

Real World Projects
Review and Q&A Sessions

1. Communication skills

Active listening
Effective communication
Dealing with difficult customers
Creating a connection

2. Problem solving strategies

Problem analysis and diagnostics
Determination of solutions
Troubleshooting methods
Root cause analysis of the problem
Latest problem solving technologies
How to get feedback from managers
Professional development

3. Time management and organization

Prioritization of tasks
Workload management
Delegation and collaboration

4. Emotional intelligence

Understanding and managing emotions
Empathy and compassion
Conflict resolution
Stress management

5. How to learn more and faster and less
to forget

5 minute brain exercise
Clear your "mental fog" with these 5
delicious brain foods
Learn a powerful memory technique to
you would never miss a meeting

The operation of artificial intelligence. How is it different from a human?
Creating a request (Prompt). What is the difference between a good query and a bad one?
Validation of results. Checking the received data for suitability in a specific case.
Versioning Policy. Identification of the used software (vendor) version in the request.
Artificial intelligence plugins in the code editor (IDE). Advantages and disadvantages.
Generating comments using artificial intelligence.
Creating tests with the help of a plugin.
Code optimization with the help of a plugin.

Trial lecture

Registruotis

Vilnius coding School CERTIFICATE

strong evidence that you are ready career ITEM!

Official certificate approved by the Education and Science Register

Recognized by the strongest Lithuanian and international companies

It proves that you have studied with the best specialists in your field

Reliable proof of acquired skills

Certificate issued by a company developing transparent activities in Lithuania

This certificate confirms that you attended at least 95% of the course lectures in real time with the lecturer, completed and defended the final thesis

Discount system

Normal cost of training 950 €

BY PAYING THE FULL AMOUNT IMMEDIATELY
we apply a 10% discount!

€ 855

(Full price 950 €)

Applies if you pay the full amount at the time of pre-registration

ALUMNI
we apply a 15% discount!

€ 808

(Full price 950 €)

Applies to all school graduates for all training and weekend workshops

RECOMMEND US TO A FRIEND
we apply a 10% discount!

€ 855

(Full price 950 €)

Applies if you come to study as a couple

* Discounts are not cumulative

** The discount for paying the full amount at once does not apply to Python, SQL, Agile and WEB design training

Registration for these trainings

Full name(Required)

Name Last name

E.mail (Required)

Telephone number(Required)

Select the date of the fundamentals of programming and IT project management training

Select the date of the data analytics (big-data) evening training

Select the date of evening training for automatic and manual testing

Select the date of the python programming basics training

Select the date of the UX/UI web design evening training

Select the date of the Java programming basics evening training

Select the date of the web development (full-stack) evening training

Select a date for C# (.NET) Basics training

Select the date of the introduction to cyber security training

Select the IT HR Academy training date

Select the date of the evening training in C# Programming: From the beginning to the application of AI

Select the date of the programming with Python evening training

Select the date of the evening training for automatic testing

Select the date of JAVASCRIPT evening training

Select the date of JAVA evening training

Select the date of the evening training on the basics of web design and front-end programming

Select the date of the web development evening training

Select the date of the evening training in data analysis and python programming basics

Select the date of the IT system security basics evening training

Select the date of the long javascript full-stack evening training

Choose the date of evening training from JAVA basics to mobile application development

Select a date for Data Science: From Python Programming Basics to Data Analytics Practice Training

Choose data analytics: SQL + Power BI - evening training date

Select the date of evening No-code training

Select a date for evening DevOps training

Select a date for the evening training in artificial intelligence

Additional questions/comments

Name	Supplier	Purpose	Validity
__cfduid	tidio.co	Used by the Cloudflare network to help identify trusted network traffic	1 years old
__cfduid	tidiochat.com	Used by the Cloudflare network to help identify trusted network traffic	1 years old
csrftoken	Instagram.com	Helps protect against CSRF attacks	1 years old
moove_gdpr_popup	vilniuscoding.lt	Saves privacy preference settings	1 years old
_ga	vilniuscoding.lt	Logs a unique user ID that identifies user behavior on the site	2 years old
_gid	vilniuscoding.lt	Logs a unique user ID that identifies user behavior on the site	Session
_dc_gtm_UA-#	vilniuscoding.lt	Google Tag Manager cookie to control the Google Analytics tag	Session
Collect	google-analytics.com	Google Analytics cookie to send information about the user's device and behavior	Session
1P_JAR	Google com	A Google cookie used to collect website statistics and track conversions	30 days
AID	Google com	A cookie used to associate activities with other devices used if you were signed in to your Google account	1 years old
APISID	Google com	A cookie to save your Google account settings and map information	2 years old
CONSENT	Google LT	A cookie to save your consent to accept Google cookies	20
HSID	Google com	A cookie to save your Google account settings and map information	2 years old
NID	Google com	A cookie to save your Google account settings and map information	6 month
SAPISID	Google com	A cookie to save your Google account settings and map information	2 years old
SID	Google com	A cookie to save your Google account settings and map information	2 years old
SIDCC	Google com	A cookie to save your Google account settings and map information	3 month
SSID	Google com	A cookie to save your Google account settings and map information	2 years old
DSID	doubleclick.net	Google DoubleClick cookie for marketing purposes	Session
IDE	doubleclick.net	Google DoubleClick cookie to collect information about advertisements clicked by the user	1 years old

Name	Supplier	Purpose	Validity
fr	facebook.com	Facebook cookie for marketing purposes	1 years old
datr	facebook.com	Facebook cookie for marketing purposes	2 years old
reg_ext_ref	facebook.com	Facebook cookie for marketing purposes	Session
reg_fb_gate	facebook.com	Facebook cookie for marketing purposes	Session
reg_fb_ref	facebook.com	Facebook cookie for marketing purposes	Session
wd	facebook.com	Facebook cookie for marketing purposes	7 days
_hjClosedSurveyInvites	hotjar.com	Hotjar cookie for marketing purposes	365 days
_hjDonePolls	hotjar.com	Hotjar cookie for marketing purposes	365 days
_hjMinimized Polls	hotjar.com	Hotjar cookie for marketing purposes	365 days
_hjDoneTestersWidgets	hotjar.com	Hotjar cookie for marketing purposes	365 days
_hjMinimizedTestersWidgets	hotjar.com	Hotjar cookie for marketing purposes	365 days
_hjIncludedInSample	hotjar.com	Hotjar cookie for marketing purposes	365 days
_hjShownFeedbackMessage	hotjar.com	Hotjar cookie for marketing purposes	365 days
_hjDoneSurveys	hotjar.com	Hotjar cookie for marketing purposes	365 days
BizoID	ads.linkedin.com	LinkedIn cookie for marketing purposes	1 month
long	ads.linkedin.com	LinkedIn cookie for marketing purposes	session
UserMatchHistory	ads.linkedin.com	LinkedIn cookie for marketing purposes	1 month
long	linkedin.com	LinkedIn cookie for marketing purposes	session
wd	linkedin.com	LinkedIn cookie for marketing purposes	7 days
cookie	linkedin.com	LinkedIn cookie for marketing purposes	2 years old
memberc	linkedin.com	LinkedIn cookie for marketing purposes	1 day
cookie	www.linkedin.com	LinkedIn cookie for marketing purposes	2 years old

Planned training:

12
.

Data analytics: SQL, Power Bi + artificial intelligence (AI) - evening training

What will I learn?

What will I be able to do after the training?

What after training?

Possible job positions after training:

Training program

Vilnius coding School CERTIFICATE

strong evidence that you are ready career ITEM!

Discount system

€ 855

€ 808

€ 855

Registration for these trainings

Flexible billing

The most popular ways

Do you want to learn individually?
1:1 studies with a lecturer

Why is it worth studying?

@vilniuscodingschool

Projects

Planned training:

12.

Data analytics: SQL, Power Bi + artificial intelligence (AI) - evening training

What will I learn?

What will I be able to do after the training?

What after training?

Possible job positions after training:

Training program

Vilnius coding School CERTIFICATE

strong evidence that you are ready career ITEM!

Discount system

€ 855

€ 808

€ 855

Registration for these trainings

Flexible billing

The most popular ways

Do you want to learn individually? 1:1 studies with a lecturer

Why is it worth studying?

@vilniuscodingschool

12
.

Do you want to learn individually?
1:1 studies with a lecturer