Ottawa utilities cost with Power BI Desktop Application

Download your bills and visualize them with Power BI Desktop Application

What you'll learn
Import Ottawa hydro and gas bills into Power BI
Import cell phone payment history from a folder into Power BI
Display payment history in multiple charts
Examine spending on utilities in Ottawa from the perspective of a homeowner
Requirements
No programming experience needed
Description
The course is based on the hypothetical user case as "Import data from Reliance, HydroOttawa and FreedomMobile for 2021 and 2020. Build graphs to display spending".
Topics
1. Overview of Power BI products: Power BI Desktop, Power BI Service and Power BI Reporting Services.
2. Data Retrieval and Transformation
2.1 Introduction to Power BI Desktop interface. Explore Report, Data and Model Views.
2.3 Retrieving data for the use in Power BI reports. We will use data from Excel and CSV files. We will also connect to a folder to retrieve all files inside.
2.4 Data modelling and transformation using Data Analysis Expressions (DAX). We will create Measures to illustrate the use of DAX
2.5 Creating and editing relationships between objects. We will create Many-To-Many Relationship between different tables
2.6 Using Query Editor for data transformation
2.7 Creating custom columns for data customization
2.8 Appending and merging queries
3. Data Visualization. Creating graphs
3.1 Data sorting
3.2 Learning how to group data for the use in graphs.
3.3 Data formatting and data visualization.
3.4 Creating cards, clustered column charts and tables
3.5 Using filtering and slicing
3.6 Data merging and refreshing
3.7 Using images as backgrounds . Inserting Text Boxes. Inserting Shapes. Working with Static Objects
4. Power BI Service
4.1 Publishing reports to share them with your coworkers or clients.
4.2 Steps to get a Pro license.
Who this course is for
Beginner Power BI developer
Ace an interview
Homepage


Ottawa utilities cost with Power BI Desktop Application Fast Download
Ottawa utilities cost with Power BI Desktop Application Full Download