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 Analytics Modelling Lab Notes (2022-23)(Q1-Q10) B. Com ( Business Analytics) Sem III         Q1: Split the column Deptname-EmpID into two columns           Step1: Copy the column Deptname – EmpID into new sheet.           Step2: Select the column           Step3:   Go to Data tab and click on Text to Columns. A dialogue box opens.           Step4: Click Next and the select Space and Other. Fill   ‘ – ‘ in other box.           Step5: Click next.           Step6: Click finish.           Q2: Format the Employee Name Column.           Step1: Copy the Employee Name column in new sheet.           Step2: In the column next to Employee Name column write the syntax...
Post a Comment
Read more
By Uma Bakshi -
Image
  Computer Lab - Practical Question Bank FACULTY OF COMMERCE, OSMANIA UNIVERSITY ------------------------------------------------------------------------------------------ B.Com (Business Analytics) III Semester Data Analytics Modeling Time: 60 Minutes                                                                     Record : 10                                                      ...
Post a Comment
Read more

DAM Sem III Lab Questions (2022)

By Uma Bakshi -
Image
Important Links Power Query link(Order data set 1) Power Query link ( Order data set 2) Power Query and Power Pivot Link (Sales_2018) Power Query and Power Pivot Link (Sales_ 2019)
3 comments
Read more
By Uma Bakshi -
  Computer Lab - Practical Question Bank FACULTY OF COMMERCE, OSMANIA UNIVERSITY ------------------------------------------------------------------------------------------ B.Com (Business Analytics) III Semester Data Analytics Modeling Time: 60 Minutes                                                                     Record : 10                                                      ...
Post a Comment
Read more