Accessibility Statement Skip Navigation
  • Why PRWeb
  • How It Works
  • Who Uses It
  • Pricing
  • Login
  • GDPR
  • Create a Free Account
Return to PRWeb homepage
  • News
  • Resources
  • Contact
When typing in this field, a list of search results will appear and be automatically updated as you type.

Searching for your content...

No results found. Please change your search terms and try again.
  • News in Focus
      • Browse News Releases

      • All News Releases
      • Multimedia Gallery

      • All Multimedia
      • All Photos
      • All Videos
  • Business & Money
      • Auto & Transportation

      • Aerospace, Defense
      • Air Freight
      • Airlines & Aviation
      • Automotive
      • Maritime & Shipbuilding
      • Railroads and Intermodal Transportation
      • Supply Chain/Logistics
      • Transportation, Trucking & Railroad
      • Travel
      • Trucking and Road Transportation
      • View All Auto & Transportation

      • Business Technology

      • Blockchain
      • Broadcast Tech
      • Computer & Electronics
      • Computer Hardware
      • Computer Software
      • Data Analytics
      • Electronic Commerce
      • Electronic Components
      • Electronic Design Automation
      • Financial Technology
      • High Tech Security
      • Internet Technology
      • Nanotechnology
      • Networks
      • Peripherals
      • Semiconductors
      • View All Business Technology

      • Entertain­ment & Media

      • Advertising
      • Art
      • Books
      • Entertainment
      • Film and Motion Picture
      • Magazines
      • Music
      • Publishing & Information Services
      • Radio & Podcast
      • Television
      • View All Entertain­ment & Media

      • Financial Services & Investing

      • Accounting News & Issues
      • Acquisitions, Mergers and Takeovers
      • Banking & Financial Services
      • Bankruptcy
      • Bond & Stock Ratings
      • Conference Call Announcements
      • Contracts
      • Cryptocurrency
      • Dividends
      • Earnings
      • Earnings Forecasts & Projections
      • Financing Agreements
      • Insurance
      • Investments Opinions
      • Joint Ventures
      • Mutual Funds
      • Private Placement
      • Real Estate
      • Restructuring & Recapitalization
      • Sales Reports
      • Shareholder Activism
      • Shareholder Meetings
      • Stock Offering
      • Stock Split
      • Venture Capital
      • View All Financial Services & Investing

      • General Business

      • Awards
      • Commercial Real Estate
      • Corporate Expansion
      • Earnings
      • Environmental, Social and Governance (ESG)
      • Human Resource & Workforce Management
      • Licensing
      • New Products & Services
      • Obituaries
      • Outsourcing Businesses
      • Overseas Real Estate (non-US)
      • Personnel Announcements
      • Real Estate Transactions
      • Residential Real Estate
      • Small Business Services
      • Socially Responsible Investing
      • Surveys, Polls and Research
      • Trade Show News
      • View All General Business

  • Science & Tech
      • Consumer Technology

      • Artificial Intelligence
      • Blockchain
      • Cloud Computing/Internet of Things
      • Computer Electronics
      • Computer Hardware
      • Computer Software
      • Consumer Electronics
      • Cryptocurrency
      • Data Analytics
      • Electronic Commerce
      • Electronic Gaming
      • Financial Technology
      • Mobile Entertainment
      • Multimedia & Internet
      • Peripherals
      • Social Media
      • STEM (Science, Tech, Engineering, Math)
      • Supply Chain/Logistics
      • Wireless Communications
      • View All Consumer Technology

      • Energy & Natural Resources

      • Alternative Energies
      • Chemical
      • Electrical Utilities
      • Gas
      • General Manufacturing
      • Mining
      • Mining & Metals
      • Oil & Energy
      • Oil and Gas Discoveries
      • Utilities
      • Water Utilities
      • View All Energy & Natural Resources

      • Environ­ment

      • Conservation & Recycling
      • Environmental Issues
      • Environmental Policy
      • Environmental Products & Services
      • Green Technology
      • Natural Disasters
      • View All Environ­ment

      • Heavy Industry & Manufacturing

      • Aerospace & Defense
      • Agriculture
      • Chemical
      • Construction & Building
      • General Manufacturing
      • HVAC (Heating, Ventilation and Air-Conditioning)
      • Machinery
      • Machine Tools, Metalworking and Metallurgy
      • Mining
      • Mining & Metals
      • Paper, Forest Products & Containers
      • Precious Metals
      • Textiles
      • Tobacco
      • View All Heavy Industry & Manufacturing

      • Telecomm­unications

      • Carriers and Services
      • Mobile Entertainment
      • Networks
      • Peripherals
      • Telecommunications Equipment
      • Telecommunications Industry
      • VoIP (Voice over Internet Protocol)
      • Wireless Communications
      • View All Telecomm­unications

  • Lifestyle & Health
      • Consumer Products & Retail

      • Animals & Pets
      • Beers, Wines and Spirits
      • Beverages
      • Bridal Services
      • Cannabis
      • Cosmetics and Personal Care
      • Fashion
      • Food & Beverages
      • Furniture and Furnishings
      • Home Improvement
      • Household, Consumer & Cosmetics
      • Household Products
      • Jewelry
      • Non-Alcoholic Beverages
      • Office Products
      • Organic Food
      • Product Recalls
      • Restaurants
      • Retail
      • Supermarkets
      • Toys
      • View All Consumer Products & Retail

      • Entertain­ment & Media

      • Advertising
      • Art
      • Books
      • Entertainment
      • Film and Motion Picture
      • Magazines
      • Music
      • Publishing & Information Services
      • Radio & Podcast
      • Television
      • View All Entertain­ment & Media

      • Health

      • Biometrics
      • Biotechnology
      • Clinical Trials & Medical Discoveries
      • Dentistry
      • FDA Approval
      • Fitness/Wellness
      • Health Care & Hospitals
      • Health Insurance
      • Infection Control
      • International Medical Approval
      • Medical Equipment
      • Medical Pharmaceuticals
      • Mental Health
      • Pharmaceuticals
      • Supplementary Medicine
      • View All Health

      • Sports

      • General Sports
      • Outdoors, Camping & Hiking
      • Sporting Events
      • Sports Equipment & Accessories
      • View All Sports

      • Travel

      • Amusement Parks and Tourist Attractions
      • Gambling & Casinos
      • Hotels and Resorts
      • Leisure & Tourism
      • Outdoors, Camping & Hiking
      • Passenger Aviation
      • Travel Industry
      • View All Travel

  • Policy & Public Interest
      • Policy & Public Interest

      • Advocacy Group Opinion
      • Animal Welfare
      • Congressional & Presidential Campaigns
      • Corporate Social Responsibility
      • Domestic Policy
      • Economic News, Trends, Analysis
      • Education
      • Environmental
      • European Government
      • FDA Approval
      • Federal and State Legislation
      • Federal Executive Branch & Agency
      • Foreign Policy & International Affairs
      • Homeland Security
      • Labor & Union
      • Legal Issues
      • Natural Disasters
      • Not For Profit
      • Patent Law
      • Public Safety
      • Trade Policy
      • U.S. State Policy
      • View All Policy & Public Interest

  • People & Culture
      • People & Culture

      • Aboriginal, First Nations & Native American
      • African American
      • Asian American
      • Children
      • Diversity, Equity & Inclusion
      • Hispanic
      • Lesbian, Gay & Bisexual
      • Men's Interest
      • People with Disabilities
      • Religion
      • Senior Citizens
      • Veterans
      • Women
      • View All People & Culture

  • Hamburger menu
  • Cision PRWeb provides efficient communication tools to continuously engage with target audiences across multiple online channels
  • Create a Free Account
    • ALL CONTACT INFO
    • Contact Us


      11AM ET Sunday – 8PM ET Friday

  • Send a Release
  • Sign up
  • Log in
  • Resources
  • RSS
  • GDPR
  • News in Focus
    • Browse All News
    • Multimedia Gallery
  • Business & Money
    • Auto & Transportation
    • Business Technology
    • Entertain­ment & Media
    • Financial Services & Investing
    • General Business
  • Science & Tech
    • Consumer Technology
    • Energy & Natural Resources
    • Environ­ment
    • Heavy Industry & Manufacturing
    • Telecomm­unications
  • Lifestyle & Health
    • Consumer Products & Retail
    • Entertain­ment & Media
    • Health
    • Sports
    • Travel
  • Policy & Public Interest
  • People & Culture
    • People & Culture
  • Send a Release
  • Sign up
  • Log in
  • Resources
  • RSS
  • GDPR
  • Send a Release
  • Sign up
  • Log in
  • Resources
  • RSS
  • GDPR
  • Send a Release
  • Sign up
  • Log in
  • Resources
  • RSS
  • GDPR

Frontline Solvers Brings Big Data to Excel, Links to Apache Spark Clusters, Power BI and Tableau Dashboards
  • USA - English


News provided by

Frontline Systems Inc.

Jul 21, 2015, 03:00 ET

Share this article

Share toX

Share this article

Share toX

Flight Delays by Airport
Flight Delays by Airport

Business analysts who aren’t data science PhDs can easily access Big Data in Excel, and build analytics models to quickly answer key business questions.

Post this

Incline Village, NV (PRWEB) July 21, 2015 -- The newest release of Frontline Systems' Solver products for Excel enables users, for the first time, to ‘pull’ sampled and summarized data into Excel from compute clusters running Apache Spark, the fast-growing Big Data software, and to ‘push’ the results of analytic models into Tableau, the popular data visualization tool from Tableau Software, and Power BI, Microsoft’s new online tool for data visualization. To illustrate what can be done today in Excel, Frontline has published an analysis of 20+ years of airline flight data, paralleling an analysis of the same dataset by HortonWorks using Hadoop, Pig, Python and four related tools.

Frontline's "V2015-R2 prime" release includes its flagship integrated product, Analytic Solver Platform, and its "professional entry-level" integrated product, Analytic Solver Pro. The release also includes new versions of XLMiner Platform, the leading tool for data mining and text mining in Excel; Risk Solver Platform, the leading tool for simulation / risk analysis and stochastic optimization in Excel; Premium Solver Platform, Frontline’s best-selling tool for large-scale conventional optimization; and subset "professional entry-level" products Premium Solver Pro, Risk Solver Pro, and XLMiner Pro. It also brings new power to Frontline's analytic apps for Excel Online and Google Sheets, where Frontline has over 50,000 cloud-based users.

"Now business analysts who aren’t data science PhDs can easily access Big Data in Excel,” said Daniel Fylstra, Frontline’s President and CEO, "and build analytics models to quickly answer key business questions."

Sampling and Summarizing Data from Apache Spark Big Data Clusters

The new release includes a built-in client that ‘talks to’ a Frontline-supplied server program that runs within an Apache Spark cluster, communicating with the Spark master and worker nodes. Business analysts can access Spark data through a simple point-and-click user interface, with no programming expertise in Java/Scala, Python or R required.

By drawing a representative sample of Big Data from all the nodes in the cluster, Excel users can easily train data mining and text mining models directly on their desktops. By drawing summarized data such as sums, counts and averages of certain variables, grouped by other variables, Excel users can obtain just the data they need to drive simulation and optimization models.

Visualizing Analytic Model Results in Tableau and Microsoft Power BI Dashboards

The new release also includes the ability to ‘push’ the results of analytic models -- such as final values of decision variables in an optimization model, key statistics, percentiles and risk measures from a simulation model, or predictions or robustness measures from a data mining model -- directly into either Tableau or Microsoft Power BI, with as little as one button click.

For Tableau, Frontline's software produces Tableau Data Extract (TDE) files, that Tableau Desktop, Server or Online versions can read import directly. For Power BI, Frontline's software communicates directly with the tool's REST API to create datasets in the user's Power BI account, with the user's permission.

With a few more point-and-click steps in either Tableau or Power BI, users can obtain insightful visualizations that simplify communication of results with managers and stakeholders. And it’s quick and easy -- especially with Power BI -- to ask questions, change assumptions, re-run the analytic models and update the visualizations.

Upward Compatible from Excel Solver, works with Excel 2016 Preview

Frontline’s Solvers for Excel are upward compatible from the Solver included in Excel, which Frontline developed for Microsoft. Users can solve problems hundreds to thousands of times larger than the basic Excel Solver, at speeds anywhere from several times to hundreds of times faster, and they can solve completely new types of problems. V2015-R2 prime works with Excel 2016 Preview edition, and will be updated as needed for the final release version of Excel 2016.

With powerful “plug-in” large-scale Solver Engines, including the Gurobi Solver, XPRESS Solver and KNITRO Solver, users can solve linear mixed-integer problems with millions of decision variables, nonlinear problems with hundreds of thousands of decision variables, and many of the largest risk-based stochastic optimization problems that have ever been solved, on any platform.

Publishing Optimization and Simulation Models to Web-based Spreadsheets

In this release, Frontline has further upgraded users’ ability to move from the desktop to the cloud. Since mid-2013, users of Excel Online in Office 365 have been able to use Frontline's Solver app, available free in the Office Store, to solve the same kinds of optimization models handled by the Solver in desktop Excel, that Frontline developed for Microsoft.

With the new release, users can easily publish optimization and simulation models to Excel Online or Google Sheets, and solve them in the cloud with Frontline’s Solver and Risk Solver apps / add-ons – up to the maximum size permitted by their desktop licenses. And they can store their models in Office 365 or SharePoint 2013, OneDrive or OneDrive for Business, or Google Drive.

Behind the scenes, Frontline is now using its powerful, scalable RASON Server and its REST API on Microsoft Azure to solve models for the Solver and Risk Solver apps / add-ons. The RASON Server can be used by other software developers as well – free developer accounts are available at https://rason.com.

Academic Version and Upgrades for Existing Users Available

Users of existing Frontline Solver products can upgrade to V2015-R2 prime at no cost with current Annual Support. Frontline has created a special program to enable faculty members in MBA programs to introduce their students to Big Data with realistic hands-on exercises, without requiring a big investment of money or time, by sharing use of Frontline's Apache Spark cluster on Amazon Web Services. Interested faculty may contact Frontline at academic(at)solver(dot)com.

The Tableau and Power BI clients are included in each of Frontline’s Pro and Platform products. The Apache Spark client is included in Frontline’s four Platform products; with sampling functionality in XLMiner Platform.

Frontline Systems Inc. (http://www.solver.com) is the leader in spreadsheet-based analytics software, helping managers gain insights and make better decisions for an uncertain future. Its products integrate forecasting and data mining for “predictive analytics,” Monte Carlo simulation and risk analysis, and conventional and stochastic optimization for “prescriptive analytics.” Frontline developed the solvers/optimizers in Microsoft Excel, Lotus 1-2-3 and Quattro Pro, distributed to more than 1 billion spreadsheet users. Founded in 1987, Frontline is based in Incline Village, Nevada (775-831-0300).

Daniel Fylstra, Frontline Systems Inc., http://www.solver.com, (775) 831-0300, [email protected]

Modal title

Big Data in Excel
Big Data in Excel
Time of Day Matters Most to Delays
Time of Day Matters Most to Delays
Excel Model Matches Hadoop-based Tools
Excel Model Matches Hadoop-based Tools
Big Data in Excel Time of Day Matters Most to Delays Excel Model Matches Hadoop-based Tools

Contact PRWeb

  • 11AM ET Sunday – 8PM ET Friday
  • Contact Us

About PRWeb

  • About PRWeb
  • Partners
  • Partnership Programs
  • Editorial Guidelines
  • Resources

Why PRWeb

  • Why PRWeb
  • How It Works
  • Who Uses It
  • Pricing

Accounts

  • Create a Free Account
  • Log in
  • Contact Us

Do not sell or share my personal information:

  • Submit via [email protected] 
  • Call Privacy toll-free: 877-297-8921

Contact Cision

Products

About

My Services
  • All News Releases
  • Online Member Center
  • ProfNet
Cision Distribution Helpline
888-776-0942
  • Legal
  • Site Map
  • RSS
  • Cookie Settings
Copyright © 2025 Cision US Inc.