Data Analytics & Business Intelligence
About Course
This course is designed to give a practical exposure to one of the most sought after Data skills- Excel and PowerBI. Whether you are a beginner, a budding data enthusiast or someone looking to explore Data Science, this course would train you on exactly what industry is looking for. The course has been created to cater to both : technical or non-technical professionals
Session Plan:
- Day 1
- Day 2
- Day 3
- Day 4
Course Content
Day 1 – Excel (Basics, Personalizing & Presenting Your Work)
-
Knowing excel and its prowess
10:00 -
Walkthrough important excel elements
05:00 -
Essential Keyboard Shortcuts
20:00 -
Quiz-Basics of Excel
-
Cell Basics and referencing: Your Building Blocks
20:00 -
Quiz – Cell Referencing
-
Data types in excel
00:00 -
Vlookup and Data Validation
00:00 -
Quiz-vlookup and data validation
-
Data aggregations, granularity and pivot tables
00:00 -
Conditional Formatting: Highlighting What Matters
55:00 -
Quiz-Pivot Table and Conditional Formatting
Day 2 – Excel (Data Mastery) & Introduction to Power BI & Data Visualization
Day 3 – Essential Concepts, Calculations and Interactive Dashboards
Day 4 – Power BI Service & Advanced Concepts
Leave us a review
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
It was very informative
Overall course was good. Good learning experience.
The course was very informative and hands on. The trainer was very patient.
yes
My experience with the course was very positive. The course was highly informative and concepts were explained in a simple and practical manner.
yes it was an excellent course
Great and informative session.
The sessions are very informative.
Informative Session
Extremely useful!
Very Nice
sessions were really informative, and it covered all basics of excel and Power BI, thank you so much for trainings.
Its awsome
Very good trainer, Manvirendra. Made class interactive, took all along.
Training was very informative.
The course is very well-designed, with sessions that were both insightful and engaging, offering clear and valuable information.
good
It was more interactive training session and explained well
