Certification Course on
“Data Analytics with Microsoft Excel, Google Sheets, and Power BI”
Course Duration: 1 Month
Total Classes: 8 (12 Hours)
Course Overview
This comprehensive course offers a thorough exploration of data analytics, focusing on three popular tools: Microsoft Excel, Google Sheets, and Power BI. It begins with fundamental concepts and techniques, progressing to the specific functionalities of each tool. Key topics include data cleaning, transformation, sorting, and filtering, as well as creating visually appealing charts and graphs. Pivot Tables and Pivot Charts are extensively covered for Excel, while Google Sheets is explored for its collaboration features and basic formulas/functions. Power BI is introduced as a business intelligence platform for transforming data into interactive dashboards and reports, covering data connectivity, advanced modeling, and visualization techniques. Overall, the course equips learners with practical skills to analyze and interpret data effectively across various industries.
What You’ll Learn
Module 1: Introduction to Data Analytics
-
- Overview of Data Analytics
- Overview of Excel, Google Sheets, and Power BI
- Basic Formulas and Functions in Excel
- VLOOKUP
- SUMIF and SUMIFS
- COUNTIF and COUNTIFS
- AVERAGIF and AVERAGIFS
- IF and IFERROR
SWITCH - Data Validation
- Conditional Formatting
Module 2: Data Manipulation with Excel
-
- Data Cleaning
- Data Transformation
- Data Sorting and Filtering
Module 3: Visualization with Excel
-
- Creating Charts and Graphs
- Customizing Charts and Graphs
Module 4: Advanced Visualization with Excel
-
- Creating Dynamic Charts and Graphs
- Using Pivot Tables and Pivot Charts
Module 5: Introduction to Google Sheets
-
- Overview of Google Sheets
- Basic Formulas and Functions in Google Sheets
- Data Manipulation and Visualization in Google Sheets
Module 6: Introduction to Power BI
-
- Overview of PowerBI
- Creating Basic Reports and Dashboards in Power BI
- Data Connectivity and Data Refresh Options in Power BI
Module 7: Advanced Power BI
-
- Creating Interactive Dashboards in Power BI
- Data Modeling in PowerBI
- Advanced-Data Visualization Techniques in Power BI
- Introduction to DAX Language
- Power BI to PowerPoint Integration
- DAX Language with Chat GPT
BDT 8000 (Online)
BDT 10000 (In-Person)
Details
1 Month | 8 Classes (12 Hours)
Next Session: 18 July 2024
Flat 60%+ OFF!
Online Details
Platform: Live Class on Zoom
Class Time: Every Thursday & Friday (8:30 PM – 10:00 PM)
In-Person Details
Class Time: Every Friday (9:30 AM – 12:30 PM)
Assessment Processes:
-
The course assessment mark is 100.
-
The assessment for this course consists of one examination: 40 Marks
-
The examination follows a Multiple-Choice Question (MCQ) format.
-
Case Study – 30 Marks
-
Assignment – 30 Marks (Top 2 will be considered)
Passing Score:
To complete the Data Analytics Course, a student must need to obtain a minimum of 70% marks.
Course Designed for:
- Data enthusiastic
- Sales professionals
- HR professionals
- Supply Chain professionals
- Accountants
- Business professionals
- Students and graduates
- Entrepreneurs and business owners
- Individuals seeking a bridging course to enhance their current reporting skills.
- Career changers
- Those looking for a deep awareness of the field.
Documents:
To get enrolled in the Data Analytics course you have to submit the following documents:
-
- Two copies of the passport-size photo
- Photocopy of the last academic certificate
- Photocopy of the NID card or passport
N: B: Course fees are non-refundable
About the Instructor
Data Analytics Course Instructor possesses the following exceptional skills
- Transforming Data into Actionable Insights: Expertise in analyzing and interpreting data to derive meaningful and actionable insights, enabling effective decision-making.
- Business Intelligence: Proficiency in utilizing business intelligence tools and techniques to extract valuable information from data, empowering organizations to gain a competitive edge.
- Automation & Analytics: Skilled in leveraging automation and advanced analytics methods to streamline processes, optimize efficiency, and drive data-centric innovation.
- Industry Experience: Extensive experience working in relevant industries, bringing real-world insights and practical knowledge to the classroom.
- Training Expertise: Well-versed in delivering professional training, effectively imparting knowledge and skills to course participants.
Admission Details
To reserve your seat, kindly complete the admission form by clicking on the following link:
https://forms.gle/L8PjP6y9VNgqU3X59
For payment, you can deposit, NPSB or EFT in the given account. Please provide the deposit slip or screenshot of the NPSB or EFT once the payment has been made. If you will pay in Bkash Account, please share the Bkash number and Transaction ID at info@iil-bd.com
The Bank Details are given below:
Bank Name: Bank Asia
Account Name: Institute Of Industrial Learning
Account Number: 62033000393
Branch Name: Banani (Dhaka North Branch)
Routing Number: 070260683
Bkash Number: 01894 – 627101 (Merchant)
For any assistance or further inquiries, our team is here to help. Feel free to reach out to us at 01894 – 627100, or 01894 – 627101.
Secure your seat now and embark on an enriching learning journey with us at IIL. We look forward to welcoming you!
Please note that payment must be made prior to filling out the admission form.
★★★★★
“Attending CPPM training program was incredibly valuable. The trainers were experts and excellent communicators. The interactive sessions fostered collaboration, and I left feeling inspired and equipped with new skills”
Golam Kibria
★★★★★
“This data analytics training program was a fantastic learning experience. The trainers were knowledgeable and experienced, and the company’s commitment to excellence was evident throughout. Exceptional experience.
Md Eusuf Jamil
★★★★★
“The trainers are experts who create a supportive and inclusive learning environment. The sessions are engaging and interactive, making the learning process enjoyable and effective. Results-driven training at its best.”