Power BI Tutorial (Offline)

About Power BI Tutorial (Offline)

Note: - this is not a Microsoft Corporation application. This is just a Power BI Tutorial.

Application content :

Power – Introduction & Setup
• What is Business Intelligence
• What is Power BI and Why Power BI in Data Analysis
• Power BI Components
• Practical Applications
• Downloading Power BI & Adjusting Settings
• Types of Data Connectors in Power BI Desktop
• Differences Between Microsoft Power BI and SSRS
• Power BI Free vs Power BI Pro vs Power BI Premium

Power BI – Query Editor
• Edit PowerBI App
• Query Editor in Power BI for Data Transformation
• Working with Numbers in Power BI
• Working with Date & Time Tools
• Creating a Rolling Calendar in Power BI
• Conditional Columns in Power BI
• Grouping & Aggregating Records
• Merge and Append Queries in Power BI
• Manage data source settings and permissions
• Data refresh in Power BI
• Power BI Data Types
• Explain Power BI Hierarchy, and How to Use it
• Power BI – Excel Integration

Power BI DashBoard and Power BI Visualisation
• Power BI – Dashboard
• Power BI – Dashboard Actions
• Adding Objects to the Power BI Report Canvas and Exploring the “Report” View
• Creating Table Relationships & Data Models in Power BI
• Inserting Basic Charts & Visuals in Power BI
• Conditional Formatting
• How to add Reports to Dashboards
• Power BI Report Formatting Options
• Power BI Report Filtering Options
• Exploring Data with Matrix Visuals
• Filtering with Date Slicers
• Adding Trend Lines & Forecasts
• Editing Power BI Report Interactions
• Adding Drillthrough Filters
• Inserting Text Cards
• How to Format a Card?
• Format Multi-Row Card
• Visualizing Geospatial Data with Maps
• How to Format Map
• Visualizing Data with Treemaps
• Format Tree Map
• Managing & Viewing Roles in Power BI Desktop
• Creating a Simple Table
• Power BI – Format Table Chart
• Create a Stacked Column Chart
• Power BI – Format Stacked Column Chart
• Create a 100% Stacked Column Chart
• Format 100% Stacked Bar Chart
• Create a Stacked Bar Chart
• Power BI – Format Stacked Bar Chart
• How to Create a Stacked Area Chart
• Power BI – Format Area Chart
• Create a Radial Gauge Chart
• Create Key Performance Indicators (KPIs) Chart
• Power BI – Format KPIs Chart
• Format Clustered Bar Chart
• Power BI – Format Clustered Bar Chart
• How to Create a Waterfall Chart?
• Format Waterfall Chart
• Create a Filled Map
• Format Filled Map
• Create a Scatter Chart.
• Format Scatter Chart
• Showing Trends with Line Charts
• Power BI – Format Line Chart
• How to Create a Shape Map?
• Format Donut Chart
• Format Pie Chart
• Format Ribbon Chart
• Create an R Script Visual
• Line and Stacked Column chart
• Format Line and Clustered Column Chart

DAX Introduction
• Data Analysis Expressions (DAX)
• Intro to DAX Calculated Columns
• Creating measures using DAX
• Adding Columns & DAX Measures in Power BI Desktop
• Filter Context in Power BI
• Common DAX Function Categories
• Basic Date & Time Functions
• DAX Window Function
• Conditional & Logical Functions
• DAX Information Functions
• DAX Text Functions
• Index function in Power BI
• DAX Trigonometric Functions
• DAX COUPDAY Financial Function
• DAX Depreciation Functions
• Power BI – Distinct() function
• Basic Math in Power BI
• Power BI – DAX Trigonometric Functions
• COUNT Functions
• Power BI – DAX Date Functions
• DAX Aggregate Functions in Power BI
• Power BI – DAX TEXT Functions
• Power BI – DAX Depreciation Functions
• Power BI- DAX Bitwise Functions
Creating Table Relationships & Data Models in Power BI
• What is a “Data Model”?
• Principles of Database Normalization
• Understanding Data Tables vs. Lookup Tables
• Understanding Table Relationships vs. Merged Tables
• Creating Table Relationships in Power BI Desktop
• Managing & Editing Table Relationships | Power BI
• Managing Active vs. Inactive Relationships | Power BI
• Connecting Multiple Data Tables in Power BI
• Understanding Filters in Power BI
• Hiding tables, columns, and fields from Power Pivot

and more