Join Program

Refer your friends for our One-Day Free Training Session & Two-Days Free Lab in Data Analytics in Power BI & Excel, and get scholarship on joining full course on Data Analytics

Data Analytics in Power BI & Excel

Register Now
  +91 9150020285
Training Module & Schedule
9.00 AM to 10.00 AM 10.00 AM to 11.00 AM 11.00 AM to 11.15 AM 11.15 AM to 12.15 PM 12.15 PM to 1.15 PM 1.15 PM to 2.00 PM 2.00 PM to 3.00 PM 3.00 PM to 4.00 PM 4.00 PM to 4.15 PM 4.15 PM to 6.15 PM 6.15 PM to 6.30 PM 6.30 PM to 7.00 PM
Introduction :
  1. Types of analytics(descriptive,predictive,prescriptive)
  2. Types of data
  3. Data workflow
 1 Hours
Data handling using Excel:
  1. Data Entry
  2. Formulas
  3. Sorting
  4. Filtering
  5. Fills
  6. Data Validation(drop down and input restriction)
  7. Pivot tables
 1 Hours
Break 15 minutes
Doing Statistics in Excel:
  1. Central Tendencies and Measure of Dispersion
  2. Data Visualization
  3. Correlation and Regression
1 Hours
Inferential Statistics in Excel:
  1. Probability distribution functions, and Hypothesis testing
 1 Hours
Lunch Break 45 minutes
Introduction to PowerBI:
  1. Connecting and Importing data
  2. Data Transformation in query editor
  3. Creating basic visualizations
 1 Hours
Introduction to DAX
  1. Building interactive dashboards
1 Hours
Break 15 minutes
Project 2 Hours
Break 15 minutes
Certification Distribution 30 minutes

Eligibility

  • A foundational knowledge of Excel is necessary.
  • Prior experience in Power BI is not required.
  • A genuine interest in learning and engaging in practical, hands-on training throughout the program.
Expert-Led Training from industry professionals with real-world experience in Data Analytics
Hands-on Practice with real-life data projects using Excel and Power BI for a comprehensive learning experience
Comprehensive Support throughout the day, including doubt resolution and guidance
Free Certification upon successful completion to showcase your expertise in Data Analytics