Unlocking the Power of Data with PowerBI (incl. Copilot)
Course Description
Are you ready to transform your data into insightful and interactive visualisations? Our comprehensive Power BI course is designed to equip you with the skills needed to harness the full potential of Microsoft Power BI. This course is perfect for professionals looking to enhance their data analysis capabilities and make data-driven decisions with confidence.
This course is composed of 7 modules, as follows:
- Get started with Power BI Desktop
- Data Sources and Transformation
- Data Modeling and Relationships
- Interactive Data Visualisations
- Analysing Data with DAX calculations
- Publishing and Sharing of Power BI Content
- Copilot for PowerBI
By the end of this course, you will have a solid foundation in Power BI and be able to create impactful reports and dashboards that drive business decisions. Join us and unlock the power of your data today!
Course Structure
It is composed of the following 7 Modules:
Get started with Power BI Desktop
- Overview of Power BI and its components
- Tour of the Power BI Desktop Interface
- Creating a new Power BI project
Data Sources and Transformation
-
- Connecting to various data sources (E.g. Excel, CSV, etc..)
- Loading data into Power BI Desktop
- Basic Data transformations using Query Editor
- Removing unnecessary columns and rows
- Renaming columns and tables
- Adding calculated columns
- Hands-on Exercise: Importing and shaping data from a data source
Data Modeling and Relationships
-
-
- Understanding the importance of data modeling
- Creating relationships between tables
- Configuring cross-filtering and cross-highlighting behaviour
- Establishing relationship cardinality (one-to-one, one-to-many)
-
Interactive Data Visualisations
-
-
- Introduction to Power BI visuals and the different types of visualisations
- Drag and Drop visual creation
- Formatting and customising visuals
- Creating hierarchies within interactive reports with drill-through actions
- Adding slicers and filters for data exploration
- Hands-on Exercise: Designing interactive visualisation for a sample dataset
-
Analysing Data with DAX calculations
-
-
-
- Introduction to DAX (Data Analysis Expressions) formulas
- Creating measures and calculated columns with DAX
- Using DAX functions for calculations and aggregations
- Hands-on Exercise: Using DAX create a new measure and incorporate the measure into a visual
-
-
Publishing and Sharing of Power BI Content
-
-
-
-
- Creation of a Workspace
- Creation of roles within the Workspace
- Contents of Workspace when publishing to service
-
-
-
Copilot for PowerBI
-
-
-
- Introduction to Copilot for Power BI
- Accessing Copilot
- Creating Reports with Copilot
- Generating Summarized Insights
- Writing Copilot Prompts
- Updating Data Models
- Security and Privacy
- Creating Custom Copilots
-
-
Register Your Interest: