Skip to main content
HomeBlogLearner Stories

How Yuliya Upskilled on Essential SQL and Data Storytelling Skills to Become a Data Analyst at Allianz

Explore how former Business Analyst Yuliya upskilled and landed her dream job as a Data Analyst at Allianz.
Jul 2023  · 6 min read

Working with data has always been a common thread throughout Yuliya’s career as a business analyst and solutions designer.

Now, she's determined to pursue her dream job.

Yuliya wanted to bring more than 16 years of experience from different IT roles into the data analytics space—and make working with data the core of her job.

Learn how Yuliya Lagadrilliere transitioned from a solutions designer to a data analyst at Allianz Direct, sharpened her SQL and data storytelling skills, and bolstered her confidence through a DataCamp certification.

Journey into Data Analytics

Yuliya's career took her through various roles in the IT industry. — spending over 16 years as a Business Analyst and Solution Designer at global enterprises such as Nokia, IKEA, and Allianz.

Through the years, she mastered translating business requirements into IT specifications and developed a comprehensive understanding of how it all fits together. Yet, what captivated her the most was working with data and creating reports for internal stakeholders.

Reporting was a silver line through my career—from monthly invoicing reports at Nokia to inventory totals in IKEA.

Yuliya LagadrilliereData Analyst at Allianz

She first joined Allianz in 2020 as a solutions designer, where she would translate business needs into IT specifications and proceed with implementing projects. As working with data was key to understanding how systems work together, Yuliya immediately realized that her lack of SQL skills would limit her success in the role. She first signed up for a free online course to learn the basics of SQL and quickly applied her newly acquired knowledge. Excited to continue learning, Yuliya sought a more comprehensive learning experience to fit into her tight work schedule.

I tried other learning platforms before, but the learning there was so heavy and long. Hours of explanation, minimal practical experience—it was so boring. I watched hour-long videos on why SQL is important. I know that SQL is important. Can we do something about it?

Yuliya LagadrilliereData Analyst at Allianz

In April 2021, Allianz partnered with DataCamp for Business to launch the first pilot of Allianz’s Data Academy—and Yuliya was among the first to join the program.

Getting Hands-on SQL Skills with DataCamp

Yuliya started her learning on DataCamp with the Analytics Literacy track, a custom track designed in collaboration with the Allianz team and the curriculum experts from DataCamp.

The interactive nature of DataCamp immediately stood out to her, alongside the fact it provided short, bite-sized videos followed by interactive exercises to practice skills right away.

Yuliya embraced every DataCamp tool to gain hands-on experience. She used Assessments to identify skill gaps, DataCamp Workspace projects to practice data skills on real business problems, and Practice pools to challenge her knowledge daily.

Sometimes I have just 20 minutes between meetings— I go to DataCamp and watch a couple of bite-sized videos, complete several exercises, and move forward in my learning goals.

Yuliya LagadrilliereData Analyst at Allianz

She loved that the Analytics Literacy track provided an overview of topics such as Data Storytelling, Machine Learning, and Statistics. Next, Yuliya explored DataCamp at her own pace and bookmarked over 40 courses to gain mastery in SQL, Data Visualisation, and Statistics—completing one course after another.

I was learning one SQL course after another. And it was beneficial to me because I could immediately apply it to my job.

Yuliya LagadrilliereData Analyst at Allianz

After completing such courses as Intermediate SQL Queries, Joining Data in SQL, Exploratory Data Analysis in SQL, and Functions for Manipulating Data in SQL, Yuliya was able to level up her SQL reporting skills and significantly improve her query performance.

I am doing very complex reports. Sometimes I had to merge 20-30 tables together, and since I am more proficient with SQL, I can do better things faster.

Yuliya LagadrilliereData Analyst at Allianz

Start your SQL journey today!

Intermediate SQL Queries

BeginnerSkill Level
4 hr
1.5M learners
Master the basics of querying tables in relational databases such as MySQL, SQL Server, and PostgreSQL.

Learning SQL on DataCamp also helped Yuliya work with two different flavors of SQL at Allianz. Now, she can translate queries between IBM BD2 SQL client and Azure DataBricks SQL dialects.

Two years after starting learning on DataCamp, Yuliya was excited to secure her position as a Data Analyst in the Finance team at Allianz Direct.

Gaining Confidence with DataCamp Certifications

Yuliya never stopped learning. This year, she decided to challenge herself and get certified in Data Analytics. She signed up for the DataCamp Data Analyst Associate Certification and followed the preparation learning track.

I heard there is a possibility to get certified. I felt a personal challenge; I felt excited. I can do it! It is my award. It is my achievement!

Yuliya LagadrilliereData Analyst at Allianz

Yuliya aspired to get certified by the end of May, needing to fit in almost 40 hours of learning in her schedule. After speaking with her manager, she secured Friday’s afternoon dedicated to learning. Also, she spent personal time in the evenings during the week learning new concepts.

While completing the Data Analyst Associate learning plan, Yuliya fell in love with data visualization and storytelling. Alongside her Certification learning plan, she took courses on Data Communication Concepts and Understanding Data Visualizations to explore these topics further.

Data storytelling teaches you how you can talk to people. You can have a nice report, but if only you can read it, what’s the use of that?

Yuliya LagadrilliereData Analyst at Allianz

After completing the learning program, Yuliya kick-started the 30 days to pass the Certification exams. DataCamp certifications consist of a timed theory exam and a practical exam—Yuliya decided to pass the first part right away.

The theory exam is an hour-long interactive test that consists of quizzes and coding questions to verify knowledge across Data Management in SQL, Exploratory Analysis Theory, Exploratory Analysis in SQL, and Statistical Experimentation Theory.

Despite being well-prepared, Yuliya found it challenging to answer questions without the possibility to research or double-check her answers. She wasn't sure if she would succeed before finishing the exam, but she was thrilled to receive the message that she had passed. One of the most challenging topics for her was Statistics, and Yuliya plans to spend more time in the coming months refreshing her understanding of this subject.

In real life, it is a bit different: you have time to think and rethink, maybe search for an answer. But when you have 90 seconds to answer what distribution you should choose for a particular problem—you really need to focus.

Yuliya LagadrilliereData Analyst at Allianz

On the other hand, the practical exam was easier than she thought. As she already applies all her knowledge to her day-to-day tasks, submitting the project was relatively easy.

It was fun! I really enjoy solving real business problems.

Yuliya LagadrilliereData Analyst at Allianz

image1.jpg

Get certified in your dream data role

Our certification programs help you stand out and prove your skills are job-ready to potential employers.

Get Your Certification
Timeline mobile.png

Advice for Fellow Learners

For anyone looking to fit learning into a busy schedule, Yuliya recommends five things:

  1. Talk to your manager about fitting learning into the work schedule.
  2. Find your own motivation.
  3. Make yourself a plan—come up with a deadline for your learning goal and block time for learning in your weekly schedule.
  4. Find a way to apply learnings at your work
  5. Make learning fun!

Conclusion

Yuliya's journey from solutions designer to data analyst at Allianz is a powerful example of the transformative impact of learning and one’s curiosity. By mastering SQL and data storytelling through DataCamp, Yuliya secured her dream job and made her day-to-day reporting more efficient. Challenging herself to become certified made her feel more confident in her role and created a clear path for future skill improvement.

Topics

Start your SQL Journey Today!

Course

Intermediate SQL Queries

4 hr
1.5M
Master the basics of querying tables in relational databases such as MySQL, SQL Server, and PostgreSQL.
See DetailsRight Arrow
Start Course
Certification available

Course

Joining Data in SQL

4 hr
113.6K
Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries.
See MoreRight Arrow
Related

How Deepthi from Allianz Benchmarked Her Data Analytics Skills by Getting Certified with DataCamp

Learn how Deepthi, a Business Analyst at Allianz, benchmarked her Data Analytics skills with DataCamp Certifications.
Alena Guzharina's photo

Alena Guzharina

4 min

From Being Unemployed to Becoming a Senior Data Engineer with DataCamp

Michael Jordan Pilgreen found himself unemployed during COVID-19. He used DataCamp to start his career as a Data Engineer at BondCLiQ.
Alena Guzharina's photo

Alena Guzharina

How a DataCamp Donates Scholar Increased His Salary by 90%

Members of our Google Developer Student Club partners like Muhammad have seen life-changing benefits from DataCamp Donates. Join our 200+ nonprofit partners empowering 35k learners across 150+ countries with free DataCamp scholarships by applying today.
Muhammad Asher's photo

Muhammad Asher

How I Saved Months Automating My Reporting with DataCamp Workspace

Discover how Will, a Data Analyst at Starting Point, built his data skills using DataCamp and then automated his reporting using DataCamp Workspace, saving him weeks of effort.
Rhys Phillips's photo

Rhys Phillips

6 min

Avoiding Burnout for Data Professionals with Jen Fisher, Human Sustainability Leader at Deloitte

Jen and Adel cover Jen’s own personal experience with burnout, the role of a Chief Wellbeing Officer, the impact of work on our overall well-being, the patterns that lead to burnout, the future of human sustainability in the workplace and much more.
Adel Nehme's photo

Adel Nehme

44 min

Becoming Remarkable with Guy Kawasaki, Author and Chief Evangelist at Canva

Richie and Guy explore the concept of being remarkable, growth, grit and grace, the importance of experiential learning, imposter syndrome, finding your passion, how to network and find remarkable people, measuring success through benevolent impact and much more. 
Richie Cotton's photo

Richie Cotton

55 min

See MoreSee More