Master in Microsoft Power BI Desktop and Service

Video description

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

  • Create, share, collaborate, and benefit from business information with purpose-built dashboards
  • Create compelling reports and visualizations, derive real-time insights, and deploy it on demand
  • Form relationships in your data model and learn data visualization best practices

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.

Publisher resources

Download Example Code

Table of contents

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

Product information

  • Title: Master in Microsoft Power BI Desktop and Service
  • Author(s): Learnsector LLP, Navya Kannan
  • Release date: May 2021
  • Publisher(s): Packt Publishing
  • ISBN: 9781801819961