Data Analysis and Visualization in Excel and Power BI

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.

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..

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.

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

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”.

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