Peter completed his degree in Economics with a specialization in Tourism. After a longer period of traveling, he found his interest in computer sciences. Before deciding to have a career in data analysis he was learning Java Script and Data Science online. During his placements, he came across a variety of projects including the following: Completed performance checks and optimized dashboards in Tableau after cloud migration ensuring a smooth shift from server to cloud enabling a better client experience. Constructed a comprehensive framework for dashboard development and defined a QA checklist for the BI Team to elevate precision while reducing errors. Standardizing the process reduced the development time by 30-40% and created transparency for management to oversee projects and check quality. Built a series of Power BI dashboards to evaluate survey data. This helped the client decide on changes to their subjects and course offerings increasing their efficiency. Resolved any data and performance issues related to workbooks and data sources. Designed, developed, and validated Alteryx workflows for automating reports, resulting in an accelerated reporting process saving significant time. Provided technical support and Alteryx training to elevate the team's overall competency and become more efficient saving approximately £25,000. I was also a project manager where a team had to find insights into a police-related dataset that could be used in a mayoral campaign. Carried out a thorough Alteryx research on DCM and SDLC and best practices to support standard operating procedures.
Peter Hajnal
![](https://content.theinformationlab.co.uk/images/medium_peter_hajnal_e647d663bc.jpg)
Certifications
Blog Posts
![Avatar](https://content.theinformationlab.co.uk/images/peter_hajnal_e647d663bc.jpg)
Wed 23 Nov 2022 | Peter Hajnal
Setting up and connecting to an IBM DB2 server in Tableau
Step 0.
Gather all the credentials you need:
· Server:
· Port :
· Database:
· User ID:
· Password:
Step 1.
You can only connect to IBM DB2 server directly if the database is z/Os and not iSeries. Tableau doesn’t support iSeries
![Avatar](https://content.theinformationlab.co.uk/images/peter_hajnal_e647d663bc.jpg)
Tue 25 Oct 2022 | Peter Hajnal
How to PM
At some point in your Client Project you will be asked to be the Project Manager. While I'm pretty sure you heard the term before, in case it's not quite clear for you what is about when it comes to The Data School, here's a little intro.
Before the initial client call, check your emails
![Avatar](https://content.theinformationlab.co.uk/images/peter_hajnal_e647d663bc.jpg)
Tue 25 Oct 2022 | Peter Hajnal
Tableau Certified Data Analyst Exam
You find a lot of useful information on convo about the exam here
Certified Data Analyst Exam - Convo
I also wanted to add my opinion on it and how I found it. First of all, get ready to be annoyed a little bit. Registering and setting up your exam date is fairly easy
![Avatar](https://content.theinformationlab.co.uk/images/peter_hajnal_e647d663bc.jpg)
Tue 25 Oct 2022 | Peter Hajnal
Dashboard week: day 1
Day one is over for our dashboard week. We've been tasked to make accessible dashboards for people with disabilities. We had the choice to decide what kind of disability are we focusing on.
After going through the options, I decided to make a universal dashboard. Next step was to make a plan
![Avatar](https://content.theinformationlab.co.uk/images/peter_hajnal_e647d663bc.jpg)
Wed 27 Jul 2022 | Peter Hajnal
Extracts in Tableau server
An extract in Tableau is a representation of your data that you have saved from your data source. This can speed up dashboards, but also allow certain advantages, such as using Tableau functionality that isn't available in the original data, or supporting very large data sets
![Avatar](https://content.theinformationlab.co.uk/images/peter_hajnal_e647d663bc.jpg)
Thu 21 Jul 2022 | Peter Hajnal
Confused yet?
Slowly getting to the end of Week 3, a day before the Alteryx Core Exam. Last few days we practiced what we already learnt, and got a handful of good ideas, know-hows, and best practices from Angelos. We were started to gain a bit of confidence, but was time to learn something new
![Avatar](https://content.theinformationlab.co.uk/images/peter_hajnal_e647d663bc.jpg)
Tue 12 Jul 2022 | Peter Hajnal
Filtering Blue vs Filtering Green
Filtering is super useful in Tableau. We can organize and simplify our data with it and we like that.
There are 6 different type of filter options:
1. Extract Filter
2. Data Source Filter
3. Context Filter
4. Dimension Filter
5. Measure Filter
6