Aggregated Posts (sorted by date)
Tracking the Nations Bank Failures InfoGraphic
Abstract from Microsoft Business Intelligence Blog (Indexed 2010-03-05):
This is an excellent example of using maps and animation to get the point across on bank failures over time. Look at Washington Mutual up here in the Northwest. Crazy. I still believe JP Chase stole WAMU for the price http...(read more)[Image]
How to build Excel Dashboards 10
Abstract from Dashboards, Applications and Business Intelligence (Indexed 2010-03-04):
Previous – Excel Dashboard Tutorial – 9Cleanup – Resize and OrganizeGive appropriate names to each portlet.During the chart creation if we did not provide names, now is the time to provide them.Right click on each title and click on “Edit” Scale down the Size Note, you can drag the corners of each portlet to resize the frames [...]SHARETHIS.addEntry({ title: "How to build Excel Dashboards – 10", url: "http://www.appsbi.com/how-to-build-excel-dashboar...(truncated)...
How to build Excel Dashboards 9
Abstract from Dashboards, Applications and Business Intelligence (Indexed 2010-03-04):
Previous – Excel Dashboard Tutorial – 8Finish the Dashboard Design and DevelopmentBy now, your dashboard is quite chaotic. You have objects all around your dashboard canvas with different sizes. We will start the process of finishing our design. Before proceeding, we save a copy of the dashboard.Navigate to menu File ‘ Save As Give a name [...]SHARETHIS.addEntry({ title: "How to build Excel Dashboards – 9", url: "http://www.appsbi.com/how-to-build-excel-dashboa...(truncated)...
How to build Excel Dashboards 11
Abstract from Dashboards, Applications and Business Intelligence (Indexed 2010-03-04):
Previous – Excel Dashboard TutorialSummaryWe built the above dashboard completely from scratch.We defined CalculationsWe defined date hierarchiesWe built Date FiltersWe built Date ParametersWe built Bar ChartsWe built Pie ChartsWe cleaned the dashboard layoutNext – Share Excel Dashboard with other Users SHARETHIS.addEntry({ title: "How to build Excel Dashboards – 11", url: "http://www.appsbi.com/how-to-build-excel-dashboards-11" });
How to build Excel Dashboards 12
Abstract from Dashboards, Applications and Business Intelligence (Indexed 2010-03-04):
Previous – Excel Dashboard Tutorial – 11How do you share your Excel Dashboard with users?Now that you have built the dashboard, you can share the dashboard in multiple ways.” Create a PDF output of the dashboard and send as email attachment.Click on the PDF icon on the toolbar as shown below and it will [...]SHARETHIS.addEntry({ title: "How to build Excel Dashboards – 12", url: "http://www.appsbi.com/how-to-build-excel-dashboards-12" });
How to build Excel Dashboards 8
Abstract from Dashboards, Applications and Business Intelligence (Indexed 2010-03-04):
Previous – Excel Dashboard Tutorial – 7Create Pie ChartWe will now create a pie chart by product name It is nice to know that the revenue distribution is not dominated by a single product.We can now change the “Category name parameter” to see the product distribution for other categoryBy Category = BeveragesSummary of steps so far” [...]SHARETHIS.addEntry({ title: "How to build Excel Dashboards – 8", url: "http://www.appsbi.com/how-to-build-excel-da...(truncated)...
Android App Store Is 57% Free Compared to Apple's 25%
Abstract from Microsoft Business Intelligence Blog (Indexed 2010-03-04):
Great analytical charts can tell an interesting story. Check out this article from Gizmodo on Free vs Paid applications from the mobile OS providers. Using the brand icons to represent the company is a great idea. http://gizmodo.com...(read more)[Image]
Excel Infographics
Abstract from Dashboards by Example (Indexed 2010-03-03):
Dashboard Spy Topic: Excel Dashboard Example.Excel dashboard guru Chandoo offers a download of an excellent infographic he created using Excel 2010. Did you know that Excel 2010 has sparklines? Take a look at this awesome excel dashboard done in an infographic poster style.Visit his post to download the excel file: Sachin Tendulkar Statistics [...]a[Image][Image][Image]
How to Create Excel Dashboards 4
Abstract from Dashboards, Applications and Business Intelligence (Indexed 2010-03-03):
Previous Part Build Excel Dashboards – 3We will Add Calculations and FormulasAdd CalculationsSince this is a raw extract of actual transactions, it may need to add additional calculations and columns to create useful metrics.For e.g in our sample file, we have the “Unit Price” and “Quantity” columns. We will create calculation to derive the “Amount” [...]SHARETHIS.addEntry({ title: "How to Create Excel Dashboards – 4", url: "http://www.appsbi.com/h...(truncated)...
How to build Excel Dashboards 6
Abstract from Dashboards, Applications and Business Intelligence (Indexed 2010-03-03):
Previous – Excel Dashboards – 5Create Year and Category ParametersRemember, we have not built any charts yet. It is very important that we build our foundation Qlet and its corresponding parameters so that all of the drop down parameters can be leveraged in the charts.It definitely helps to plan your dashboard development. Since the dashboard [...]SHARETHIS.addEntry({ title: "How to build Excel Dashboards – 6", url: "http://www.appsbi.com/how-to-build-excel-dashboards-6" });
How to build Excel Dashboards 5
Abstract from Dashboards, Applications and Business Intelligence (Indexed 2010-03-03):
Previous Article – Create Excel Dashboards – 4Add Date Hierarchy ColumnsMost of the data, has some form of date information. Now date is very granular information. Very often, to generate trending information, you need to derive year and month columns.In the dashboard designer, you can easily generate Date hierarchy columns for any kind of reporting.In [...]SHARETHIS.addEntry({ title: "How to build Excel Dashboards – 5", url: "http://www.appsbi.com/how-to-build-excel-dashboards...(truncated)...
Cleverbot Fails DataStage Certification Exam
Abstract from Tooling Around on the IBM Information Server (Indexed 2010-03-03):
Cleverbot is a Learning Artificial Intelligence AI software program that cannot learn how to use IBM InfoSphere DataStage. Cleverbot at www.cleverbot.com. I put it through the DataStage Certification sample questions. User: Wh...
IBM Patents The Obvious, The Obtuse and the Brilliant
Abstract from Tooling Around on the IBM Information Server (Indexed 2010-03-01):
IBM is the biggest submitter of US patents and they are a mixed bag of obvious patents, confusing patents and genuine inventions.
Upgrading PerformancePoint Server 2007 to PPS 2010
Abstract from The Microsoft PerformancePoint Team Blog (Indexed 2010-02-25):
Most of the customers who have been using PerformancePoint Server 2007 have accumulated several months, if not years, worth of dashboards and data. Their KPIs, grids, charts, scorecards, and custom objects have gone to good use, providing a great deal...(read more)[Image]
How to build Excel Dashboards 3
Abstract from Dashboards, Applications and Business Intelligence (Indexed 2010-02-23):
Previous step : Excel Dashboards – 2Create Dashboard and Table portletOnce connected, it will show you a list of action items to pick fromWe will click on “New Blank Dashboard“In the Dashboard Name, we type in “Order Management Analytics”Click OK.It will present you with a table browser showing all the available worksheets as tablesExpand the [...]SHARETHIS.addEntry({ title: "How to build Excel Dashboards – 3", url: "http://www.appsbi.com/how-to-build-excel-da...(truncated)...
iDashboards Winter Olympics Dashboard
Abstract from Dashboards by Example (Indexed 2010-02-22):
Dashboard Spy Topic: 2010 Winter Olympics Scorecard from iDashboards.The dashboard gurus at business intelligencedashboard software vendor, iDashboards, are continuing their tradition of helping fans of the Olympic Games track the medal counts of the competing countries.Take a look at this dashboard screenshot. Use this link totry out the interactive iDashboards Winter Olympics Dashboard for [...]a[Image][Image][Image]
How to build Excel Dashboards 2
Abstract from Dashboards, Applications and Business Intelligence (Indexed 2010-02-22):
Previous Step: Excel Dashboards – Part 1Launch Dashboard Software and ConnectLaunch InfoCaptor Dashboard Software on your Desktop and click on the connect button on the toolbarThe connection wizard has items that simplify connecting to different data sources.For Excel Files, Click on the Excel buttonOnce you click, it automatically selects the appropriate Driver for youClick on [...]SHARETHIS.addEntry({ title: "How to build Excel Dashboards – 2", url: "http://www.appsbi.com/how-to-bu...(truncated)...
How to build Excel Dashboards 1
Abstract from Dashboards, Applications and Business Intelligence (Indexed 2010-02-22):
Databases are often under lock-n-key of the IT Department and not possible to connect directly due to security reasons. So if you plan to build a Dashboard prototype or a Dashboard Mockup it makes sense to export the data to Excel and build it.Modular Dashboard DesignLot of the online tutorials and Dashboard e-books teach you [...]SHARETHIS.addEntry({ title: "How to build Excel Dashboards – 1", url: "http://www.appsbi.com/how-to-build-excel-dashboards-1" });
What can the Wall Street Journal teach us about information graphics?
Abstract from Visual Business Intelligence (Indexed 2010-02-22):
A new book about information graphics was published last month titled The Wall Street Journal Guide to Information Graphics, by Dona M. Wong, the graphics director for this respected newspaper. I get excited whenever a new book about data visualization is published, especially one that teaches practical techniques, because too few of us are working [...]
Products and Pricing for IBM Information Server on the Amazon Cloud
Abstract from Tooling Around on the IBM Information Server (Indexed 2010-02-19):
An IBM Developerworks newsletter has the details and links to pricing for running DataStage and QualityStage on the Amazon elastic cloud. T