These are the exercise files used for Power BI Business Analytics Training course.

The course outline can be found in

https://www.tertiarycourses.com.sg/power-bi-business-analytics-training.html

https://www.tertiarycourses.com.my/power-bi-business-analytics-training-malaysia.html

Topic 1 Get Started on Power BI

• Overview of Business Intelligence
• Introduction to Power BI
• Power BI Application Case Studies
• Login to Power BI Service Account
• Explore Power BI Service Interface
• Import/Connect Data to Power BI Service
• Power BI Desktop and Mobile

Topic 2: Create Report with Visualizations

• Overview of Visualizations on Power BI Service
• Create Visualizations
• Format Visualizations
• Filter Data and Slicer
• Create a Report with Visualizations

Topic 3 Dashboard

• What is Dashboard
• Pin a Visual to Dashboard
• Customize Dashboard
• Create Visual by Q&A
• Edit Dashboard Visual
• Share Dashboard

Topic 4: Transform Data with Power BI Desktop

• Overview of Power BI Desktop
• Get Data into Power BI Desktop
• Connect to Data Sources
• Publish Report to Power BI Service
• Power Query Editor
• Transform Data
• Combine Data from Multiple Sources
• Filter Data
• Merge and Append Queries
• Customised Queries
• Transform and Clean Data

Topic 5 Model Data with Power BI Desktop

• Manage Data Relationship
• Calculated Columns
• Hide and Unhide Fields
• Calculated Measures
• Calculated Table

Topic 6: Advanced Visualization

• Combination Charts
• Animated Scatter Chart
• Waterfall and Funnel Charts
• Advanced Color Formatting
• Group Interactions Among Visualizatoins
• Visual Hierarchies and Drill Down

Topic 7 Advanced Data Exploration and DAX

• Quick Insights
• Create Custom Q&A Suggestions
• DAX Language

Topic 8: Power BI App

• What is Power BI App
• Build App
• Use App
• Update App

Mini Capstone Project