You are joining proctoring zone ...

Analyzing and Visualizing Data with Excel

Master Microsoft Excel. Specialize in exploring data analytics and visualization. This course will prepare you to import data from different sources, create bridge between data sources, and prepare data for analysis and computation. After preparing the data for analysis, you can find out how business calculations can be computed in an efficient manner. This course offers sufficient practice with Excel to familiarize on the most commonly used business functions. This course specializes in importing data, creating data table and visualizing data.

Online Instructor-Led

Course Features

Related Courses

This course is part of the Microsoft Professional Program Certificate in Data Science. Excel is widely used all over the world and it includes some tools, which can help in data analysis and improving the visualization and applying some business logics. In this course, you will learn about the new tools in excel, that too from an expert from the Excel Product Team at Microsoft.

After the completion of the course, you will learn how to import data from various resources and how to create mashups between them. You will also be able to prepare data for any sort of analysis.

Course Objectives

Gather and transform data from multiple sources

Discover and combine data in mashups

Learn about data model creation

Explore, analyze, and visualize data

Curriculum

Module 1:

Course Overview

Importing Data from Databases

Lab: Explore and Extend a Classic Excel Dashboard

Excel Dashboard

Quiz

Module 2:

The Excel Data Model

Basic DAX

Quiz

Lab: Explore an Excel Data Model

Module 3:

Importing Data from a CSV File

Lab: Importing Data from a CSV File

Quiz

Module 4:

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

Quiz

Module 5:

Creating and Formatting Measures

Using Advanced DAX Functions

Lab: Creating Measures using Advanced DAX Functions

Quiz

Module 6:

Importing Data from a Formatted Excel Report

Lab: Advanced Text Query

Quiz

Module 7:

Visualizing Data in Excel

Lab: Data Visualizations in Excel

Quiz

Module 8:

Using Excel with Power BI

Power BI Mobile App

Quiz

Instructor

Instructors are handpicked from a selected group of industry experts and mentors and trained to deliver the best online learning experience. All training.com instructors have at least ten years of industry experience and extensive functional expertise in the field they train.

Certification

The assessment will be done on the basis of an online test and Project Evaluation at the end of the course.

Weightage of Project Evaluation is 30% and that of Online test is 70%. Minimum pass percentage for online test is 70.

On completion of the Assessment (Project + Test) with a minimum of 70% marks, training.com will issue a certificate of successful completion from NIIT.

Five re-attempts will be provided to clear online test in case the candidate scores less than 70%.

A Participation certificate will be issued if the candidate does not score 70% in the Assessment.

Soft copy of the certification will be issued to the participants, on completion of the course.

Pre-requisites

Understanding of Excel analytic tools such as tables, pivot tables and pivot charts is a must. Some experience in working with data from databases and also from text files will be helpful.

FAQs

Who should join this course?

The Business Analytics with excel is a great course for both beginners and experienced professionals who are uninitiated to or have recently stepped into the field of analytics. This course is beneficial for

IT developers & testers

Junior Data scientists

Data analysts

Analytics Professionals

Project managers

Students

Professionals working with data in any industry

Why should I join this course?

After the course, you will be able to learn how to draw an analysis from complex datasets using pivot tables and slicers. You can even apply statistical tools and concepts like moving average, hypothesis testing, ANOVA and regression to data sets using excel after the course. This course is a must for IT professionals.

What happens if I miss a session?

All the live sessions are recorded and available for later view. Learners can refer to recordings of a missed session at their convenience.

Where can I find my session schedule?

The session schedule will be available in the training.com Student portal - Learning Plan section. You can login to your training.com account to view the same.

Do you provide any study materials?

The study material will be available in the training.com Student portal - Resources section. You can login to your training.com account to view the same.

What is your refund policy?

Upon registering for the course, if for some reason you are unable or unwilling to participate in the course further, you can apply for a refund. You can initiate the refund any time before start of the second session of the course by sending an email to support@training.com , with your enrolment details and bank account details (where you want the amount to be transferred). Once you initiate a refund request, you will receive the amount within 21 days after confirmation and verification by our team. This is provided if you have not downloaded any courseware after registration.

What are the minimum system requirements to attend the program?

Minimum system requirements for accessing the courses are:

Personal computer or Laptop with web camera

Headphone with Noise Clarity Microphone

Broadband connection with minimum bandwidth of 4 mbps.

Its recommended to use System Health Check to examine the OS details, Add in, Plugins, Camera, Mic and other external devices.

Is there an official support desk for technical guidance during the training program?

Yes. For immediate technical support during the live online classroom sessions, you can call 91-9717992809 or 0124-4917203 between 9:00 AM and 8:00 PM IST. You can write to support@training.com for all other queries and our team will be happy to help you.

Password should have length of min 8 and max 30 characters. It should contain alteast One Uppercase, Lowercase, Number and Special character. It should not contain '`', '~', '%', '^', '*', ''', '\' characters.

+91

Please tick this box to indicate that you understand that your personal data will be used in accordance with the Privacy Policy here. *

Trouble Signing in ?

Use your Student ID given to you by your NIIT Learning Centre to login.

Password should have length of min 8 and max 30 characters. It should contain alteast One Uppercase, Lowercase, Number and Special character. It should not contain '`', '~', '%', '^', '*', ''', '\' characters.