# Foundatum > Strong Foundations for Resilient Data ## Posts - [Analytic Data Engineering Part 2 - Creating Data to Analyze](https://foundatum.ca/2024/06/12/analytic-data-engineering-part-2-creating-data-to-analyze/): In the last part of this series, we set up the Wide World Importers database and created about a year’s worth of data. This is great to do some initial research, however it doesn’t simulate a real-world scenario. We need to have a situation where the underlying data is changing, ideally in a fashion that makes it appear like decisions are being made based on the data. The good news is that there is a stored procedure already written that creates this data. It’s what was used to create the first year’s worth. I have included a procedure that finds… - [Analytical Data Engineering: Part 1 - Provisioning the Database Source](https://foundatum.ca/2024/06/05/analytical-data-engineering-part-1-provisioning-the-database-source/): There are a couple things we’re going to need to provision before we can properly learn data engineering for analytics. I this post, we’re going to: Install Some Software If you already have Visual Studio with the “Data storage and processing” option selected and Azure Data Studio, then you can skip to the next section. Go download the Visual Studio Installer and install, making sure that you have checked off the appropriate options: Next, go Download and install Azure Data Studio. There are very few options, so you should be able to figure this out on your own. We’ll need… - [How to Set Up Data Engineering in an Enterprise Setting: A Comprehensive Guide](https://foundatum.ca/2024/05/31/how-to-set-up-data-engineering-in-an-enterprise-setting-a-comprehensive-guide/): Intro Over the past 7-8 years, I have worked with many students that have recently graduated. They come out with tons of skills and are almost ready for the business world. Most start their careers doing some basic report building. Then, they gradually work their way into other parts of the data and analytics space. That is the exact same journey that I took more than 10 years ago, albeit on more primitive technology. The challenge that I see is that people don’t have any experience with dynamic data. Data changes every time you look at it. This is the… - [Practical Advice for Building a Real-Time Analytics Business Case](https://foundatum.ca/2022/12/01/real-time-building-business-case/): Practical Advice for Building a Real-Time Analytics Business Case ## Pages - [Cookie Policy (CA)](https://foundatum.ca/cookie-policy-ca-2/): This page was last changed on 2024-02-29, last checked on 2024-02-29 and applies to citizens and legal permanent residents of Canada. 1. Introduction Our website, https://foundatum.ca (hereinafter: “the website”) uses cookies and other related technologies (for convenience all technologies are referred to as “cookies”). Cookies are also placed by third parties we have engaged. In the document below we inform you about the use of cookies on our website. 2. What are cookies? A cookie is a small simple file that is sent along with pages of this website and stored by your browser on the hard drive of your computer or… - [About Me](https://foundatum.ca/about/): I am a Data Analytics Architect. Folks often struggle to understand what I actually do as a day job. We all make up stories for how our business runs. I create environments in which organizations can understand the truth behind their business. Only when we look at the data, can we make definitive statements on the landscape of our businesses. I am also a recovering Data Scientist. Having done work in a number of industries where my efforts were largely spent procuring data in a format that I could make use of. This seems to be a common theme for… - [Privacy Policy](https://foundatum.ca/privacy-policy/): Who I am I am a Data professional with 10 years of experience with the Microsoft suite of tools. I’ve been a report builder, data engineer, solution architect, and team leader. I want this space to be a place that I can share many of the skills and patterns that I’ve learned. Comments When visitors leave comments on the site we collect the data shown in the comments form, and also the visitor’s IP address and browser user agent string to help spam detection. An anonymized string created from your email address (also called a hash) may be provided to… [comment]: # (Generated by Hostinger Tools Plugin)