Problem Statement We have a table of consuer complaints data, and let’s find an insight from it. Which service(s) is receiving complaints the most? I am going to investigate on this, and make a plan to reduce those complaints.
Data sources Power Query View Since this is a flat table, will be separated into two tables.
Model View Visualizations Key takeaways Which communication tool is used for submitting complaints? - Over 60% of complaints are made via Internet.
Problem Statement I am a food delivery man. I have data of food delivery log to investigate which delivery area I should be in when to maximize my pay. When should I work harder in a day to get more tips? Let’s see how it goes through data wrangling with Power BI.
Data sources Table.Profile This is a flat table data. Let’s separate the table into fact and dimention tables to create a star-schema data model.
Have you had an opportunity that you needed to develope a report which would be consumed globally? If there is datetime data, you need to be cautious how you would show it in your report.
Will it be based upon UTC? Local time? I came up with an idea that it allows an end user to choose their own timezone so that datetime in a report would be converted by the user’s own choice.
A road bike race for only chromoly bikes in Japan. Hope it sounds interesting. Riding my road bike is one of my favorite hobby and I find myself enjoying it. I have two road bikes: Ridley carbon bike and Japan made chromoly road bike. I cannot deny myself with the good impression of riding a steel bike hence I still keep the bike to enjoy riding a bike with no pressure.
Since I have never attended the race, I decided to do some research so that I can win the race if possible or getting for better results.
Fuji Mt Hill Climb Race is one of the remarkable road bike races in Japan. It would be worth putting so much efforts to win the race. There is decant amount if road racers aiming for winning the race.
This report might help someone who try to define performance level of recent winners so that the can find figures they need to reach to win.
Data sources The race’s association provides lists of result in each race annually in PDF format.
It is a quite obvious Strava provides decent analysis tools for athletic performance in hand. This feature is only available in paid subscription though. It might be nice to have a flexible and easy to use platform for your analysis.
Strava provides the REST API to retrieve data from web with authentication.
I am going to show you how to get data from Strava directly.
Data sources Strava API is the main datasource.
