Introduction to Power BI FREE CHAPTER

• Introduction
• Downloading, Installing, and Activating the New Features in Power BI

Basic Charts in Power BI

• Section Overview
• Creating a Column Chart in Power BI
• Creating a Stacked Column Chart in Power BI
• Creating a Pie Chart in Power BI
• Creating a Donut Chart in Power BI
• Creating a Funnel Chart in Power BI
• Creating a Ribbon Chart in Power BI
• Include and Exclude in Power BI
• Exporting Data from Visuals

Maps in Power BI

• Basic Maps in Power BI
• Creating a Filled Map
• Creating a Map with a Pie Chart
• Formatting a Map
• Changing the Background in a Map
• Creating the Map of India in Power BI
• Creating the Map of Australia in Power BI

Tables and Matrix in Power BI

• Creating a Table
• Formatting a Table
• Conditional Formatting in a Table
• Aggregation in a Table
• Matrix
• Conditional Formatting in a Matrix
• Hierarchies in a Matrix
• Sub-Total and Total in a Matrix
• Formatting Numbers in a Table

Other Charts in Power BI

• Section Introduction
• Line Chart in Power BI
• Drill Down Line Chart in Power BI
• Area Chart in Power BI
• Line Chart versus Column Chart in Power BI
• Scatter Plot in Power BI
• Waterfall Chart in Power BI
• TreeMap in Power BI
• Gauge Chart in Power BI

Cards and Filters in Power BI

• Introduction
• Number Card in Power BI
• Text Card in Power BI
• Formatting a Text Card in Power BI
• Date Card
• Date Card (Relative Filtering)
• Multi-row Card
• Applying Filters on Visuals
• Applying Filters on a Page
• Using Filters on All Pages
• Drillthrough in Power BI

Slicers in Power BI

• Slicers in Power BI
• Text Slicers in Power BI
• Formatting a Text Slicer
• Date Slicers in Power BI
• Formatting a Date Slicer
• Number Slicers in Power BI

Advanced Charts in Power BI

• Advanced Charts in Power BI
• Creating an Animated Bar Chart Race
• Drill Down Donut Chart
• Drill Down Column Chart
• Creating a Word Cloud in Power BI
• Creating a Sankey Chart in Power BI
• Creating an Infographic in Power BI
• Creating a Play Axis in Power BI
• Creating a Scroller in Power BI
• Creating a Sunburst Chart in Power BI
• Creating a Histogram in Power BI

Power BI Objects, Bookmarks, and Actions

• Inserting Images in Power BI
• Inserting Text in Power BI
• Inserting Shapes in Power BI
• Inserting Buttons in Power BI
• Inserting a Web Uniform Resource Locator (URL) in Power BI
• Inserting a Page Navigation Option in Power BI
• Inserting a Bookmark Option in Power BI
• Drillthrough Action in Power BI

Power BI Services

• Creating a Report in Power BI
• Creating an Account in the Power BI Service
• Publishing a Report to the Power BI Service
• Exporting a Report to PPT, PDF, and PBIX
• Commenting, Sharing, and Subscribing to Power BI Reports
• Creating a Dashboard in the Power BI Service
• Problems in the BI Dashboard and their Solution
• Automatically Refreshing Reports in the Power BI Service

Text Functions in Power Query

• Text Functions in Power Query
• Merging Columns in Power Query
• Split and Trim Functions
• Upper Case, Lower Case and Proper Case
• Adding Prefixes and Suffixes
• Left, Right, and Mid Functions in Power Query
• Extracting Text with Delimiters

Date Functions

• Date Functions
• Year, Quarter, and Day Functions
• Difference between Dates
• Month and Day Name
• Finding Day and Week of the Week/Month/Year
• Extracting the Date and Time
• Calculating Age
• Day of Year, Quarter, or Month

Number Functions in Power Query

• Number Functions
• Basic Number Functions
• Percentage, Percent of, and Modulo Functions
• Rounding Off Functions
• IsEven and IsOdd Functions

Appending Data in Power BI

• Appending Data
• Appending Multiple Comma Separated Values (CSV) Files in a Folder
• Appending Multiple Excel Sheets and Tables
• Appending Excel Sheets or Tables with Different Columns
• Appending Multiple Files from a Folder
• Appending Different Data Sources

Introduction to Merge Queries

• Merge Queries
• Merging Sheets or Tables
• Merging Data from Multiple Excel Files
• Merging Data from Different Data Sources
• Merging Data Having Multiple Criteria

Introduction to Conditional Column and Column from Examples

• Section Introduction
• Column from Examples - Splitting Text
• Column from Examples - Merging Columns
• Column from Examples - Date
• Column from Examples - Alphanumeric
• Conditional Column - One Column
• Conditional Column- Two Columns
• Conditional Column- Comparing Two Columns
• Conditional Column - On Dates

Important Topics in Power BI

• Section Introduction
• Working with the Fill up and Fill Down Options
• Grouping in Power BI
• How to Transpose?
• How to Unpivot?
• What are Data Types?
• Replacing Errors and Values
• Keeping and Removing Rows
• Adding, Removing, and Going to Specific Columns

M Language

• M Language
• Introduction to M Language
• ISINDATE Function in M Language
• Adding and Subtracting Dates Using M Functions
• Basic Date M Functions
• Basic Text M Functions
• Writing a Simple M Code
• Tricks to Get Help on More than 900 M Functions