Business Intelligence with Microsoft Power BI - with Material

Business Intelligence with Microsoft Power BI - with Material

by Pavan Lalwani
Released February 2021
Publisher(s): Packt Publishing
ISBN: 9781801078580

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Whether you want to prepare your data for visualization or create eye-catching reports and dashboards from datasets, Power BI is the answer. This course will teach you the necessary Power BI tools, and you will gain the skills and confidence to use them effectively in the real world.

The course starts by introducing you to Power BI and takes you through the setup process of Power BI on your machines. Next, you will learn how to create charts, maps, tables, and matrix in Power BI. Moving along, you will learn to use cards, filters, slicers, and advanced charts. Next, you will learn to insert objects, such as images, texts, and shapes, in Power BI and discover what are bookmarks and actions. As you advanced, you will learn to create, publish, and export reports using the Power BI service and become familiar with the text, date, and number functions. Finally, you will learn how to append data, understand merge queries, and go through additional important topics of Power BI, such as group, transpose, and unpivot.

By the end of this course, you will have the Power BI skills needed for turning huge chunks of boring datasets into impressive reports and dashboards.

What You Will Learn

  • Use Power Query to clean data
  • Create maps of different countries and regions in Power BI
  • Discover how to work with advanced cards and slicers
  • Append data from various sources in Power BI
  • Use Power View to visualize data
  • Design impressive reports and dashboards

Audience

Whether you are new to Power BI or an experienced data analyst, who is looking to learn Power BI to present the data in the form of stunning reports and dashboards, this course is for you. A basic understanding of Microsoft Excel will be beneficial but is not mandatory.

About The Author

Pavan Lalwani: Pavan Lalwani is a highly skilled and self-motivated trainer who has expertise in various business intelligence tools, such as Power BI, Tableau, and Microsoft Excel. He has 10 years of experience in training individuals in different industry sectors, such as banking, finance, healthcare, IT, automobile, manufacturing, and pharmaceutical. His major clients include Mercedes-Benz, Loreal, IBM, L&T, Wipro, Bajaj Finance, ITC, DHL, Deutsche Bank, Yes Bank, Mahindra, Morgan Stanley, and Deloitte, among others that are spread across the globe.

He believes in providing end-to-end solutions through his training videos and is himself responsible for designing the course content, quizzes, online training, clarifying doubts, and any additional help required.

Table of contents

  1. Chapter 1 : Introduction to Power BI
    1. Introduction
    2. Downloading, Installing, and Activating the New Features in Power BI
  2. Chapter 2 : Basic Charts in Power BI
    1. Section Overview
    2. Creating a Column Chart in Power BI
    3. Creating a Stacked Column Chart in Power BI
    4. Creating a Pie Chart in Power BI
    5. Creating a Donut Chart in Power BI
    6. Creating a Funnel Chart in Power BI
    7. Creating a Ribbon Chart in Power BI
    8. Include and Exclude in Power BI
    9. Exporting Data from Visuals
  3. Chapter 3 : Maps in Power BI
    1. Basic Maps in Power BI
    2. Creating a Filled Map
    3. Creating a Map with a Pie Chart
    4. Formatting a Map
    5. Changing the Background in a Map
    6. Creating the Map of India in Power BI
    7. Creating the Map of Australia in Power BI
  4. Chapter 4 : Tables and Matrix in Power BI
    1. Creating a Table
    2. Formatting a Table
    3. Conditional Formatting in a Table
    4. Aggregation in a Table
    5. Matrix
    6. Conditional Formatting in a Matrix
    7. Hierarchies in a Matrix
    8. Sub-Total and Total in a Matrix
    9. Formatting Numbers in a Table
  5. Chapter 5 : Other Charts in Power BI
    1. Section Introduction
    2. Line Chart in Power BI
    3. Drill Down Line Chart in Power BI
    4. Area Chart in Power BI
    5. Line Chart versus Column Chart in Power BI
    6. Scatter Plot in Power BI
    7. Waterfall Chart in Power BI
    8. TreeMap in Power BI
    9. Gauge Chart in Power BI
  6. Chapter 6 : Cards and Filters in Power BI
    1. Introduction
    2. Number Card in Power BI
    3. Text Card in Power BI
    4. Formatting a Text Card in Power BI
    5. Date Card
    6. Date Card (Relative Filtering)
    7. Multi-row Card
    8. Applying Filters on Visuals
    9. Applying Filters on a Page
    10. Using Filters on All Pages
    11. Drillthrough in Power BI
  7. Chapter 7 : Slicers in Power BI
    1. Slicers in Power BI
    2. Text Slicers in Power BI
    3. Formatting a Text Slicer
    4. Date Slicers in Power BI
    5. Formatting a Date Slicer
    6. Number Slicers in Power BI
  8. Chapter 8 : Advanced Charts in Power BI
    1. Advanced Charts in Power BI
    2. Creating an Animated Bar Chart Race
    3. Drill Down Donut Chart
    4. Drill Down Column Chart
    5. Creating a Word Cloud in Power BI
    6. Creating a Sankey Chart in Power BI
    7. Creating an Infographic in Power BI
    8. Creating a Play Axis in Power BI
    9. Creating a Scroller in Power BI
    10. Creating a Sunburst Chart in Power BI
    11. Creating a Histogram in Power BI
  9. Chapter 9 : Power BI Objects, Bookmarks, and Actions
    1. Inserting Images in Power BI
    2. Inserting Text in Power BI
    3. Inserting Shapes in Power BI
    4. Inserting Buttons in Power BI
    5. Inserting a Web Uniform Resource Locator (URL) in Power BI
    6. Inserting a Page Navigation Option in Power BI
    7. Inserting a Bookmark Option in Power BI
    8. Drillthrough Action in Power BI
  10. Chapter 10 : Power BI Services
    1. Creating a Report in Power BI
    2. Creating an Account in the Power BI Service
    3. Publishing a Report to the Power BI Service
    4. Exporting a Report to PPT, PDF, and PBIX
    5. Commenting, Sharing, and Subscribing to Power BI Reports
    6. Creating a Dashboard in the Power BI Service
    7. Problems in the BI Dashboard and their Solution
    8. Automatically Refreshing Reports in the Power BI Service
  11. Chapter 11 : Text Functions in Power Query
    1. Text Functions in Power Query
    2. Merging Columns in Power Query
    3. Split and Trim Functions
    4. Upper Case, Lower Case and Proper Case
    5. Adding Prefixes and Suffixes
    6. Left, Right, and Mid Functions in Power Query
    7. Extracting Text with Delimiters
  12. Chapter 12 : Date Functions
    1. Date Functions
    2. Year, Quarter, and Day Functions
    3. Difference between Dates
    4. Month and Day Name
    5. Finding Day and Week of the Week/Month/Year
    6. Extracting the Date and Time
    7. Calculating Age
    8. Day of Year, Quarter, or Month
  13. Chapter 13 : Number Functions in Power Query
    1. Number Functions
    2. Basic Number Functions
    3. Percentage, Percent of, and Modulo Functions
    4. Rounding Off Functions
    5. IsEven and IsOdd Functions
  14. Chapter 14 : Appending Data in Power BI
    1. Appending Data
    2. Appending Multiple Comma Separated Values (CSV) Files in a Folder
    3. Appending Multiple Excel Sheets and Tables
    4. Appending Excel Sheets or Tables with Different Columns
    5. Appending Multiple Files from a Folder
    6. Appending Different Data Sources
  15. Chapter 15 : Introduction to Merge Queries
    1. Merge Queries
    2. Merging Sheets or Tables
    3. Merging Data from Multiple Excel Files
    4. Merging Data from Different Data Sources
    5. Merging Data Having Multiple Criteria
  16. Chapter 16 : Introduction to Conditional Column and Column from Examples
    1. Section Introduction
    2. Column from Examples - Splitting Text
    3. Column from Examples - Merging Columns
    4. Column from Examples - Date
    5. Column from Examples - Alphanumeric
    6. Conditional Column - One Column
    7. Conditional Column- Two Columns
    8. Conditional Column- Comparing Two Columns
    9. Conditional Column - On Dates
  17. Chapter 17 : Important Topics in Power BI
    1. Section Introduction
    2. Working with the Fill up and Fill Down Options
    3. Grouping in Power BI
    4. How to Transpose?
    5. How to Unpivot?
    6. What are Data Types?
    7. Replacing Errors and Values
    8. Keeping and Removing Rows
    9. Adding, Removing, and Going to Specific Columns
  18. Chapter 18 : M Language
    1. M Language
    2. Introduction to M Language
    3. ISINDATE Function in M Language
    4. Adding and Subtracting Dates Using M Functions
    5. Basic Date M Functions
    6. Basic Text M Functions
    7. Writing a Simple M Code
    8. Tricks to Get Help on More than 900 M Functions

Product information

  • Title: Business Intelligence with Microsoft Power BI - with Material
  • Author(s): Pavan Lalwani
  • Release date: February 2021
  • Publisher(s): Packt Publishing
  • ISBN: 9781801078580