Print the page
Trainer Profile Microsoft Power BI
Code: IT
Duration: 4 Days
Location: Doha
Fee: QAR 9,800
Course Overview
The Power BI Course is designed to provide participants with a comprehensive understanding of Microsoft Power BI, a powerful business analytics tool used to visualize and analyze data from various sources.Course Objectives
By the end of the course, participants will be able to:- Gain a solid understanding of Power BI concepts, components, and architecture.
- Learn how to connect to and import data from different sources into Power BI.
- Develop skills in creating visually appealing reports using Power BI's easy interface.
- Learn to use Power BI's powerful data visualization features to present data effectively.
- Learn how to publish, share reports to a broader audience.
- This course is suitable for individuals and professionals who want to enhance their data analysis and reporting skills, as well as those interested in leveraging Power BI for business intelligence purposes.
- Someone who has no experience with Power BI.
- Basic knowledge of MS Excel.
Course Contents
Introduction to Power BI- Overview of Power BI and its flow
- Power BI Architecture
- Power BI Components
- Power BI License
- Chapter Quiz
- Installation and setup
- Connecting to data sources
- Exploring the Power BI interface
- Creating your First Clustered Column Chart
- Exploring detailed options of Column Chart
- Working with Bar & Pie Chart & Understanding its options
- Creating Amazing Line Chart
- Pro Tip: Creating Stepped Line Style
- Creating Cards for KPI
- Tree Map
- Adding Interactive Slicers for Reports
- Updating & Refreshing Data
- Understanding Edit interactions
- Adding Animated Scroller & Country Flags
- Adding Date (Year & Quarter) Slicer
- Creating Reset Filter Button
- Adding Decomposition Tree
- Tables & Metrics
- Adding Conditional Formatting
- Q&A (Use Natural Language to Explore Data)
- Project à Creating Interactive Dashboard with Customize Background
- Publishing reports Online on Power BI Service
- Sharing and collaborating on reports
- Viewing Published Report on Mobile App
- Creating Maps
- Creating Filled Map
- Pasting Data Manually without Importing
- Creating Funnel Chart
- Visual Level
- Page Level
- Report Level
- Getting Top 5 Employees
- Creating Secondary Axis Chart
- Creating Magic with Bookmarks
- Understanding Drill through Reports
- Creating Subscription in Power BI Service
- Creating New Workspace
- Publishing reports in Workspace
- Importing Messy Data in Power Query
- Exploring Power Query Editor
- Transforming & Cleaning data with Power Query
- Common data cleansing activities with Power Query
- Combining Columns, Changing Case & Fixing Date issue
- Unpivot Data (Converting Summarized data into Flat file for detailed Analyse)
- Combining Data from Multiple tables
- Combining Multiple Files & creating reports
- Adding Conditional Column using IF Condition
- Challenging & Complex Data Cleaning Project