Ottawa utilities cost with Power BI Desktop Application
Learn how to import and analyze data from various sources in Power BI, including Ottawa hydro and gas bills, cell phone payment history, and more. Discover how to create visualizations and graphs to display spending patterns and examine utility expenses from a homeowner’s perspective. This course covers topics such as data retrieval and transformation, data modeling and transformation using DAX, data visualization techniques, and publishing reports in Power BI Service. Perfect for beginner Power BI developers looking to enhance their skills and ace interviews. Get started today!
Import Ottawa hydro and gas bills into Power BIImport cell phone payment history from a folder into Power BIDisplay payment history in multiple chartsExamine spending on utilities in Ottawa from the perspective of a homeownerThe 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.Topics1. 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 queries3. 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 Objects4. 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 developerAce an interview
User Reviews
Be the first to review “Ottawa utilities cost with Power BI Desktop Application”
You must be logged in to post a review.
There are no reviews yet.