What you will learn

  • Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.
  • With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor.

Skills you will gain

  • Shareable Certificate Earn a Cerfiticate upon completion
  • Face to Face or Live Online Start instantly and learn at your own schedule
  • Flexible Schedule Set and maintain flexible deadlines
  • Intermediate For those with working experience or likely to have completed foundation level training  

This course consists of 5 lessons

Getting Started with Power BI Desktop: Power BI Concepts and Overview - Accessing Help - Power BI Screen Elements and Toolbars - Introduction to Main Features - Imports - Visualizations - Filters and Queries - Reports

Connecting to Data Sources with Power BI Desktop: Data Sources Power BI Desktop will Connect to Data Types and Properties in Power BI Desktop - Import and Enter Data - Get Data and Query Editor - Introducing the Query Editor - Using the Query Editor to Connect to Data - Combining Data Sources as a Mash Up - Use Append Queries - Merge Data Tables - Working with Relationships in Data

Data Visualizations: Overview of Data Visualizations - Creating and Working with Tables and Matrix Views - Applying Conditional Formats to Visualizations - Charts - Types - Options - Interactive Slicers - Date Slicers – Dropdowns and Searches - Number Slicers with Value Ranges - Date Slicers with Relative Filters - Create Reusable Field Hierarchies - Record Grouping and Binning in Visualizations - Analytics Lines in Visualizations - Insight – Explain Increase/Decrease - Forecast - Create Measures - Create a KPI Visualization - Drill Visualizations to see underlying Data - See Records - Date Hierarchies - Page Drillthrough Filters - Show Values As and Quick Measures - Clustering - Creating Role Based Views - Data Categories, Geo-Data and Maps

Querying and Shaping the Data: Common Activities using Query Editor - Filters - Using Delimiters - Transforms - Pivot and Group By - Creating Custom Calculated Columns - Adding Conditional Columns - Columns From Examples - Introduction to DAX Expressions - Histograms

Reports and Output Options: Report Elements and Options - Working with Pages - Keyboard Shortcuts and Navigation - Selection Pane - Lock Objects - Adding Graphics - Report Level Filters - Bookmarks - Spotlight - Report Themes - Export Power BI Data to CSV - Create a Power BI Template

Enquire today

Frequently asked questions

Shareable on LinkedIn

You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.

Are you ready to begin learning exceptional new skills?

Call:
01225 308979

Email:
info@go.courses

Registered Office:
Go Courses Ltd.
10 Laura Place
Bath
United Kingdom
BA2 4BL

View on a map

Delighted satisfaction rating