Course details
Power BI Course Outline
I. Introduction to Power BI
- What is Business Intelligence (BI)?
- History of Power BI
- Benefits of Power BI
- Components of Power BI
- Installing Power BI Desktop
- Understanding Power BI Building Blocks
- Demo: Sample Power BI Reports
- Creating a Simple Report
II. Get Data & Transform Data with Power Query
- Introduction to Power Query as an ETL Tool (Extract, Transform, Load)
- Getting Data from Various Sources:
- Excel Files
- CSV Files
- Folders
- SQL
- Access
- Websites
- Understanding Power Query Editor
- Load vs Direct Query
- Data Manipulation:
- Append Queries
- Merge Queries
- Filter Rows
- Split Columns based on Delimiters
- Merge Columns
- Eliminate Columns
- Fix Metadata Issues
- Create Custom Columns based on Conditions
- Refreshing Queries
III. Introduction to M Query Language & Data Modeling
- Introduction to Data Modeling
- Creating Relationships between Tables
- Building a Data Model:
- Hiding Columns from Reporting View
- Sorting and Formatting Data
- Creating Hierarchies
- Creating Calculated Columns using M Language
- Creating a Date Dimension
IV. Power BI Visualizations
- Introduction to Visuals in Power BI
- Creating and Customizing Simple Visualizations
- Recommended Charts for Your Dataset:
- Bar Charts & Column Charts
- Line Charts & Funnel Charts
- Pie Charts & Donut Charts
- Tree Charts & Maps
- Combination Charts
- Using KPI and Card Charts
- Working with Table and Matrix Views
- Adding Interactivity:
- Buttons & Bookmarks
- Text Boxes, Shapes, and Images
- Creating Stunning Dashboards & Interactive Reports
V. Slicing and Dicing Data
- Filters in Power BI
- Using Slicers
- Working with Parameters
- Managing Interactions Between Objects
- Drill Down and Roll Up Techniques
VI. Introduction to DAX Language
- Introduction to DAX Functions
- Understanding DAX Syntax
- DAX Data Types and Operators
- Key DAX Functions:
- Logical Functions
- Aggregate Functions
- Date and Time Functions
- Text Functions
- Mathematical Functions
- Calculate Function
- Working with Complex DAX Formulas
VII. Publishing and Sharing Power BI Reports
- Publishing Reports from Power BI Desktop
- Working with Power BI Service:
- On the Web
- On Mobile/Tablet Devices
- Modifying Reports in Power BI Service
- Exporting Data from Visualizations
- Creating Dashboards Based on Multiple Reports
- Sharing Dashboards and Reports
- Empowering Stakeholders through Data Sharing
- Refreshing Datasets
- Setting Up Power BI Gateway to Refresh Local Data
- Managing Roles in Power BI
Job roles this course is suitable for:
Business Analyst , Sales & Marketing Engineer , Business Development LeaderAbout Al Manal Training
Al Manal Training Institute stands as a premier destination for top-notch educational courses, located in the heart of Abu Dhabi, UAE. We offer a diverse range of coaching programs tailored to meet your professional and personal development needs. Our offerings include:
- Test Preparations
- Healthcare and Medical
- Soft Skills
- Microsoft Courses
- Accounting Courses
- Language Courses
- Management Courses
- CAD and Engineering Courses
- Designing Courses
At Al Manal, we pride ourselves on our team of expert instructors, each bringing extensive experience and knowledge in their respective fields. Our goal is to help you master any course effectively and efficiently. To ensure personalized attention and optimal learning, we maintain small class sizes. This approach allows students to address their queries in real-time, facilitating a quicker and more thorough understanding of the material.
Our training sessions are designed to be both intensive and friendly, striking the perfect balance to help you achieve your goals. We are dedicated to not only providing exceptional education but also to assisting our students in securing their dream IT jobs. Many students choose Al Manal Training Institute for our commitment to quality education at affordable prices, a combination that sets us apart from our competitors.
Join us at Al Manal Training Institute and take the next step towards achieving your educational and career aspirations with confidence!
See all Al Manal Training coursesYou may add more courses here,
your list will be saved.