M&N-Business Intelligence Consulting
Dashboard and Report Design-Data Mining
HomeTurbodata Business IntelligenceTurbodata predictive analyticsTally Data ConsolidationNavision Business IntelligenceData Capture ServicesData CleaningData Normalization-Data CompressionDashboard and Report Design-Data MiningManagement TeamContact UsCase Studies-Turbodata

 

 Data Mining

Gathering the report and dashboard requirements for a datawarehousing project at an end client is a very specialized task. M&N Business Intelligence follows a set methodology for gathering report requirements.

·         Understand the business process: this is done by process modeling and by data modeling.

·         Conducting the end client interviews.

·         Understanding the daily canned report requirements. These normally include understanding the current spreadsheets been used by the end client.

The entire purpose of the above exercise is to understand the following:

·         What is to be reported?

·         To whom are the facts to be reported?

·         When the reports are to be delivered and in what format?

·         To what granularity level are the details to be reported to various end users. This helps in understanding the drill down and drill through parameters.

There are some basic tenets that need to be understood while gathering the reporting requirements.

  • Measures: these are the numbers such as sales, cost that need to be reported. These figures could come directly from the tables, could be generated as custom measures during cube formation or could be generated as reporting variables. Depending upon our understanding of how, by whom a particular measure is to be used, we decide how the measure shall be created.
  • Dimensions: these are the groups by and the filter parameters for various measures. There are primarily 2 types of dimension entities used for reporting purposes. Type-1 dimension entails capturing only the current data, while type-2 dimension entails capturing the historical data.The dimension entities could be a list of attributes like that of a person or a hierarchy as in the case of say region-district.
  • Conformed dimensions: certain type of dimension entities need to be standardized across the whole organization such as date. They are called conformed dimensions.
  • Aggregates: sometime the measures need to be looked at a higher level of granularity. For example say the management of a company desires to look at the cashflow only in terms of monthly figures. In such cases we generate aggregates.

 
Report requirements gathering process: In this part of the analysis we gather all the tactical and the strategic reporting requirements.
We have a sample report gathering requirement document for your consideration in adobe format. You can get the word format by submitting your e-mail address to our team.

Report Requirements Business Intelligence -Sample

Your email address:

Design of Dashboards:A dashboard is a visual representation of a set of graphs and metrics that the end user desires to look on a single page. The following factors need to be taken into account while designing dashboards:

 

  • The 'big picture' to be shown should be clearly defined.
  • The metrics to be shown should be clearly defined and documented.
  • The dashboard should be visually appealing.

 

M&N Business Intelligence India LLP: 4503 DLF Phase-4, Gurgaon, Haryana 122009
Phone:+91-8802466356 
Email:apoorv@mnnbi.com;

State your current issue/problem 
a.) Consolidation of multiple instances of Tally/SAP/Navision Data
b.) Reports been refreshed in the source system slowly
c.) Manual effort required for data consolidation
d.) Requirement for predictive and forecasting analysis
e.) Inventory/cash flow optimization problem 
f.) Manual filing of GST data 
 
 
 
 
State the time frame for solving the required problem 
 
 
 
 
Your contact details: Name, Phone number, email, best time to contact
 
 
 
 
 
Comments: