Course Information
Course Overview
Upon completing this course, you will have gained the skills to produce different types of Business Intelligence (BI) reports and visualizations using Microsoft Power BI software. Our personalized training course will firstly help you to have a better understanding of BI and its main processes, and how these processes can be achieved using Microsoft Power BI Software. At the same time, you will receive extensive hands-on practice on Extraction, Transformation and Loading (ETL) processes. During this part vital concepts will be explained about data cleaning & manipulation, data modeling, data integration and merging, star-schemas, and converting existing data sources into dimension & fact tables to be a base for powerful reporting and visualization. Moreover, you will be exposed to the different loading options to optimize performance. In addition, our course will give you the experience on how different dataset can be integrated based on understanding the concepts of cardinality and database relationship concepts. Following that, the course will take you through the detailed stage of how to create different kinds of reports and visualizations. It is at this stage that you will master how to utilize many powerful features such as multi-level filters and interactivity features. Also, to consolidate your reporting capabilities you will learn about functions, calculated columns, while measures will be illustrated. This will be followed by illustrating the different methodologies of publishing and by sharing the produced reports and visualizations safely using the tools of the Power BI software. Not only the Power BI (desktop) version will be used, but you will also be exposed to the Power BI (mobile) versions as well. The course is prepared with many real-life and industry examples used in the explanation. At the same time, the course will be hands-on practical based to help strengthen the understanding of the concepts. Rest assured that this course will share with you many secrets in BI and reporting that are the result of many years of work and research.
Outline
Introduction:
Connecting to data sources:
Extensive Practice for Extraction, Transformation and Loading (ETL):
Data formatting and shaping:
Data Integration:
Data Visualizations:
Explore Power BI service (The Power BI online platform):
Summary and Conclusions
Who should take this course?
This course is important for:
Professionals who need to deal with data and data stores.
Professionals who is concerned with creating different kinds of reports & visualizations.
Managers.
Business Reporting Officers.
Decision Makers.
The course delivery method
The course is available with the following modes:
Online live instructor-led mode:
The course will be delivered using ZOOM application. Participants are required to install ZOOM application to their computers.
Face to face instructor-led mode:
The course will be held in a training venue at reputable hotel or business center. The participants will be informed about the venue details after registration. Participants are required to bring their own computing devices.
Duration
One day, from 9 am - 5 pm , including refereshments and lunch break.
Software requirements
Participants are required to have the following software to be installed prior to the course session:
- ZOOM
- Microsoft Excel 2016 or higher
Course prerequisites
To have good understanding for the course, it is important to have at least basic computer skills and basic understading for relational database concepts.
Location
Our scheduled trainings are held in Ottawa, Montreal, Toronto and Vancouver. at the same time, we are able to provide our services to the other cites in Canada based on request.