Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
Introduction
Theoretical Science of Data Analysis
- The principles of data analysis
- Objectives of data analysis
- Approaches for data analysis
Excel and Data Science
- Data consistency
- Data types used in Excel
Overview of Power BI
- Processes and Power products used in Power BI
Preparing the Development Environment
- Installing and configuring Excel
- Installing and configuring Power BI
Business Data Analysis in Excel
- Inserting and working with PivotCharts
- Inserting and working with PowerPivots
- Mail merging
- Linking and duplicating sheets
- Freezing panes
- Splitting windows
- Using conditional formatting
- Creating a named range
- Using Execel Web Query
- Working with Power Excel functions
Power BI and Excel Integration
- Importing data from Excel to Power BI with Power View
- Incorporating Excel into the Power BI Portal
Cleaning Data in Power BI
- Cleaning up cross tab data with unPivot
- Cleaning up multiple cross tab data
- Combining data from multiple tabs and sheets
Databases and Reports in Power BI
- Using relationships to eliminate VLOOKUP
- Creating calculated columns
- Creating a custom date table
- Working with reports and visuals
- Filtering reports and viewing data
- Publishing the report to Power BI Portal
DAX and Power BI
- Adding calculated columns
- Text grouping
- Using Bin Analysis
- Adding measures
- Comparing past and current data
Summary and Conclusion
Requirements
- An understanding of the basics in Excel.
Audience
- Data Analysts
Testimonials
I liked the examples and the way he explained.
Sandeep Parashar
The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions.
Daria Rudin
Tamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.
Christine Weiler
Clear and clear explanation of Excel problems
Mateusz Lemańczyk
interaction of the group with the group, group requests for solving specific problems
Szymon Karczerwski - RSM Poland
I mostly enjoyed the exercises.
Anna Szumniak
Training agenda was well thought out.
Przemek Zalasinski
I genuinely enjoyed the short exercises.
Mateusz Podsiadlo
variety of tasks
Olga Głowacka
The activity was conducted in an accessible language and very interesting. The trainee is drawn into the world of Excel and makes a promising trip with his mentor (Mr. Daniel) after the highlands and lowlands of the program :)
Marta Nijakowska
The pace was the perfect fact that we had a group specially selected. We went through all the functionalities of Excel, which I wanted to discover such things that I did not know.
Ewa Czerwińska
a lot of exercise
Małgorzata Jasniecka
Possibilities to practice all the knowledge gained during the training in additional tasks.
Wioleta Kubczak
a large range of information
Piotr Janicki
problem solving on a regular basis. searching for the most useful elements for trainees.
Dominik Gardo
Trainer's help in solving problems
Tomasz Czornak
Doing live exercises in Excel, and trainer knowledge.
Perceval Pradelle
the way of providing information, simple readability, the ability to make contact
Pirelli
adjusting the scope of training to the actual needs at my workplace
Marcin Ostrówka
examples
IZBA SKARBOWA W OPOLU
Help the trainer to perform tasks
Anna Hałas
Assistance of the trainer during the classes
Magdalena Toczek
trainer's knowledge, readiness to solve emerging problems and answer questions
Anna Chęcińska
Flexibility and adaptation of issues as needed
Joanna Mika
The training contained a lot of interesting and well-chosen examples for practical use.
Piotr Walewski
The atmosphere, the knowledge of the trainer, skills of the manager
Beata Perzanowska
The way of conducting classes, clear transfer of issues
Anna Kremens
Creating and PivotTable capabilities. Providing / looking for answers to current questions / problems.
Bartosz Muńko
Content and the way it was provided.
Marcin Samborski
temperament, knowledge, efficiency
Henryk Kubiak
It was really nice of the trainer that he took a lot of time to answer our questions and helped us improve or gave us hints on how to improve some macros we were already using without fully understanding the code.
David Trieu - CD Projekt SA
I generally enjoyed the practical examples.
Marika Agius
I liked the step by step and hands on realistic data examples.
CARL MIFSUD
I mostly liked the hands-on practice and exercises.
Godwin Spiteri
Tamil has an excellent way of explaining things. He speaks clearly and will take the time to explain things individually when necessary.
Theresa Fenech
The trainer was very well prepared and encouraged interaction with the group. The exercises were very interesting and enabled us to utilize the knowledge on the subject in a practical context.
Tomasz Kolbuszewski
Trainer was calm and very patient to explain in a way that everyone understands, even those with basic knowledge of excel.
Sera Farrugia
I appreciated its applicability to work related issues.
Ranier Buhagiar
I appreciate that the training was customized to our company's needs.
Rosanne Tanti
I liked the fact that we were a small group and therefore the trainer was able to offer individual attention to each trainee.
Claire Pace
clear, readable messages, very well prepared materials for work. It is a pity that screenshots of descriptive materials in English
Renata Kurek
A lot of practical issues
innogy Polska S.A.
Practical exercises, discovering new excel possibilities
Małgorzata Kiedykl
Gaining new skills in Excel and learning the VBA language which I hope will help me in my future work.
Sylwia Śliwka
A lot of exercise. Trainer doesn't need to have support for his course. He has really great knowledge for his subject.
Quentin Demeyere
interesting and at the same time easy, absorbed way of presentation
Justyna Gutowska-Błaszyk
solving live problems (problems that participants had).
Dominik Gardo
tips
Kamil Kowalski
a large variety of examples, transparent creation of forms step by step, efficiently conducted workshops despite the diversity of knowledge and skills of participants
Bogusia Kafel
substantive and useful examples
Magdalena Barcicka
The trainer prepared for training, specifically and on the subject
P4 Sp. z o.o.
Work on computers
P4 Sp. z o.o.
specific examples and adjusting the exercises to our needs
Marcin Gołdyn
practical examples
P4 Sp. z o.o.
tempo and help adapted to the participants' needs
Dariusz Leszczak-Phong
Broad knowledge of the lecturer
Michał Jąkalski
I generally enjoyed the instructors knowledge.
US Bank
Leader's enthusiasm and commitment :)
Credit Agricole Bank Polska S.A
exercises
Credit Agricole Bank Polska S.A
In case of problems, an individual approach; patience.
Credit Agricole Bank Polska S.A
Contact, no barriers to making contact. exercises
Credit Agricole Bank Polska S.A
commitment and direct contact and practical knowledge
Credit Agricole Bank Polska S.A
I generally was benefit from the examples.
Ewelina Palacz
The training was really useful. I liked the most the parts related to the pivot tables, filtering, lockup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.
Katarzyna Chalinska - UBS Business Solutions Poland Sp. z o.o.
Training was well prepared from the beginning. Enthusiasm and great attitude of the trainer helped us successfully deliver the training. Positive feelings! Highly recommended!.
Łukasz
I was benefit from the possibility to ask various questions and real life solutions to them.
Magdalena Wojtas
A synthetic and efficient course of training. A small group, a lot of exercises
Anna Bazel
Practical use of content provided during training in the exercises. Translation on examples.
SECO/WARWICK S.A. ; ; TRW Steering Systems Poland Sp. z o.o.
Very helpful, made me feel more comfortable using Excel.
TruGreen
I appreciated the amount of effort and energy that Roman put into this. Hours and hours and hours of Excel training will inevitably get boring, but Roman's attention to detail, energy, and thoroughness made me want to keep learning--even at 5 PM on the second, of two, eight hour learning days.
Christian Labenberg - TruGreen
I generally enjoyed the relevant examples and interesting curriculum.
Alex Gubanov
Excellent trainer. Very adept at modifying the course to fit our time line.
TruGreen
I liked learning new ways to process data in Excel, in an engaging and fun learning environment.
Hunter Smith
I mostly was benefit from the interaction with the class.
TruGreen
Roman was great! He was really entertaining and helpful. He is very knowledgeable and passionate about the subject. He made the class enjoyable, and made you want to learn and ask questions.
TruGreen
All
Neinver Asset Management Polska Sp. z o.o.
exercises
Katarzyna Skorys
The way of transferring knowledge. Unfortunately, I regret that I was only one day. I hope that my company will also benefit from your services next year.
Neinver Asset Management Polska Sp. z o.o.
A lot of shortcuts and such flavors that improve work.
DNV GL Business Assurance Poland Sp. z o.o.
work on our real files
Katarzyna Grodecka
Very good introduction to VBA, numerous examples, getting to know many previously unknown functionalities
Przemysław Naskręt
What I liked most was the very practical approach, the ability to work on files on which we actually work every day and to adapt the training to our needs, our internal work specifics.
Anna Jarocka
the scope of training to stick to topics; a lot of examples
DNV GL Business Assurance Poland Sp. z o.o.
The coach had time for all participants and made sure that no one was left with mistakes / unresolved task, and yet there was not enough time to implement the planned material
Anna Niestępska
The flexibility of the trainer and the ability to adjust the exercises to the questions raised during the training. The training did not have a rigid plan, the plan evolved during the training under the influence of my needs.
Paweł Imbir
Tricks and Tips and also structural items.
Ritesh Gupta
Learned many new tricks and lots of eye-openers. Tamil kept it interesting and was always able to surprise with new things and insights.
APM Terminals B.V.
The trainer was a knowledgeable and approachable person it was good to refresh & extend my excel knowledge.
laura kooijman
The smart tips that are not too complicated but helpful.
APM Terminals B.V.
Tamil was great at handling our idiosyncrasies and responding to specific needs from people at various skill levels.
Brian Pishko
Flexibility in conducting training, matching the scope of training to participants.
Marcin Doleżyk
I was benefit from the examples from different area of VBA programming.
UBS Business Solutions Poland Sp. z o.o.
The whole topic is interesting - everything was OK.
Bartosz Wierzewski - UBS B
Good knowledge of the lecturer
Marcin Doleżyk
I was benefit from a lot of exercises.
UBS Business Solutions Poland Sp. z o.o.
I was benefit from the well prepared examples, plenty of opportunity to practice.
Piotr Ogar - UBS Business Solutions Poland Sp. z o.
communicativeness and the way of transferring knowledge
Nord Inwest Sp. z o.o.
exercise
Gabriela Szyndralewicz - Nord Inwest Sp. z o.o.
way of approach leading to the students
Krystyna Pałka - Nord Inwest Sp. z o.o.
Related Courses
Power BI Dashboards
14 hours
Power BI for Business Analysts
21 hours
Power BI Dashboard Design
7 hours
Analyzing Data with Power BI
28 hours
Power BI
14 hours
Power BI for Developers
28 hours
Advanced Power BI
21 hours
Analysing Financial Data in Excel
14 hours
Excel For Statistical Data Analysis
14 hours
Excel Advanced with VBA
21 hours