Place holder for Lyric project
Computing the Minimum Number of Flight Segments
If we want to compute the minimum number of flight segments between a starting city and target city, we can construct an undirected graph. In the graph the nodes represent cities and the edges represent the flight segments. We can count the number of segments to determine the shortest distance.
The following can be applied to any situation in finding the shortest path. It is an implementation of the breadth first search algorithm.
See code below.
Modeling and Prediction for Movie Audience Ratings
One of the key issues facing film production companies is, will the production company make a profit from a movie. It is assumed that favorable audience reviews will in-turn lead to higher ticket sales or DVD sales, both items directly affect a movie’s profitability.
The analysis will look at what attributes lead to a higher average audience review score on the public website, Rotten Tomatoes
Spoiler Alert The analysis creates a model that is close, but isn’t 100% confident.
Blazin’ Burger Business Performance Metrics
Over the last year, the three New York locations of fast-food restaurant Blazin’ Burger have
produced mixed financial results.
Below is a presentation-ready dashboard that will show
- KPI’s that show performance data from each location
- External data from NYC board of health
Below are dashboards created using MicroStrategy.
Oracle PL/SQL Aggregation – Rank
One of the more interesting aggregation functions is RANK. After doing a standard SELECT and GROUP BY; you can then have SQL rank the results using an aggregated value from another column.
Let’s dive in and look at how RANK works and what can it do for us.
Limit Rows Returned
Previous to Oracle 12c limit the number of rows returned usually meant encapsulating the query as a subquery. It wasn’t particularly nice looking and was out of alignment with other relational database query languages.
MySQL uses the LIMIT operator and Microsoft T-SQL uses the TOP operator. In Oracle 12c, Oracle introduced the FETCH FIRST operator. Let’s see how it works.
Oracle PL/SQL Subtotal Operators
There are times when we need not just the total value for the column, but subtotal values depending on different column values. Oracle supports subtotal operators through the three key operators they are CUBE, ROLLUP, and GROUPING SETS. Below are examples of each one and how best to use them.
Aggregation in Oracle PL/SQL
Oracle 12 uses normal SQL statements when doing aggregation. The standard rules for aggregating in SQL apply. You need to group by all non aggregated columns and having clause will be evaluated after the group by operator.
Some examples of aggregation in Oracle PL/SQL are below.