Lifelong learning for working professionals
Power BI Basic

Power BI Basic

Course Summary

This basic Power BI training is intended for end users who have access to complete data models and are ready to visualize data from these models.
The course is designed for beginners and no previous experience is required.

You learn step by step how to use your data to build reports in Power BI Desktop and publish them in the cloud service where you can create and share your custom dashboards.

IT users who want to turn raw data into knowledge

Basic Excel knowledge and Basic understanding of data analysis is a plus but no requirement

This course has no certification

This training is delivered by Lasaros Mavropoulos

Lasaros is a consultant, communicator and coach with over 25 years of experience in Business Intelligence, data management and technology-driven solutions.
He specializes in Business Intelligence, SQL Server and the entire Power BI ecosystem and has been working with these technologies since 1998 and involved with Power BI since its inception in 2014.

Previously balancing the role of consultant and instructor, since 2016 Lasaros has shifted his focus to training, mentoring and coaching.
As an expert in data analytics, Lasaros develops and delivers comprehensive training programs tailored to both technical and strategic needs, helping organizations optimize their data solutions.

Lasaros is also an Azure evangelist, sharing his expertise in Microsoft cloud technologies and advocating innovative solutions with Azure in the field of BI.

Course content

Modules

  • Introducing the Power BI Platform
  • Getting Data with Power BI Desktop
  • Applying basic transformations
  • Beginning Data Modeling and DAX
  • Introducing the Power BI Service
  • Understanding Visualizations and Visual Interactions
  • Filtering, Slicing and Dicing
  • Geo Location (Map) Visualizations
  • Using custom visuals

Outline Power BI Basics (2 days Level 1)

Day 1

Introducing the Power BI Platform

  • What is Power BI?
  • Power BI Desktop, The First Experience
  • Exploring Power BI Website
  • Introduction to Power Components

Getting Data and apply some basic transformations

  • The Role of Power Query in a Power BI Solution
  • Introduction to Data Mash-Up Engine of Power BI
  • Τhe Query Editor Transformation GUIDataModelling Basics
  • Power BI xVelocity engine basics and concepts
  • Relationships in Power BI
  • Hierarchies and Formatting
  • Sorting by other columns
  • Date Table
  • Calculated Columns, Measures, and Calculated Tables

Data Visualization

  • Power BI Desktop Visualization
  • Formatting Visuals in Power BI Desktop
  • Basic Charts and Visuals in Power BI
  • Sorting, Filtering, and categorization
  • Maps and Geo-Spatial Visualization

Power BI Service

  • Basic Sharing and using workspaces in Power BI web site
  • Dashboard vs. Report
  • Power Q&A
  • Mobile Dashboard Design
  • Schedule Refresh vs. Other types of connections
  • Gateway’s Role in the Service

Day 2

Understanding Visualizations

  • Importance of Visualization
  • Basic Charts; Bar and Column Charts
  • Clustered vs. Stacked Charts
  • Q&A for Reports
  • Quick Measures in Power BI
  • Drill Down and Up using visuals and hierarchies
  • Table and Matrix
  • Conditional formatting
  • Multi Pages reports

Slicing and Dicing

  • Filters
  • Scopes of Filters: Visual Level, Page Level, Report Level
  • Modes of Filtering: Basic, Advanced, Relative, Top N
  • Drill through Page Filter
  • Creating master-details page scenario in Power BI
  • Slicers
  • Types of Slicers; Date, Text, Number
  • Slicer Formatting
  • Syncing Slicer between Pages

Geo Location Visualization

  • Using Bing to find spots
  • Fine Tuning Address Details
  • Using Latitude and Longitude
  • Filled Map Regions and Polygons
  • Filled Map Data Category importance
  • Custom map visual with Shape Maps
  • The Hero of all maps, ArcGIS Map;

Custom Visuals

  • Adding and using a custom visual
  • Infographic Designer
  • Speedometer Gauge
  • Map custom visuals
  • Hierarchy Slicer
  • R Custom Visuals

Course Overview

19 450 kr

2 days

,

Can’t find a (suitable) date, but are interested in the course? Send in an expression of interest and we will do what we can to find a suitable opportunity.

Register interest

Customized Courses

The course can be adapted from several perspectives:

  • Content and focus area
  • Extent and scope
  • Delivery approach

In interaction with the course leader, we ensure that the course meets your needs.

Contact us

Stockholm

  • Tegnérlunden 3
    111 61 Stockholm
  • +46 8 587 116 10

Göteborg

  • Kungsportsavenyen 37
    411 36 Göteborg
  • +46 31 313 94 20

Skicka intresseanmälan för utbildningen

Send an expression of interest for the training