Presenting Real-time Google Analytics Data in PowerPoint: Live Charts, Lesser Heartburn, Greater Accuracy

Presenting Real-time Google Analytics Data in PowerPoint: Live Charts, Lesser Heartburn, Greater Accuracy

What does an SEO agency gearing up for a client review, an advertiser trying to showcase media to potential buyers, a business head trying to prove his worth to an investor, and an  in-house analyst trying to streamline ecommerce operations have in common? The heartburn of having to put together a meaningful story from the exhaustive data in their Google Analytics account. First, pulling out the right information and tying it together in a neat presentation for the report is at least a half day’s work (on a good day). And since website information changes rapidly, the report could get obsolete before it even gets presented. And finally, the routine of pulling out fresh data, exporting it to Excel to run some numbers and putting that back into PowerPoint is just downright boring.

But what if you did not have to do any of this? If you could just create your presentation once and have it updated in real-time? Sounds unbelievable, right? In this post we’ll show you how oomfo can ensure that your analytics presentations are always up-to-date, every time!

5 months ago

What does an SEO agency gearing up for a client review, an advertiser trying to showcase media to potential buyers, a business head trying to prove his worth to an investor, and an  in-house analyst trying to streamline ecommerce operations have in common? The heartburn of having to put together a meaningful story from the

Read more by Hrishikesh Choudhari October 2, 2011 Tutorials
Create live charts in PowerPoint from SalesForce – Revenues, forecasts and more

Create live charts in PowerPoint from SalesForce – Revenues, forecasts and more

Before every week’s sales performance review with your manager, you need to present your SalesForce numbers in the best light possible. You go to your SalesForce account, set some filters and run a report on those filters. Then you export it as an Excel document and import the data in PowerPoint. Finally, you create charts to suit to the meeting’s agenda. You do this boring and time-consuming task every Friday, before your weekly meeting. Haven’t you had enough of it? Don’t you think you spend more time creating reports and charts, and less time actually selling?

6 months ago

Before every week’s sales performance review with your manager, you need to present your SalesForce numbers in the best light possible. You go to your SalesForce account, set some filters and run a report on those filters. Then you export it as an Excel document and import the data in PowerPoint. Finally, you create charts

Read more by Hrishikesh Choudhari August 24, 2011 Tutorials
Create live charts in PowerPoint with Twitter Analytics data

Create live charts in PowerPoint with Twitter Analytics data

You have been creating charts in PowerPoint for a long time. You create a presentation, insert a chart, write or copy-paste the data into spreadsheet, customize some settings and you are done. And, it has worked perfectly for you till now. Hasn’t it?

6 months ago

You have been creating charts in PowerPoint for a long time. You create a presentation, insert a chart, write or copy-paste the data into spreadsheet, customize some settings and you are done. And, it has worked perfectly for you till now. Hasn’t it

Read more by Hrishikesh Choudhari August 18, 2011 Tutorials
Create your own animation style for any chart element

Create your own animation style for any chart element

All the charts in oomfo are animated and have been known to create a great first impression. But that’s not all. Using the Styles feature in oomfo, you can effortlessly create your own animation styles and apply them to any chart element. Your caption can fade in to visibility, the axis labels can travel across the chart and the divisional lines scale up to size. In this post, we will take a detailed look at creating two different animation styles – an elegant one for the column chart and a jazzy one for the line chart.

Creating an elegant animation for the column chart

The definition of elegance varies from person to person. For me, it is scaling the divisional lines at the back of the chart horizontally to their full size. This, of course, is in addition to the default animation the chart has.

First up, create a simple column chart. Click on the Insert chart button in the oomfo ribbon to bring up the oomfo chart builder. Go ahead and select the 2D column chart.

We will stick with the default data itself for the chart, and head straight to the Chart Cosmetics tab to create the animation style. The custom animation, as I pointed out earlier, is created using the Styles feature of oomfo. In the bottom part of the Chart Cosmetics tab, you will see the heading Customize Individual Chart Elements with icons to create, apply and edit styles. This is going to be your bread and butter for all types of custom animation and styles. Click on Create Styles to get started.

9 months ago

All the charts in oomfo are animated and have been known to create a great first impression

Read more by Sanket May 19, 2011 Tutorials
Make your charts match the PowerPoint theme in seconds

Make your charts match the PowerPoint theme in seconds

Your presentations don’t just convey information, they convey your personality too. You could keep it simple, add a touch of elegance or completely jazz it up! And whatever personality your presentations are conveying, wouldn’t you want your charts to convey that too? Yes sir. With the latest addition to oomfo, you can now match the charts to your PowerPoint theme in seconds. In this post, you will see how you can do this in a step-by-step example.

To start with, chose a theme for your presentation. I chose the Median theme because it looks elegant, thus conveying my personality

10 months ago

Your presentations don’t just convey information, they convey your personality too. You could keep it simple, add a touch of elegance or completely jazz it up!

Read more by Sanket May 17, 2011 Tutorials

Export PowerPoint slides as web pages

Many a times, you need to export your PowerPoint presentations as web pages and put them out for the world to see. PowerPoint recognizes this need and provides you with fairly comprehensive export options, but they come with their own set of problems. In this post, we will take a look at how they work and the issues you will face. We will also take a look at a new approach to exporting slides – using oomfo. Yes, using oomfo you can export your slides to web pages, one at a time, whether they contain the oomfo charts or not.

Exporting slides to web pages using PowerPoint

We will take a look at the two options PowerPoint provides to export slides as web pages. I will be using PowerPoint 2007 to take you through the post. PowerPoint 2003 provides the same options as well but PowerPoint 2010 does not have the export options at all.

I have created a sample PPT using a readymade theme.

I know the title of the presentation is not the most ideal way to get started but then we have a different agenda here, don’t we?

To export the presentation, we will head to the Save As option in the Office button. Go to Save As > Other Formats.

10 months ago

Many a times, you need to export your PowerPoint presentations as web pages and put them out for the world to see. PowerPoint recognizes this need and provides you with fairly comprehensive export options, but they come with their own set of problems. In this post, we will take a look at how they work

Read more by Sanket May 14, 2011 Tutorials

Previous Posts