HOME

Customer Service Analysis

Power Bi rapport showing a customer analysis. The report has 5 different view/pages:

  • Start
  • CEO-Business Analysis-I
  • CEO-Business Analysis-II
  • Operation Manager-I
  • Operation Manager-II

Measurers

You have to create some Measurers to use in the report.

Data

Financial Performance Analysis

Financial performance analysis is a normal task for Power BI.

Refer to the multi-company financial dataset available on Kaggle - Link

You can leverage Power BI data visualization in this project for three different cases:

  • For the summary/overview page, you can use Funnel Charts, Combo Charts (Column Charts, Line Charts, Waterfall Charts)
  • For the income statement page, you can use Cards, Funnel Charts, and Combo Charts (Line Charts and Column Charts)
  • For the balance sheet page, you can use Cards and Tables.

Product Sales Data Analysis

Businesses must keep detailed records of their sales for a variety of reasons. However, if there is too much data, it often becomes difficult to keep track of everything.

Analyzing sales data allows companies to keep track of their sales and answer all critical questions regarding their performance.

This sales data analysis project entails analyzing a company’s sales data and indicating profit by product, sales, and other significant factors that might influence the company’s performance.

You can use Microsoft’s sample dataset. The data set must be connected to Power BI Desktop to remove irrelevant data before visualizing and exporting the filtered data as dashboards.

The dashboard could leverage Power BI visualization types such as Pie Charts, Bar Charts, Doughnut Charts, Funnel Charts, etc.

Marketing Campaign Insights Analysis

Use the Marketing Analytics dataset available on Kaggle to showcase the efficacy of various marketing campaigns and the performance of product groups and platforms using any marketing analytics dataset.

For the data visualization dashboard, you can explore many of the Power BI visualization types, such as Bar Charts for category-wise expenditures, Column Charts for campaign success rate, Smart Narratives for displaying the key highlights of the campaign, Bubble Charts for customer-wise spending, Cards for showing individual data insights, etc.

Airport Authority Data Analysis

The Airport Authority Data Analysis project aims to provide a clear picture of all the significant airport data. The total number of flights (incoming and departing flights), the total number of flight delays (arrivals and departures), ground processing time, and the passenger feedback section can all be included in the summary page of this project’s dashboard.

In case of flight changes, emergencies, or delays, this analysis could assist airport management authorities in making timely data-driven choices.

Use the Airline delays and cancellation dataset available on Kaggle.

The dataset includes multi-year airline data from 2009 to 2018 to provide more time-series insights.

For flight analysis, you can use Power BI visualization options like Cards, Bar Charts, Flow Maps, TreeMaps, and Tornado Charts. For passenger feedback, you might prefer to use Bar Charts, Column Charts, or Cards.

Global Energy Trade Analysis

For this project, use the International Energy Statistics dataset from Kaggle. It addresses several topics, such as the expansion of wind energy, energy consumption as a different basis for comparing national economies, etc.

The resulting dashboard could display total energy statistics on production, exchange, and usage of primary and secondary energy, conventional and non-conventional energy sources, and new and renewable energy sources.

For the dashboard, you can use Power BI visualization types such as Bar Charts, Flow Maps, Cards for the overview page, Ribbon Charts, Treemaps, Bar Charts for the energy production and exchange pages, etc.

Northwind

Use the Excel file northwind.xlsx and create a Power BI rapport basede on the 7 tables. Check that the different relations are created.

Calculated Columns

order_details

In the order_details table you have to create a Total column.

order

In the order table you have to create tre columns, all basede on the OrderDate column.

  • Year
  • Month as text
  • Weekday as text

Dax

Create theis DAX calculated fields:

  • Total sales basede on the order_details table

AdventureWorks Database

The Adventure Works company represents a bicycle manufacturer that sells bicycles and accessories to global markets.

Use the AdventureWorks data available on GitHub for analysis & visualization.

Use Power BI for the visualization part, use MS Excel and Power BI’s query editor for analysis.

Only Sales

The model has seven tables:

|Table|Description| |—–|——-| |Customer|Describes customers and their geographic location. Customers purchase products online (Internet sales).| |Date|There are three relationships between the Date and Sales tables, for order date, ship date, and due date. The order date relationship is active. The company’s reports sales using a fiscal year that commences on July 1 of each year. The table is marked as a date table using the Date column.| |Product|Stores finished products only.| |Reseller|Describes resellers and their geographic location. Reseller on sell products to their customers.| |Sales|Stores rows at sales order line grain. All financial values are in US dollars (USD). The earliest order date is July 1, 2017, and the latest order date is June 15, 2020.| |Sales Order|Describes sales order and order line numbers, and also the sales channel, which is either Reseller or Internet. This table has a one-to-one relationship with the Sales table.| |Sales Territory|Sales territories are organized into groups (North America, Europe, and Pacific), countries, and regions. Only the United States sells products at the region level.|