Introduction to Business Intelligence |.Microsoft Power BI |
𝗘𝗡𝗥𝗢𝗟𝗟 𝗡𝗢𝗪 FOR THIS COURSE ON UDEMY
https://www.udemy.com/course/power-bi...
This Microsoft Power BI course will help you to become a Power BI expert. It will enhance your skills by offering you comprehensive knowledge on Power BI, and the required hands-on experience for solving real-time industry-based Power BI projects.
As we progress through this course, you’ll learn to unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.
In this course, you will gain an understanding of the concept and working of Power BI Desktop and Power BI online services.
You will learn how to connect Power BI to different data sources.
You will be able to transform your data using Power Query and create data models.
You will 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 will be able to present your data in an efficient and interactive way.
And lastly, you will learn how to publish your reports and dashboards to the Power BI online service.
Course content
Section 1: Business Intelligence (BI) Concepts & introduction
1: Introduction to Business Intelligence
2: The relation between Business Intelligence and Data Warehouse
3: Power BI overview & Installation
4: Introduction Power BI desktop
Section 2: Connecting Power BI with Different Data sources
5: Connecting with Data
6: Connect to Excel in Power BI Desktop
7: Connect to CSV files in Power BI Desktop
8: Connect to SQL Server in Power BI Desktop
9: Connect to a Web page from Power BI Desktop
10: Enter data directly into Power BI Desktop
Section 3: Power Query for Data Transformation
11: Introduction to power query
12: Query Editor
13: Text Transformations
14: Number Column Calculations
15: Data Type
16: Date and Time Calculations
17: Append Queries_Merge Queries
18: Data source settings and Refresh settings
19: Data formatting
20: Hierarchy Creation in PowerBI
Section 4: Power BI Data Modeling – Relationship View & PowerPivot
21: Data Modeling Introduction
22: Primary key vs Foreign Key
23: Relationship build, Edit, Delete
24: Snowflake Scheme
25: Active vs In Active relationship
26: Relationship Primary key with multiple foreign keys from different data
Section 5: Data Analysis Expression (DAX)
27: Data Analysis Expression (DAX)
28: Creating Calculated Columns, Creating Measures
29: DAX Date and Time Functions
30: DAX Text Functions
31: DAX Logical Functions
32: Related Function
33: Implicit Vs Explicit Measures
34: Statistical Functions
35: DAX Filter Functions
36: DAX X-factor Functions
37: DAX Time Intelligence Functions
38: DAX Rank Functions
39: New Table and Quick Measure
Section 6: Reports & Visualization types in Power BI
40: Reports and Visualization types in Power BI
41: Page Settings
42: Getting started with color formatting and axis properties
43: Customize Visualization and X-axis and Y-axis properties
44: Filters in Power BI
45: Slicers in Power BI
46: Table and Matrix
47: Conditional formatting on visuals
48: Card and Multi-row card
49: Treemap
50: Combo Chart
51: Line chart, Area chart, and Stacked area chart
52: Gauge chart
53: KPI
54: Drill through
55: Map and Filled map
56: Pie chart and Doughnut charts
57: Ribbon charts
58: Waterfall Chart
59: Funnel chart
60: Import Data model to Power BI desktop
61: Phone layout
62: Bookmark
Section 7: PowerBi Publishing- Reports
63: Comparing Power BI Desktop and Power BI Service
64: Sign in to Power BI
65: Power BI Service walkthrough
66: Publishing a report from Power BI Desktop to Power BI Service
67: Create a Dashboard in Power BI Service
68: Power BI Service Workspace UI
69: Edit a Report in Power BI Service
70: Power BI Report - Reading View
71: Power BI Report - Usage Metrics
72: Analyze in Excel
73: Power BI Report - Quick insights
74: Dashboard walkthrough
75: Add Tile in Dashboard
76: Q and A
77: Dataset Settings
78: Get More Visuals
79: Row-level security with Power BI
Why Learn Power BI?
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.
Why should you take up this Power BI course?
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gart