Scribd
Upload
17 views2 pages

Power BI Course Outline New

The course outline for Power BI covers essential topics including the definition, importance, and components of Power BI, as well as data visualization and business intelligence. It includes practical skills such as data connection, modeling, and visualization techniques, along with hands-on activities like dashboard creation and report building. The course also touches on DAX expressions, data cleaning, and sharing dashboards, culminating in a final exam and feedback session.

Uploaded by

Mominul Islam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views2 pages

Power BI Course Outline New

The course outline for Power BI covers essential topics including the definition, importance, and components of Power BI, as well as data visualization and business intelligence. It includes practical skills such as data connection, modeling, and visualization techniques, along with hands-on activities like dashboard creation and report building. The course also touches on DAX expressions, data cleaning, and sharing dashboards, culminating in a final exam and feedback session.

Uploaded by

Mominul Islam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

COURSE OUTLINE

POWER BI

Topics
• Initial discussion about Power BI, Like
➢ Definition
➢ Importance
➢ Compared with the current practice of Excel
➢ Components
• Business intelligence & data visualization
• Data sources
• Installation of Power BI desktop

• Different data sources


• Connection of data with Power BI
• Linking of data
• Idea about data modeling
• Simple analysis creation and idea generation of visuals
• Data visualization and formatting techniques
• How to save your files for future

• Know about charts of Power BI


• Stacked bar chart
• Stacked column chart
• Clustered bar chart
• Clustered column chart
• 100% stacked bar chart
• 100% stacked column chart
• Line chart
• Area chart
• Pie charts
• Maps on Power BI
• Funnel charts
• Gauge & cards
• Tables & matrices
• Map in Power BI
• Card, slicer & filter

• Data cleaning activity with power query


• Simple mathematical formation
• Add column
• Split column
• Merge column
• Data trimming
• Custom column
• Data connection from the multiple database
• Data modeling
• Data visualizations and formatting
• Inserting text, shapes & others
• Dashboard creation
• Data formatting and visualization
• Single-direction relationships
• Bidirectional relationships
• Fact tables, dimension tables

• Brief discussion on DAX


• Using DAX expressions for conditional formatting
• Creating custom conditional formatting rules
• Introduction to date and time functions in Power BI

• Hierarchies and Drill-Downs in Visuals


• Utilizing the Filter Pane for Guided Data Exploration
• Drill-Through Navigation for Detailed Analysis
• Creating Custom Navigation with Buttons
• Bookmarks for Dynamic Report Sections

• Building reports and dashboards for sample data


• Group discussion for different trial dashboards made by participants
• Discussion about learning from previous classes

• How to publish Power BI desktop to web


• Sharing dashboard among the groups
• Final exam for dashboard creation
• Feedback/requirement for further improvement

You might also like