Top Banking Certification Courses


Advanced Data Analysis Techniques Training

Introduction:

Nowadays, it is no surprise that corporate staff is overwhelmed by the abundance of unstructured data. ERPs and databases have evolved to a point where they can house large amounts of data. The question now is, what do you do with this data to add value? This advanced data analysis techniques program will introduce hands-on business intelligence (BI) to allow you to clean, normalize, and interpret large volumes of data.

You can establish historical relationships, analyze the current situation, and predict future strategies. BI's borderless application covers operational, tactical, and strategic business decisions. It spans all departments and cascades down to all users who perform data cleansing, reporting, analysis, modeling, integration, and automation.

In this advanced data analysis techniques course, we use MS Excel exclusively as an ultimate and readily available BI tool, allowing you to develop an exclusive level of expertise and add immediate value to your job and company.

Defining Advanced Data Analysis Techniques:

Advanced data analysis techniques encompass various methods for inspecting, cleaning, transforming, and modeling data to discover useful information, inform conclusions, and support decision-making.

This advanced data analysis techniques course dives deep into these techniques, covering not just quantitative but also qualitative, historical, case study, and customer data analysis techniques. Participants will gain insights into common data analysis techniques and the instrumental tools that enable efficient and meaningful analysis.

Targeted Groups:

  • Business Professionals.
  • Business Analysts.
  • Data Analysts.
  • Research Analysts.
  • Finance Professionals.
  • Marketing and Sales Professionals.
  • HR Professionals.
  • IT Professionals.
  • Administrative Staff.
  • Supervisors, General Business Professionals, and staff from any function need to learn and apply state-of-the-art data analysis techniques to their daily business reporting and decision-making.

Course Objectives:

At the end of this advanced data analysis techniques course, the participants will be able to:

  • Boost Excel Business Intelligence (BI) expertise in data slicing, dicing, massaging, and data aggregation and modeling.
  • Perform data normalization, consolidation, report writing, analysis, and reconciliation.
  • Link Excel with Access, Web, Text, Internet, SQL, ERPs, and other databases to develop dynamic BI models, dashboards, scorecards, and flash management reports.
  • Advance and enhance the look and feel of reports using dynamic visualization techniques
  • Acquire numerous tips and tricks that enable them to work efficiently.

Targeted Competencies:

By the end of this advanced data analysis techniques course, the participant's competencies will:

  • Massage and normalize data.
  • Report, analysis, and reconciliation.
  • Interpretation of large data sets.
  • Model and what-if scenarios.
  • Establish data integration.
  • Develop dynamic dashboards and scorecards.
  • Design key performance indicators.

Course Content:

Unit 1: Data Analysis Tools and Techniques:

  • Consolidate data from separate files and sheets.
  • Know advanced data validation using lists, dates, and custom validation.
  • Powerful array functions.
  • Cell management tools: left, right, mid, concatenate, value.
  • Name, edit, and manage cells and ranges.
  • Subtotal, Sumif, Sumifs, sum-product, count, Countif, and counties.
  • Look up data, texts, and values using Vlookup.
  • The incredible table-tools technique.
  • Slice dates into day names, weeks, week numbers, month names, years, and quarters.
  • Text-to-columns and dynamic trimming using trim and lens.
  • Manage texts and numbers using replace, find, and substitute.
  • Text change functions.

Unit 2: Mastering Data Reporting:

  • The 20 must-learn pivot-tables tools.
  • Create pivot tables.
  • Number formatting techniques.
  • Design report layout.
  • Sort in ascending, descending, and more sort options.
  • Filter labels and values.
  • Expand and collapse reports.
  • Drill down option.
  • Summarize values by sum, average, minimum, maximum, count.
  • Show values as % of total and % of.
  • Pivot table options.
  • Insert formulas.
  • Data analysis.
  • Copy pivot tables.
  • Create pivot charts.
  • Dynamic chart labeling.
  • Master the slicer.
  • Show report filter pages.
  • Linking pivot tables and pivot graphs with PowerPoint.
  • Conditional formatting with pivot tables.
  • Design reports using the get pivot data.

Unit 3: Data Modeling and Integration:

  • Spinner.
  • Checkbox data modeling with the if function.
  • Option button data modeling with if function.
  • List box data modeling with choose function.
  • Scenario manager.
  • Link Excel with text files.
  • Link Excel with databases (Access).
  • Understand the linking of Excel with SQL.
  • Link Excel with the Internet.
  • Link Excel with Excel.

Unit 4: The Look and Feel:

  • Chart and visualize techniques.
  • Use the camera tool.
  • Work with formula-driven visualizations.
  • Use fancy fonts.
  • Leverage symbols in formulas.
  • Work with sparklines.
  • Create unconventional style charts.

Unit 5: Tips and Tricks:

  • Control and protect your reports, worksheets, and workbooks.
  • Data entry form.
  • Custom list.
  • Text-to-speech.
  • Understand advanced conditional formatting.
  • Shortcuts for your daily work.

Amman (Jordan)
16 - 20 Feb 2025
3200 Euro
Lisbon (Portugal)
24 - 28 Feb 2025
5300 Euro
Istanbul (Turkey)
02 - 06 Mar 2025
4900 Euro
Cairo (Egypt)
09 - 13 Mar 2025
3500 Euro
Kuala Lumpur (Malaysia)
09 - 13 Mar 2025
4400 Euro
Online
09 - 13 Mar 2025
1900 Euro
Barcelona (Spain)
10 - 14 Mar 2025
5300 Euro
Barcelona (Spain)
17 - 21 Mar 2025
5300 Euro
Amman (Jordan)
30 Mar - 03 Apr 2025
3200 Euro
Geneva (Switzerland)
31 Mar - 04 Apr 2025
6500 Euro
Dubai (UAE)
06 - 10 Apr 2025
4400 Euro
London (UK)
07 - 11 Apr 2025
5500 Euro
Brussels (Belgium)
14 - 18 Apr 2025
5300 Euro
Istanbul (Turkey)
20 - 24 Apr 2025
4900 Euro
Online
27 Apr - 01 May 2025
1900 Euro
Paris (France)
28 Apr - 02 May 2025
5300 Euro
Madrid (Spain)
28 Apr - 02 May 2025
5300 Euro
Online
04 - 08 May 2025
1900 Euro
Casablanca (Morocco)
19 - 23 May 2025
4000 Euro
Manama (Bahrain)
25 - 29 May 2025
4500 Euro
Sharm El-Sheikh (Egypt)
08 - 12 Jun 2025
4500 Euro
Kuala Lumpur (Malaysia)
08 - 12 Jun 2025
4400 Euro
Istanbul (Turkey)
08 - 12 Jun 2025
4900 Euro
London (UK)
09 - 13 Jun 2025
5500 Euro
Cairo (Egypt)
15 - 19 Jun 2025
3500 Euro
London (UK)
23 - 27 Jun 2025
5500 Euro
Geneva (Switzerland)
23 - 27 Jun 2025
6500 Euro
Amsterdam (Netherlands)
23 - 27 Jun 2025
5300 Euro
Vienna (Austria)
23 - 27 Jun 2025
5500 Euro
Barcelona (Spain)
30 Jun - 04 Jul 2025
5300 Euro
Dubai (UAE)
13 - 17 Jul 2025
4400 Euro
Amman (Jordan)
13 - 17 Jul 2025
3200 Euro
Manama (Bahrain)
20 - 24 Jul 2025
4500 Euro
Casablanca (Morocco)
21 - 25 Jul 2025
4000 Euro
Cairo (Egypt)
27 - 31 Jul 2025
3500 Euro
Online
27 - 31 Jul 2025
1900 Euro
Boston (USA)
28 Jul - 01 Aug 2025
7200 Euro
Istanbul (Turkey)
03 - 07 Aug 2025
4900 Euro
London (UK)
04 - 08 Aug 2025
5500 Euro
Dubai (UAE)
10 - 14 Aug 2025
4400 Euro
Brussels (Belgium)
11 - 15 Aug 2025
5300 Euro
Barcelona (Spain)
18 - 22 Aug 2025
5300 Euro
Kuala Lumpur (Malaysia)
24 - 28 Aug 2025
4400 Euro
Istanbul (Turkey)
24 - 28 Aug 2025
4900 Euro
Milan (Italy)
25 - 29 Aug 2025
5900 Euro
Kuala Lumpur (Malaysia)
31 Aug - 04 Sep 2025
4400 Euro
London (UK)
01 - 05 Sep 2025
5500 Euro
Barcelona (Spain)
01 - 05 Sep 2025
5300 Euro
Dubai (UAE)
07 - 11 Sep 2025
4400 Euro
Rome (Italy)
08 - 12 Sep 2025
5900 Euro

Top Banking Certification Courses
Advanced Data Analysis Techniques Training (BA)

 

Mercury dynamic schedule is constantly reviewed and updated to ensure that every category is being addressed at least once a month, if not once every week. Please check the training courses listed below and if you do not find the subject you are interested in, email us or give us a call and we will do our best to assist.