Certified Master Course on Power BI
- Duration: 15 Hours
- Module: 9 Modules
- Platform: Online & In-Person
Upcoming Batch
Batch - Online | 30 Oct 2024 | Mon & Wed 9:00 PM to 10:00 PM | 16 Hours
Batch - Offline | 11 Oct 2024 | Friday 4:00 PM to 6:00 PM | 16 Hours
Click to RegistrationPower BI Training Bangladesh - About The Course
Power BI is one of the most powerful tools for transforming raw data into actionable insights. Whether you’re an analyst, business owner, or data enthusiast, this course will give you the skills to create visually compelling reports, share real-time dashboards, and make data-driven decisions with ease.
Who Is This Course For? This training is designed for:
- Beginners who are new to Power BI and want to learn the basics.
- Intermediate users looking to enhance their data analysis skills.
- Professionals in need of advanced techniques for complex data projects.
What You’ll Learn: Our comprehensive course is divided into three modules, covering everything from the fundamentals to the advanced features of Power BI.
Methodology
- Online & Face to face interactive class
- Practical Case Studies
Contact Us
- +88 01733405068
- support&icdb.info
Key Features of the Course
- Expert-Led Training: Learn from seasoned professionals with real-world experience.
- Hands-on Projects: Practical tasks designed to reinforce learning.
- Interactive Learning: Live Q&A, case studies, and real-world scenarios.
- Certification: Receive a certificate upon course completion.
Investment
- Offline Tk. 8500 (Discounted Fees Tk. 4999)
- Online Tk. 4500 (Discounted Fees Tk. 2999)
Course Content
Chapter 01 : Introduction of Power BI
- Overview of Power BI and its components
- Understanding the role of Power BI in data analytics
- Key concepts: Reports, Dashboards, and Workspaces
- Setting up your Power BI environment
Chapter 03: Exploring Power BI Desktop
- Installing and configuring Power BI Desktop
- Importing data and creating datasets
- Overview of the Power Query Editor
- Basic data transformation techniques
Chapter 05: Enhancing Reports for Data Storytelling
- Designing effective and interactive reports
- Using visuals and custom visuals to tell compelling stories
- Incorporating themes, styles, and branding into reports
- Creating and using slicers for dynamic reporting
Chapter 07: Advanced DAX Concepts
- Creating time-based calculations (YTD, QTD, MTD)
- Handling fiscal calendars
- Row context vs. filter context
- Using ALL, ALLEXCEPT, and REMOVEFILTERS
- Understanding the use of iterators like SUMX, AVERAGEX, etc.
- Using Table manipulation functions
Chapter 09: Publishing reports to the Power BI service
- Publishing reports to the Power BI service
- Sharing dashboards and reports
- Managing permissions
- Collaborating using Power BI
Chapter 02 : Using Power BI
- Navigating the Power BI interface
- Connecting to different data sources
- Overview of Power BI service and Power BI Desktop
- Understanding data refresh
Chapter 04: Data Cleaning and Transformation with Power Query
- Deep dive into data cleaning techniques
- Transforming data using Power Query
- Handling missing and inconsistent data
- Merging and appending datasets
Chapter 06: Introduction to DAX (Data Analysis Expressions)
- Understanding the basics of DAX
- Creating calculated columns and measures
- Basic functions: SUM, AVERAGE, COUNT, MIN, MAX
- Logical functions: IF, SWITCH, AND, OR
- Text functions: CONCATENATE, LEFT, RIGHT, MID
- Date and time functions: TODAY, NOW, DATEDIFF
- Aggregation functions: SUMX, AVERAGEX, COUNTROWS
Chapter 08: Data Modeling
- Introduction to data modeling in Power BI
- Building relationships between tables
- Best practices for optimizing data models