Tag: microsoft office

Data Visualization in Microsoft Power BI

Ben Richardson Leave a comment

Contents

  1. Introduction.
  2. How to create a table.
  3. How to create a Power BI pie chart.
  4. Creating a line chart in Power BI.
  5. Report creation.
  6. Conclusion.

Introduction

The final article will take us through Power BI Visualizations and how to create them using the data sets created previously in these series. The walkthrough will cover 3 basic Visualizations: Table, Pie Chart, and Line Chart. These will then combine to create a basic report/dashboard within Power BI.

Read More

Loading and Managing Data within Microsoft Power BI

Ben Richardson Leave a comment

Contents:

  1. Introduction
  2. Importing data from Excel, SQL Server, and the Web.
    1. Importing data from Excel into Power BI.
    2. Importing websites into Power BI.
    3. Importing data from SQL Server Database into Power BI.
  3. Data Manipulation Basics in Power BI.
    1. Group By option.
    2. Splitting columns.
    3. Duplicating columns.
    4. Combining columns.
  4. Managing relationships within Power BI.
    1. Merging/Joining datasets.
    2. Model views/Relationship link.
    3. Hierarchies.
  5. Conclusions.

Introduction

This article will cover off importing data, manipulating data, and finally managing relationships within Power BI. Again, like the previous article, this one will focus on the basic principles of using Power BI, as opposed to an in-depth walkthrough.

Read More