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 Data Analytics: Concepts, Tools, and Techniques
- What is Data Analytics?
- Data Types and Sources
- Data Exploration and Preprocessing
- Data Visualization
- Types of Analytics
- Data Analytics Tools and Software
- Data Ethics and Privacy
- Case Studies and Real-world Examples
- CRIP-DM Model
- OSEMN Framework
- Extract, Transform and Load (ETL)
- Data Warehouse
Class 2: From Installation to Data Transformation
- What is Power BI?
- Power BI Desktop vs. Power BI Service
- Installation and Setup
- Data Sources and Connectivity
- Loading Data into Power BI
- Data Transformation and Cleaning
Module 3: Advanced Data Transformation with Power Query
- Intro to Data Query Editor
- Transform
- Add Column
- Column From Example
- Conditional Column
- Custom Column – M Language (Mash-up/Clean Up Language)
Module 4: Data Warehousing, Relationships, and DAX Fundamentals
- DWH (Dim, Fact, SCD)
- Relationship Types
- Creating Relationships
- Managing Relationships
- Cross-Filtering and Cross-Highlighting
- DAX Introduction
- DAX Data Types
- Operators in DAX
- DAX type handling
- DAX Function Category
- Components of DAX Data Model
- Context in DAX
- Performing Calculations
Module 5: Dashboard using Advanced DAX and Measures
- Loading Dataset
- Building Relationship
- 50+ DAX Practice Problems using DAX
Module 6: Creating Dashboards and Reports
- Building Visualizations
- Chart Types (Bar charts, Stacked Bar, Line charts, Pie charts, etc.)
- Formatting Visuals
- Interactive Elements (Filters, Slicers, Drillthrough)
Module 7: Creating Dashboards and Reports
- Building Relationships
- Adding Visualizations to Reports
- User Retention
- Visuals: Line, Bar, Cohort, Waterfall, Funnel etc.
- Creating Tabs and Pages
- Report Layout and Design Best Practices
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: 17 August 2024
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.”