Posts

By Uma Bakshi -
Image
B.Com Business Analytics Business Applications For Emerging Technologies 2025-26 Q1. Use Microsoft Excel to solve the following: Use Microsoft Excel to solve the following. Download a company’s (TATAMOTORS.NS) financial statements like P&L, Balance Sheet, Cash flow etc for the past 10 years  to solve the following questions.  Download TATAMOTORS.NS financial statements calculate the year-on-year growth rate of revenue.  Create a bar chart to visualize the growth.  Forecast the revenue for next three years. Step 1: Download 10 Years of Financial Statements Best source (free): Yahoo Finance 1. Go to Yahoo Finance and search: TATAMOTORS.NS 2. Open the Financials tab → Income Statement 3. Switch to Annual 4. Copy the Total Revenue for the last 10 years 5. Paste into Excel like this:   Step 2: Calculate Year-on-Year (YoY) Revenue Growth Add a new column: =(B3-B2)/B2 Format as Percentage: • Select column C • Home → % (Percentage format)   Step 3...
Post a Comment
Read more
By Uma Bakshi -
Image
     Data Driven Decision Making     B.Com (Business Analytics)                                          Sem I   Questions from 1 to 5 :: PYTHON         Q1.  Write a program to print the following sentences, Hello Everyone and                   Welcome to the world of Python.           #program starts here           print ( "Welcome to python class" )      Q2. Write a program to print two statements “Hello World” and “I                     am learning Python”.           a.     Concatenate the strings       ...
Post a Comment
Read more
By Uma Bakshi -
Image
                                                              ADVANCE DATA VISUALIZATION PRACTICAL QUESTION BANK NOTES Questions (1-10) Download and install PowerBI on your desktop. Get Started. Click on Import data from Excel. Import Financial Sample from your files. FINANCIAL SAMPLE LINK           Q1: Percentage of total ‘Gross Sales’ for each Month.                     Step1:  Click on Modelling on tool bar.                                    Click on Quick measure                                    A...
Post a Comment
Read more