Has anyone done the PowerBI lab exercises 1-3? I can post more info if needed. Just need the answers for questions 1-5, then the second exercise (1 & 2) and third exercise (2 &3).

6. Filter the rows on the bi salesFact query to include dates from January 1st, 2000. (Hint: Apply a Date filter in the Date column to import dates after December 31st, 1999. Before you can apply a date filter, you need to change the Date column's Data Type to Date) Filter the rows on the bi date query to include dates from January 1st, 2000. (Hint: Apply a Date filter in theDate column to import dates after December 31st, 1999. Before you can apply a date filter, you need to change the Date column's Data Type to Date) 7. 8. Rename the queries as follows: bi date: Date bigee; Locations bimanufacturer Manufacturers bi product: Products Sales 9. Load the data into Power BI Desktop. This might take a few minutes. 10. Explore the imported data in the Data View Lab Questions 5 points possible (graded) Answer the following question by reviewing the imported data in Power BI Desktop. (Hint: Use the Data view) How many rows were imported from the Date query? How many rows were imported from the Locations query? How many rows were imported from the Manufacturer query? How many rows were imported from the Products query? How many rows were imported from the Sales table? 1. 2. 3. 4. 5. 6. Filter the rows on the bi salesFact query to include dates from January 1st, 2000. (Hint: Apply a Date filter in the Date column to import dates after December 31st, 1999. Before you can apply a date filter, you need to change the Date column's Data Type to Date) Filter the rows on the bi date query to include dates from January 1st, 2000. (Hint: Apply a Date filter in theDate column to import dates after December 31st, 1999. Before you can apply a date filter, you need to change the Date column's Data Type to Date) 7. 8. Rename the queries as follows: bi date: Date bigee; Locations bimanufacturer Manufacturers bi product: Products Sales 9. Load the data into Power BI Desktop. This might take a few minutes. 10. Explore the imported data in the Data View Lab Questions 5 points possible (graded) Answer the following question by reviewing the imported data in Power BI Desktop. (Hint: Use the Data view) How many rows were imported from the Date query? How many rows were imported from the Locations query? How many rows were imported from the Manufacturer query? How many rows were imported from the Products query? How many rows were imported from the Sales table? 1. 2. 3. 4. 5