10 Powerful Uses of FreeSight
FreeSight is so versatile and flexible it would be hard to list all possible uses. Here are ten hugely powerful and real examples of what our customers do with FreeSight, often as an alternative to spreadsheet data processing and reporting. Click on the headers below for more detail...
Read More Regulatory Reporting and Reconciliation to GL – for a large Bank
Financial Institutions are frequently faced with new regulations requiring new reporting of their transactions, assets, liabilities, etc. In one case, our customer had to comply with quarterly reporting that requires them to gather data from dozens of diverse sources, process currency conversions, apply complex data conversion rules, and produce reports...
Read More Financial Reporting – for a large international Bank
Through growth and acquisition, a large international bank has multiple transaction processing systems located in different locations across multiple countries. Daily transactions might take place in any of multiple currencies – with currency exchange rates or interest rates changing daily. Aggregating all transactions from multiple source systems...
Read More Database Querying, Charting and Reporting – for a large Law Firm
As one of the services it provides to its corporate clients, this law firm looks at individual companies’ practices and performance, and compares these to other companies within their industry vertical, market cap, or any other set of criteria as may be defined on an ad hoc basis...
Read More Data Integration of Multiple Sales Files – for a large Telecommunications Company
A telecom company sells products through 3rd party retail locations across the country. For all types of sales analysis purposes, every week each location sends a sales report to corporate headquarters, which is merged with all types of other corporate data for analysis. Scores of files are sent to...
Read More Mutual Fund Performance Reporting – for a mid-sized Mutual Fund Company
Every quarter a performance report is created for each mutual fund managed by the company. The report has multiple pages of charts and tables that compare performance against all kinds of metrics, including industry averages for this type of fund, year-to-date and year-over-year results, fund composition, top holdings etc...
Read More Accounting Forecast Revisions and Comparisons – for a mid-sized Non-Profit Organization
The Finance Manager of this organization was looking for more data analysis and reporting flexibility than their accounting software (Sage 300) could easily or inexpensively accommodate. In this situation, the organization regularly looks at multiple versions of forecasts – the original projections, compared against quarterly updates, or...
Read More Cleaning Dirty Data for Analysis – for a mid-sized Manufacturing Company
The Controller of a manufacturing company receives a report exported from their ERP system. It arrives as a .txt file that is easy enough to read for a human (even though it contains 10’s of thousands of rows), but when he tries to analyze the information he finds that the...
Read More Data Cleansing for Research Study – for a top Canadian University, Academic Research Paper
A research project required analysis of over one million data observations that originated from several different sources. These needed to be joined and cleaned up i.e. the data was not always consistent in spelling, format, layout, etc. After the data was joined and cleaned, it would need to be analyzed...
Read More Product and Customer Analysis – for a small Medical Products Company
Every company needs to do analyses of their customers and their product sales. The question is, how easy it is to aggregate and integrate all of the necessary data into a master table for reporting and ad hoc queries? “One of the guys from the Marketing...
Read More Combining and Cleaning Customer Data from 3 Systems – for a small Non-Profit Organization
The administrator of an NFP organization manages their donor database in Raiser’s Edge, a popular data management software application for fundraisers. They also use another software package, Constant Contact, to capture information about people participating in various events and marketing campaigns. A third set of data comes from online...
Read More Bridging the Gap Between End-User Computing and IT Governance
Why is end-user computing such a problem for IT? Data integrity, audit trail, spreadsheet governance, process control, security… The answer contains a long list. IT needs controls and systems in place to ensure proper governance and auditability over sensitive corporate data. Enterprise-level...
Read More User-Friendly and Self-Service Business Intelligence
“My enterprise BI system is great but my team still works with spreadsheets on their PCs to analyze data and create reports. Clearly it’s not meeting all of the team’s needs.” (more…)...
Read More What’s the difference between a Pivot Table and FreeSight Analysis Table?
Pivot Tables and FreeSight Analysis Tables are both created to summarize or filter selected subsets of your data into easy-to-read tables. One key difference is that an Analysis Table can be a stand-alone report like a pivot table, or it can be one of many steps in...
Read More YTD and Other Rolling Time-Series Data Analyses Made Easy
You’re giving a presentation and your boss asks, “How did we do against last quarter, and this time last year?”, and “Let me see that as a percentage difference”, or, “Let me see those numbers by month instead of quarter”. Of course, you are asked for the one metric you...
Read More Data integration, the joining of multiple data files, is easy in FreeSight!
Using most data tools, data integration requires one of either “copy and paste”, matching field tabs or column headers, consistent file formats, or some type of scripting or programming. In FreeSight, it’s just “drag and drop”… I recently did a search on how to merge multiple data...
Read More Pivot Tables Made Simple and Flexible
Isn’t there an easier way to work with pivot tables? Summarizing data by using pivot-tables is a hugely powerful spreadsheet innovation. But if it were easy and intuitive to do, then more people would do it. There are thousands of websites, books, courses and seminars, and independent...
Read More Avoiding Spreadsheet Hell
Have you ever found an error in your work well into your analysis and had to retrace and then redo all of your work? Have you ever come back to your work a few days later, having forgotten exactly how you got to where you are? (more…)...
Read More Easier than VLOOKUP?
FreeSight’s patented “join” technology replaces spreadsheet VLOOKUP functions entirely. Creation and use of Reference Tables to connect, join and update data is simple and seamless in a FreeSight model. Easier to show you… (more…)...
Read More I spend so much time cleaning my data…
…and formatting reports that I don’t have enough time to thoroughly analyze the data and do ad hoc queries. What if I could turn that ratio around – spend less time cleaning and more time in the analysis? That is the point of FreeSight…...
Read More