Setup Menus in Admin Panel

Give us a Call: M: (+971) 55 253 7914

Live Online Courses
Click for schedules & registraion
 
Search Courses
Generic filters
Exact matches only
Filter by Custom Post Type

Live Online Training Schedules

Now participate in a live online course for a highly discounted fee of only $850, as a limited introductory offer.
(Terms and conditions apply)
CodeDateFormatFees 
DM0608 Feb - 10 Feb, 2021Live Online$1300Register
DM0610 May - 14 May, 2021Live Online$1800Register
DM0609 Aug - 11 Aug, 2021Live Online$1300Register
DM0608 Nov - 12 Nov, 2021Live Online$1800Register

Classroom Training Schedules

CodeDateVenueFees 
DM0608 Feb - 19 Feb, 2021Amsterdam$7125Register
DM0627 Jun - 01 Jul, 2021Dubai$3950Register
DM0620 Sep - 24 Sep, 2021Istanbul$4750Register
DM0605 Dec - 16 Dec, 2021Dubai$5950Register

Did you know you can also choose your own preffered dates & location? Customise Schedule

Course Overview

Analysing data empowers you to make better decisions. Data analysis is the term given to the process of evaluating data and translating it into information. It consists of data mining, statistical analysis, business analytics, descriptive and predictive analysis, and big data analytics.

It involves several stages including determining a data set, organising the data for handling, applying evaluation models, deriving key findings and generating reports from the processed data. The main objective of data analysis is to discover understandings that can be used in more effective decision making.

What will you learn from this particular Data Analysis training program? In this course, you will learn how to perform data analysis using Microsoft Excel’s most popular features.

Microsoft Excel is one of the most widely used tools for data analysis and its in-built pivot tables are possibly the most common analytics tool used by a range of professionals from beginners to those with advanced levels of experience. You will be taught how to create pivot tables from a collection with rows and columns in Excel.

You will find out the power of Excel pivots and their power to condense data in flexible ways, enabling rapid evaluation of data and creating useful insights from the collected data. Pivot tables and charts are used in many diverse industries by the masses who want to generate various types of reports relevant to the performance of their organisations.

They do so because, in Excel, formulas can be used easily to accumulate data and create meaningful information. In addition to pivot tables, pivot charts and slicers can also be used to visualise data and create user-friendly dashboards that depict data as readable information.

This Zoe training course will empower you with the ability to apply your new data analysis skills to business analytics, big data analytics, bioinformatics, and statistics.

Course Objectives

Upon completing this Data Analysis Training Certification course successfully, participants will be able to:

  • Learn about data model creation
  • Explore, analyse, and visualise data
  • Sift data using slicers in multiple pivot tables
  • Produce aggregate reports using formula-based techniques
  • Collect and transform data from multiple sources
  • Understand and combine data in mashups
  • Generate flexible data aggregations using pivot tables
  • Exemplify data visually using pivot charts
  • Evaluate margins and other popular ratios using calculation on the pivot table

Training Methodology

This is an interactive Data Analysis Training Certification program and will consist of the following training approaches:

  • Lectures
  • Seminars & Presentations
  • Group Discussions
  • Assignments
  • Case Studies & Functional Exercises

Similar to all our courses, this program also follows the ‘Do-Review-Learn-Apply’ model.

Organisational Benefits

Companies who send in their employees to participate in this Data Analysis course can benefit in the following ways:

  • Give your employees the ability to manage large data volumes using the latest tools
  • Provide your workforce with flexible and cost-effective professional development opportunities
  • Analyse case studies in this domain and be able to apply successful techniques in your organisation
  • Comprehend the principles and practice of Big Data and the context in which this operates

Personal Benefits

Professionals who participate in this Data Analysis Training Certification course can benefit in the following ways:

  • Progress in your career in the Big Data domain
  • Benefit from a structured training with the latest curriculum as per current industry requirements and best practices

Who Should Attend?

This Data Analysis Training Certification course  would be suitable for:

  • IT Professionals
  • Testing professionals
  • Programming Developers and System Administrators
  • Business Intelligence, Data Warehousing and Analytics Professionals
  • Data Engineers
  • Data Analysts & Business Intelligence Professionals
  • Database Administrators and other DB professionals
  • Anyone who works with Excel regularly
  • Individuals who want to learn data exploration and analysis
  • Anyone looking to pursue a career in data analysis or business intelligence
  • Participants looking for a comprehensive, engaging, and highly interactive approach to training

Course Outline

MODULE 1: DATA ANALYSIS WITH EXCEL

  • What is Data Analysis?
  • Excel Pro Tips for Power Users
  • Advanced Excel Formulas & Functions
  • Structuring Source Data for Analysis in Excel
  • Excel tables
  • Advantage of Excel tables over regular ranges
  • Filter, sort and see totals
  • Use tables to add columns to the existing data in the Excel table
  • Raw data structure in Excel
  • Design & formatting options
  • Sorting, filtering, & grouping tools
  • Calculated fields, items & values
  • Interactive Excel dashboards

MODULE 2: PIVOT TABLES

  • Why Pivot Tables?
  • Create pivot tables
  • Data Analysis with Excel PivotTables
  • Use pivot tables and pivot charts to create dashboards
  • Connect multiple slicers to the pivot tables
  • Configuring pivot table layouts & styles
  • Pivot Table layouts & styles
  • Pivot Charts, slicers & timelines

MODULE 3: USING PIVOT TABLES FOR ADVANCED CALCULATIONS

  • The full power of pivot tables
  • Filter pivot table data to achieve interesting subsets of the data
  • Apply calculated fields with pivot tables
  • Calculate profitability and find anomalies

MODULE 4: AGGREGATE DATA

  • Use formulas to aggregate data
  • Aggregate data as an alternative to pivot tables
  • Flexible reporting layouts
  • Pivot charts using more than one table

MODULE 5: LAB ENVIRONMENT & INSTALLATIONS

  • Set the lab environment up with Office applications
  • Data analysis in Excel using tools:
    • pivot tables
    • pivot charts and slicers
  • Excel data models
  • Power Pivot add-in
  • DAX expressions for calculated columns and measures

MODULE 6: QUERIES

  • What are the queries?
  • Power Query for Excel 2010 and 2013
  • Excel data model built from a single flat table
  • Import multiple tables from a SQL database
  • Create an Excel data model using imported data
  • Create a collated result with data from text-files and data from a SQL database
  • Up & running with Power BI Desktop
  • Publishing to Power BI Service
  • SQL database analysis for beginners

MODULE 7: DATA FILTERS & MEASURES

  • How to establish measures to calculate each cell
  • Filter context for calculation
  • DAX functions
  • Enhanced queries to import data from a formatted Excel sheet
  • Queries beyond the standard user interface

MODULE 8: DATA VISUALISATIONS

  • Data visualisations in Excel
  • Cube functions for year-over-year comparisons
  • Create timelines, hierarchies, and slicers
  • Excel working together with Power BI
  • Excel workbooks with Power BI service
  • Excel on the mobile platform

MODULE 9: CASE STUDIES

  • Facebook Post data from Spartan Race
  • IMDb movie ratings
  • Apple Store mobile app ratings
  • Shark attack records from 1900-2016
Online Courses
Note
Customized Schedule is available for all courses irrespective of dates on the Calendar. Please get in touch with us for details.
Download Classroom Training Calendar 2020 Download Classroom Training Calendar 2021

 

Download Live Online Training Calendar 2020 Download Live Online Training Calendar 2021




ZOE Talent Solutions Logo


Address

Middle East – Head Office

918, Blue Bay Towers,
Al Abraj Street (Marassi Drive),
Business Bay, Dubai, UAE

UK Office

337, Forest Road, London,
England, E17 5JR

Ph: +44 7443 559344

Join Our Team as a Trainer

We are proud to have a team of highly experienced expert training professionals from all over the world.

If you feel you have the right skills to become a part of our training team. Please use the link below.

>Apply Now

top
Copyright © Zoe Talent Solutions 2020

Due to the recent COVID-19 pandemic, we've decided to offer live online webinar training classes for all of our courses.


You can participate in our training sessions with the safety & comfort of your own home or office. This helps you fulfill your learning requirements, while availing massive discount on regular course fees.


Register for a live online session now.


To register for a course, please fill the information request form on the course page, or reach us through the live chat or WhatsApp using the apps below.

Live Online Training

Now participate in a live online course for a highly discounted fee of Only $850, as a limited introductory offer.

(Terms and conditions apply)