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