SQL Cheat sheet for The “AVERAGE” DB Guy Few years ago an article on CNBC defined data analysis “The Sexiest Job of the 21st Century”. I wouldn’t be so optimistic, but certainly it is becoming more and more demanded by the day. There is high demand for big data professionals, ETL specialists, data architects andRead More
Espacio RES (@espacio_RES) is organizing in Seville a 2 week Business Intelligence course with MicroStrategy and SQL Server. SELECT CONVERT(DATE,’20161114′,112) AS [Start Date], CONVERT(DATE,’20161127′,112) AS [End Date] The course is free for students and unemployed professionals. The classes will be held in English from Mon to Fri (9am – 2pm). I will be the main teacher,Read More
One of the things I like the most about Power BI is the ability to use custom visuals. I did not try building one myself and honestly I think it’s beyond my skills, yet there is a gallery with a growing number of pre-build viz that you can download and use. Go to https://app.powerbi.com/visuals?WT.mc_id=Blog_Visuals andRead More
Doing a very simple math: assuming a 30 days month, at 100DWU we will receive a $504 (USD) bill for computing + $62.5 (USD) for 1TB of data, a total $566.5* for a fully functioning SQL Data Warehouse. On the other end of the spectrum, 2000DWU for 1 month would be $10,080(USD)*.
The Lahman database is one of the most (if not the most) complete free sports dataset