Need professional Enterprise Reporting and BI solutions for your business? Check SSW's Enterprise Reporting Consulting page.
It’s easy to capture lots of telemetry from your software; everything from exceptions to usage statistics. But do you know what to do with it and how to interpret what this data is telling you? That’s the difference between information, intelligence, and wisdom.
Whenever you need a number from a system you should think of how you can create a report, so next time you can press a button to get the result.
When making reports, charts, and visualizations, it’s important to be consistent with your titles.
In OLAP (Online Analytical Processing) cubes, dimensions are ways to categorize data. For example, in a sales cube, you might have dimensions for Time, Products, and Geography. Each dimension can have a hierarchy, and the top level is often represented as "All," which aggregates the data across all members of that dimension.
Databases, data warehouses, and data lakes are all essential components of Business Intelligence (BI) systems, but they serve different purposes and have distinct characteristics. Understanding their differences can help organizations make informed decisions about data storage and analysis.
Almost every piece of software requires a database - even the humble to-do app needs somewhere to store those tasks. Data is the lifeblood of many businesses, and the underlying databases are often the piece of infrastructure that live longest. But are you taking the time to really think about which database is the best fit for the job?
A Data Warehouse is a centralized repository of data that is used for analysis and reporting, providing organizations with valuable insights to support decision-making processes. A Data Warehouse can offer significant benefits, so understanding its appropriate use cases and limitations is essential.
In today's data-driven world, businesses face the challenge of managing and extracting insights from vast and diverse datasets. But how can businesses leverage the power of their data to gain a big picture view of their operation and make informed business decisions?
Welcome to Data Lakes.
- Do you know the difference between information, intelligence, and wisdom?
- Do you build reports to be reused?
- Do you use “by” rather than “per” in your chart titles?
- Reports - Do you configure every dimension’s "All Caption" to be "All"?
- Do you use the right data storage?
- Do you use the right database for the job?
- Do you use a Data Warehouse?
- Do you understand Data Lakes?