Enhance your skills with comprehensive knowledge on Power BI Desktop, Power BI Online, and the required hands-on experience to solve real-time industry-based Power BI projects
About This Video
Enhance your skills with comprehensive knowledge on Power BI Desktop, Power BI Online, and the required hands-on experience to solve real-time industry-based Power BI projects
About This Video
In Detail
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.
Chapter 1 : Business Intelligence Concepts and Introduction
Introduction to Business Intelligence
The Relation Between Business Intelligence and Data Warehouse
Power BI Overview and Installation
Introduction to Power BI Desktop
Chapter 2 : Connecting Power BI with Different Data Sources
Connecting with Data
Connect to Excel in Power BI Desktop
Connect to CSV Files in Power BI Desktop
Connect to SQL Server in Power BI Desktop
Connect to a Webpage from Power BI Desktop
Enter Data Directly into Power BI Desktop
Chapter 3 : Power Query for Data Transformation
Introduction to Power Query
Query Editor
Text Transformations
Number Column Calculations
Data Type
Date and Time Calculations
Append Queries and Merge Queries
Data Source Settings and Refresh Settings
Power Query Data Formatting
Hierarchy Creation in Power BI
Chapter 4 : Power BI Data Modeling – Relationship View and PowerPivot
Data Modeling Introduction
Primary key Versus Foreign Key
Relationship build, Edit, Delete
Snowflake Scheme
Active Versus Inactive relationship
Relationship Primary Key with Multiple Foreign Keys from Different Data
Chapter 5 : Data Analysis Expression (DAX)
Introduction to Data Analysis Expression (DAX)
Creating Calculated Columns, Creating Measures
DAX Date and Time Functions
DAX Text Functions
DAX Logical Functions
DAX Related Function
DAX Implicit Versus Explicit Measures
DAX Statistical Functions
DAX Filter Functions
DAX X-factor Functions
DAX Time Intelligence Functions
DAX Rank Functions
New Table and Quick Measure
Chapter 6 : Reports and Visualization Types in Power BI
Introduction to Reports and Visualization Types in Power BI
Page Settings
Getting started with color formatting and axis properties
Customize Visualization and X-axis and Y-axis properties
Filters in Power BI
Slicers in Power BI
Table and Matrix
Conditional Formatting on Visuals
Card and Multi-Row Card
Treemap
Combo Chart
Line chart, Area chart, and Stacked area chart
Gauge chart
KPI
Drill through
Map and Filled map
Pie chart and Doughnut charts
Ribbon charts
Waterfall Chart
Funnel chart
Import Data model to Power BI desktop
Phone layout
Bookmark
Chapter 7 : Power BI Publishing - Reports
Comparing Power BI Desktop and Power BI Service
Sign in to Power BI
Power BI Service walkthrough
Publishing a report from Power BI Desktop to Power BI Service
Create a Dashboard in Power BI Service
Power BI Service Workspace UI
Edit a Report in Power BI Service
Power BI Report - Reading View
Power BI Report - Usage Metrics
Analyze in Excel
Power BI Report - Quick Insights
Dashboard Walkthrough
Adding Tile in Dashboard
Q and A
Dataset Settings
Get More Visuals
Row-Level Security with Power BI