Course Details
The Data Visualization Using Microsoft Power BI course is designed to introduce learners to business intelligence, data analysis and data visualization using Microsoft Power BI.
Power BI helps users work with information from different data sources, create interactive visualizations, build operational dashboards and extract meaningful insights from data. The course provides a practical introduction to Power BI, covering data import, visualization, data transformation, relationships, DAX, dashboards, reports and Power BI Service.
No prior experience is required, making the course suitable for anyone interested in learning Power BI and developing practical data analysis and visualization skills.
What You’ll Learn
- Introduction to Business Intelligence and Data Analysis
- Understanding Microsoft Power BI and its applications
- Different data sources for Power BI
- Power BI installation and prerequisites
- Importing and working with data in Power BI Desktop
- Creating column, pie and stacked column charts
- Creating maps and other visualizations
- Tables, matrices and cards
- Slicers and filters
- Editing report interactions
- Power Query Editor and data transformation
- Data types, filtering and combining data
- Fact and Dimension tables
- Database normalization and table relationships
- Star and Snowflake schemas
- Active and inactive relationships
- Relationship cardinality
- DAX formulas, measures and calculated columns
- Common DAX functions and operators
- Logical, conditional, text, mathematical and statistical functions
- DAX iterators and time intelligence formulas
- Reports, dashboards and workspaces
- Publishing and managing datasets
- Scheduled and incremental data refresh
- Power BI Service and data gateways
- Performance optimization
- Bookmarks, drill-through and drill-down
- Custom tooltips and interactive report features
- Q&A and natural language queries
- Import vs DirectQuery
- Using Python scripts and AutoML in Power BI
- Power BI best practices
These topics are based on the nine-lesson course structure and detailed curriculum in the supplied brochure.
Additional Information
- Course Duration: 22 Hours
- Certification: Professional Qualification attested by Qatar Chamber of Commerce
- Tools Required: Laptop, mouse and notebook
- Laptop Requirement: A computer from i3 to i7 can be used to run the software according to the course material
- Suitable For: Anyone interested in data analysis, business intelligence and data visualization
- Previous Experience: No prior Power BI experience is required
- Learning Focus: Practical training in Power BI Desktop, Power Query, DAX, data visualization, dashboards and Power BI Service
