SourceLogic Solutions Home SourceLogic Solutions - Software Tools

DATA WAREHOUSING

by admin 4/12/2008 6:36:00 PM
  What is a data warehouse?
A data warehouse is a database that is structured in a particular way so that it is very efficient in generating reports. The term data warehouse can mean anything from just the database to the entire application, which includes a tool for viewing reports.

Why do I need a data warehouse?
If you need to be able to look at reports in a flexible and user friendly manner, then you may be interested in a data warehouse. The reports allow you to look at your data by multiple dimensions. So lets say you sell 10 different products and you have 3 brands. You can generate a report very quickly that will show you gross sales and net sales by product by time AND by brand, all in the same report.

Sounds complicated, how difficult is this to use?
The report generator we usually use is Microsoft Excel. There are no special add-ins or additional software to install, just plain Excel. If you are familiar with Excel, then you will be able to start generating reports from a data warehouse very quickly.

How big is a data warehouse?
The size of the database can be as big or as small as your data requirements call for. The great thing about a data warehouse is that it is very scalable. You can start small and grow from there.

What platform is used for the database? 
We have chosen Microsoft as the platform for most of the services we offer. Therefore, in the case of data warehousing, we utilize Microsoft SQL Server and Microsoft Analysis Services as the platform of choice.

I already have a database, can that be converted into a data warehouse?
In most cases, the data warehouse is a separate database that is not intended to be used for other purposes, such as supporting your line of business applications or your website. The structure of the data warehouse database is very different than the structure you probably have in your current database.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Software Tools

Everyone talks about Web 2.0. We give you a plan to implement it.

by admin 4/5/2008 9:58:00 PM

Determining where your application UI will benefit from AJAX

AJAX-powered user interfaces can dramatically improve the user experience of Web-based applications in many different ways. SourceLogic Solutions can review your application and identify where AJAX can offer the most dramatic impact and and best return on investment.

On the lightweight end of the spectrum, you can re-implement basic features of your Web application to be more responsive and offer visual pizzazz (e.g. Google-style "suggest" search box, background content loading, balloon help, tabbed displays, sortable tables, etc). On the other end of the spectrum, rich AJAX clients can replace Web-based portals as a way to interact with Web services and SOA assets (e.g. Enterprise Mashups).

What it takes to succeed with AJAX

It is common to think that the same Web developers who code Java or .NET server-side Web applications or design CSS-based HTML pages, will be able to quickly become expert AJAX developers. The reality is usually very different. The technical skills are are not the same, the UI demands are more complex, the ramp up time can be high and it can be time-consuming to evaluate the various frameworks as they relate to your customer and back-end needs.

SourceLogic Solutions provides you with a UI design and development team that is experienced with a broad range of AJAX component libraries and frameworks, and understands the CSS, HTML and DOM programming necessary for implementation. This gives your team more time to come up to speed, decisions on what AJAX tools to use, a strategy on how to incrementally add AJAX, and a visual blueprint of how the final web application will operate.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Consulting Basics | Software Tools

ECOMMERCE DEVELOPMENT

by admin 3/31/2008 6:33:00 PM

 

 

ECOMMERCE DEVELOPMENT
  Selling products over the internet is no longer a novelty. It's now a basic part of retail business today, and it has allowed for the creation of thousands of "online only" companies, many of whom do not have a physical store anywhere.

When customers visit an ecommerce website, there are certain expectations they have from their experiences with shopping on other sites. Here are some of the features all ecommerce websites should contain:
  • Product Catalog - Including an easy to use heirarchical navigation
  • Search - An ecommerce site must have a robust search engine
  • Shopping Cart - One that saves the contents if the user leaves the site.
  • Secure Checkout - Customers expect to see that little lock at the bottom of the browser window
  • Order Status - Your customers should be able to log onto your site and check the status of their order
And this is just the basics. Here are some of the optional ecommerce features that our clients have asked us for:
  • Complements - This item complements the item you are currently viewing
  • Alternates - When you're out of stock, this is a similar item that is in stock
  • Customers also bought - Other people that bought this item also bought these other items
  • Recently viewed - Keeps track of the items that were recently viewed, but not added to the shopping cart
  • Top sellers - These are items that have recorded the most sales
  • Featured products - Show select products on your home page
  • Sale items - Allow for products to go on sale and change the price for some period of time
  • Coupons - Customers enter a coupon code and get a discount off their order
And the list goes on and on.

Ecommerce development is a large part of our business. Our developers have created ecommerce functionality for some of the largest internet e-tailers and we're ready to help you with your next project.

 

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

E-Commerce | Software Tools

Powered by BlogEngine.NET 1.3.0.0
Theme by Mads Kristensen

About the author

Name of author Author name
Something about me and what I do.

E-mail me Send mail

Calendar

<<  September 2010  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar

Pages

    Recent comments

    Disclaimer

    The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    © Copyright 2010

    Sign in