I am building a model for a new database in Visio. The Excel spreadsheet contains the table definitions for the model, not the data that needs to be modelled. (Forget that the table definition list is in an Excel spreadsheet. It could be in a CSV, database table, etc.) I need ...
Microsoft® Excel 2002 Summary:This article shows you how to build a real-time data server in Microsoft Excel 2002. DownloadOdc_xlrtdbuild.exe. Contents Introduction The Now & Today RTD Server Under the Hood Security Syntax Solution: Wide World Importers Price List Exploring the Solution Summary...
I mentioned modularity as a core concept of building a modern data platform in my 2021 article, but I failed to emphasize the importance of data orchestration. This time around, I have a whole section dedicated to orchestration and why it has emerged as a natural compliment to a modern data...
Here’s the drill… You’ve got a set of data dumped from some performance analytics database… It has a basic date series with some kind of output, and you need to put it into a chart that your executives can understand at a glance. Excel has an extremely powerful charting system, bu...
(the AdventureWorks2008 database that you can download and install as described in Stacia Misner's article on p. 31). You can use various applications to create a data map. The format isn't as important as the content. I like to develop data maps in Microsoft Office Excel.Figure 2shows...
You can use various applications to create a data map. The format isn't as important as the content. I like to develop data maps in Microsoft Office Excel. Figure 2 shows the DimProduct tab I created in my data map. I also created DimCustomer and FactInternetSales data maps. Each ...
Building a Geodatabase Exercise 3: Creating subtypes and attribute domains Suzanne Montes GEOG 482 Creating an attribute domain Right-click the Montgomery geodatabase and select Properties The Database Properties dialog box appears. Click the Domain tab. Enter LatDiameter in the last empty field und...
Change Data Capture –CDC The basic gist of CDC is using your database’s CRUD commands as a stream of data itself. The first CDC platform I came across was an OSS project called Debezium and there are many players, big and small, vying for space in this emerging category. Click Strea...
time to make the switch. In a spreadsheet, you let go of a smooth user experience to gain powerful functionality. In a database, you can make queries to display only specific, related pieces of data—but you need to be comfortable with writing SQL and packing the insights into a report....
I am creating a database through Access for employee end of shift reports. Currently these reports are not being stored in a database and instead are filled out on an Excel file. The Excel format wor...