Simply speaking, a database is any structure in which data is to be arranged along with tools to store, manipulate and retrieve the data.
Several such pre-configured “data arrangements” are available as products, each developed in its time to solve data-related challenges. Let’s mention a couple.
Relational Database: In a relational database data is arranged in tables with relations...
The flexibility, diversity and power of Excel makes it a generic tool for almost any task. However, this richness of options and openness can put your data and business at risk.
Consider a large table you maintain in Excel. Mistakenly, you mis-typed a date to be: 05/10/20020. You didn’t notice. That row is...
YES!
SQL is the most popular Databases language. It is robust, proven and works with extremely large tables stored in any common relational Database software. If you want to learn more about Databases and SQL – read my last week’s Blog post...
Relational Databases (RDB) drive nearly all of the information systems in the service of any organization today. Despite being a central and critical technology, it’s only 40 years old, 10 years younger than me.
It was Edgar Codd from IBM who first devised the RDB concept in the early 1970’s. Only in 1978 was the first commercial RDBMS (Relational Database...
As you probably know, a function (or subroutine) can accept arguments (or parameters) from the calling function (or sub). These arguments are part of the definition (or “stub”) of the function. For example:
Function AddTwoNumbers(_
ByVal FirstNumber as Single, _
ByVal SecondNumber as Single) as Single
The above function...
We planned our Dashboards and prepared the data. We’re now ready for the artistic magic: the visual effect and user experience. This is the focus of today’s Blog post, the last in this “all Dashboards” 4-articles series. If you missed the previous parts, start here.
Now is the time to take the blueprint of our Dashboard we sketched when we planned our Dashboards layout,...
After we have finished all the preparations for our Dashboard in the previous Blog post of this Dashboards’ Guide series, we’re now ready to start implementing our Dashboard in Excel.
A good data staging serving our Dashboards must be very efficient, to quickly refresh the Dashboards. This implies that we need to carefully strike a balance across all resources required...
In the previous Blog post we understood the main aspects and types of Dashboards. In this second of a 4-part Blog post, we start preparing ourselves for the much-anticipated Dashboard.
The place to start is the business requirements analysis document, we prepared (or received) before we planned and implemented the application. The Dashboards’ elements should already be described right there.
...
Dividing information systems’ role into two main focus areas, we have the operational processes on one hand (OLTP) and the analytics on the other (OLAP).
Considering the ultimate goal of supporting and driving the business, OLTP systems streamline the daily work, govern the processes and control the data as it is being accumulated in the database. OLAP solutions are tasked with...
Today I launched my third course in the Computer Programming and Databases with Excel VBA and SQL program. This course, titled Beyond Excel Boundaries with User Forms: Deliver a Professional User Experience, covers User Forms implementation as the user interface for Excel-based business applications.
This launch today made it an easy...
50% Complete
Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!