en flag +1 214 306 68 37
BI Solution to Enable Market and Business Data Analysis across 40+ Dimensions

BI Solution to Enable Market and Business Data Analysis across 40+ Dimensions

Industry
Consulting, Professional Services
Technologies
MS SQL Server

About Our Client

The Client is a B2B management consultancy from the New York State, advising their clients on strategy, finance and marketing perspectives of their businesses. They help companies to transform into robust partners beyond being service providers, as well as improve their value proposition to succeed on the market.

Challenge

The Client needed a business intelligence solution to process their clients’ raw data, transform it into valuable insights and create thorough reports.

Solution

The system is based on a MS SQL Server data warehouse and includes an OLAP cube with 40+ dimensions to allow the Client to form a holistic view of their clients’ processes.

The Client accesses the solution via a web portal based on Kyubit BI technology. The Home screen offers an overview of previously created and saved reports (for example, by geography, by industry, by region and individual companies, etc.), which can be instantly modified according to the Client’s current needs, for example, by adding more KPIs or excluding a few measures.

bi for management consultancy summary by industry

According to the Client’s requirements, ScienceSoft composed the following dimension groups to drill down and drill through the data:

  • Companies
  • Company by region
  • Company by sector
  • Countries
  • Dates
  • Top companies filtered by market capitalization
  • Top companies filtered by net income
  • Top companies filtered by revenue
  • Top companies filtered by TEV
  • Top companies filtered by total debt
  • Industries
  • Stock exchange

The measures include the following financial values:

  • Gross profit
  • Revenues
  • Net income
  • NTA
  • NWC
  • PPE
  • TCA
  • TCL, and more

Right from the Home screen the Client’s analysts can start a new analysis, create a new folder to group up certain reports, delete an analysis, move the current analysis to another folder or clone it.

bi for management consultancy regions and industries

The report’s visualization has a wide range of chart types, color themes and palettes, supported by 3D setting options to make analysis more informative.

The Client can also print out reports, convert them to Excel and PDF, as well as share them with clients via a generated URL.

Results

ScienceSoft delivered a thorough BI solution according to the Client’s requirements. It consists of a wide range of dimensions and KPIs to allow analyzing different industries in various economic conditions. The Client now uses this solution to offer advanced consultancy on their client’s strategic development.

Technologies and Tools

MS SQL Server, MS Analysis Service, MS Integration Service, Kyubit BI

Have a question to our team or need help with your project?

Our team is ready to provide client references, estimate your project, or answer any other question related to your IT initiative.

Upload file

Drag and drop or to upload your file(s)

?

Max file size 10MB, up to 5 files and 20MB total

Supported formats:

doc, docx, xls, xlsx, ppt, pptx, pps, ppsx, odp, jpeg, jpg, png, psd, webp, svg, mp3, mp4, webm, odt, ods, pdf, rtf, txt, csv, log

More Case Studies