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
                                                              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
By Uma Bakshi -
  Advanced Data Visualization B.Com (Business Analytics) V Semester Power Bi and Tableau : I.             From the file given below show the following data visualization in Power BI. FINANCIAL SAMPLE LINK   1.     Percentage of total ‘ Gross Sales’ for each Month. 2.     Top 3 ‘ Month Name’ and Gross Sales . 3.     Sales by Country and Product. (Insert pivot table) 4.     Sales price by Date and Country. (Insert pivot chart) 5.     Manufacturing price by Product and Year . 6.     Segment and Units sold. (Insert pivot chart) 7.     Discount and Manufacturing price . (Insert pivot table and chart) 8.     Year and Discounts. (Insert doughnut chart) 9.     Frequency of Manufacturing price .          10.Cog...
Post a Comment
Read more