Certification Course on “Advanced Data Analytics with Power BI”
Course Duration: 1 Month
Total Live Classes: 8 (16 Hours)
Course Overview
This Power BI course is designed to equip participants with the essential skills and knowledge to leverage Power BI for effective data analysis and visualization. The course is structured into eight comprehensive modules covering various aspects of Power BI, from introductory concepts to advanced data modeling and visualization techniques. Each module is designed to provide hands-on experience through practical exercises and real-world examples.
Learning Outcomes
-
Acquire a solid understanding of data analytics concepts.
-
Master Power BI Desktop and its functionalities.
-
Learn to clean, transform, and prepare data for analysis.
-
Write DAX formulas to create powerful calculations.
-
Build effective data models with proper relationships.
-
Craft interactive dashboards and reports using various chart types.
-
Apply Power BI to solve real-world business problems.
-
Share and collaborate on reports with colleagues
What You’ll Learn
Module 1: Introduction to Power BI and Setup
• Introduction to Data Analytics
• What is Power BI?
• Power BI Desktop vs. Power BI Service
• Installation and Setup
• Data Sources and Connectivity
Module 2: Data Preparation and Basic Modeling
• Loading Data into Power BI
• Data Transformation and Cleaning
• Data Query Editor
• Introduction to Data Modeling Basics
Module 3: Advanced DAX and Measures
• Introduction to DAX
• Basic DAX Functions (SUM, COUNT, AVERAGE, ETC.)
• Hands-on exercises for DAX
• Filtering and Aggregation in DAX
• Time Intelligence Functions
• Creating Measures
• Calculated Columns vs. Measures
• Using DAX in Measures
Module 4: Data Modeling and Relationships
• Relationship Types
• Creating Relationships
• Managing Relationships
• Cross-Filtering and Cross-Highlighting
Module 5: Data Visualization
• Building Visualizations
• Chart Types (Bar charts, Line charts, Pie charts, etc.)
• Formatting Visuals
• Interactive Elements (Filters, Slicers, Drillthrough)
Module 6: Creating Dashboards and Reports (Example 1)
• Building Dashboards
• Adding Visualizations to Reports
• Creating Tabs and Pages
• Report Layout and Design Best Practices
Module 7: Creating Dashboards and Reports (Example 2)
• Building Dashboards
• Adding Visualizations to Reports
• Creating Tabs and Pages
Module 8: Power BI Publishing and Real-world Projects
• Applying Power BI to Real Data Analysis and Case Studies
• Solving Business Problems
• Publishing Reports to Power BI Service
• Sharing Reports with Others
• Collaboration and Workspace Management
Course Fees
Only BDT 3999
Course Details
1 Months | 8 Classes (16 Hours)
Next Session: To be announced
Platform: Online Live Session
Class: Every Saturday and Tuesday
Time: 8:00 PM – 10:00 PM
Assessment Processes:
- The course assessment mark is 100.
- The assessment for this course consists of one examination
- The examination follows a Multiple-Choice Question (MCQ) format.
- Case Study
- Assignment
Passing Score:
To complete the Advanced Data Analytics with Power BI Course, a student must need to obtain a minimum of 70% marks.
Course Designed for:
- Data Analysts
- Business Intelligence Professionals
- Business Managers and Executives
- IT Professionals
- Students and Recent Graduates
- Entrepreneurs and business owners
- Career changers
- Anyone Interested in Data Analysis
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
Let’s Introduce to Your Instructor
Database Administrator (DBA), Manager
Ex-Data Analyst
SureCash & TallyKhata
Admission Details
Pay First
Then fill up 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.”