hi😍,
MySelf Ravi Chandu

Skills: Microsoft Power BI, SQL, Microsoft Excel, Power Apps

• Upwork
• Linkedin
• Github
• badges

---

Projects

1) Data Analysis For A Restaurant Menu

2) 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.

3) 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)

4) 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

5) SQL Joins PowerBI

Explaining SQL JOINs with Power BI

` Power BI Dashboard - SQL JOINs`

6) Power App

Here is the simple Survey app – Collects the data from app and stores in Excel sheets.

We can easily record & update the data using Power Apps We don’t have to write the data which are collect from people and again update in excel sheet.