Learn SQL & Excel
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 10 Hours | 1.73 GB
Genre: eLearning | Language: English
Learn how easy it is to combine the two most popular business analytics tools in this comprehensive course.
There is simply no more valuable combination of data analysis tools than SQL & Excel.
Many business users can be intimidated by a database. This course will help you understand that in many ways, a database is like a supersized version of Excel. This means that you can bring invaluable insight to your team by delivering metrics that others can't, and that in turn leads to new job opportunities and increased job security.
I graduated from university with a degree in Finance. I got a job at a software company that made software to model oil and gas financial analysis. With no prior SQL background, I immediately discovered the value that a database could offer to business professionals. I instantly recognized that SQL & Excel made absolutely perfect sense together, and I also realized that I could deliver immediate, attention getting results.
I had the opportunity to work for a client managing $150 billion worth of oil & gas assets, and they were having trouble modelling the financials in just the way we wanted. We gathered a team, went around the accounting application, and crafted a new reporting solution in SQL & Excel. Because of the time and resource constraints, our acceptable margin of error on this project was $500 million dollars. Using a custom made SQL & Excel reporting solution, we delivered exact results accurate to the penny, not off by $500 million! I knew then that this combination of tools would be able to garner more attention than anything else I would ever work with.
Since then, I've gone on to become a professional software developer working exclusively with SQL databases. I built QuerySmith, the world's most popular SQL add-in for Excel. It's graphical, it's easy to use, it's the software used in the course and it's completely free.
I've delivered solutions to clients again and again that bridge the gap between the technical world of SQL and the business world of Excel. It's much easier than you think, and you can do it too.