Power BI Introduction DURATION 2 Days
Course Overview
This 2-day course is intended for anyone who is new to designing and implementing self-service Business Intelligence (BI) solutions using Microsoft Power BI Desktop and the Power BI Service. It is ideal for anyone who needs to quickly get up to speed with analysing and reporting on data in Power BI.
Power BI Introduction
DURATION
2 days
INTRODUCTION
The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Also, as Power BI Desktop and the Power BI Service are continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience.
With the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.
Full course breakdown available – training@jcstraining.com
PREREQUISITES
There are no specific technical prerequisites for this course, but a familiarity with Excel may prove beneficial. The main consideration is to have a basic understanding of your business needs to collect, cleanse, and analyse data, in order to be able to visualise and gain insights into that data.
Upon successful completion of this course, students will be able to:
- Understand Key Components of Power BI
- Load Data from Commonly Used Sources
- Shape and Transform Datasets
- Merge and Append Data
- Parameterise Queries
- Implement a Data Model
- Create and Manage Relationships
- Gain an Understanding of DAX
- Implement Calculated Columns
- Implement Measures
- Implement Time Intelligence
- Create Reports with Text-Based Visuals
- Implement Conditional Formatting
- Create and Implement Charts
- Implement Gauges and KPIs
- Implement Maps
- Implement Slicers
- Understand the Power BI Web Service
- Manage Content in Workspaces
- Publish Reports and Create Dashboards
COURSE OUTLINE
|
Part 1: Introduction and Power Query 1. Introducing Power BI Introducing Power BI Products and Services Introducing Power BI Desktop 2. Loading Data Load Data from Text Files Load Data from Excel Files Load Data from OneDrive and SharePoint Review Other Supported Data Sources 3. Transforming Data Cleanse Data Shape Datasets Transform Datasets Merge and Append Data Power Query Parameters Power BI Template Files Part 2: Data Modelling and DAX 4. Data Modelling Data Modelling Concepts Configure Table and Column Properties Categorise Data Sorting Columns Create and Manage Relationships Understand Filter Propagation 5. The DAX Expression Language Introducing DAX Create Calculated Columns Add Measures to the Data Model Implicit v Explicit Measures Quick Measures Manipulate the Filter Context with CALCULATE Analyse Data over Time (Time Intelligence) |
Part 3: Reports and Visuals 6. Visualising Data Implement and Format Table and Matrix Visuals Rename Fields in Visuals Show Items with no Data Conditionally Format Visual Content Use Card Visuals Implement and Format Charts Use Tooltips Implement and Use Hierarchies Group and Bin Data Automatically Find Clusters of Data Animate Scatter Charts Gauges and KPIs Implement Maps Implement Slicers Cross-Filtering and Cross-Highlighting Implement Bookmarks Implement Buttons Text Boxes, Shapes, and Images Control the Display of Content Part 4: Publishing Reports 7. The Power BI Web Service Introducing the Power BI Web Service Publish Reports to the Power BI Web Service Manage and Organise Content in Workspaces Create and Manage Dashboards Dashboard Themes |
Power BI Introduction DURATION 2 Days
Course Overview
This 2-day course is intended for anyone who is new to designing and implementing self-service Business Intelligence (BI) solutions using Microsoft Power BI Desktop and the Power BI Service. It is ideal for anyone who needs to quickly get up to speed with analysing and reporting on data in Power BI.
Power BI Introduction
DURATION
2 days
INTRODUCTION
The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Also, as Power BI Desktop and the Power BI Service are continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience.
With the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.
Full course breakdown available – training@jcstraining.com
PREREQUISITES
There are no specific technical prerequisites for this course, but a familiarity with Excel may prove beneficial. The main consideration is to have a basic understanding of your business needs to collect, cleanse, and analyse data, in order to be able to visualise and gain insights into that data.
Upon successful completion of this course, students will be able to:
- Understand Key Components of Power BI
- Load Data from Commonly Used Sources
- Shape and Transform Datasets
- Merge and Append Data
- Parameterise Queries
- Implement a Data Model
- Create and Manage Relationships
- Gain an Understanding of DAX
- Implement Calculated Columns
- Implement Measures
- Implement Time Intelligence
- Create Reports with Text-Based Visuals
- Implement Conditional Formatting
- Create and Implement Charts
- Implement Gauges and KPIs
- Implement Maps
- Implement Slicers
- Understand the Power BI Web Service
- Manage Content in Workspaces
- Publish Reports and Create Dashboards
COURSE OUTLINE
|
Part 1: Introduction and Power Query 1. Introducing Power BI Introducing Power BI Products and Services Introducing Power BI Desktop 2. Loading Data Load Data from Text Files Load Data from Excel Files Load Data from OneDrive and SharePoint Review Other Supported Data Sources 3. Transforming Data Cleanse Data Shape Datasets Transform Datasets Merge and Append Data Power Query Parameters Power BI Template Files Part 2: Data Modelling and DAX 4. Data Modelling Data Modelling Concepts Configure Table and Column Properties Categorise Data Sorting Columns Create and Manage Relationships Understand Filter Propagation 5. The DAX Expression Language Introducing DAX Create Calculated Columns Add Measures to the Data Model Implicit v Explicit Measures Quick Measures Manipulate the Filter Context with CALCULATE Analyse Data over Time (Time Intelligence) |
Part 3: Reports and Visuals 6. Visualising Data Implement and Format Table and Matrix Visuals Rename Fields in Visuals Show Items with no Data Conditionally Format Visual Content Use Card Visuals Implement and Format Charts Use Tooltips Implement and Use Hierarchies Group and Bin Data Automatically Find Clusters of Data Animate Scatter Charts Gauges and KPIs Implement Maps Implement Slicers Cross-Filtering and Cross-Highlighting Implement Bookmarks Implement Buttons Text Boxes, Shapes, and Images Control the Display of Content Part 4: Publishing Reports 7. The Power BI Web Service Introducing the Power BI Web Service Publish Reports to the Power BI Web Service Manage and Organise Content in Workspaces Create and Manage Dashboards Dashboard Themes |
