Check out the solution in the video Different Designs For Reporting Data. Remember that new development videos are posted on Mondays with other videos possibly being posted other days of the week. We look at four different designs for reporting dating in this video and where they may apply. Keep in mind that there are other derivatives of this, but these are the standard four that we'll see in many different situations even when they differ.
Some questions to think about:
- What reporting style would be best for people who need as many data points as possible?
- What reporting style would be best for people who need the latest information?
- What reporting style would be best for people who need deeper information after an initial look?
Check out the highest-rated Automating ETL course on Udemy, if you're interested in data.
My Automating ETL students will find this video helpful as a basis for some ideas for their reporting. As I mention, I did not put this video in the course so that I could save room for more meaningful videos. That being said to students, these should provide you with some ideas of useful video styles that you can use depending on the data.
YouTube | Automating ETL | T-SQL In 2 Hours | Consumer Guide To Digital Security