The Next-Generation DSR

CPGs have had access to Point of Sale (POS) data now for many years and many of them use a Demand Signal Repository (DSR) to gather, clean and report on this data.  (Actually most of them use a number of DSR's and even when they do have just one, still can't handle truly cross-retailer analytics).  

I've been involved with a number of these systems as a software-buyer, a system-administrator, consultant and most recently, leading the analytic development at Orchestro.  

There are some excellent tools available and, in their current form, they can help you drive both additional revenue and reduced costs when used well.  However, in my experience many of these tools have been sold in under the guise of "saving time" through reporting automation.  That's valuable, but it's not "finding a new sales opportunity" valuable.

I think we are still in the infancy of DSR development: systems are operating at the limits of the technology they were built on and necessary trade-offs mean that being good at one thing (e.g. speed) makes it more challenging to be good at others (e.g. analytics).

The next generation of DSR can be dramatically more effective.  In particular, it will be:

• much faster while handling much more data
• much easier to use
• easy to load with CPG's data
• easily integrated with additional data feeds (weather, economic time-series, google-trends, twitter feeds, geo-demographic data)
• truly cross-retailer
• easily integrated with your chosen BI, visualization and ad-hoc analytics tools.
• couple rapid data-handling with effective predictive analytics to drive discovery, insight and better decisions.

I'm not going to tell you that these ideas are new (or mine).  This list provides a very high standard and against it, DSRs have consistently under-delivered.

What I am saying, is that the technology now exists to deliver on the promise.

Over this upcoming series of posts we'll look at developments in database technology, analytics and visualizaton that will enable DSR 2.0. (Or should that be DSR 3.0?).  Sign up for the blog feed and make sure you don't miss it.

Back to blogging on "Better Business Analytics"

It's been quite a while, just over 12 months in fact since my last blog post.  In that time, I've been hard at work developing analytic applications for the Orchestro DSR.  (Orchestro's off-shelf alerting tool is especially cool and something I am very proud of contributing to).    I enjoyed my time at Orchestro, they're a good team and have big plans, but one key thing I found out about myself is that I prefer working real-life problems to developing software for someone else to have all the fun :-)

So, I'm now back full-time on consulting and I will occasionally blog on topics of interest to me.   Expect to see more soon on:

• Next-generations DSRs (Demand Signal Repositories)
• Retail supply-chain analytics
• Handling (BIG-ish) data for analytics
• The right tools for the job (Predictive Analytics, Business Models, Optimization)
• Some more thoughts on store-clustering
• Inventory modeling at retail (and why it's different, again)
• Order forecasting using POS data
• Further thoughts on SNAP and other ignored demand drivers
• and if there is something you would like to hear more on ... just drop me a line.

Joins In Oracle

Joins in Oracle

A join is a query that combines rows from two or more tables, views, or materialized views. Oracle Database performs a join whenever multiple tables appear in the FROM clause of the query. The select list of the query can select any columns from any of these tables. If any two of these tables have a column name in common, then you must qualify all references to these columns throughout the query with table names to avoid ambiguity. If two tables in a join query have no join condition, then Oracle Database returns their Cartesian product.

Most join queries contain WHERE clause conditions that compare two columns, each from a different table. Such a condition is called a join condition. To execute a join, Oracle Database combines pairs of rows, each containing one row from each table, for which the join condition evaluates to TRUE. The columns in the join conditions need not also appear in the select list.

To execute a join of three or more tables, Oracle first joins two of the tables based on the join conditions comparing their columns and then joins the result to another table based on join conditions containing columns of the joined tables and the new table. Oracle continues this process until all tables are joined into the result. The optimizer determines the order in which Oracle joins tables based on the join conditions, indexes on the tables, and, any available statistics for the tables.

Main purpose of Joins in Oracle

        v Join the data across the table.

        v A join is actually performed by the where clause which combines specified row of the          table.

    Types of Join

   1. Equi Join

   2. Non-Equi Join

   3. Natural Join

   4. Cross Join

   5. Self Join

   6. Outer Join

   7. Outer Join

        v Left Outer Join

        v Right Outer Join

        v Full Outer Join

   8. Inner join

    First We Create the Two Tables Using Foreign Key

   First Table Department

   Create table department(dept_no int primary key, dept_name char(20), location char(20))

   Insert into department values(101,'Marketing','Birgunj')

   Insert into department values(102,'Finance','Simraungadh')

   Insert into department values(103,'HR','Ludhina')

     

      Department

DEPT_NO	DEPT_NAME	LOCATION
101	Marketing	Birgunj
102	Finance	Simraungadh
103	HR	Ludhina

Second Table Employee
Create table employee(emp_no int primary key, emp_name char(20), job char(20), MGR int, dept_no int, foreign key(dept_no) references department(dept_no))

   

How To Create Stock Unit In Tally

How to create the stock Unit

1.    Select the “Inventory info “from Gateway of Tally.

2.    Select the “Units of measure” or press “U” key.

3.    Select the “Create” or press “C” key.

4.    Enter the symbol of unit e.g. kg

5.    Enter the Formal Name of the unit e.g. Kilogram

6.    Enter the Number of decimal places – max 3 or min 0 or leave it blank.

7.    Press “y” key or press enter key to save the unit.

How to display the stock Unit

1.    Select the “Inventory info “from Gateway of Tally.

2.    Select the “Units of measure” or press “U” key.

3.    Select the “display” or press “D” key.

Examples Of Stock Unit

Symbol	Formal Name
Kg.	Kilogram
Pcs.	Pieces
Ltr.	Liter
Mtr.	Miter
Pkt.	Packet
Ctn.	Cartoon
Btl.	Bottle
Dzn	Dozen

How To Create Stock Group In Tally

How to create the stock Group 

1.    Select the “Inventory info “from Gateway of Tally.

2.    Select the “Stock Group” option or press “G” key.

3.    Select the “Create “option or press “C” key.

4.    Enter the name of the stock Group. E.g. Finished goods

5.    Select the under Group – Primary.

6.    Select “ Can quantities of item be added” – yes

7.    Press y key or press enter key to save it.

How to display the stock Group

1.    Select the “Inventory info “from Gateway of Tally.

2.    Select the “Stock Group” option or press “G” key.

3.    Select the “display “option or press “D” key. 

How to modify / alter / change / edit / correct the stock Group

1.    Select the “Inventory info “from Gateway of Tally.

2.    Select the “Stock Group” option or press “G” key.

3.    Select the “alter “option or press “A” key. 

4.    Modify your required option.

5.    Pres CTRL+A key to save the edited Group. 

How to delete the stock Group

1.    Select the “Inventory info “from Gateway of Tally.

2.    Select the “Stock Group” option or press “G” key.

3.    Select the “alter “option or press “A” key.

4.    Select the Stock Group which you want to delete.

5.    Press ALT+D key to delete the Stock Group 

Example of Stock Group

Samsung Group

Motorola  Group

LG Group

Sony Group

Chaudhary Group

Finished Goods

Raw Materials

Spare Parts

Playing Goods

How To Create General Ledger In Tally

How to create the General Ledger 

1.Select the Account info from Gateway of Tally.

2.Select the “Ledger” option or press “L “key.

3.Select the “create” option or press “C” key.

4.Enter the Ledger Name e.g. Purchase a/c

5.Select the Under Group e.g. Purchase accounts.

6.Select “Inventory values are affected” – yes.

7.Enter the opening balance if necessary.

8.Enter the party details if necessary.

9.Press CTRL+A key to save the Ledger.

How to display the General Ledger

1.Select the Account info from Gateway of Tally.

2.    Select the “Ledger” option or press “L “key.

3.    Select the “display” option or press “D” key.

How to modify / alter / change / edit / correct the General Ledger

1.    Select the Account info from Gateway of Tally.

2.    Select the “Ledger” option or press “L “key.

3.    Select the “alter” option or press “A” key.

4.    Modify your required option.

5.    Press CTRL+A key to save the edited  Ledger

How to delete the General Ledger

1.    Select the Account info from Gateway of Tally.

2.    Select the “Ledger” option or press “L “key.

3.    Select the “alter” option or press “A” key.

4.    Press ALT+D key delete the Ledger.

5.     Press y key or press enter key to delete confirm.

How to Create Company in Fact Software

Introduction of Fact Business Accounting Software

Fact is an International financial business accounting software. It is developed by Vedika Software Pvt. Ltd. in Calcutta. Which is used to store and maintain daily transactions like Journal, Cash and Bank Book, Purchase Book, Sales Book, Purchase return, Sales Return, Consumption and Production Entry but It will automatically create Reports, Cash/Bank Book Register, Ledger Balance, Stock Summary, outstanding report, Trial Balance, Final Account (Profit & Loss and Balance Sheet) & Other many Reports.

How to open the Fact program

1. Select the start menu.

2. Select the Run.

3. Type: - c:\Fact\Factwin.exe

4. Press enter key to open the fact program.

How to close Fact program

1. Select the Account menu.

2. Select the exit.

First we Create 3 new Companies:

(a) First company by selecting “NONE” Option è this is your Main Company in which you use for record all transactions.

(b) Second Company by selecting “SAMPLE DATA”

(c) Third Company by selecting “MANUFACTURING SAMPLE DATA”

How to create a First new company in Fact program

1. Select the account menu.

2. Select the ‘New’ option.

3. Enter the initials (Max.3 character only)

4. Select the data disk drives e.g. D: or C:

5. Enter the name of the Account (Company Name)

6. Enter the address of the company.

7. Enter the short Name of the company.

8. Enter the income tax number of the company.

9. Select the install AR/AP – Yes.

10. Click on NONE option.

11. Press ALT+S key or click on save button.

How to Edit/Modify company

1. Select the Account menu.

2. Select the ‘modify’ option.

3. Press F1 key and select the company code which you want to modify.

4. Modify your required option.

5. Press ALT+S key to save the changes.

 How to Delete the company

      1.  Select on Account menu

      2.  Select on Delete option

      3. Press F1 key & select company code which you want to delete

      4. Press enter key to confirm deletion –yes.

How to create the second company (sample Data)

   1.     Select the account menu.

   2.     Select the ‘New’ option.

   3.     Enter the initials(Max.3 character only)

   4.     Select the data disk drive e.g. D: or C:

   5.     Enter the name of the Account (Company Name)

   6.     Enter the address of the company. 

   7.     Enter the short Name of the company. 

   8.     Enter the income tax number of the company. 

   9.     Select the install AR/AP – Yes.

  10. Click on SAMPLE DATA option.

  11. Press ALT+S key or click on save button.

How to Modify Company

1. Select the Account menu.

2. Select the ‘modify’ option.

3. Press F1 key and select the company code which you want to modify.

4. Modify your required option.

5. Press ALT+S key to save the changes.

 How to Delete the company

      1.    Select on Account menu

      2.    Select on Delete option

      3.  Press F1 key & select company code which you want to delete 

      4.  Press enter key to confirm deletion –yes.

How to create the THIRD COMPANY (Manufacturing sample Data)

    1.     Select the account menu.

    2.     Select the ‘New’ option.

    3.     Enter the initials(Max.3 character only)

    4.     Select the data disk drive e.g. D: or C:

    5.     Enter the name of the Account (Company Name)

    6.     Enter the address of the company.

    7.     Enter the short Name of the company.

    8.     Enter the income tax number of the company. 

    9.     Select the install AR/AP – Yes.

   10.  Click on MANUFACTURING SAMPLE DATA option.

   11.  Press ALT+S key or click on save button.

How to Modify company

1. Select the Account menu.

2. Select the ‘Modify’ option.

3. Press F1 key and select the company code which you want to modify.

4. Modify your required option.

5. Press ALT+S key to save the changes.

 How to Delete the company

     1.   Select on Account menu

     2.  Select on Delete option

     3.  Press F1 key & select company code which you want to delete 

     4.  Press enter key to confirm deletion –yes.

Note:- If you are create 3 company & finally create General ledger & Copy from this Codes to system Control for Account Menu.

how to create company in tally

Company Creation Process in Tally 9.0 Program

1.  Select the “Create Company“option from Company info menu or press ‘C ‘key.

2. Now the company creation format display with the following options.(Properly fill up these all options to create a new company)

Directory: C:\Tally9\data

Name : Enter your company Name here. For Example :-  Raj Industries Pvt. Ltd.

Mailing Name : It auto display the same name as entered above. It means the postal name of company which we can use to send officials letters and documents.

Address : Enter the address of the company. For Example : -  Adarshnagar -10, Birgunj (Nepal)

Statutory compliance    :    Select “None” in case of Nepal

Pin Code :  After selecting none option pin code telephone no. etc will inactive

Email Address:   

Use Indian vat :  

Local Sales Tax Number:

Inter-state Sales Tax Number:

Currency Symbol : Country Currency Name Example, Rupees

Maintain : Accounts only (In Case of Service Sector) or Accounts with Inventory (In Case of Manufacturing Sector purchased & Sale is involved it is used Accounts with Inventory other wise vice-verse)

Financial Year From: Like 01/04/2014

Books beginning from: Your Beginning date of entry posting

Tally Vault Password:

(Warning: forgetting your tally vault password will render your data unusable)

Use security control: - yes

Name of the administrator:                Password:                              Repeat:

Use Tally audit features - yes

Base Currency information

Base currency information: RS.

Formal Name: Nepalese Rupees

Number of Decimal Places: 2

Is symbol suffixed to the amounts?  NO                    Show amounts in millions?  No

Symbol for decimal portion: Paisa        Put a SPACE between amounts and symbol? Yes

introduction of tally

Introduction to the Tally 9.0

Tally is financial accounting software. This program is developed by Peutronics Pvt. Ltd. It allows the user to create a company, create accounts, make voucher entries and print reports. This Financial accounting software is used to store and maintain daily business transactions like purchases, sales, receipts, payments, purchase returns, sales returns, deposit and withdrawals. But it auto creates Stock Ledger, Trial Balance, Trading A/c, Profit & Loss and Balance Sheet, Cash/Fund Flow, Ratio Analysis and other many  financial reports.

 There are some special features of Tally Program:-

1.     Tally is a worldwide used multinational and multi language program.

2.  It has high level of data security and more facilities to store and keep the financial records.

3.     It has colorful screen and easy entry formats.

4.  It has well designed reporting facilities and many more short keys facilities are available for the users.

5. It is based on double entry system which facilitates the modernized accounting transaction entries as per the requirement of the user.

Tally program auto creates a data directory named ‘Data’ inside the program where it stores the company’s data.

  Tally opening screen description

The Tally program has following six screen parts they are as:

Title bar: - Tally’s title bar is displayed at the top of the screen.

Horizontal bar: - It is the second screen after the title bar where we can get the information about the tally program detail.

Gateway of Tally: - The Gateway of Tally area has two major parts

Left hand side: - Where company’s current date, current period, name of company and the date of last entry are displayed.

Right hand side: - Through which Tally program is operated and every user of Tally starts their works using these command options.

Button bar: - It is displayed on right hand side of the Tally’s screen where many short key buttons are displayed which is very helpful for the better operation of the Tally program.

Calculator Area: - It is displayed above the bottom side of the Tally’s screen. It is used for the mathematical calculation.

Bottom bar: - It is displayed at the down side after the calculator area of the Tally’s screen. 

           

Gateway of Tally screen before company creation & after company creation

Special note:-The screen of the Gateway of Tally is normally displayed while we open the tally program at first time but actually that screen is not sufficient for user. But   after the company creation in tally program when we open the company then it is found having quite different screen of the gateway of tally. Now its look is likely more changed than before. It is sure user will feel it himself.

COMPANY INFORMATION

How to open tally 9 program

1. Click on the start menu.

2.  Click on the run.

3. Type -   C:\Tally9\Tally9.exe

4. Now press enter key to open the tally program.

Note: - The directory of tally program can be modified by the user as per the requirement so; it is not fixing that the command typed above to open the tally program should be exactly same for every user.  It may be changed for per user as per their uses.

How to close the tally program

1. Click on Quit option or press Q key at gateway of Tally program.

2. Click on Yes or Press Y key.

Or

1. Press ESC key at gateway of Tally.

2. Press Enter key to Quit from Tally program.