The video explains how to design a break-even decision model in Microsoft Excel to determine whether it is more cost-effective to manufacture a product or outsource it. The model is created by comparing the total costs associated with both manufacturing and outsourcing the product. The model takes into account the number of units, fixed costs,…
In this video, the presenter is discussing how to predict sales or demand through linear and non-linear prediction models based on the demand curve. The demand curve is a graphical representation of the relationship between the price of a good or service and the quantity of it that consumers are willing and able to purchase….
The video explains how to perform market basket analysis in Power BI, using sales data of over half a million items. Market basket analysis is a data mining technique used by retailers to understand customer purchasing patterns and increase sales. The process starts by importing the data into Power BI, and creating a duplicate of…
In this video, the steps to create a bell curve using Microsoft Excel are demonstrated. A column named “Data” is created. 500 random values are generated between 100 and 200 using the “RANDBETWEEN” formula and entered into the “Data” column. The mean and standard deviation of these 500 values are calculated using the “AVERAGE” and…
This video demonstrates how to create a Power BI dimensional report from a star schema database created in Microsoft Access. A star schema is a type of relational database schema that consists of a central fact table surrounded by dimension tables, linked to the central fact table by ID’s. In the video, the sales query…
This video demonstrates how to use Looker Studio to analyze the performance of a sales team. It starts by connecting a Google Sheet as a source data for the Looker Studio dashboard. Then, the presenter creates a blank report and inserts a title, a date control, scorecards, a combo chart, a column chart, and pie…
This video tutorial is about creating a pie chart using the R programming language. R is a free software environment for statistical computing and graphics and is widely used for data analysis, visualization, statistical modeling, and reporting. To create the pie chart, the tutorial starts by defining four variables: “sales”, “col”, “names”, and “labels”. The…
Conditional formatting in Microsoft Excel is a useful tool for highlighting and visualizing data based on specified conditions. There are several predefined rules, such as “Greater Than”, “Less Than”, “Between”, “Equal To”, “Text That Contains”, “A Date Occurring”, “Duplicate Values”, “Top 10 Items”, “Bottom 10 Items”, “Above Average”, “Below Average”, “Data Bars”, “Color Scales”, and…
This video is about analyzing human resource data using Microsoft Power BI. It covers how to import data from a Google spreadsheet, perform data modeling and cleaning, and create various visualizations such as slicers, gauge charts, map charts, bar charts, pie charts, and stacked bar charts. These visualizations help in analyzing employee data such as…
The video explains how to calculate basic statistics in Python. It covers the steps involved in importing libraries for statistical calculations, generating a list of random numbers, plotting the data on charts, calculating mean, median, mode, standard deviation, variance, covariance, correlation and linear regression. The results are displayed on the console window and bar chart….