Details
You are a business user of reports and dashboards and need to use a tool to support your decision making. You use data both in tabular and in graphical format and need to access both summarized and detailed versions of the data. You need to interact live with the data sets using a web-based application.
The course:
- Makes use of the Microsoft PowerBI.com web-based application to create basic reports and dashboards. The reports and dashboards can be shared both inside and outside of the company
- Focuses on the skills that will be needed by dashboards users to compile reports and dashboards, and share the dashboards with colleagues and clients
- Covers the basic built-in visualizations in detail, with the relevant exercises
- Covers the advanced built-in functionality for visualization as demonstrations and as self-study sections
- Gives some guidelines for report and dashboard design
Cost
$229.90 If you are currently resident in South Africa you will need to pay VAT at 15%.Duration:
1 dayBrochure:
Delivery Method
Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.
Audience
This is a bespoke course for specific audiences and is therefore not on our public schedule. This course needs to be customised to the unique settings of a business and will, therefore, be quoted on separately. The possible audience includes the executive team, their personal assistants, divisional heads, line managers, as well as personnel who need to receive alerts on changes in data.
Pre-Requisites
Delegates must have a working knowledge of Microsoft Windows, and either Microsoft Edge, Microsoft IE, or Google Chrome. Delegates should be able to use one of the Microsoft Office applications on a basic level. Delegates should have some experience in doing reporting. This is a group course for between 6 - 8 delegates from one company. Extra delegates charge at R1000 per person.
Course Outline / Curriculum
"Course Outline":
- Overview of Business Intelligence and PowerBI
- Microsoft Self-Service Business Solution
- Microsoft PowerBI applications
- Using Data Sources:
- Data Sources available
- Uploading Excel workbook
- Uploading CSV file
- Uploading a Web page containing tables
- Accessing a SQL Server database
- Accessing Microsoft PowerBI.com web-based application
- Login
- Review the structure of the application
- Accessing the first dashboards
- Use Built-in Visualizations and Formatting to create Reports
- Data Structure of the sample database
- Tables
- Table granularity
- Matrices
- Cards
- Multi-level cards
- Switching between table types
- Basic charting and the Bar chart
- Column chart
- Line chart
- Pie chart
- Adjusting charts
- New visualizations
- Enhancing charts
- Clustered charts
- 100% Stacked charts
- Text boxes
- Page background color
- Interacting with the data
- Drilling down
- Slicers
- Using charts to slice data
- Filtering data
- Dashboards
- Working with a Dashboard
- Using the PowerBI application for Android
- Create an alert
- Additional visualizations
- Donut charts
- Funnel charts
- Scatter charts
- Bubble charts
- Waterfall charts
- Line and stacked column charts
- Maps
- Gauges
- Custom visualizations
- Bubble chart play axis
- Best Practice for Dashboard design
- Optional: Data sources and data manipulation
- Accessing a SQL Server database
- Refresh data
- Split data columns imported from a CSV file
- Close