Assignment of AI and data science

  Name Jasmine  Roll no 5008(24046722) Class Bca(2nd-sem)

  What is Power BI? Power BI is a business intelligence tool of Microsoft that is mainly designed to curate and present data insights that are most intriguing and engaging. It is a versatile tool that can easily derive data origins, including cloud services and Excel spreadsheets. Power BI is used by many businesses to create better visualization of data through charts, graphs, and other data interpretation techniques. Discover the art of Power BI more through the CCSLA exclusive  PL-300: Microsoft Power BI Data Analyst  course to gain valuable insights from industry leaders. Furthermore, Power BI offers data refinement and structuring to enable the development of reports, presentations, and interactive dashboards. The Power BI works at its total capacity to convert data, clean it, and make it more appealing using visual elements. It facilitates sharing and collaboration using cloud services. It helps them to cooperate reasonably in the team and make data-driven decisions...

  How to use goal seek in Excel Let’s learn how to use the goal seek function in Excel 👍🏻 Go to the data tab. 2. Expand the What-if analysis tools list in the forecast group. Click Goal seek to open the goal seek dialog box. Select the formula cell that you want to get the desired result into the set cell box. Enter the desired output in the “to value” cell box. Select the variable input cell for the “By changing cell” box. Click OK to get the goal seek status dialogue box. The goal seek status will show whether it found a solution or not. It will also show you, the new input value to get the given value for the target cell.  FINAL OUTPUT:- BEFORE:- AFTER:-

Use Scenario Manager Using Scenario Manager in Excel can help you analyze different sets of data and see how changes in variables can affect your results. Essentially, you’ll be able to create various "what-if" scenarios to predict outcomes and make informed decisions. By the end of this guide, you’ll be able to set up and use Scenario Manager with ease. Steps to do scenario manager Step 1: Open your Excel file Open your Excel file where you want to use Scenario Manager. Make sure your data is well-organized with clear headings and values. This will help you easily identify which cells you want to change. Step 2: Go to the Data tab Click on the "Data" tab at the top of the Excel window. The Data tab contains numerous tools for data analysis, including the Scenario Manager. Step 3: Click on What-If Analysis In the Data tab, find the "What-If Analysis" option and click on it. This will open a dropdown menu that includes different tools for forecasting and sc...

  What is it? The  data table in Excel  can be used to change two variables. Users need to provide input variables. Excel returns the output based on the formula and variables given by the users. Step 1:  Create a table with various interest rates, as shown in the below image. Step 2:  In the formula cell (H14), type the actual EMI formula, i.e., cell K10. Step 3:  Select the newly created table. Go to the  Data . Under the Forecast group, click on the  What-If Analysis  drop-down list and choose the  Data Table .  Click in the 'Column input cell' box (the percentages are in a column) and select cell h11. We select cell h11 because the percentages refer to cell h11 (% sold for the highest price).  Note: this is a one variable data table so we leave the Row input cell blank. 4. Click OK. Result:

  Steps to create dropdown list Prepare Your List: First, create a list of items you want to appear in the drop-down list. Enter these items in a single column or row in your worksheet. For example, you can enter them in cells c7 to c18. Output:- Select the Cell for the Drop-Down: Click on the cell where you want the drop-down list to appear. Output:- Open Data Validation: Go to the  Data  tab on the Ribbon. Click on  Data Validation  in the Data Tools group. Output:- Set Up Data Validation: In the Data Validation dialog box, go to the  Settings  tab. In the  Allow  box, select  List . Output:- Enter the Source: In the  Source  box, enter the range of cells that contain your list items. For example, if your list is in cells  C8 to C18enter =$C$8:$C$18 Alternatively, you can click the small button to the right of the Source box and then select the range directly on the worksheet. Output:-   Complete the Setup: Cli...