blog | Ravi Chandu E
Data analysis for a restaurant menu - Upwork - Project
title: “Sales Analysis”
layout: post
—
AtliQ - Sales Insights Data Analysis - Power BI
Github Repo
Power BI - Dashboard
Market Analysis Report for National Clothing Chain
Udacity Project
Github Repo
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)
title: “Maven Restaurant”
layout: post
—
Maveen-resturant
Maven Restaurant Challenge(Maven Analytics)
Github Repo
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
SQL-Joins-PowerBI
Github Repo
Explaining SQL JOINs with Power BI
Github Repo
Calculate function (DAX)🦁
Calculate function is the most used function in dax
we can use it from basic calculation to advanced calculation
Calculate function Syntax
dax
CALCULATE(
Expression, [Filter1], [Filter2], ..
)
You’ll find this post in your _posts directory. Go ahead and edit it and re-build the site to see your changes. You can rebuild the site in many different ways, but the most common way is to run jekyll serve, which launches a web server and auto-regenerates your site when a file is updated.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Curabitur pretium tincidunt lacus. Nulla gravida orci a odio. Nullam varius, turpis et commodo pharetra, est eros bibendum elit, nec luctus magna felis sollicitudin mauris. Integer in mauris eu nibh euismod gravida. Duis ac tellus et risus vulputate vehicula. Donec lobortis risus a elit.
