Data Analysis and Modeling using Power BI

Data Analysis and Modeling using Power BI workshop that provides participants with skills and knowledge to connect to, transform, and visualize business data using any of the Power BI (Business Intelligence) applications. BI professionals and technically proficient business users who need to analyse and model data utilize Power BI. This transformed data in the form of collections of visuals are share as reports, with other people inside their organizations to drive decision making and providing useful insight.

Content

Consuming and Transforming Data by using Power BI Desktop

• Connect to data sources.
• Perform transformations.
• Cleanse data.

Modeling and Visualizing Data

• Create and optimize data models.
• Create calculated columns, calculated tables, and measures.
• Measure performance by using KPIs, gauges and cards.
• Create hierarchies.
• Create and format interactive visualizations.
• Manage custom reporting solutions.

Configure Dashboards, Reports and Apps in the Power BI Service

• Access on-premises data.
• Configure a dashboard.
• Publish and embed reports.
• Configure security for dashboards, reports and apps.
• Configure apps and apps workspaces.

Training Methodology

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.