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 (6-10) : Python   Q6. Write a program to assign three values to the variables a, b and c            and perform the operations addition, multiplication, ((a+b)+c),          ( a-(b+c)), (a*(b+c)), (a + (b*c)), (a*(b-c)).           #Write a program to assign three values to the variables a, b and c     and perform the operations addition, multiplication, ((a+b)+c),   (a-(b+c)), (a*(b+c)), (a + (b*c)), (a*(b-c)).    a =  int ( input ( 'Enter a number of your choice' ))           b=  int ( input ( 'Enter a number of your choice' ))      c=...
Post a Comment
Read more
By Uma Bakshi -
Image
ADVANCE DATA VISUALIZATION PRACTICAL QUESTION BANK NOTES (Q11-Q20) B.COM – BUSINESS ANALYTICS SEM V GLOBAL SUPER STORE ORDERS LINK        Global Super Store Data      Import Global Super Store Data from your files.      11. Percentage of total sales for each ‘Ship mode’.              Step1: Click on data           Step2: Click on New Measure on Table Tool Bar           Step3: Enter “ Total Sales = Sum(O rders [S ales ])” and then click                          on tick mark.           Step4: A new field gets added “Total Sales”           Step5: Go to “Report” just above the “Data”         Step6 : Then select the table from Visualizations.       ...
Post a Comment
Read more