• Post category:StudyBullet-7
  • Reading time:7 mins read


Gain Real World Power BI Skills from various projects

What you will learn

Perform Power BI Data Analytic Skills

Analyse data

Clean and transform data

Build and publish Reports

Sales and Product Analysis – Project

Product by Country Sales Data Analysis – Project

Movie Rental Sales Analysis – Project

Retirement Analysis – Project

Transforming less structured data & Analyse Data – Project

Description

Microsoft Power BI is a suite of business intelligence (BI), reporting, and data visualization products and services for individuals and teams. Power BI stands out with streamlined publication and distribution capabilities, as well as integration with other Microsoft products and services.

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website.” The solution comprises several products and services, and value and versatility comes from leveraging the individual elements, and taking advantage of how they work together.

Data has become a ubiquitous part of business today, making it essential for businesses to understand how to gain value from the wealth of raw data available to them. The right information must be gleaned from the data and presented clearly for making well-informed business decisions. Because of this, business intelligence (BI) systems have gained tremendous traction that can assist an organization in discovering useful information, suggesting conclusions, and supporting decision-making. BI is a system that analyses data, provides actionable information, and helps users to take informed business decisions. As a proven technology leader, Microsoft has propelled itself to the forefront with the introduction of its powerful analytics tool, Power BI.


Get Instant Notification of New Courses on our Telegram channel.


Microsoft’s Power BI toolkit transforms your data into meaningful information, making it one of the most popular business intelligence tools in the world. The increasing popularity of Power BI has led to an increased demand for Power BI professionals and business analysts.

In this course we will work on the various  projects below to build useful Power BI Analytic Skills :

  • Sales and Product Analysis
  • Product by Country Sales Data Analysis
  • Movie  Rental Sales Analysis
  • Retirement Analysis
  • Transforming less structured data & Analyse Data
English
language

Content

Microsoft Power BI and Microsoft 365 Setup

Introduction
What is Power BI
What is Power BI Desktop
Install Power BI Desktop
Explore Power BI Desktop
What is Microsoft 365
Install Microsoft 365
Explore Microsoft 365

Project 1 : Sales and Product Analysis

The task
The Data Source
Connect to data source
Clean & Transform Data
DAX & Measures
Join tables using DAX Expressions
Enabling Map Visuals
Building your Report
Format your report
Publish Report To Power BI Service

Project 2: Country Sales Data Analysis

The task
What is Microsoft SQL Server
Download Microsoft SQL Server
Install Microsoft SQL Server
Install SQL Server Management Studio – SSMS
Connect SSMS to SQL Server
Install sample database
Perform Country Sales Analysis with Power BI and SQL Server

Project 3: Movie Sales Analysis

The task
What is PostgreSQL
Install PostgreSQL
Connect to PostgreSQL Database
Install Sample Database
Connect Power BI to PostgreSQL Database
Perform Movie Sales Analysis with Power BI

Project 4 : Retirement Analysis

The Task
Please Read
Connecting to data web data source
Clean and transform data : Part 1
Clean and transform data : Part 2
Combine data sources
Creating analysis report: Part 1
Creating analysis report: Part 2
Publish report

Project : Transforming less structured data & Analyse Data

The Task
The data source
Transform less structured data