In 2009, the U.S. Federal Budget Deficit was soaring. Since 2008, it had climbed over 308% to a whopping $1.4 Trillion. Fortunately, the following 5 years saw steady declines and the gains from 2008-2009 have been nearly wiped out. The total United States Federal Budget Deficit for 2014 was $483.4 Million, which was just a little over 5% higher than the budget deficit of 2008 when it was $458.6 Million.

Continue reading

The 2015 Reese’s Senior Bowl will be played on January 24th, 2015 at Ladd-Peebles Stadium in Mobile, Al. The game showcases the best NFL prospects of the collegiate players who have completed their eligibility.

All of the players who have been invited and accepted are represented on the map below according to their hometown. The map can be filtered by which squad the player is on, team they played for, conference their team belonged to, and/or their state of residence. There are also some charts below the map showing totals for conference, team, and state of residence. When a selection is made from one of the top menus or directly on the map, the charts below will automatically update to reflect your selection.

Continue reading

Earthquakes in the United States are quite common in some areas and virtually non-existent in others. Most of them are relatively tame. However, occasionally some earthquakes occur that cause significant damage. Fortunately, the United States Geological Survey keeps records of every earthquake worldwide.

There are a surprising large number of earthquakes in the United States everyday, and if the past 30 days is any indicator, the state of California gets approximately 60% of them. Between December 23, 2014 and January 22, 2015, the state of California had a total of 3,057 earthquakes. In contrast, the remaining 47 states of the lower 48 combined for just 2,040 earthquakes.

Continue reading

Super Bowl 49

The NFL Playoffs for 2014-2015 are in the books and Super Bowl XLIX (49) will see the New England Patriots vs the Seattle Seahawks.

I thought it would be interesting to see which conference(s) contributed the most players to this game. So, I acquired some player data from ESPN and began doing some simple analysis.

The first thing that I noticed is that there is not one single conference that is providing the most players. There is, in fact, a three way tie at the top between the BIG 10, the PAC 12 and the SEC. All three conferences each have 18 former players that will be playing in the Super Bowl. With a total of 106 active players on the rosters of the Patriots and Seahawks, these three conferences alone are providing nearly 51% of all the players.

Continue reading

Movie prices are not as expensive as you think

According to a new report out today from accounting firm Pricewaterhousecoopers, 53% of consumers admit to avoiding the movies at least once during 2014 due to high ticket prices. Total box office receipts in 2014 were down 5% from 2013. The average ticket price was down, as well – from $8.24 to $8.12.

Even though the report cites high prices, I believe that the reason for declining ticket sales is a lack of value being presented to potential moviegoers. Hence, the second most cited reason – “Movie genre/themes/titles not as interesting to me”. Any time a product is not worth the price, most consumers will communicate this as the price is too high instead of saying that product is not worth the price.

Also, when looking at historical movie ticket price data, ticket prices haven’t increased significantly after adjusting for inflation. The highest average ticket price since 1980 was $8.54 in 2010, but to find the second highest average ticket price you have to go all the way back to 1988. The average ticket price for that year was $8.20 (in 2014 dollars). The interactive chart below, shows the average movie ticket price for each year since 1980 along with the average movie budget for the same years. Both metrics show a steady trend upwards, but nothing dramatic.

Another item of interest is the average movie budget for 1997 was a whopping $61,145,370, which is nearly 65% more than 2014.

Data source: Box Office Mojo
My excel data file.

Bangalore, India (PRWEB) December 23, 2014

Jigsaw Academy, India’s leading online school of analytics and MISB Bocconi, the first and only offshore presence of the Bocconi University, Milan, Italy have announced the launch of the Executive Program in Business Analytics (EPBA) – Big Data Analytics for Professionals. The 10 month executive program will be India’s first long-term course that blends general management with Big Data and Business Analytics and is scheduled to start 21 March 2015.

The program focuses on giving participants an understanding of predictive modeling, data mining, big data analytics, marketing, operations and risk analytics, among other analytics areas. On program completion, participants will be capable of data driven decision making and leadership in industries such as retail, finance, telecommunications, healthcare and manufacturing.

“Business analytics is gaining prominence as a must-have competency in many professions today, with more and more organisations building Big Data and analytics practices internally. Though many business analytics courses have been launched across the country, the problem is that most of these courses look at traditional techniques and business analytical tools. There is an unserved need in the market for an executive program which enables working professionals to learn conventional analytics tools and Big Data techniques, which prompted us to partner with a reputed university like MISB Bocconi to develop the EPBA program. This program is aimed at the busy working professional, for whom time is a premium, and who is keen to gain a competitive edge with professional learning in business analytics”says Gaurav Vohra, CEO, Jigsaw Academy.

“The USP of the course is that it includes renowned international faculty from SDA Bocconi in Milan, Italy, together with analytics and Big Data experts from Jigsaw Academy,” adds Gaurav.

“With our courses at MISB Bocconi, we aim at helping our participants with developmental skills and trainings pertinent to the demands of the market.” says Himanshu Rai, Dean of MISB Bocconi. “Bocconi has been shaping leaders for several decades all over the world. Through this program MISB Bocconi continues this tradition and strives to create leaders who understand analytics and can use it strategically to transform their organizations. To ensure this, the program will be delivered by the world class faculty of Bocconi, which is adept at addressing issues faced by the industry, corporates, public sector and government services”. he added.

The program involves 120 hours of in-person training to be held over six (6) three-day modules at the MISB Bocconi campus in Powai, Mumbai. In the interim, Jigsaw Academy will also conduct twenty (20) live online classes of three (3) hours each for a total of 60 hours which participants can attend from their home, office or any other convenient location using an Internet connection. In addition to the live online and in-person classes, participants will also have access to over 100 hours of pre-recorded video lectures on data science and Big Data analytics for a period of 12 months.

Learning hours are supplemented by round-the-clock, unrestricted access to the Jigsaw Lab, a cloud-based analytics tool and content library that allows participants to gain hands-on competence with the most in-demand analytics tools and technologies in the industry, including SAS, R and Hadoop. The corresponding data science toolkit is designed to augment participants’ practical exposure to these tools.

The program is priced at Rs. 3,60,000 which includes tuition fee, learning materials and one-year access to the Jigsaw Lab.

About MISB Bocconi

MISB Bocconi, located in Mumbai, is the world’s only offshore presence of Università Bocconi, one of Europe’s premier universities.MISB Bocconi offers Post-Graduate program in Business and Executive Education, designed and taught by the faculty of SDA Bocconi, Milan, Italy.

SDA Bocconi, the management school of Università Bocconi, is one of the select business schools world-wide to have received, for its MBA program, all three of the prestigious international accreditations—AACSB (Association to Advance Collegiate Schools of Business), EQUIS (European Quality Improvement System), and AMBA (Association of MBAs).

MISB Bocconi’s key differentiator lies in the wide-ranging practical and academic expertise of the SDA Bocconi faculty; pro-active learning pedagogies include industry interaction, job-oriented internships, and projects to prepare students for global leadership. International exposure is integral to the program through the dual-campus student exchange between Milan and Mumbai and immersion across three continents.

About Jigsaw Academy

Jigsaw Academy, the online school of analytics, has trained over 10,000 students across 20+ countries in the most widely used industry-relevant data analytics tools and techniques. Our founders have over 25 years of combined experience in consulting and analytics across multiple industry verticals in India and the United States.

Our vision of offering an industry-relevant curriculum has led to innovative partnerships with leading academic institutions such as SDA Bocconi in Milan, Italy, Great Lakes Institute of Management in Chennai, and the Indian Institute of Management in Bangalore. As our award winning courses are well recognized in the industry, Jigsaw is the approved analytics training partner for many large organizations, including Accenture, Infosys, and Genpact.



Mail: info(at)jigsawacademy(dot)com

Phone: +91-9243522277

More Data Science Press Releases

New York, NY (PRWEB) January 05, 2015, inc., an artificial intelligence company, today announced that it has secured $ 9.2 Million in a Series A Financing led by FirstMark Capital, with participation from IA Ventures, Softbank Capital and Pritzker Group Venture Capital. The investment will expand data and science efforts towards fully emulating a human scheduling negotiation.

“We believe passionately that the time for AI-Driven companies like has come,” said Matt Turck, Partner at FirstMark Capital. “Dennis and the team are executing on a very ambitious plan which might well change the paradigm for how the vast majority of professionals around the world schedule meetings.”

“ is the first and only company to solve the problem of scheduling meetings in a scalable yet humanistic way. Their breakthrough approach is the future of human computer interaction — and the overwhelming response from users since we first invested bears this out.” – Brad Gillespie, Partner at IA Ventures.’s customers talk to Amy (or Andrew) ingram as they would to any other person – and they can have her do all the tedious email ping pong that comes along with scheduling a meeting. It requires no sign-in, no password, no download; all they do is CC: amy(at)x(dot)ai.

“Amy feels like the future. Even more than Siri and Google Now, she seems seamlessly human and as effective as a real person doing the same task.” – CBS News is democratizing access to a service previously available to a select few – a goal so dramatic that only a machine driven solution and a free or negligible price point will ever make possible. is currently looking for some of the best and brightest Data Scientists, Data Engineers, and Backend Engineers. For a chance to be the arbiter of time, head over to

About, inc. was founded in 2014 by former Visual Revenue (Predictive Analytics software acquired by Outbrain) CEO Dennis R. Mortensen and his co-founders Alex Poon, Matt Casey and Marcos Jimenez. The wider founding team members are industry veterans from analytics, big data, and the predictive modeling world.

For more details on, inc. visit the corporate website at, email hello(at)x(dot)ai or simply see ‘how Amy schedules your meetings‘.

More Data Science Press Releases

(PRWEB) January 04, 2015

Global marketing analytics software market to grow from $ 1.20 billion in 2014 to $ 2.10 billion by 2019, at a CAGR of 11.84%. In terms of regions, NA is expected to be the biggest market in terms of market size, whereas LA and Europe are expected to experience increased market traction, during the forecast period. The marketing analytics market is setting a positive market trend. It provides various benefits such as increased customer traffic, less time to create awareness of new products and services, and better manageability of online marketing program. The marketing analytics software offers an increased capability of solution to handle more number of customer transactions.

One of the major forces that are driving the marketing analytics software market is the increasing trend of traffic analysis on the online marketing activities. The marketing analytics software is becoming an integrated component in most business organizations. It is currently an essential feature for customer’s experience on online marketing activities and also changes the way in which enterprises deals with partners and suppliers as well as empowers their workforce with access to information and services.

Complete report is available at .

The major restraints in this market are installation cost of marketing analytics software and easy availability of open-source solutions. These are the major factors which are restricting the growth of marketing analytics software market. Besides, there are a few challenges that are lack of awareness about marketing analytics software, lack of system integration in order to deploy the software, and lack of skilled labours to operate marketing analytics software.

Companies profiled in marketing analytics software market research report are Adobe Systems Incorporated, Accenture, IBM, Oracle, Wipro Limited, Experian, Harte-Hanks Inc, Pega-System, SAS Institute Inc., and Teradata Corporation.

Order a copy of this report at .

The report will help the market leaders/new entrants in this market in the following ways:

    This report segments the market into application in marketing methods, deployment modes, and end users comprehensively. The report provides the closest approximations of the revenue numbers for the overall market and the sub segments. The market numbers are further split across the different verticals and regions.
    This report will help in better understanding of the competitor and gain more insights to better position one’s business. There is a separate section on competitive landscape, which includes competitor ecosystem and competitor portfolio comparison. Besides, there are company profiles of top ten players in this market. In this section, market internals are provided that can put one ahead of the competitors.
    The report helps in understanding the pulse of the market. The report provides information on key market drivers, restraints, challenges, and opportunities.

Priced at US$ 4650 for a single user PDF, a discount on this research report can be requested at .

Browse Similar Reports:

“Customer Analytics Market by Solution (Data Management/ ETL, Analytical Tools/ Modules, Voice of Customer, Social Media Analytical Tools, Web Analytical Tools, Dashboard and Reporting) – Global Forecasts and Analysis (2014 – 2019)” is a Dec 2014 publication of 139 pages and it says customer analytics market to grow from $ 1,623.2 million in 2014 to $ 4,054.9 million by 2019. In terms of regions, North America and Europe are expected to be the biggest markets in terms of revenue contribution, while Asia-Pacific, Middle East and Africa, and Latin America are expected to experience increased market traction, during the forecast period. Companies profiled in this research report are Actuate Software Corporation, Angoss Software Corporation, Fair Isaac Corporation (FICO), International Business Machine (IBM), Oracle Corporation, Pitney Bowes Inc., SAP AG, SAS Institute Inc., Teoco Corporation, and Verint System Inc. Complete report available at .

“Retail Analytics Market by Business Function (Marketing and Customer, Merchandizing and In-store, Supply Chain, Strategy and Planning), & by Solutions (Analytical Tools, Mobile Applications, Reporting Tools) – Worldwide Forecasts and Analysis (2014 – 2019)” is a Aug 2014 publication of 180 pages and it says retail analytics market is estimated to grow from $ 1.88 billion in 2014 to $ 4.40 billion in 2019, at a Compound Annual Growth Rate (CAGR) of 18.6% from 2014 to 2019. Geographically, North America is expected to be the biggest market in terms of revenue contribution while Latin America (LA) and Asia-Pacific (APAC) are expected to emerge rapidly in this market with high CAGRs for 2019. Companies profiled in this research report are Adobe Systems, Angoss Software, Experian, IBM, Microsoft Corporation, Microstrategy, Oracle, SAP, SAS Institute, and Tableau Software. Complete report available at .

“Telecom Analytics Market by Software Applications (Customer, Network, Market, Price, and Service Analytics), by Hardware Type (Servers, Storage, Network Equipment), and by Service Type (Implementation, Training & Support, Consulting) – Global Forecast to 2019” is a Oct 2014 publication of 160 pages and it says global telecom analytics market to grow from $ 975.2 million in 2014 to $ 4,296.6 million by 2019, at a CAGR of 34.5%. In terms of regions, NA is expected to be the biggest market in terms of market size, while Europe and Asia-Pacific (APAC) are expected to experience increased market traction, during the forecast period. Companies profiled in this research report are EMC Corporation, Oracle Corporation, IBM Corporation, SAP AG, Microsoft Corporation, CISCO Systems, Inc., Accenture Plc, Hewlett-Packard Company, Teradata Corporation, and Wipro Limited. Complete report available at .

About Us:

RnR Market Research library offers syndicated reports by market research publishers from across the globe. We help you find the most relevant business intelligence from ready-to-buy syndicated market research studies. Not limited to industry reports covering telecommunication, healthcare, pharmaceutical, financial services, energy, technology, real estate, logistics, F&B , media and more, RnR Market Research also offers company data, country profiles, trends, information and analysis on the sector of your interest. ( ).

Find More Tableau Press Releases

Interactive Map of all Federally Declared Disasters

The Federal Emergency Management Agency (FEMA) was created on April 1, 1979 via an executive order by President Jimmy Carter. FEMA’s mission is to support the United States’ Citizens and first responders. The Federal Emergency Management Agency coordinates the federal government’s role in preparing for, preventing, mitigating the effects of, responding to, and recovering from all domestic disasters, whether natural or man-made, including acts of terror.

FEMA keeps a list of all of the federally declared disasters on its website. The list is called the ‘FEMA Disaster Declarations Summary‘ and goes all the way back to the first disaster declaration in 1953.

Below is a data visualization that includes an interactive map of all the data from this dataset. First, I want to give a brief explanation of some of the terms in the data. There are four programs that are available to be used in relief efforts – IH Program, IA Program, PA Program, and the HM Program.

  • IH Program – denotes whether the Individuals and Households Program was declared for this disaster.
  • IA Program – denotes whether the Individual Assistance Program was declared for this disaster.
  • PA Program – denotes whether the Public Assistance Program was declared for this disaster.
  • HM Program – denotes whether the Hazard Mitigation Program was declared for this disaster.

You are viewing this page on a small screen. While the interactive map is fully functional, your ability navigate may be limited due to the small screen.

excel tutorial

I am a big fan of Microsoft Excel. Between my day job and getting data ready to post on this website, I usually spend approximately 30 hours a week performing data cleaning, formatting, and analysis with Excel. It is hands-down the best spreadsheet program available. However, I do have one huge pet peeve with the program and that is how it handles numbers that have hyphens between them. The default in excel is to turn these numbers into a date. For instance, if you enter “4-10” into a cell, it is automatically turned into “10-Apr”.

After entering "4-10" to an excel cell, it is automatically converted to a date.

When you enter “4-10”

Hyphenated number "4-10" was automatically converted to a date "10-Apr" by Excel.

Excel changes it to “10-Apr”

According to Microsoft, this is a feature of the program where it is attempting to anticipate what you are trying to do. That’s really useful, unless you aren’t really trying to enter a date and actually want the hyphenated numbers.

There are actually three different solutions to this problem. Unfortunately, one of those solutions does not include going to the settings and unchecking a box to turn off this ‘feature’.

Stop Excel Auto Format to Date by Changing the Cell Format:

Probably the simplest way to stop this irritating problem is to simply change the formatting of the cell or cells before you enter the hyphenated numbers. Any cells that are pre-formatted as text will keep the numbers hyphenated as they are entered. You can do this by choosing the formatting drop down menu from the home tab, or by right clicking the cell, choosing format, then clicking on text under the number tab.

Another option is to enter an apostrophe in the cell before entering the hyphenated numbers. After pressing enter, the apostrophe disappears and the cell is automatically formatted as text.

Both of these solutions work perfectly if you are manually entering the data into the spreadsheet. A scenario that I find myself in much too often is that I have a text file with delimited data that I need to open in excel. If the data includes hyphenated numbers, they will be converted to dates automatically when the file opens. There is no conventional way to change the formatting of the cell(s) to text before the file opens.

Fortunately, there is one way to change the formatting of cells in this scenario. We can use the text import feature. It is found under the data tab, in the ‘get external data’ section. Just click on it and browse to your text file.

Use the text import feature of Excel to change the formatting of cells before opening a file.

Use the text import feature of Excel to change the formatting of cells before opening a file.

Choose the file that you want to import, then click open. Then the ‘text import wizard’ will open. Make sure ‘delimited’ is selected and click next.

Text Import Wizard 1

On step two, you need to choose what character is dividing the columns in your data. In my case, it is commas. When you have made the correct selection, the preview window will show how your data will be divided like my example below. When you have the correct delimiter(s) selected, click next.

Text Import Wizard 2

In step three, we will choose the format of each of the columns. For most of the data, the ‘general’ format works just fine. We need to be sure to click on the column where the hyphenated data resides and change the format to ‘text’. When done, click ‘finish’ to exit the wizard.

Text Import Wizard 3

After exiting the text import wizard, Excel will ask you where you want to put the data. Usually cell ‘A1’ works just fine. Click ok and your data appears in the spreadsheet with hyphenated numbers that have not been converted to dates.

Text Import Wizard 4