Power BI for beginners
- Description
- Curriculum
- FAQ
- Reviews
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
-
7Power BI Overview - Part 1Video lesson
-
8Power BI Overview - Part 2Video lesson
-
9Power BI Overview - Part 3Video lesson
-
10Components of Power BIVideo lesson
-
11Building blocks of Power BIVideo lesson
-
12Exploring Power BI Desktop interfaceVideo lesson
-
13Exploring Power BI ServiceVideo lesson
-
14What are Power BI AppsVideo lesson
-
15Connecting to Web based DataVideo lesson
-
16Clean and transform data - Part 1Video lesson
-
17Clean and transform data - Part 2Video lesson
-
18Combining Data SourcesVideo lesson
-
19Creating Visuals in Power BI - Part 1Video lesson
-
20Creating Visuals in Power BI - Part 2Video lesson
-
21Publishing Report to Power BI ServiceVideo lesson
-
22What is SQL ServerVideo lesson
-
23SQL Server 2017 Express InstallationVideo lesson
-
24Download Sample DatabaseVideo lesson
-
25Attach sample databaseVideo lesson
-
26Connecting to SQL Server Database with Power BI DesktopVideo lesson
-
27What is PostgreSQLVideo lesson
-
28Install PostgreSQLVideo lesson
-
29Connecting to PostgreSQL Database ServerVideo lesson
-
30Download and load sample databaseVideo lesson
-
31Connect to PostgreSQL with Power BI Desktop - Part 1Video lesson
-
32Connect to PostgreSQL with Power BI Desktop - Part 2Video lesson
-
33Importing and Transforming Data from an Access Database FileVideo lesson
-
34Changing LocaleVideo lesson
-
35Connecting to Microsoft Access Database FileVideo lesson
-
36Power Query Editor and QueriesVideo lesson
-
37Creating and Managing Query GroupsVideo lesson
-
38Renaming QueriesVideo lesson
-
39Splitting ColumnsVideo lesson
-
40Changing Data TypesVideo lesson
-
41Removing and Reordering ColumnsVideo lesson
-
42Duplicating and Adding ColumnsVideo lesson
-
43Creating Conditional ColumnsVideo lesson
-
44Connecting to Files in a FolderVideo lesson
-
45Appending QueriesVideo lesson
-
46Merge QueriesVideo lesson
-
47Query Dependency ViewVideo lesson
-
48Transforming Less Structured Data - Part 1Video lesson
-
49Transforming Less Structured Data - Part 2Video lesson
-
50Creating TablesVideo lesson
-
51Query ParametersVideo lesson

External Links May Contain Affiliate Links read more