Having shared the SQL technique and the script for generating data for Date Dimension for use in self-service BI and Analytics in my last blog post, here I share another technique for the same purpose but for those of you who are not familiar with SQL.
Here is the Excel Spreadsheet that lets you create Date Dimension data for two years from a given start date. All that you have to do is enter the desired start of the year in date format in cell B3. Rest is taken care that everything refreshes automatically.
Hit the like stars if you find it useful. Share the post further to spread the learning. Follow the analyst arsenal for effortless continued learning. Happy Learning..!!
Here I go posting a white paper on one of the classical and intellectually challenging problems that an analyst might come across. The paper is titled – “Understanding and Solving Relational Division problems in SQL – The Analyst way”.
Hope you enjoy reading this paper.
Please leave your comments and suggestions, if any, here.
Will be back with more stuff. Stay tuned to the blog. Until then, happy learning..!!
Hi.. Here I have composed a comprehensive listing of keyboard shortcuts for Microsoft Office Excel 2010 in downloadable PDF format.
Please do share the keyboard shortcuts if you know any that are missing in this list and help improve this listing.
Do share your comments or suggestions, if any..
Happy time until my next blog post.. 🙂