Description

This Microsoft Power BI course will help you become a Power BI expert. It'll enhance your skills by offering you comprehensive knowledge on Power BI Desktop and Power BI Online, and unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.

Power BI is a business intelligence tool by Microsoft that provides analytics services. It provides interactive dashboards and visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves without having to depend on anyone else, as Power BI's artificial intelligence is there to help you out. Power BI provides cloud-based BI services, known as Power BI Services, along with a desktop-based interface called Power BI Desktop. It offers data modeling capabilities along with data preparation, data discovery, and interactive dashboards. In this course, you will gain an understanding of the concept and working of Power BI Desktop and Power BI online services. You'll start with learning how to connect Power BI to different data sources. Then you'll be able to transform your data using Power Query and create data models. After this, you'll also level up your data analysis skills using DAX and create calculated columns and measures. With the help of reports and visualization in Power BI, you'll be able to present your data in an efficient and interactive way. And lastly, you'll learn how to publish your reports and dashboards to the Power BI online service. By the end of this course, you'll be able to excel at your career as a business intelligence and data analyst professional. The resource files are updated on GitHub at https://github.com/PacktPublishing/Master-in-Microsoft-Power-BI-Desktop-and-Service

What You Will Learn

Learn how to connect Power BI to different data sources
Transform your data using Power Query and create data models
Learn data modeling concepts to find correlation in data
Level up your data analysis skills using DAX and create calculated columns and measures
Present data effectively and interactively using reports and visualization
Publish your reports and dashboards to the Power BI online service

Audience

This course is for individuals looking for jobs as business analysts, business development managers, data analysts, and reporting professionals, especially in the business intelligence domain. Apart from this, statisticians aiming to implement their statistics skill to derive business insights and marketing, finance, sales, and other domain professionals who need extensive business intelligence will also benefit.

Microsoft Power BI Desktop installed on your computer (which is free) along with a basic understanding of Microsoft Excel will be beneficial but is not mandatory.

Approach

With the help of interesting examples and engaging activities, this course will unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.

The course uses hands-on experience to solve real-time industry-based Power BI projects to make you competition-ready.

Key Features

Create, share, collaborate, and benefit from business information with purpose-built dashboards * Create compelling reports and visualizations, derive real-time insights, and deploy it on demand * Form relationships in your data model and learn data visualization best practices

Github Repo

https://github.com/PacktPublishing/Master-in-Microsoft-Power-BI-Desktop-and-Service

About the Author

Learnsector LLP

Learnsector is dedicated to giving the best-in-class training in the fields of programming, cybersecurity, cloud, machine learning, analytics, and project management. Their exclusive training helps one to acquire the relevant skillset mandatory to grab thriving opportunities. They train intensively to implement the technical skills in a real-world scenario and help you stay up-to-date with the latest technologies and requirements of IT organizations across the world.

Course Outline

1. Business Intelligence Concepts and Introduction

1. Introduction to Business Intelligence

In this video, you will get an introduction to Microsoft Power BI and also recognize the five 'whats' that Power BI helps us answer.

2. The Relation Between Business Intelligence and Data Warehouse

In this video, you will understand what an ETL (Extract, Transform, Load) process is and the relationship between business intelligence and data warehouse.

3. Power BI Overview and Installation

In this video, you will be introduced to the different components of Power BI and then you'll learn how to install Power BI Desktop.

4. Introduction to Power BI Desktop

In this video, you will look at the Power BI Interface and understand the Power BI settings.

2. Connecting Power BI with Different Data Sources

1. Connecting with Data

In this video, you'll be given a brief introduction to connecting data and also explore the different file formats and different data sources that can be connected to Power BI.

2. Connect to Excel in Power BI Desktop

This video explains how to connect an Excel file to Power BI Desktop.

3. Connect to CSV Files in Power BI Desktop

In this video, you'll learn how to connect CSV or text file to Power BI Desktop.

4. Connect to SQL Server in Power BI Desktop

In this video, you'll learn how to connect the SQL Server to Power BI Desktop.

5. Connect to a Webpage from Power BI Desktop

In this video, you'll learn how to connect data on the web to Power BI Desktop.

6. Enter Data Directly into Power BI Desktop

In this video, you'll learn how to manually enter data into Power BI Desktop.

3. Power Query for Data Transformation

1. Introduction to Power Query

In this video, you will get introduced to basic concepts of Power Query.

2. Query Editor

In this video, you'll look into the working of a Query Editor.

3. Text Transformations

In this video, you'll look into how to perform text transformation on a column in Query Editor.

4. Number Column Calculations

In this video, you'll learn how to perform number calculations on a column in Power Query Editor.

5. Data Type

In this video, you'll see how to identify the data types and how to change from one data type to another.

6. Date and Time Calculations

In this video, you'll understand the date transformation, group by, and conditional column options in Power Query.

7. Append Queries and Merge Queries

This video demonstrates how to append and merge queries in Query Editor.

8. Data Source Settings and Refresh Settings

This video shows how to work around with the data source and refresh settings.

9. Power Query Data Formatting

This video demonstrates about the Power Query data formatting.

10. Hierarchy Creation in Power BI

This video shows how to create hierarchy in Power BI.

4. Power BI Data Modeling - Relationship View and PowerPivot

1. Data Modeling Introduction

This video provides an introduction to data modeling.

2. Primary key Versus Foreign Key

This video demonstrates the difference between the primary key and foreign key.

3. Relationship build, Edit, Delete

This video explains how to build the relationship with two different approaches: manual and shortcut.

4. Snowflake Scheme

This video explains about the Snowflake scheme.

5. Active Versus Inactive relationship

This video explains the difference between active and inactive relationships.

6. Relationship Primary Key with Multiple Foreign Keys from Different Data

This video demonstrates the relationship between primary key with multiple foreign keys from different workbooks.

5. Data Analysis Expression (DAX)

1. Introduction to Data Analysis Expression (DAX)

This video provides an introduction to Data Analysis Expression (DAX).

2. Creating Calculated Columns, Creating Measures

This video shows how to create calculated columns and measures.

3. DAX Date and Time Functions

This video explores DAX date and time functions.

4. DAX Text Functions

This video explores DAX text functions.

5. DAX Logical Functions

This video explores DAX logical functions.

6. DAX Related Function

This video explores DAX related functions.

7. DAX Implicit Versus Explicit Measures

This video demonstrates DAX implicit and explicit functions.

8. DAX Statistical Functions

This video explores DAX statistical functions.

9. DAX Filter Functions

This video explains DAX filter functions.

10. DAX X-factor Functions

This video explains DAX X-factor functions.

11. DAX Time Intelligence Functions

This video explains DAX time intelligence functions.

12. DAX Rank Functions

This video explains DAX rank functions.

13. New Table and Quick Measure

This video demonstrates the new table feature.

6. Reports and Visualization Types in Power BI

1. Introduction to Reports and Visualization Types in Power BI

This video introduces you to the reports and visualization types in Power BI.

2. Page Settings

This video explains about the page settings.

3. Getting started with color formatting and axis properties

This video helps you get started with color formatting and axis properties.

4. Customize Visualization and X-axis and Y-axis properties

This video demonstrates how to customize visualization and x-axis and y-axis properties.

5. Filters in Power BI

This video explains filters in Power BI.

6. Slicers in Power BI

This video explores slicers in Power BI.

7. Table and Matrix

This video focuses on table and matrix.

8. Conditional Formatting on Visuals

This video demonstrates how to do conditional formatting on visuals.

9. Card and Multi-Row Card

This video explores about the card and multi-row card.

10. Treemap

This video explains about Treemap.

11. Combo Chart

This video explains about the combo chart.

12. Line chart, Area chart, and Stacked area chart

This video explores line chart, area chart, and stacked area chart.

13. Gauge chart

This video explains about the gauge chart.

14. KPI

This video dives into KPI.

15. Drill through

This video explains drill through feature.

16. Map and Filled map

This video explores map and filled map feature.

17. Pie chart and Doughnut charts

This video explains about the pie chart and doughnut chart.

18. Ribbon charts

This video explains about the ribbon chart.

19. Waterfall Chart

This video explains about the waterfall chart.

20. Funnel chart

This video explains about the funnel chart.

21. Import Data model to Power BI desktop

This video dives into importing data model to Power BI desktop.

22. Phone layout

This video focuses on phone layout.

23. Bookmark

This video explores show pane features in Power BI.

7. Power BI Publishing - Reports

1. Comparing Power BI Desktop and Power BI Service

This video provides shows the comparison between Power BI desktop and Power BI service.

2. Sign in to Power BI

This video demonstrates how to sign in to Power BI.

3. Power BI Service walkthrough

This video will walk you through the Power BI service.

4. Publishing a report from Power BI Desktop to Power BI Service

This video explains how to publish a report from Power BI desktop to Power BI service.

5. Create a Dashboard in Power BI Service

This video shows how to create a dashboard in Power BI service.

6. Power BI Service Workspace UI

This video explores Power BI service workspace user interface.

7. Edit a Report in Power BI Service

This video explains how to edit a report in Power BI service.

8. Power BI Report - Reading View

This video focusses on the reading view of Power BI report.

9. Power BI Report - Usage Metrics

This video focuses on the usage metrics of Power BI report.

10. Analyze in Excel

This video shows how you can share the Power BI file to the Excel format.

11. Power BI Report - Quick Insights

This video explores Power BI report.

12. Dashboard Walkthrough

This video walks you through the dashboard of Power BI.

13. Adding Tile in Dashboard

This video shows how to add a tile in the Power BI dashboard.

14. Q and A

This video focuses on the Q and A feature of Power BI.

15. Dataset Settings

This video explores dataset settings.

16. Get More Visuals

This video explores how to get more visuals in Power BI.

17. Row-Level Security with Power BI

This video explains row-level security with Power BI.

Course Images

Master in Microsoft Power BI Desktop and Service

By Packt

Booking options

Highlights