BIRT, which stands for Business Intelligence and Reporting Tools, is an Eclipse-based open-source reporting system for Java and J2EE-based web applications. Including the word "Tools" in the acronym is appropriate, since BIRT is in fact a collection of development tools and technologies used for developing reports utilizing the BIRT runtime framework component on your application server. BIRT isn't essentially a product, but a series of core technologies on top of which products and solutions are built, similar in fashion to the Eclipse framework.
The BIRT Report Designer, which is the most visible and familiar product built with the BIRT framework, is an Eclipse plug-in that utilizes BIRT technologies to allow users to design reports in the BIRT document format.
In this article by John Ward we will create a simple report by first setting up a simple project.Read Creating a Simple Report using BIRT in full
Report Services, Analysis Services, and Integration Services are the three pillars of Business Intelligence in Microsoft's vision that continues to evolve. Reporting is a basic activity, albeit one of the most important activities of an organization because it provides a specialized and customized view of the data of various forms (relational, text, xml etc) that live in data stores. The report is useful in making business decisions, scheduling business campaigns, or assessing the competition. The report itself may be required in hard copy in several document formats such as DOC, HTML, PDF, etc. Many times it is also required to be retrieved in an interactive form from the data store and viewed on a suitable interface, including a web browser. The Microsoft SQL Server 2005 Reporting Services, popularly known by its acronym SSRS, provides all that is necessary to create and manage reports and deploy them on a report server with output available in several document formats. The reader will greatly benefit from reading the several articles detailed in the author's Hodentek Blog. The content for the articles were developed using VS 2003, VS 2005, SQL 2000 and SQL 2005.Read Creating a Simple Report with Visual Studio 2008 in full
In this article by John K. Murphy, author of DotNetNuke 5.4 Cookbook, we will cover the following topics:
- Downloading and installing a skin
- Creating a simple HTML skin
- Creating a simple ASCX skin
In this tutorial by Jonathan Williamson, we are going to examine the process behind creating a text-based logo in Blender. We will be looking at some modeling techniques mixed with several modifiers to create a background for the logo, and then we will move on to creating the actual text. Following that we will set up the lighting and render settings to produce our final image.Read Creating a Text Logo in Blender in full
Plone is a powerful web application used mainly for website content management and comprised of many different, but related Python packages.
In the previous article we have learned how to install themes with Buildout and examine themes with Omelette and Python. Remember, we will not cover theme creation in depth; this is only a sample for site administrators (who may or may not be required to develop themes, in addition to managing their site).
In this article by Alex Clark, author of Plone 3.3 Site Administration , we will learn how to create a theme using the ZopeSkel tool to generate some of the boilerplate code.Read Creating a theme package with ZopeSkel in full
Getting introduced to working with Postgres was described in the recent article, "installation and some basic features of EnterpriseDB". Migration of data from SQL Server 2008 was described in "The migration of a table from SQL Server 2008 to EnterpriseDB". In this tutorial Dr. Jayaram Krishnaswamy shows how you may create a Visual Studio 2008's Windows application to access data on EnterpriseDB. Reading of two previous articles is recommended.Read Creating a VB.NET application with EnterpriseDB in full
MySQL Query Browser, one of the open source MySQL GUI tools from MySQL AB, is used for building MySQL database queries visually. In MySQL Query Browser, you build database queries using just your mouse—click, drag and drop!
When you’re creating a query for non-technical users and you don’t want them to see the complexity of the query, you can create a view from the query. Your users can then use the view as a table; for example, they can double-click the view, which will effectively execute its complex query behind the scene.
In MySQL Query Browser, you have two ways to create a view, which Djoni Darmawikarta will demonstrate in this article:
- From an existing query
- Writing from scratch manually
This article by Bethany Hiitola, author of Getting started with Audacity 1.3, provides some practical instructions to get you started using Audacity to record voice tracks. We will discuss how to actually record the script, save it, and learn some tricks about adding more to an already-recorded voice track, record additional tracks, label and delete tracks.Read Creating a Voice Track with Audacity 1.3 in full
Packt are due to launch a new Enterprise brand, into which future Silverlight titles will be published. For more information on that launch, look here.
In this article by Frank LaVigne, author of Microsoft Silverlight 4 Business Application Development, we shall:
- Create a WCF service and business object for receiving data
- Submitting data to the server
In this two-part article by Francesco Marchioni, we will be developing and configuring web applications using JBoss web container. Most developers have surely gained some experience with web applications. Therefore, we will not cover the basics of web applications; we will rather disclose how easy it can be to create a consistent web layer for your applications, using just the right tools and, of course, the right technique.
We will cover the following topics in more detail:
- What is JSF and how to install it on JBoss AS
- How to create a JSF facade for our pasture application
- How to configure JBoss Web Server
This article by Jayaram Krishnaswamy describes how you may connect to SQL Server 2008 and display the retrieved data in a GridView Control on a web page. Trying to establish a connection to the SQL Server 2008 is not possible in Visual Studio 2008 as you will see soon in the tutorial. One way to get around this, as shown in this tutorial, is to create an ODBC connection to the SQL Server and then using the ODBC connection to retrieve the data.
Visual Studio 2008 Version: 9.0.21022.8 RTM, Microsoft Windows XP Professional Media Center Edition, and SQL Server 'Katmai' were used for this tutorial.Read Creating a Web Page for Displaying Data from SQL Server 2008 in full
The article, Creating a website with Artisteer, helps you develop a good-looking, professional website using Artisteer without the need to learn programming languages. This article by Jakub Sanecki, author of Creating Templates with Artisteer, explains the process of designing templates for websites using Artisteer.Read Creating a website with Artisteer in full
Tables got a bad review in accessibility circles, because they used to create complex visual layouts. This was due to the limitations in the support for presentational specifications like CSS and using tables for layout was a hack—that worked in the real world—when you wanted to position something in a precise part of the web page.
Tables were designed to present data of all shapes and sizes, and that is really what they should be used for.
This article by Joshue O Connor, shows how to build a simple table using Joomla! and the features contained within the WYSIWYG editors that can make the table more accessible.Read Creating Accessible Tables in Joomla! in full
We need an administration interface to manage the content that users post to our website. In fact, the administration interface is a universal feature needed in any web application that stores and manages data. For this reason, Django comes with a fully-fledged administration interface ready to be used. This administration interface is considered one of the coolest features in Django because it's easy to use, yet powerful and flexible.
In this article by Ayman Hourieh, you will learn about:
- Activating the administration interface
- Using the administration interface to manage content
- Customizing the administration interface
- Assigning permissions to users and groups
The administration interface is a universal feature needed in any web application that stores and manages data. For this reason, Django comes with a fully fledged administration interface ready to be used. This administration interface is considered one of the coolest features in Django because it's easy to use, and yet is powerful and flexible. This article is based on the updated version- Django 1.0. The previous article on Creating an Administration Interface was on the older version of Django.
In this article by Ayman Hourieh, you will learn how to:
- Activate the administration interface
- Use the administration interface to manage content
A cube in the context of Business Intelligence is a multidimensional representation of business facts that can be accessed quickly to provide specific information. (This can be accomplished by properly written queries in a relational database, but the overhead involved in processing the query, which may involve a large number of 'joins', is simply not efficient). While a relational model is more suited to OLTP, a different model is necessary for OLAP. Whereas highly normalized tables are a norm for OLTP, the model for OLAP does not require normalization. The SQL Server Analysis Services that supersedes the earlier versions is specifically meant for analyzing data in the archives or in OLTP databases to be retrieved and burnished to provide the 'Intelligence' by mining for facts hidden in the data. This two part article by Dr. Jayaram Krishnaswamy describes how a Cube is designed using Visual Studio 2008 and how it may be browsed on the Analysis Server. In Part 1, the necessary items for creating the Cube, namely the Data Source and Data Source Views are described.Read Creating an Analysis Services Cube with Visual Studio 2008 - Part 1 in full
As noted in Part 1, OLAP presents Business Intelligence via what is known as a CUBE. A Cube has many dimensions and it provides a faster method to access the intelligence compared to the structured querying where the overhead of 'Joins' makes it inefficient. Taking the example of a 'Sales' Cube having everything related to sales we can identify the dimensions as the Sales Outlet, The Customers , the Products and the time period over which sales are being audited or looked into. We also notice that there are certain measures that we are interested related to these 'dimensions' like 'Store Sales', 'Cost of Products, 'number of units sold' etc. The Analysis Services analyzes these intricate relationship that exist in a cube. In this part we will see the process of creating a Cube in VS 2008.Read Creating an Analysis Services Cube with Visual Studio 2008 - Part 2 in full
In web application development, gauges can be useful for showing complicated or dynamic data in a visual or intuitive way. In this article by Sandro Paganotti, author of Designing Next Generation Web Projects with CSS3, we'll learn how to create a fully customizable animated gauge that can respond to real-time changes. We'll also discuss techniques to port this type of widget for support in older web browsers. We'll start by learning about a cool SASS enhancement called Compass; this is another way to deal with CSS3 experimental prefixes. The following is the list of the topics we'll discuss:
A basic gauge structure
Moving the arrow
Animating the arrow
Dealing with older browsers
In this article by Ajit Kumar, author of Sencha MVC Architecture, we will take a step-by-step approach to create a functional application in ExtJS using the MVC architecture and the framework classes related to it. For the sake of completeness and illustration of the concepts, we will be taking up an application requirement and implementing it in ExtJS.
As a requirement, we will be creating an application, which would:
Show the list of departments and the users
Show the list of users for a selected department
Allow the user to edit user information
Refresh the users list to get all the users of all the departments