Course Information
Course Overview
Perform Business analysis| Connect to various Data Sources|Transform Data |Publish Data
Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.
Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service, Power BI Desktop, and Power BI Mobile—can help you more effectively create and share impactful visualizations with others in your organization.
In this beginners course you will learn how to get started with this powerful toolset. We will cover topics like connecting to and transforming web based data sources. You will learn how to publish and share your reports and visuals on the Power BI service.
You will learn how to import data, create visualizations, and arrange those visualizations into reports. You will learn how to how to pin visualizations to dashboards for sharing. You will also learn how to use DAX language( Data Analysis Expressions) to perform calculations on data models.
Topics include:
Connecting to SQL Server and PostgreSQL Databases
Connecting to Microsoft Access Database File
Creating reports with data visualizations
Modifying existing reports
Creating and managing data dashboards
Creating Power BI datasets, dashboards, reports, and workbooks
Connecting to web based data source
Connecting to Excel dataset
Using Query Editor
Joining tables and creating tables
Formulating via DAX logic
Using quick measures and dynamic measures
Using conditional statements
Performing various transformation on connected dataset
Course Content
- 6 section(s)
- 58 lecture(s)
- Section 1 Introduction and Lab Environment Setup
- Section 2 Overview of Power BI
- Section 3 Connecting to Web Data: Tranform | Visualize |Publish
- Section 4 Connecting to Databases Data Sources
- Section 5 Transforming Data using Power BI Desktop
- Section 6 Power BI Desktop Modelling
What You’ll Learn
- How to sign up to Power BI Service
- How to install Power BI Desktop
- Building blocks of Power BI
- Overview of Power BI Service
- Connecting to web based data source
- Clean and transform web based data
- Combine web based data sources
- Create visuals from web based data source
- Publish reports and visuals to Power BI Service
- Connect to SQL Server Database with Power BI Desktop
- Connect to PostgreSQL Database with PostgreSQL
- Connect to Microsoft Access Database File with Power BI Desktop
- Perform various transformation on connected data sources
- Connecting to files in a Folder with Power BI Desktop
- Transform less structured data
- Perform data modelling with Power BI Desktop
- Optimize models for reporting
- Perform time intelligence on models
- Applying filters to visuals
Skills covered in this course
Reviews
-
JJesus Lopez Molina
Vamos bien
-
DDan McIver
Too much explaining stuff we can find out ourselves and reading directly what is on the screen.
-
HHalari Donka Syiemlieh
Overall a good beginners course. There were minor setbacks with the resources and downloads, an updated version would greatly help.
-
SStephen Bishop
As an introduction to Power BI I find the course very helpful. The Tutor explains the topics clearly.