Course offered at select NIIT Centres

Data Analysis and Visualization in Excel and Power BI

Overview

  • Total Duration 38 Hours
  • Course Type Classroom + Online

Classroom + app based learning

Industry Experience Faculty

Faculty Guidance through app

Hands-on application of tools

Course offered at select NIIT Centres

  • Learn analysing data and visualizing data with Advanced Excel
  • Learn to build & publish dashboards in Power BI by Microsoft
  • Extensive Learning hours with 38 hours of classroom training including the classroom assessment with additional 36 hours of online guided practice for better learning and increased retention
  • Hybrid Learning with Guided practice & Weekly Practice quiz questions on the app along with the classroom sessions
  • Hands-on application of Tools

Share

Get in touch with us

I understand the Privacy Policy .

Program gets you hands-on with data analysis and visualization in Advanced Excel along with equipping you with a understanding of data handling in Power BI with progression towards complex data visualization in Power BI.

 

  Learning Objectives

  1.  Learning using excel in Data Analysis and Visualization

              a. Using Excel inbuilt functions and user defined formula to for data analysis

              b. Using Excel Data Analysis Toolpack for data analysis

              c. Creating and customizing charts in excel for data visualization

    2. Data Visualization in Power BI

              a. Understanding Power BI Interface and Power BI Variants i.e. Power BI Desktop and Web

              b. Using Excel Data in power BI for visualization

              c. Reporting/Dashboarding using power BI

              d. Publishing Power BI Dashboards

              e. Data relationships and queries in Power BI

              f. Data Transformations in power BI

  • Data Analysis in Excel
  • Visualization using Power BI
  • Have basic knowledge of working in the Windows environment and Microsoft excel
  • Knowledge of Maths/Statistics upto Class XII

 

Related courses

img
Working with Advanced Excel 2013

Working with Advanced Excel 2013

Trial Course Available
Duration:
Certification: NIIT
Batches starting soon

Enquire Now Know More
img
Social Media Marketing Short-Term Course

Social Media Marketing Short-Term Course

Trial Course Available
Duration:
Certification: NIIT
Batches starting soon

Enquire Now Know More
img
Programming in Java

Programming in Java

Trial Course Available
Duration:
Certification: NIIT
Batches starting soon

Enquire Now Know More
img
Python Programming and Data Exploration in Python

Python Programming and Data Exploration in Python

Trial Course Available
Duration:
Certification: NIIT
Batches starting soon

Enquire Now Know More
img
Programming Using C and C++

Programming Using C and C++

Trial Course Available
Duration:
Certification: NIIT
Batches starting soon

Enquire Now Know More
img
OOPs using C++

OOPs using C++

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Programming in C

Programming in C

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Data Analysis and Visualization in Excel and Power BI

Data Analysis and Visualization in Excel and Power BI

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Programming in R

Programming in R

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Email Marketing Short-Term Courses

Email Marketing Short-Term Courses

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
SEO, SEM and Google Courses

SEO, SEM and Google Courses

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Working with Tally.ERP9 -Level 1

Working with Tally.ERP9 -Level 1

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Working with Advanced Excel 2013

Working with Advanced Excel 2013

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Certificate in Office Productivity Tools and Web Page Designing

Certificate in Office Productivity Tools and Web Page Designing

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Accounting with Tally.ERP9

Accounting with Tally.ERP9

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
GST Using Tally.ERP9

GST Using Tally.ERP9

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Introduction to GST

Introduction to GST

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Working with MS Office 2013

Working with MS Office 2013

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Data Structures and Algorithms

Data Structures and Algorithms

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
Developing Web Apps using Servlets and JSP

Developing Web Apps using Servlets and JSP

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More
img
HTML5 Programming

HTML5 Programming

Trial Course Available
Duration:
Certification:
Batches starting soon

Enquire Now Know More

FAQ's

Who should join this course?

Undergraduates and graduates looking to enhance their productivity skills and wanting to become hands-on with data analysis in excel and data visualization in Power BI.

Why is this course Unique?

1. Unique Curriculum : The course is designed to make one proficient in data analysis and visualization in Excel and Power BI starting from the fundamentals and going onto application of these tools which are one of the most widely used tools in the industry.

2. Extensive hands-on skills : The student will gain competence through hands-on learning in the latest technologies and tools, which are being widely used in the Data Analytics industry.

3. Online learning : Apart from the regular ILT classroom sessions, the students will have access to online learning and practice on Training.com and NIIT student app.

4. Expert Faculty : Experienced faculty in related field interacting with students. Apart from guiding students on concepts and its implementation, he will pose challenges to learners to think through all the topics leading to better learning and increased retention..

What learning resources are available?

Expert Faculty: Experienced faculty in related field interacting with students. Apart from guiding students on concepts and its implementation, he will pose challenges to learners to think through all the topics leading to better learning and increased retention.

Study Material: Students will be provided with advanced study materials in form of e-books.

 Hands-on Learning: Apart from classroom hours, learners will be provided with dedicated machine room hours to practice their learnings on MS-excel and Power BI software’s.

 

What are the pre-requisites for the enrolment?

Data Analysis in Excel:

  • Exploring the World of Data, Information, and Reporting
  • Processing Data from Business Transactions
  • Summarizing Data
  • Analyzing Data for Decision Making
  • Exchanging Data Between Various Sources
  • Analyzing and Presenting Complex Data

Visualization using Power BI:

  • Getting Started with Importing Data Options
  • Data Transformation Strategies
  • Building the Data Model
  • Leveraging DAX
  • Visualizing Data
  • Digital Storytelling with Power BI
What certificates will I be receiving for this course?

1 Graded Certificate

Only students successfully completing the program with a CWAP of >=50% will be awarded the Graded Certificate in “Data Analysis and Visualization in Excel and Power BI”

2 Participation Certificate

Students who do not appear for the Appraisals or score a CWAP of < 50% will be issued only a Participation Certificate in “Data Analysis and Visualization in Excel and Power BI”.

What will be my takeaway from this course?

At the end of this program, the learner will be able to:

i. Carry out data analysis in using advanced Excel functions and user defined formulas

ii. Bringing in data from various sources for analysis in excel

iii. Work with excel data in Power BI

iv. Transform and Visualize data in Power BI

v. Create dashboards in Power BI

vi. Write powerful advanced Dax calculations in Power BI

vii. Use Power BI for Digital Storytelling

Appointment with counsellor