Sub-Total: $0.00
Scripting views for SQL databases
Tired of re-running queries and exporting CSVs? 🚀 In this Data Survival Skills session, Robin shows how to use SQL views to turn one-time queries into reusable datasets. With SQL Server Management Studio, she walks through saving a query as a view, using an example of tracking the most popular tour package. Once saved, views can connect directly to Excel or Power BI, refresh instantly, and be reused for reports like group size trends. Instead of repeating the same steps, views let you share, scale, and simplify reporting—saving time and keeping results consistent.
#SQL #SQLViews #DatabaseManagement #DataAutomation #PowerBI #Excel #DataAnalysis #BusinessIntelligence #Productivity
If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why to apply these tools. In this weekly series, instructor Robin Hunt explains a new skill, secret, tip, technique, best practice, or golden piece of advice in each installment. Robin covers topics that can help you do your job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making data sets and visualizing data.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.