Country dropdown

Analyzing and Visualizing Data With Excel Course

 

INTRODUCTION

Excel is one of the most widely used solutions for analyzing and visualizing data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated business logics.

Learn how to import data from different sources, create mashups between data sources, and prepare data for analysis. After preparing the data, find out how business calculations can be expressed using the DAX calculation engine. See how the data can be visualized and shared to the Power BI cloud service, after which it can be used in dashboards, queried using plain English sentences, and even consumed on mobile devices. 

 Participants actively learn through a series of practical simulations which ensures that they maximize their learning and can use the tools immediately when they return to the office. In addition to the practical component, all participants also receive a manual describing all the techniques learned.

WHO SHOULD ATTEND?

This training course is ideal for Advanced Microsoft Excel professionals who need to learn how to analyze and visualize data in excel. Participants will need to have attended or be familiar with the basics of Microsoft Excel.

DURATION

5 Days                                                                           

LEARNING OBJECTIVES

  • Gather and transform data from multiple sources
  • Discover and combine data in mashups
  • Learn about data model creation
  • Explore, analyze, and visualize data

TOPICS TO BE COVERED

  • Data Analysis in Excel
  • Lab: Explore and Extend a Classic Excel Dashboard
  • The Excel Data Model
  • Basic DAX
  • Lab: Explore an Excel Data Model
  • Importing Data from a CSV File
  • Lab: Importing Data from a CSV File
  • Importing Data from Databases
  • Importing Data from Multiple Files
  • Create a Date Table in Excel Data Model
  • Lab: Creating Mash-ups of Data from Multiple Sources
  • Creating and Formatting Measures
  • Using Advanced DAX Functions
  • Lab: Creating Measures using Advanced DAX Functions
  • Importing Data from a Formatted Excel Report
  • Lab: Advanced Text Query
  • Visualizing Data in Excel
  • Lab: Data Visualizations in Excel
  • Using Excel with Power BI

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprise of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

ACCREDITATION

Upon successful completion of this training, participants will be issued with an Indepth Research Services (IRES) certificate.

 TAILOR- MADE

This training can also be customized for your institution upon request to a minimum of 4 participants. You can have it delivered in our IRES Training Centre or at a convenient location.

For further inquiries, please contact us on 

Tel: +254 (020) 211 3814.

Mob: +254 715 077 817, +254 731 240 802, +254 735 331 020.

Email: This email address is being protected from spambots. You need JavaScript enabled to view it..

REQUIREMENTS

The training is designed for participants who are reasonably proficient in English and have an understanding of basic Statistics and M&E.

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

ACCREDITATION

Upon successful completion of this training, participants will be issued with an Indepth Research Services (IRES) certificate.

TRAINING VENUE

The training is residential and will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact the Training Officer.

Email: This email address is being protected from spambots. You need JavaScript enabled to view it..

Mob: +254 715 077 817

Tel: 020 211 3814

PAYMENT

Payment should be transferred to IRES account through bank on or before C.O.B 12th August 2019

Send proof of payment to This email address is being protected from spambots. You need JavaScript enabled to view it..

CANCELLATION POLICY

Payment for the all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

  1. Participants may cancel attendance 14 days or more prior to the training commencement date.
  2. No refunds will be made 14 days or less to the training commencement date. However, participants who are unable to attend may opt to attend a similar training at a later date, or send a substitute participant provided the participation criteria have been met

Please Note: The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

 

Event Properties

Event Duration 5 Days
Event Date 19-08-2019
Event End Date 23-08-2019
Cut off date 12-08-2019
Individual Price(Kenyan) KES 69,000
Individual Price (International) EUR 790
Individual Price(International in Dollars) USD 920
Location Nairobi, Kenya
Share this event:

Contact Us

+254 715077817 | +254 792516000
outreach@indepthresearch.org
Westlands, Rhapta Road
Njema Court, Suite R2

Search