Course Duration
2 Days
Microsoft
Authorized Training
IT
Course cost:
was £1,725
£1,232
IT Certification Overview
This course will provide you with the basic knowledge and skills to import / ingest data, create a model and create visualisations using Power BI Desktop.
Newto Training Reviews
What Our Happy Alumni Say About Us
Prerequisites
- Basic understanding of data concepts, such as tables, spreadsheets, and common visualization types.
- Familiarity with basic statistical concepts, such as averages and sums.
- Some experience with Excel functions like pivot tables, charts, and formulas is advantageous.
- Ability to navigate and use software applications comfortably.
- Familiarity with Power BI Desktop is beneficial but not mandatory.
Target audience
Anyone who will be creating Power BI Desktop semantic models and reports.
The course is aimed at both non-technical 'power users' and IT Professionals who will be creating semantic models and reports.
v
Learning Objectives
By the end of this course, learners will be able to:
- Import and Ingest Data: Connect to various data sources, including CSV files, Excel spreadsheets, and SQL Databases, and import data into Power BI Desktop.
- Transform Data: Utilize the Power Query Editor to cleanse and transform imported data, such as removing unnecessary columns and rows, normalizing datasets, and merging data.
- Model Data: Enhance data models by managing relationships, customizing fields, creating calculations, and establishing hierarchies to facilitate accurate data analysis.
- Create Visualisations: Develop interactive reports and dashboards by adding various visual elements, including tables, charts, maps, slicers, and custom tooltips, to effectively provide data insights.
Power BI Desktop for Technical Users Course Content
Module 1: Introduction to Power BI
- Overview of the processes involved in creating a Power BI report.
Module 2: Accessing data
- Importing source data from flat files
- Connecting to Microsoft SQL Server
Module 3: Transforming data in Power Query
- Applied steps
- Naming rules
- Reducing the dataset
- Working with columns
- Calculated columns
- Changing the structure of data
- Merging and appending datasets
Module 4: Modelling data
- Relationships
- Enhancing columns
- Sorting data
- Formatting data
- Data categories
- Default summarization
- Hiding fields and queries
- Data groups
- Hierarchies
- Calculations using DAX
- Default context filters
- Aggregation
- Calculations with filters
- Logical functions
- Filter information
- Relational functions
- Time intelligence
Module 5: Visualization
- Report design layout
- Report design
- Built-in, code, and custom visualizations
- Visual interactions
- Decoration
- Tabular and textual visualizations
- Charts and graphics
- Maps
- Slicers
- Custom page tooltips
Exams and assessments
There are no formal exams included in this course.
Hands-on learning
This course includes:
- Hands-on labs to apply key concepts in a real-world environment.
Power BI Desktop for Technical Users Dates
Next 4 available training dates for this course
VIRTUAL
VIRTUAL
VIRTUAL
VIRTUAL
Advance Your Career with Power BI Desktop for Technical Users
Gain the skills you need to succeed. Enrol in Power BI Desktop for Technical Users with Newto Training today.