Power BI Level 1 - Introduction 1 Day
Course Overview
This 1-day course is intended for anyone new to designing and implementing self-service business intelligence solutions with Microsoft Power BI. The course introduces students to the capabilities and components of Power BI before delving into the realms of discovering and loading data from text files, such as CSV files and Microsoft Excel. This is followed by an introduction to analysing data quality issues and basic data modelling concepts. We follow this up with an introduction to extending the semantic model with the DAX expression language – something that can be utilised to perform calculations on our data to be incorporated into reports.
INTRODUCTION
This 1-day course is intended for anyone new to designing and implementing self-service business intelligence solutions with Microsoft Power BI.
The course introduces students to the capabilities and components of Power BI before delving into the realms of discovering and loading data from text files, such as CSV files and Microsoft Excel.
This is followed by an introduction to analysing data quality issues and basic data modelling concepts.
We follow this up with an introduction to extending the semantic model with the DAX expression language – something that can be utilised to perform calculations on our data to be incorporated into reports.
An overview of the different visuals used in reports follows. In particular, working with commonly used visuals such as tables, matrices, bar charts, column charts, and line charts. In addition, we introduce some user interactivity by incorporating slicers into reports.
The final module demonstrates how we can publish reports created locally in Power BI Desktop to the Power BI web service.
The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience.
Due to the ever-changing nature of this technology, course content may vary to keep the training as relevant and up to date as possible.
PREREQUISITES
No previous knowledge of Power BI is required.
Attendees should be able to demonstrate a good level of computer literacy and skills. You will have a good understanding of your business needs to collect, cleanse, and analyse data, in order to be able to visualise and gain insights into that data.
COURSE OBJECTIVES
Upon successful completion of this course, students will be able to:
- Understand the Role Power BI plays in Self-Service BI
- Understand the Constituent Parts of Power BI Desktop
- Discover and Load Data from Text Based Files
- Address Data Quality Issues
- Perform Basic Data Transforms
- Become Acquainted with the Semantic Model
- Understand the Role of the DAX Expression Language
- Implement Calculated Columns
- Understand the Purpose of Visual Calculations
- Create Reports with Text-Based Visuals
- Create and Implement Charts
- Implement a Slicer in a Report Page
- Understand the Role of the Power BI Web Service
- Publish Reports
COURSE OUTLINE
|
1. Introducing Power BI Describe the Power BI Products and Services Introducing Power BI Desktop The Components of Power BI 2. Loading Data from Files Load Data from Text Files Load Data from Excel Workbooks 3. Cleaning and Transforming Data Why You Should Clean Your Data Cleansing Data in Power Query Basic Power Query Transforms 4. Introducing the Semantic Model Basic Data Modelling Concepts Configure Table and Column Properties |
5. Introducing the DAX Expression Language Introduction to DAX Extend the Semantic Model with Calculated Columns Aggregate Data (Implicit Measures) Introduction to Visual Calculations 6. Visualising Data Implement and Format Table and Matrix Visuals Implement and Format Charts Using Slicers 7. Publishing Reports Introduction to the Power BI Web Service Publish Reports to the Power BI Web Service Manage and Organise Content in Workspaces |
Power BI Level 1 - Introduction 1 Day
Course Overview
This 1-day course is intended for anyone new to designing and implementing self-service business intelligence solutions with Microsoft Power BI. The course introduces students to the capabilities and components of Power BI before delving into the realms of discovering and loading data from text files, such as CSV files and Microsoft Excel. This is followed by an introduction to analysing data quality issues and basic data modelling concepts. We follow this up with an introduction to extending the semantic model with the DAX expression language – something that can be utilised to perform calculations on our data to be incorporated into reports.
INTRODUCTION
This 1-day course is intended for anyone new to designing and implementing self-service business intelligence solutions with Microsoft Power BI.
The course introduces students to the capabilities and components of Power BI before delving into the realms of discovering and loading data from text files, such as CSV files and Microsoft Excel.
This is followed by an introduction to analysing data quality issues and basic data modelling concepts.
We follow this up with an introduction to extending the semantic model with the DAX expression language – something that can be utilised to perform calculations on our data to be incorporated into reports.
An overview of the different visuals used in reports follows. In particular, working with commonly used visuals such as tables, matrices, bar charts, column charts, and line charts. In addition, we introduce some user interactivity by incorporating slicers into reports.
The final module demonstrates how we can publish reports created locally in Power BI Desktop to the Power BI web service.
The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience.
Due to the ever-changing nature of this technology, course content may vary to keep the training as relevant and up to date as possible.
PREREQUISITES
No previous knowledge of Power BI is required.
Attendees should be able to demonstrate a good level of computer literacy and skills. You will have a good understanding of your business needs to collect, cleanse, and analyse data, in order to be able to visualise and gain insights into that data.
COURSE OBJECTIVES
Upon successful completion of this course, students will be able to:
- Understand the Role Power BI plays in Self-Service BI
- Understand the Constituent Parts of Power BI Desktop
- Discover and Load Data from Text Based Files
- Address Data Quality Issues
- Perform Basic Data Transforms
- Become Acquainted with the Semantic Model
- Understand the Role of the DAX Expression Language
- Implement Calculated Columns
- Understand the Purpose of Visual Calculations
- Create Reports with Text-Based Visuals
- Create and Implement Charts
- Implement a Slicer in a Report Page
- Understand the Role of the Power BI Web Service
- Publish Reports
COURSE OUTLINE
|
1. Introducing Power BI Describe the Power BI Products and Services Introducing Power BI Desktop The Components of Power BI 2. Loading Data from Files Load Data from Text Files Load Data from Excel Workbooks 3. Cleaning and Transforming Data Why You Should Clean Your Data Cleansing Data in Power Query Basic Power Query Transforms 4. Introducing the Semantic Model Basic Data Modelling Concepts Configure Table and Column Properties |
5. Introducing the DAX Expression Language Introduction to DAX Extend the Semantic Model with Calculated Columns Aggregate Data (Implicit Measures) Introduction to Visual Calculations 6. Visualising Data Implement and Format Table and Matrix Visuals Implement and Format Charts Using Slicers 7. Publishing Reports Introduction to the Power BI Web Service Publish Reports to the Power BI Web Service Manage and Organise Content in Workspaces |
