library(readr) df<-read.csv("mod4peerrev_data.csv") library(tidyverse) library(ggplot2) library(dplyr) library(ggeasy) library(patchwork) library(stringr)
summary(df$Price) summary(df$Quantity)
colSums(is.na(df))
library(ggplot2) ggplot(df, aes(x=Category))+ geom_bar()+ labs(title = 'Frequency Count by Category')
df1 <- df%>% dplyr::groupby(Category)%>% dplyr::mutate(Category = strto_title(Category))%>% tally()
ggplot(data = df1, aes(x = Category, y = n,fill = Category))+ geom_bar(stat = "identity") + labs(subtitle = "Order Category Made by Mark Recio")
ggplot(data = df1, aes(x= reorder(Category, -n), y = n, fill = n))+ geombar(stat = "identity") + geomtext(aes(label = n), size = 2, vjust = -0.3) + themeclassic() + theme(legend.position = "none") + labs(x = "Category", y = "Number of Category") + ggeasy::easyalltextcolor(color = "blue") + labs(subtitle = "Order Category Meaningful Way Made by Mark Recio")
library(ggplot2) ggplot(df, aes(x=Price)) + geomboxplot() + coordcartesian(ylim =c(-1,1.0))+ labs(title = 'Box Plot Price')
ggplot(df, aes(x=Price)) + geomhistogram(binwidth = .75) + coordcartesian(xlim = c(-50, 50), ylim = c(0, 10000))+ labs(title = 'Histogram of Price')
library(ggplot2) ggplot(df, aes(x=Quantity)) + geomboxplot() + coordcartesian(ylim =c(-1,1.0))+ labs(title = 'Box Plot Price')
ggplot(df, aes(x=Quantity)) + geomhistogram(binwidth = 1.0) + coordcartesian(xlim = c(0, 25), ylim = c(0, 3000))+ labs(title = 'Histogram of Quantity')
I find Alteryx to be a good tool to use for data analysis and visualization; however, I prefer to use Microsoft Power BI to be best source for me in my career. Microsoft Power BI allows me to easily to use DAX function for calculations, put into charts into visualization, and get the insights and summary information. Microsoft Power BI offers lots of features to make rich data visualization and dashboards. Microsoft Power BI is the tool for Business Analyst. Microsoft Power BI has the platforms supported for Windows, Mac, Android, and Chromebook, while Alteryx only supports Windows. Microsoft Power BI ranked as the #2 among all Business Intelligence Tools. Microsoft Power BI is much more affordable to use and worth the money than using Alteryx. Alteryx is the tool to use for fast reporting with no programming needed and less learning curve than