Microsoft Power BI - Introduction

Description

Unlock the power of your data with our Power BI Introduction course - the perfect starting point for anyone looking to turn raw information into clear, interactive insights. Whether you're working in finance, marketing, operations or any other field, this hands-on course will guide you through the essentials of Power BI, Microsoft’s leading business intelligence tool.

Power BI is a collection of software services, apps and connectors that work together to turn your unrelated sources of data into coherent, visually immersive and interactive insights. Your data might be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.

Build your Power BI skills as this interactive, tutor led course gives you plenty of time to try out new things and ask questions as you go. Our expert and highly respected trainers break the course down into easily digestible chunks and make sure no-one gets left behind.

What you will learn

Content

• What is Power BI?
• The Elements of Power BI
• Exploring the Power BI desktop
• Importing Data Sources
• Importing and Connecting to Data Sources
• Connecting to a Data Source in Excel/ CSV Files
• Loading Data to the PowerBI Desktop
• Power Query Editor
• Introduction to the Power Query Editor
• Data Types, Header Rows and Replace Values
• Remove Columns & Rows
• What is DAX?
• Introduction to DAX Syntax
• Add a Calculated Column to a Dataset
• Visualising Data in a Report
• Create a Report in Power BI
• Use visuals such as Column, Bar, Line and Area Charts.
• Other Visual Types (Tables/Cards/Funnel/Map)
• Formatting the Axis, Legend & Values
• Using Slicers
• Editing Interactions between Visuals
• Filters
• The Data Model
• Introduction to the Data Model and its importance
• Publish Report to Power BI Service
• Quick overview of Publishing a Report to the Power BI Service

Learning Outcomes

You’ll learn how to:

• Connect to data sources like Excel and CSV files
• Create dynamic dashboards and reports
• Use visualisations to tell compelling data stories
• Apply filters, slicers and basic DAX formulas
• Share your insights with colleagues and stakeholders