Microsoft Power BI

1) Sales Insights Data Analysis - Power BI

In this report

• I created a Dynamic forecast for the next 1-year revenue & profit and
• Dynamic Top N customers contribution to revenue and profits
   the users easily know their Top N customers to make decisions and future plans. And Data source is from the Local Mysql Database.

2) Market Analysis Report for National Clothing Chain

Linear regression

Linear Regression method helps us to find whether the relationship among X variable(Independent) & Y variable(Dependent) is exists & level of effect. here

• Postive relationship (X increase leads to Y increase)
• Negative relationnship (X increase leads to Y decrease)

eg: customers income level vs purchases of products

• R = correlation Cofficient(ranges from -1 to 1),
• R^2 = Coefficient of Determination(ranges from 0 to 1)

3) Maveen Resturant

Here are the details

Country = Mexico Cities under Mexico(4) = Ciudad Victoria, Cuernavaca, Jiutepec, San Luis Potosi Total Consumers = 138 Total Restaurants = 130

1) What type of cuisine is preferred most by consumers? Top 5 Preferred cuisine by consumers

4) SQL Joins PowerBI

Explaining SQL JOINs with Power BI

` Power BI Dashboard - SQL JOINs`