This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms
.
Course Objectives
At the end of this course you will be able to:
Connect to data from different sources.
Use the Query Editor
Perform Power BI desktop data Shaping and Transformation.
Create Power BI desktop Modelling.
Create Power BI desktop Visualizations and Reports.
' 1 year email support service
Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.
Introduction to Power BI
Power BI Jargon explained
A quick look at Power BI Desktop
A quick look at the Power BI service
Helpful resources
Power BI and Excel
Introduction to using Excel data in Power BI
Upload Excel data to Power BI
Import Power View and Power Pivot to Power BI
Getting started with Power BI Desktop
Overview of Power BI Desktop
Accessing Help and Helpful resources
Connect to data sources in Power BI Desktop
Shaping and Transforming Data with Query Editor
Introduction to the Query Editor
Data Sources Power BI Desktop can Connect to
Introduction to Steps and M code
Combining Data Using Merge and Append Queries
Data Type Properties
Working with Delimiters
Clean and transform your data with the Query Editor
Text Specific Transformation Tools
Number Specific Transformation Tools
Date Specific Transformation Tools
Split and Merge columns
Creating an Index Column
Adding Conditional Columns
Columns From Examples
Grouping and Aggregating data
Pivoting and Unpivoting
Using filters
Modeling the data
Introduction to modeling your data
How to manage your data relationships
Create calculated columns
Optimizing data models
Create calculated measures
Show Values As and Quick Measures
Create calculated tables
Explore your time-based data
Introduction to DAX
DAX calculation types
DAX functions
Visualizations
Introduction to visuals in Power BI
Create and customize simple visualizations
Modify colors in charts and visuals
Shapes, text boxes, and images
Page layout and formatting
Group interactions among visualizations
Visual hierarchies and drill-down
Using custom visualizations
Create a KPI Visualization
Geo-Data and Maps
Reports, Publishing and Sharing
Introduction to the Power BI service
Quick insights in Power BI
Create and configure a dashboard
Ask questions of your data with natural language
Create custom Q&A suggestions
Share dashboards with your organization
Introduction to content packs, security, and groups
Publish Power BI Desktop reports
Print and export dashboards and reports
Create groups in Power BI
Use content packs
Update content packs
Publish to web
Who is this course for? Who is this course for?
This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms.
Requirements Requirements
Before attending this course, delegates should have:
- A general knowledge of database concepts (fields, records and relationships)
- Familiarity with Excel.
Career path Career path
Business Intelligence
Data Analysis
ETL & Data Warehousing