Facebook Linkedin Instagram Twitter
  • Who We Are
  • What We Do
  • Programs
  • Duration: 5 Days
  • Mode: Face-to-Face

Overview

This course aims at giving hands-on practice with implementing real-time applications using advanced Excel and Power BI and provides an approach for the study of concepts related to gathering insights from data, which would enable data-driven decision making in computing technology.

Highlights

  • Industry need analysis explained in detail
  • Hands-on practice with advanced Excel and Power BI
  • Concepts explained through animation and simulation
  • Power BI with statistics and building interactive dashboards
  • Industry application-based case study and discussion

Eligibility

  • III & Final year (Science and Engineering) students and working professionals with lesser experience are also eligible.
  • Pre-requisites: Basic knowledge of computer skills and statistics

Course Content

DAY 1
  • Data Analytics Overview
  • Understanding Data Analytics and its Importance
  • Types of data & various data collection techniques
  • Data Analytics roadmap
DAY 2
  • Data coding and preliminary data analysis
  • Use of various software for data analytics
  • Conditional formatting, sorting techniques & pivot techniques
  • Data cleaning and generating insights through graphics/visualization
  • Advanced formulas and functions in Excel for data analytics
DAY 3
  • Data analysis using statistical models – inferential statistics & predictive analytics
  • Analyzing data with pivot tables
  • Using charts and graphs to visualize data
  • Dashboarding and modelling
DAY 4
  • Introduction to Power BI and its features
  • Connecting to data sources in Power BI
  • Transforming data in Power BI
  • Advanced techniques in Power BI
DAY 5
  • Advanced data modelling techniques in Power BI
  • Creating interactive reports and dashboards in Power BI
  • Sharing and collaborating in Power BI, Power Apps, and Power Automate
  • Case study – industrial real-time applications

Outcomes

At the end of the course, the participant will be able to:
  • Learn the basic concepts in predictive analytics
  • Learn key analytical skills in data cleaning, analysis, & visualization tools
  • Analyze using plots and charts for data visualization
  • Perform data analytics using advanced Excel and Power BI
  • Develop models and dashboards

Certification Criteria

  • Attendance: 100%
  • Assignment completion: 100%
  • Post-test assessment score: 70% minimum
  • Duration: 5 Days
  • Mode: Face-to-Face
  • The programs will be certified by TVSTS.

Register Now

Apply For Job

Upload supported files Doc & PDF

Online Courses Registration

Apply For Job

Upload supported files Doc & PDF.
  • Corporate Training - B2B
  • Training – Onsite & Online
  • Consultancy & Management
  • BFSI
  • Educational Outreach Program - B2E
  • Manpower Solutions
  • Contract Staffing
  • NAP
  • LEAD
  • Our Facilities
  • Career
  • Ongoing Programs