Archives‎ > ‎

Interesting Articles

  • BI METHODOLOGIES Methodologies Development Lifecycle In developing a business intelligence project or solution, there are some different perspectives, whereas some believe that there are no specific methodologies one would say that a software development approach should be taken, such as a waterfall model or even an agile approach. Application development model PLAN             ANALYSE             DESIGN             BUILD             DEPLOY             REVIEW               The above illustrates the waterfall approach to a business intelligence project; this can also be applied to dashboard development yet perhaps not to the actual design of the dashboard. This model can contain multiple iterations and stages revisited if necessary.   PLANNING In planning a dashboard requirements gathering should be a main part of the planning stage, identifying the users and uses of the dashboard to ...
    Posted Oct 16, 2014, 3:27 AM by Leroy Dyer
  • DASHBOARDS / SCORECARDS / METRICS DASHBOARDS / SCORECARDS / METRICS The creation and deployment of dashboards and scorecards is also a key factor in presenting business intelligence data. Operational / Strategic often referred to Executive and Analytical are the main types of dashboards created. Each dashboard type has a level of detail or summarization. Operational dashboards These dashboards are often used to monitor data and traffic and real-time information. Operational dashboards have added considerations such as refresh rate, as the refresh interval can affect performance of the dashboard.   Strategic often referred to Executive dashboards These dashboards often contain key performance indicators tracking costs, sales and performance over time. Annual, quarterly and monthly this level of summarization is generally all that is required for such dashboards.   Analytical dashboards ...
    Posted Apr 21, 2016, 5:16 PM by Leroy Dyer
  • LOCATIONAL INTELLIGENCE Locational Intelligence This offers annalists an additional level of analytic capability the ability to have multiple layers of information is a key requirement to the business intelligence process as organization and classification of data enables a greater understanding of unstructured data.   “Integration of Location (GIS) and standard BI platforms brings LI to greater usefulness by making it available as an option to anyone who is familiar with the more readily-available BI solutions, and without the need to master new concepts or a new user interface. Spatial relationships also greatly enhance many of the details commonly reported by BI systems, providing an added level of analysis that is useful in viewing and assessing trends (and existing data types).” (sau)   A ...
    Posted Apr 21, 2016, 5:17 PM by Leroy Dyer
  • WHICH WAYS CAN WE PRESENT DATA? Which ways can we present data? There are many different charts and graph types to present data, such as; Pie charts: used for showing segments of the whole. Bar charts: used to show data over time, (not good for small changes) Line graphs: used to show multiple items in a group / comparing changes within the group. Useful for (small changes) scatter plots: useful for comparing differences between two different things: These traditional charts can be generated by various online and offline creation tools a blog offered at Hongkiat.com give a list of 22 chart generator software’s available. (Listed below)   ·         Rich chart live: (ric) ·         DIY chart : (diy) ·         Online chart generator : (cha1) ·         Chartel.net : (cha6) ·         ChartGo : (cha5) ·         Create a graph ...
    Posted Apr 21, 2016, 5:17 PM by Leroy Dyer
  • Effective presentation of business intelligence data Effective presentation of business intelligence data By Leroy Dyer Introduction   Currently there are many companies and institutions presenting data and making enquires and investment into Business intelligence. Many companies are realising the potential of analysing big data and representing and presenting such data. Analysing web market trends, web usage data, medical data, customer sales, market rates, customer segmentation and trends, patterns can be identified and insights created. The presentation of business intelligence attempts to address this ideal. The way in which, results are displayed becomes a key factor so that the people reading the results can quickly and correctly identify the insights being projected. Business intelligence is a relatively new methodology although data analysis is not a new methodology to ...
    Posted Apr 21, 2016, 5:18 PM by Leroy Dyer
Showing posts 1 - 5 of 10. View more »

BI METHODOLOGIES

posted Jun 16, 2013, 5:15 AM by Leroy Dyer   [ updated Oct 16, 2014, 3:27 AM ]

Development Lifecycle

In developing a business intelligence project or solution, there are some different perspectives, whereas some believe that there are no specific methodologies one would say that a software development approach should be taken, such as a waterfall model or even an agile approach.

Application development model

PLAN

 

 

 

 

 

 

ANALYSE

 

 

 

 

 

 

DESIGN

 

 

 

 

 

 

BUILD

 

 

 

 

 

 

DEPLOY

 

 

 

 

 

 

REVIEW

 

 

 

 

 

 

 

The above illustrates the waterfall approach to a business intelligence project; this can also be applied to dashboard development yet perhaps not to the actual design of the dashboard.

This model can contain multiple iterations and stages revisited if necessary.  

PLANNING

In planning a dashboard requirements gathering should be a main part of the planning stage, identifying the users and uses of the dashboard to be created, identifying the insight required to be shown.  These insights play an important role in the overall selection of the correct key performance indicators and metrics. Displaying and applying these metric are key to the dashboard becoming a success.

AYNALYSE

The data used within a dashboard is the key driving influence behind the dashboard being designed. This stage of analysis of results is a key issue. The data being displayed may be able to be analysed by using a data modelling technique such as Recency, frequency and monetary valuable insight can be shown. There are various types of dashboards for various levels of operations ranging from performance dashboards to strategic dashboards and real-time monitoring dashboards are also currently deployed across multiple platforms, from gaming to mobile business analytics applications.

DESIGN

In the design of a business intelligence dashboard, an approach called the “Three threes” is often commonly used. THREE APPLICATIONS, THREE LAYERS, and THREE TYPES: By integrating the application of the dashboard for multiple application types i.e.: monitoring, analysis and management this gives the dashboard a use which is more than just displaying data, by adding this functionality to the dashboard, we are able to create a dashboard that can also look at a snapshot in the current area to which it is being applied. By adding multiple dimensions to a dashboard giving the user the ability to drill down and delve into the data to take a closer or more directed look at the data, or even ROLL UP? This gives us a grand overview and perspective on the data.  By determining the role of the dashboard to be applied, the correct type of dashboard can be created.

BUILD

In the building of a dashboard there are many products supporting dashboard creation.  This needs to be evaluated according to the data or deployment strategy or even tools available to the project. Connecting a dashboard to existing technologies can be a tricky process and not all of the vendors of business intelligence products are able to accomplish this goal. The selection process also can be limited by budget, so understanding the business requirements can also determine which software vendor is used.

Deploy

The deployment of the dashboard is also a major consideration, deploying in a cloud based environment, or web based environment, creating a standalone application? These are the questions which need to be answered. By determining the access requirements needed by the dashboard the correct decisions can be taken. With mobile BI a media rich or even an html5 environment can be created and deployed on a platform that can be accessed by modern smart phone technologies.

REVIEW

This stage is mainly testing and reviewing the requirement stages to ensure that all requirements have been met, exploring the functionality and metrics applied. By using spread sheet technologies to check the validity of results.

This methodology can be approached as a rigid or agile approach, iterations can be applied to each stage revisiting if required.  This approach is entirely as flexible as required. By taking a methodical approach to designing dashboards and business intelligent presentations a user and company’s goals can be achieved. 

DASHBOARDS / SCORECARDS / METRICS

posted Jun 16, 2013, 5:14 AM by Leroy Dyer   [ updated Apr 21, 2016, 5:16 PM ]

The creation and deployment of dashboards and scorecards is also a key factor in presenting business intelligence data. Operational / Strategic often referred to Executive and Analytical are the main types of dashboards created. Each dashboard type has a level of detail or summarization.

These dashboards are often used to monitor data and traffic and real-time information. Operational dashboards have added considerations such as refresh rate, as the refresh interval can affect performance of the dashboard.  

These dashboards often contain key performance indicators tracking costs, sales and performance over time. Annual, quarterly and monthly this level of summarization is generally all that is required for such dashboards.

 

These dashboards also offer additional drill down functionality, enabling deeper insight into the data being analysed

 

When designing dashboards it is important to select the right type of dashboard, as adding functionality where it is not needed clutters the dashboard. Anything selected to be placed in a dashboard must have relevance to the insight being displayed. Selecting the correct chart is also important. Many charts can be created for various types of data presenting and selecting the KPI or metrics required is often important for the insights being shown or projected. Tableau software now has 23 different chart types for dashboard design. This is bringing the tableau software to the current market leader in dashboard technologies. Oracle and Microsoft are also leaders in the development of business Intelligence dashboards. Microsoft Excel has been used to also create pivot charts which have also been widely used. A useful dashboard should be tailored to the employee or users’ needs and requirements. By using caption and headings to identify charts is also an important factor as concerns with placing too many charts on a dashboard often comes with the added sacrifice of “explanation”.

 

I believe yes; dashboards enable the necessary business stakeholders easily identify information; with traditional database queries and spread sheet analysis often information is not easily identified, and easily missed. Insight are difficult to determine and relationships not always apparent. Using software such as Tableau OLAP cubes can be visualized more effectively. Dashboards can contain maps, charts, tabulated data, and word clouds and other visualizations; the human mind reacts well to such stimulus. The deployment of the dashboards is relatively simple, the functionality and metrics on a dashboard give the company an insight into the data being presented. These interactive charts have enabled business and data modelling to become a fore runner in the big data industry and also in the management and analysing of sales and customer data collected from online transactional data collection. This makes them invaluable to data driven business models.

Dashboards are being commonly used in many forms from gaming to flight statuses. Poker sites use dashboards to present gamers with statistics about games and present winning statistics even offering comparisons with other player’s statistics. Whereas websites offering flight-stats offer present flight data and seat statuses. Such dashboards could be classed as consumer business intelligence. These types of “consumer” dashboards are used to present data to web users or gamers seamlessly over different forms of platforms from gaming consoles to mobile applications. The consumer often is unaware that they are using a dashboard or scorecard. Consumers are being trained in the use of business intelligence dashboards via such portals. It would seem that business intelligence and presenting data has become common place.

With the increasing development in analytical modelling software, companies are now employing advanced visual modelling algorithms and techniques. By visualizing data, companies can visualize their data in various unseen dimensions. Customers can be represented graphically, even geographically or even as clusters which can be segmented by using advanced regression techniques such as , separating customers by Recency, Frequency and Monetary. This gives us the ability to determine valuable customers. The valuable customer segment can then be identified. Their similarities examined, this can then be used to determine business strategies and valued customer insight. The ability to display 3d or interrogate views is of a paramount importance in the increase of these advance business techniques and algorithms. Visual modelling has now become a major driving force in the development of customer driven businesses and has impacted many companies sales and allowed them to achieve an increase in specific target marketing strategies.

Insight driven graphical representation of business data and operational data have already provided businesses with valuable customer insight, market information and predictive analysis. The ability to monitor market changes visually has provided growth opportunities to companies proving its value in the business marketplace. Amazon have used transactional and web mined data to identify customer buying strategies, such data is used in developing customer insights and targeting mechanisms. This data can also be made available in shared data ware housing knowledge bases ready for advanced analytics and visual modelling techniques.

LOCATIONAL INTELLIGENCE

posted Jun 16, 2013, 5:09 AM by Leroy Dyer   [ updated Apr 21, 2016, 5:17 PM ]

Locational Intelligence

This offers annalists an additional level of analytic capability the ability to have multiple layers of information is a key requirement to the business intelligence process as organization and classification of data enables a greater understanding of unstructured data.

 

“Integration of Location (GIS) and standard BI platforms brings LI to greater usefulness by making it available as an option to anyone who is familiar with the more readily-available BI solutions, and without the need to master new concepts or a new user interface. Spatial relationships also greatly enhance many of the details commonly reported by BI systems, providing an added level of analysis that is useful in viewing and assessing trends (and existing data types).” (sau)

 

A recent research report – (sau) discusses locational intelligence, with advanced mapping capabilities presenting data can show geographical information in innovative and informing ways. Trends can be mapped and visualizations can reflect data down to street level, for customer trends and marketing this is a useful way to determine current customer movement and trends.

The ability to access information “on the move” has become a rapidly growing area of business intelligence, accessing dashboards, and scorecards keeping in contact with real-time information and information sharing has become of great importance to data driven companies. This area of business application development is a fast growing area of business information presentation. The simplification of dashboards is becoming increasingly important. The benefits of mobile business intelligence are significant and are confirmed In a TDWI best practices report – (MOB)

By deploying dashboards in the cloud making the dashboard or scorecard available to users immediately has also given application developers an efficient way to connect to and collaborate.

WHICH WAYS CAN WE PRESENT DATA?

posted Jun 16, 2013, 5:08 AM by Leroy Dyer   [ updated Apr 21, 2016, 5:17 PM ]

Which ways can we present data?

There are many different charts and graph types to present data, such as;

Pie charts: used for showing segments of the whole.

Bar charts: used to show data over time, (not good for small changes)

Line graphs: used to show multiple items in a group / comparing changes within the group. Useful for (small changes)

scatter plots: useful for comparing differences between two different things: These traditional charts can be generated by various online and offline creation tools a blog offered at Hongkiat.com give a list of 22 chart generator software’s available. (Listed below)

 

·         Rich chart live: (ric)

·         DIY chart : (diy)

·         Online chart generator : (cha1)

·         Chartel.net : (cha6)

·         ChartGo : (cha5)

·         Create a graph : (cre2)

·         JS charts : (cre1)

·         Pie chart tool : (nce)

·         Piecolor : Hohli charts: (htt)

·         Css chart generator : (css)

·         Chart part : (cha4)

·         Chart maker : (cha3)

·         Google chart tools : (cha2)

·         amCharts visual editor : (amc)

·         pie chart maker : (cre)

·         ChartGizmo : (cha)

·         Online chart tool : (Onl)

·         OWTChart Generator : (Hig)

·         HighCharts : (Hig)

·         ICharts : (ICh)

 

These third party tools offer traditional chart making facilities, yet for business intelligence and large data sets, more dimensions and measures are required. Greater software is required. Dealing with large datasets the information presented is often taken from multiple data sources; this data is not easily handled. This has given rise to specialists in business information technology company solutions.

 

·         SAP AG, SAS, ORACLE, IBM, MICROSOFT

 

These are the top five vendors in business intelligence software, although there are others making headway and providing new innovations in the presentation of data;

 

·         Tableau Business Intelligence: (tab) : dashboard creation:

·         QlickTech: (qli): A free software business chart making software.

·         WebFOCUS: (inf): Web enterprise integration software.

·         TIBCO Spotfire: (spo) : Information architect, data mining, predictive. Analytics

 

Currently there are many database management systems adding this functionality to current solutions.

Effective presentation of business intelligence data

posted Jun 16, 2013, 5:04 AM by Leroy Dyer   [ updated Apr 21, 2016, 5:18 PM ]

 

Currently there are many companies and institutions presenting data and making enquires and investment into Business intelligence. Many companies are realising the potential of analysing big data and representing and presenting such data. Analysing web market trends, web usage data, medical data, customer sales, market rates, customer segmentation and trends, patterns can be identified and insights created. The presentation of business intelligence attempts to address this ideal. The way in which, results are displayed becomes a key factor so that the people reading the results can quickly and correctly identify the insights being projected. Business intelligence is a relatively new methodology although data analysis is not a new methodology to businesses. In the presentation of information generated by data, business intelligence has become a vastly growing field. This precise task is handled in many different ways. Charts and graphs are used to present data in a visual way, this enables insights to be easily visualized and shared with the appropriate audience. There are many software solutions available to businesses, we shall attempt to cover a selection of these software solutions and compare the types of presentation capabilities. At this present moment there are no specific methodologies in relation to the presentation of Business intelligence but some whitepapers have been written and approaches and methodologies are being discussed.

Data analytics, has vastly improved over the last ten years and previous methods of presenting statistical data has been unable to cope with the increasing demand and growth of databases and marketing information. Such databases have become data warehouses which capture vast amounts of analytical data. Mapping this data, analysing and effectively presenting multidimensional, data collected over time, categorized by location and other methods has become a growing concern for companies as data contains valuable information about customers and markets. This can have a great effect on sales and profits, therefore providing mechanisms to react to change effectively. Predicting market change, identifying valuable products or customers and even monitoring a company’s objectives and performance targets and achievements, has become a valuable asset. 

 

 

 


 

Which ways can we present data?

There are many different charts and graph types to present data, such as;

Pie charts: used for showing segments of the whole.

Bar charts: used to show data over time, (not good for small changes)

Line graphs: used to show multiple items in a group / comparing changes within the group. Useful for (small changes)

scatter plots: useful for comparing differences between two different things: These traditional charts can be generated by various online and offline creation tools a blog offered at Hongkiat.com give a list of 22 chart generator software’s available. (Listed below)

 

·         Rich chart live: (ric)

·         DIY chart : (diy)

·         Online chart generator : (cha1)

·         Chartel.net : (cha6)

·         ChartGo : (cha5)

·         Create a graph : (cre2)

·         JS charts : (cre1)

·         Pie chart tool : (nce)

·         Piecolor : Hohli charts: (htt)

·         Css chart generator : (css)

·         Chart part : (cha4)

·         Chart maker : (cha3)

·         Google chart tools : (cha2)

·         amCharts visual editor : (amc)

·         pie chart maker : (cre)

·         ChartGizmo : (cha)

·         Online chart tool : (Onl)

·         OWTChart Generator : (Hig)

·         HighCharts : (Hig)

·         ICharts : (ICh)

 

These third party tools offer traditional chart making facilities, yet for business intelligence and large data sets, more dimensions and measures are required. Greater software is required. Dealing with large datasets the information presented is often taken from multiple data sources; this data is not easily handled. This has given rise to specialists in business information technology company solutions.

 

·         SAP AG, SAS, ORACLE, IBM, MICROSOFT

 

These are the top five vendors in business intelligence software, although there are others making headway and providing new innovations in the presentation of data;

 

·         Tableau Business Intelligence: (tab) : dashboard creation:

·         QlickTech: (qli): A free software business chart making software.

·         WebFOCUS: (inf): Web enterprise integration software.

·         TIBCO Spotfire: (spo) : Information architect, data mining, predictive. Analytics

 

Currently there are many database management systems adding this functionality to current solutions.

 

Locational Intelligence

This offers annalists an additional level of analytic capability the ability to have multiple layers of information is a key requirement to the business intelligence process as organization and classification of data enables a greater understanding of unstructured data.

 

“Integration of Location (GIS) and standard BI platforms brings LI to greater usefulness by making it available as an option to anyone who is familiar with the more readily-available BI solutions, and without the need to master new concepts or a new user interface. Spatial relationships also greatly enhance many of the details commonly reported by BI systems, providing an added level of analysis that is useful in viewing and assessing trends (and existing data types).” (sau)

 

A recent research report – (sau) discusses locational intelligence, with advanced mapping capabilities presenting data can show geographical information in innovative and informing ways. Trends can be mapped and visualizations can reflect data down to street level, for customer trends and marketing this is a useful way to determine current customer movement and trends.

The ability to access information “on the move” has become a rapidly growing area of business intelligence, accessing dashboards, and scorecards keeping in contact with real-time information and information sharing has become of great importance to data driven companies. This area of business application development is a fast growing area of business information presentation. The simplification of dashboards is becoming increasingly important. The benefits of mobile business intelligence are significant and are confirmed In a TDWI best practices report – (MOB)

By deploying dashboards in the cloud making the dashboard or scorecard available to users immediately has also given application developers an efficient way to connect to and collaborate.

The creation and deployment of dashboards and scorecards is also a key factor in presenting business intelligence data. Operational / Strategic often referred to Executive and Analytical are the main types of dashboards created. Each dashboard type has a level of detail or summarization.

These dashboards are often used to monitor data and traffic and real-time information. Operational dashboards have added considerations such as refresh rate, as the refresh interval can affect performance of the dashboard.  

These dashboards often contain key performance indicators tracking costs, sales and performance over time. Annual, quarterly and monthly this level of summarization is generally all that is required for such dashboards.

 

These dashboards also offer additional drill down functionality, enabling deeper insight into the data being analysed

 

When designing dashboards it is important to select the right type of dashboard, as adding functionality where it is not needed clutters the dashboard. Anything selected to be placed in a dashboard must have relevance to the insight being displayed. Selecting the correct chart is also important. Many charts can be created for various types of data presenting and selecting the KPI or metrics required is often important for the insights being shown or projected. Tableau software now has 23 different chart types for dashboard design. This is bringing the tableau software to the current market leader in dashboard technologies. Oracle and Microsoft are also leaders in the development of business Intelligence dashboards. Microsoft Excel has been used to also create pivot charts which have also been widely used. A useful dashboard should be tailored to the employee or users’ needs and requirements. By using caption and headings to identify charts is also an important factor as concerns with placing too many charts on a dashboard often comes with the added sacrifice of “explanation”.

 

I believe yes; dashboards enable the necessary business stakeholders easily identify information; with traditional database queries and spread sheet analysis often information is not easily identified, and easily missed. Insight are difficult to determine and relationships not always apparent. Using software such as Tableau OLAP cubes can be visualized more effectively. Dashboards can contain maps, charts, tabulated data, and word clouds and other visualizations; the human mind reacts well to such stimulus. The deployment of the dashboards is relatively simple, the functionality and metrics on a dashboard give the company an insight into the data being presented. These interactive charts have enabled business and data modelling to become a fore runner in the big data industry and also in the management and analysing of sales and customer data collected from online transactional data collection. This makes them invaluable to data driven business models.

Dashboards are being commonly used in many forms from gaming to flight statuses. Poker sites use dashboards to present gamers with statistics about games and present winning statistics even offering comparisons with other player’s statistics. Whereas websites offering flight-stats offer present flight data and seat statuses. Such dashboards could be classed as consumer business intelligence. These types of “consumer” dashboards are used to present data to web users or gamers seamlessly over different forms of platforms from gaming consoles to mobile applications. The consumer often is unaware that they are using a dashboard or scorecard. Consumers are being trained in the use of business intelligence dashboards via such portals. It would seem that business intelligence and presenting data has become common place.

With the increasing development in analytical modelling software, companies are now employing advanced visual modelling algorithms and techniques. By visualizing data, companies can visualize their data in various unseen dimensions. Customers can be represented graphically, even geographically or even as clusters which can be segmented by using advanced regression techniques such as , separating customers by Recency, Frequency and Monetary. This gives us the ability to determine valuable customers. The valuable customer segment can then be identified. Their similarities examined, this can then be used to determine business strategies and valued customer insight. The ability to display 3d or interrogate views is of a paramount importance in the increase of these advance business techniques and algorithms. Visual modelling has now become a major driving force in the development of customer driven businesses and has impacted many companies sales and allowed them to achieve an increase in specific target marketing strategies.

Insight driven graphical representation of business data and operational data have already provided businesses with valuable customer insight, market information and predictive analysis. The ability to monitor market changes visually has provided growth opportunities to companies proving its value in the business marketplace. Amazon have used transactional and web mined data to identify customer buying strategies, such data is used in developing customer insights and targeting mechanisms. This data can also be made available in shared data ware housing knowledge bases ready for advanced analytics and visual modelling techniques.

Development Lifecycle

In developing a business intelligence project or solution, there are some different perspectives, whereas some believe that there are no specific methodologies one would say that a software development approach should be taken, such as a waterfall model or even an agile approach.

Application development model

PLAN

 

 

 

 

 

 

ANALYSE

 

 

 

 

 

 

DESIGN

 

 

 

 

 

 

BUILD

 

 

 

 

 

 

DEPLOY

 

 

 

 

 

 

REVIEW

 

 

 

 

 

 

 

The above illustrates the waterfall approach to a business intelligence project; this can also be applied to dashboard development yet perhaps not to the actual design of the dashboard.

This model can contain multiple iterations and stages revisited if necessary.  

PLANNING

In planning a dashboard requirements gathering should be a main part of the planning stage, identifying the users and uses of the dashboard to be created, identifying the insight required to be shown.  These insights play an important role in the overall selection of the correct key performance indicators and metrics. Displaying and applying these metric are key to the dashboard becoming a success.

AYNALYSE

The data used within a dashboard is the key driving influence behind the dashboard being designed. This stage of analysis of results is a key issue. The data being displayed may be able to be analysed by using a data modelling technique such as Recency, frequency and monetary valuable insight can be shown. There are various types of dashboards for various levels of operations ranging from performance dashboards to strategic dashboards and real-time monitoring dashboards are also currently deployed across multiple platforms, from gaming to mobile business analytics applications.

DESIGN

In the design of a business intelligence dashboard, an approach called the “Three threes” is often commonly used. THREE APPLICATIONS, THREE LAYERS, and THREE TYPES: By integrating the application of the dashboard for multiple application types i.e.: monitoring, analysis and management this gives the dashboard a use which is more than just displaying data, by adding this functionality to the dashboard, we are able to create a dashboard that can also look at a snapshot in the current area to which it is being applied. By adding multiple dimensions to a dashboard giving the user the ability to drill down and delve into the data to take a closer or more directed look at the data, or even ROLL UP? This gives us a grand overview and perspective on the data.  By determining the role of the dashboard to be applied, the correct type of dashboard can be created.

BUILD

In the building of a dashboard there are many products supporting dashboard creation.  This needs to be evaluated according to the data or deployment strategy or even tools available to the project. Connecting a dashboard to existing technologies can be a tricky process and not all of the vendors of business intelligence products are able to accomplish this goal. The selection process also can be limited by budget, so understanding the business requirements can also determine which software vendor is used.

Deploy

The deployment of the dashboard is also a major consideration, deploying in a cloud based environment, or web based environment, creating a standalone application? These are the questions which need to be answered. By determining the access requirements needed by the dashboard the correct decisions can be taken. With mobile BI a media rich or even an html5 environment can be created and deployed on a platform that can be accessed by modern smart phone technologies.

REVIEW

This stage is mainly testing and reviewing the requirement stages to ensure that all requirements have been met, exploring the functionality and metrics applied. By using spread sheet technologies to check the validity of results.

This methodology can be approached as a rigid or agile approach, iterations can be applied to each stage revisiting if required.  This approach is entirely as flexible as required. By taking a methodical approach to designing dashboards and business intelligent presentations a user and company’s goals can be achieved.

Whilst it could be said there are no specific methodologies for developing an effective presentation of business intelligence data. Various approaches and considerations and ideals remain essentially the same. Target audience, functionality, colour, insight, analytics’, metric and kpi’s all play key roles in the decisions taken when designing or presenting data. Taking an approach such as the software development lifecycle or agile approach or even a prince2 or scrum approach is highly advisable. In reflection when presenting BI the choices are limitless, personal choice target audience company ethos play a major part in building bi presentations. New charting types and tools are rapidly expanding the field of business intelligence. With the introduction of word clouds and tag clouds keyword metrics and search data and social website mining has opened up the field of displaying qualative as well as quantitive data. This will be exciting for market researchers and broader researchers as these types of analytics have been a manual task or even beyond the range of categorization and classification. It could be argued that there is no need of a modern methodology as taking a rigid approach to data can obscure insight generation and discovery; agile methodologies enable a wide scope for creativity and development.   

What is a Data Warehouse?

posted Jun 16, 2013, 4:57 AM by Leroy Dyer   [ updated Apr 21, 2016, 5:19 PM ]

What is a Data Warehouse?

A data warehouse is a centralized data store collating data, from multiple sources, making it easier to share data across multiple platforms.  Data from various data stores can be pulled or pushed, reports created for rich media presentations, websites, also manages big data.

Figure 1

DATA: these points can be: sql server, sas enterprise miner, oracle, and spread sheet data

Typically, a relational database designed for query and analysis, rather than transactional queries.

  • A place where historical data is stored, for archival purposes, analysis and security.
  • Contains raw or formatted data
  • Combines data from multiple sources.

Why

  • Data is stored in various types of format and in different locations.
  • Data in various sources is not easily accessed such as operational databases (OLTP).
  • Online transactional processing systems are and not designed for analysing data, this data is also often live data which is constantly updating and changing.
  • Data is often stored in different platforms and different locations.
  • Subject orientated –Decision based
  • Integrated – various platforms
  • Non-volatile – not changing
  • Time variant – showing changes over time

Defined as; too much volume, velocity, variability, potentially 5 petabyte or more, to work on normal database architectures. Such as Google, Facebook, twitter etc.

Testing / developing a data warehouse

  • Business analysts ------ get requirements
  • Q-A tester ----------- develops and executes test cases.
  • Architects ----------- set up test environment
  • Developers ------------- reform test units
  • Database administrators ------- reform functionality (user acceptance tests)
  • Sources
  • ETL layer
  • The data warehouse
  • The business intelligence front end (dashboards) (Scorecard)
  • Test all entry point
  • Testing the dashboard
  • Logical calculations – compare data M art to report
  • Data validation –create equivalent sql queries from dashboard and data mart.
  • Make sure create reports based on user requirements
  • Verify Field lengths data elements
  • Use automation tools
  • Test speed + performance + workloads, workflows and wait time.

The data ware house needs to load data from various sources, the data EXTRACTED needs to be TRANSFORMED into a format which can be used by the data warehouse for analysis.

EXTRACT:     from OLTP SYSTEM and copied to the ware house

Transform:   remove inconsistences, format to a common format, add missing fields derive new fields to store calculated data.

Load:        Map data into the warehouse

  • Source to target map: required to plan the etl process.
  • Capture business rules
  • Data flow mapping
  • Data movement requirements
  • Mapping document specification:
  • SOURCE: Input Definition
  • TARGET: output formats
  • Business and data transformation rules
  • Data quality requirements
  • Source & Target SQL is available here also.

WHAT IS BUSINESS INTELLIGENCE

posted Jun 16, 2013, 4:55 AM by Leroy Dyer   [ updated Apr 21, 2016, 5:19 PM ]

Software applications used in spotting, analysing, reporting business data. Also provides access to data which can be used in day to day operation, integrating data into logical business areas, websites dashboards. Provide historical current predictive views of business data.

Enables companies to make informed decision in business areas where data has been identified weaknesses or threats or potential investment.

Business intelligence is made up of activities, data mining, online analytical processing reporting, chart building, data warehousing management and design.

 SAP / ORACLE / MICROFT SQL SERVER / PIVOTPOINT EXCELL / IBM COGNOS

Main Companies: SAS, MICRO STTRATEGY, INFORMATICA

  • Online transactional processing
  • Online analytical processing
  • Business intelligence GIVES US THE POWER TO PROVIDE DIFFERENT VEIWS OF DATA IN A SINGLE DASHBOARD, PREDICTIONS CAN BE MADE, DATA CAN BE EXPLORED OVER TIME:
  • BUSINESS INTELLIGENCE ALLOWS US TO USE TOOLS TO TURN DATA INTO INFORMATION TO SUPPORT DECSIONS.
  • BUSINESS INTELLIGENCE IS ABOUT DECISION MAKING.
  • Exploding data volumes
  • Increasing complicated decisions
  • Need for quick reflexes
  • Technological progress
  • Operational performance
  • Improvement in customer services
  • Identification of new opportunities in comparator organizations
  • Insights into market trends

ORGANIZATIONAL MEMORY

INFORMATION INTERGRATION

INSITE CREATION

PRESENTATION

What are the effects of gaming on modern popular culture?

posted Jan 5, 2012, 2:54 AM by Leroy Dyer   [ updated Apr 21, 2016, 5:20 PM ]

With the advent of such game machines as XBOX360,  Play-station and Nintendo. The effects of games on popular culture have been widely investigated. With games such as CALL OF DUTY, GEARS OF WAR, and various other games. Violent games such as these have become common place in gaming culture. The modern game play has changed drastically from just playing at home with friends, to playing online against others. With this level of competition, the realism in games, game culture has taken a new form. With the advent of online gaming a lot of games have become clan based, this is where groups of individuals have joined together to compete against other clans. This clan culture has essentially created outlets for online bullying and racism where usually there would be no such situation. Over the last few years the problem of online bullying, racism, has increased and game companies have tried to create “GAME CHAT” channels and a COMPLAINTS SYSTEM to combat these issues. The responsibility is sketchy is it the responsibility of the parents to ensure that younger audiences are not using games that have been rated over 18, although it can be said that some parents automatically buy their children games that come out on the market even if the game is rated “18”. While it can be said that not all gaming has a negative impact on our culture, there are some games that could be taken to be educational, these game could have a positive impact on development of good gaming habits and even educate younger adults. 

With more than 100 million units sold and $5 billion in revenue earned, Call of Duty is a mega-entertainment franchise comparable to the likes of Harry Potter or Star Wars.

Those properties have had undeniable effects on pop culture at large. Star Wars lines still get quoted - "these are not the droids you're looking for" - while Harry Potter costumes are a perennial favourite come Halloween time. So, given the video game series' huge commercial success, has Call of Duty had a similar effect?

The people behind the games think so, but pop culture and video game observers aren't so sure.

 

Source: http://tech.ca.msn.com/video-games/article/has-call-of-duty-had-a-cultural-impact

By Peter Nowak, MSN Tech & Gadgets, November 4, 2011


What is spyware? Can any spyware be acceptable?

posted Jan 5, 2012, 2:51 AM by Leroy Dyer   [ updated Jan 5, 2012, 2:51 AM ]


What is spyware?
“Spyware is a type of malware that can be installed on computers, and which collects small pieces of information about users without their knowledge. The presence of spyware is typically hidden from the user, and can be difficult to detect. Typically, spyware is secretly installed on the user's personal computer. Sometimes, however, spywares such as key loggers are installed by the owner of a shared, corporate, or public computer on purpose in order to secretly monitor other users.”
Source url : http://en.wikipedia.org/wiki/Spyware WIKIPEDIA

1. Spyware is one type of malicious software (Mal-ware) that collects information from a computing system without your consent.
2. Spyware can capture keystrokes, screenshots, authentication credentials, personal email addresses, web form data, Internet usage habits, and other personal information. The data is often delivered to online attackers who sell it to others or use it themselves for marketing or spam or to execute financial crimes or identity theft
A Spyware is generally a reporting software generally sending data to another source. The cookie is a well-known mechanism for storing information about an Internet user on their computers. Web sites often store relevant information about a user’s visit to their site in a cookie Spyware often uses these mediums to retrieve data, Spyware is part of an overall public concern about privacy and security on the Internet, These software's usually penetrate the computers defences via a Tool bar software even search engines, these can hijack your browser setting forcing you to go their projected marketing ploys causing a downward spiral of malware being installed on your computer or Internet enabled device. These software's then can cause unwanted / undesirable effects. Viruses differ in the fact that viruses seek to spread and destroy data, whereas spyware attempts to store data and report. Spyware is not interested in destroying the host machine as it live on the host and needs the host to report data from. The removal of spyware itself is a multi-million pound business and the spyware removal companies are often the biggest offenders of spyware distribution.

Hijacking
“The BHO API exposes hooks that allow the BHO to access the Document Object Model (DOM) of the current page and to control navigation. Because BHOs have unrestricted access to the Internet Explorer event model, some forms of malware have also been created as BHOs. For example, the Download Malware installs a BHO that would activate upon detecting a secure HTTP connection to a financial institution, record the user's keystrokes (intending to capture passwords) and transmit the information to a website used by Russian computer criminals. Other BHOs such as the My Way Search bar track users' browsing patterns and pass the information they record to third parties.”
SOURCE URL: http://en.wikipedia.org/wiki/Browser_Helper_Object WIKIPEDIA

This can include ActiveX add-ons, dropper malware, these are often packaged with wanted downloads such as, toolbars, down-loader assistants, etc. or even by visiting various sites with bad certification, the certificate of the website is often the dropper software by accepting to enter the site you essentially allow the software to drop or be installed onto your unsuspecting system. These soft wares essentially hijack your browser causing undesired browsing events, such as pop-up windows and browser redirection.

Data Collectors
These include location tracking, browser habits, passwords, clipboard contents, key-stokes and Key sequences. These key sequences will become hijacked by future delivery's/updates of the spyware. These spy wares also have update elements within them delivering more harm full software or even Stronger resilient to Anti-virus detection.
Network Information is also a common target, i.e.: ports open/closed - In/use IP information etc. These data collector can come in so many forms hidden and open that it is hard to defend against. they can also come as harmless applications or even as you sign up to a service your information is immediately shared or accessible by other shared data collector resources across multiple domains, where your details are now unprotected and you may even find yourself under attack from various scam artists or even bombarded by aggressive advertising.


Web Bugs/Bots / Malicious code
“"Bot" is derived from the word "robot" and is an automated process that interacts with other network services. Bots often automate tasks and provide information or services that would otherwise be conducted by a human being. A typical use of bots is to gather information (such as web crawlers), or interact automatically with instant messaging (IM), Internet Relay Chat (IRC), or other web interfaces. They may also be used to interact dynamically with websites.”
Source url : http://www.cisco.com/web/about/security/intelligence/virus-worm-diffs.html cisco:

This is where a website has deployed spyware tactics within html code. Although not visible to the unsuspecting user it reports spyware data, even steals data about the site visitor with cookie data or even scripts, reporting back to another source via monitoring tools or even email. These web bots can be deployed to machines via various social networking sites via Internet gaming, downloading music from non-reputable sites, instant messaging and so forth. these bots are often disguised as other products or even bundled with “cracked” games or software.





Can any spyware be acceptable?
There are times when Spyware is deployed for valid reasons as some applications are reliant on locational data such as Google Latitude, Parental Guidance Software, Banking, phone monitoring software etc. In this modern Era what may have been thought of as spyware may actually be useful and intentional software, Firewall software and Anti-Virus software are often are very astringent in their deployment and often need Tailoring to allow for these types of applications. There is a multitude of Anti-virus and Internet security software on the market. With a closed network there is no requirement for antivirus scanning although there are security requirements at all points of entry into the system. Currently the with the advent of the Internet data is the most sort after commodity, this for me becomes a matter of protection, sharing details across the Internet should be done with grave care and only with reputable sources, i.e.: sites which have a REAL WORLD base, as these sites are usually under the country of origins legislation which should provide the adequate protection and recourse should any problems arise.

My research question is important because.....
The importance of identifying threats and potential harmful software, and categorizing wanted software is paramount. When dealing with businesses which are now closely related to cloud services. The company’s exposure to outside threats has been increased. New and improved ways need to be found to limit the exposure to these aspects of the Internet. Via use of Firewall and Hardware solutions such as digital keys, biometric user passwords, and other swipe technologies.
Spyware is interesting as the definition of spyware may even need to be redefined, used by marketing companies as a point of fact using various strategies, such as Browser session hijacking - this class of spyware changes the users browser settings, so that when they attempt to open a link, the user is directed to the company’s marketing strategy. This is often used by Malware companies, directing the user to various malware sites and paid advertising which earns the malware author financially. These marketing strategies are extremely aggressive and may even need regulation.

Marketing organizations are also interested in personal information, such as browsing habits, shopping habits, locational data, browser data, search data and more. this also inspires company's such as APPLE, MICROSOFT, GOOGLE, FACE BOOK. to sell such data to whomever is willing to pay. This can be dangerous for companies which allow workers to use personal email addresses at work as most people today are involved with a social networking site. With the advent of more networking sites forums and the sharing of code pictures and other resources the need for adequate protection is paramount to browsing the Internet safely in this modern era. There are now so many forms of spyware it is hard to distinguish, spyware from worms to viruses as the commonality of deployment, repair, protection from and removal are so similar. Correctly identifying problems and their common sources are a key company concern and I.T managers worst nightmare if not completely or correctly prepared.

3D Scanning

posted Jan 5, 2012, 2:48 AM by Leroy Dyer   [ updated Jan 5, 2012, 2:48 AM ]

3D Scanning allows the creation of a 3D mesh from a real world object or environment. From here all sorts of application possibilities open up including animation, archiving, medical research, rapid prototyping, industrial design and quality control inspection.

There are numerous options available to do this, each with their own advantages. Some read the object with red laser light, others use white light to record the subject, plus there are manual systems which allow point by point analysis of the object.



Working with various programs you can create your own 3d scanner / tricorder.


FLAT LINE LASOR
WEB CAM

As Simple as that:






Software (USEFULL)


1-10 of 10