O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hands-On Data Visualization with Microsoft Power BI

Video Description

Analyze and visualize data with Power BI

About This Video

  • Use Power BI to gather data, create reports, and get in action within few minutes.
  • Bring the power of business intelligence to everyone including the non-tech users using Power BI as a tool.
  • Build a solid base with the recent updated features of Power BI to support efficient decision-making across any number of business sectors.

In Detail

Are you wasting time on compiling data from multiple sources instead of analyzing data? Are you relying on your Tech team to develop custom reports and dashboards? Power BI is a self-service business intelligence tool that reduces your dependency on the IT team to create reports and dashboards. Power BI is used to get insights from the data, saving your cost and time.

This course aims to equip you with BI tools to make better business decisions and create accurate reports and dashboards in just few minutes. This course is specifically designed to give you hands-on experience of Power BI with more of a focus on practical applications in business environments. You’ll walk through Power BI, end to end, starting from how to connect to and import your data, author reports using Power BI Desktop, and publish those reports to the Power BI service.

By taking this course, you’ll build a solid ground in business intelligence and will be able to create real-time reports and dashboards in minutes.

All the code and supporting files for this course are available on Github at https://github.com/PacktPublishing/Hands-on-Data-Visualization-with-Microsoft-Power-BI

Downloading the example code for this course: You can download the example code files for all Packt video courses you have purchased from your account at http://www.PacktPub.com. If you purchased this course elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

Table of Contents

  1. Chapter 1 : Getting Started with Power BI
    1. The Course Overview 00:02:10
    2. Basic Concepts of Business Intelligence 00:02:13
    3. Installing Power BI 00:02:06
    4. Connecting to Different Data Sources 00:01:50
  2. Chapter 2 : Data Transformation and Modeling
    1. Basic Data Transformations 00:04:28
    2. Splitting Columns and Changing Data Types 00:05:17
    3. Conditional Columns and Merge Queries 00:05:37
    4. Creating Calculated Columns 00:01:49
    5. Manage Your Data Relationships 00:03:09
  3. Chapter 3 : Power BI Desktop Visualizations
    1. Introducing Various Visuals 00:01:05
    2. Communicating with Charts – Part 1 00:10:34
    3. Communicating with Charts – Part 2 00:14:26
    4. R Language Plotting Basics 00:04:54
    5. R Visual Integration 00:02:12
    6. Page Layout and Formatting 00:01:47
  4. Chapter 4 : Power BI Service
    1. Introduction to Power BI Service 00:03:17
    2. Uploading Reports to Power BI Service and Quick Insights 00:04:16
    3. Natural Language Querying 00:02:32
    4. Alerts and Notifications in Power BI Service 00:04:17
    5. Personal Gateway 00:04:27
  5. Chapter 5 : Working with Excel in Power BI
    1. Using Excel Data in Power BI 00:01:59
    2. Connecting to Excel Workbook on OneDrive for Business 00:02:15
    3. Pinning Excel Tables or Visuals 00:02:59
  6. Chapter 6 : Publishing and Sharing
    1. Introduction to Content Pack, Security, and Groups 00:01:32
    2. Creating a Group 00:01:44
    3. Creating, Using, and Editing Content Pack 00:04:16
    4. Row-Level Security (RLS) 00:04:56
    5. Integrate and Share OneDrive for Business with Power BI 00:01:56
  7. Chapter 7 : Power BI Mobile
    1. Introduction to Power BI Mobile 00:03:12
    2. Mobile Dashboard Layout 00:01:21
    3. Sharing and Annotating in Power BI Mobile 00:01:48
    4. Using Custom Charts from Marketplace 00:02:54