Leveraging Narrator on Public domain data for Analytics

Introduction:

Many organizations use Business Intelligence (BI) tools for their conventional & core data, such as Dashboarding for reporting. Narrator is also used by many organizations for their reporting, dashboarding, insighting on the core data on a day-to-day basis

However, in the last few years, Narrator has also emerged as one of the tools where you can host your alternate data like data sourced from public domain or portals etc.

With Narrator, users can automate the process of hosting and analyze data sourced from public domains, create smart reports, unlocking valuable insights, and driving informed decision-making with the help of reporting and dashboards.

Public domain data sources & use cases

Public domain data refers to non-traditional sources such as public domains, portals, websites, databases etc which have data about the Industry, various players, informative items, rates, dynamic information which keeps varying on hourly or daily basis. For example, branches of financial institutions (available from regulatory websites), Companies database, Pricing analysis, Competition analysis, Comparative analysis of rates, Property prices comparisons. 

Use cases:

• Extraction of data from various branches of FIs and compiling it into a comprehensive report using Narrator. This allows the bank to analyze demographics, preferences, and banking behaviors to tailor services and marketing strategies effectively.
• Other databases and Datasets available in public domains, individual websites in terms of location data like Retail Stores chains & their branches, bank ATMs, geolocation information etc can be extracted from various sources, automated, and stored in database and compared in Narrator.
• Extracting Companies data from diverse sources and organizing it into separate databases. This enables organizations to get target markets of these companies, key people and gain insights into the social initiatives and emerging businesses, facilitating targeted collaborations, funding opportunities, and strategic partnerships for mutual growth and impact. These data sets could include listed, unlisted, Startups, Associations, non-profit organisations etc.
• Extraction of currency & interest rates from multiple websites, enabling users to compare and analyze currency exchange rates effectively. Rate comparison could include prices like Forex prices, Fixed deposit rates. This feature empowers businesses to make informed decisions regarding currency price comparisons, movements, strategies, and global market investments, ensuring optimal financial management and risk mitigation.
• Extracting data from financial wealth data to compare various key performance indicators like flows, assets under management, policies, premiums of different fund houses and Insurance companies. By consolidating and analyzing this data, investors gain insights into fund-to-fund comparisons, growths, ratios etc allowing them to make informed decisions regarding their own fund structures, growth strategies and planning.
• Extraction of property prices data from various real estate portals for comparison purposes. By aggregating and analyzing this information, users can gain insights into real estate market trends, pricing comparisons, affluent areas, regional variations, set up of branches, stores etc and property valuations. 

Modus-Operandi:

The data extraction process involves utilizing Python libraries. The extracted data is then processed and stored in databases such as PostgreSQL or MongoDB using SQL for efficient retrieval and analysis. Once the data is stored, Narrator’s integration capabilities allow for seamless access to the data and create customized reports for visualization insighting.

 

 

Possible outputs & solutions

Narrator integrates seamlessly to the backend functions to retrieve data from database and craft smart, tailored reports addressing specific business requirements. These outputs include:

• Analytics reports,
• Comparisons & Insights via email body notifications,
• PDF documents, and
• Comparative analyses for assessing moving averages of prices.

Examples of Insights via Email:

Examples of Analytical Reports:

Example of Property prices comparison:

Conclusion

Thus, Narrator can also be used for sourcing data on an automated basis from various public domains seamlessly integrating with backend functions to generate smart and customized analytic reports and meaningful insights. Its adaptive outputs extend to delivering insights and reports via email notifications, PDF documents, and comparative analyses, delivering a comprehensive solution for public domain data for informed decision-making.