Exclusive Fognini Inc. (EFI) is a family-owned business specializing in high-end customized skis. Giulio, a remarkable engineer, is the majority shareholder and president of the company. The balance of shares is owned by three family members. Giulio founded the business 15 years ago. His wife, Haley, was a professional skier at the time and has attributed the gold medals she won to the highly innovative skis her husband had built for her. The market for high-end, customized skis presented an unmet demand, and Giulio took advantage of that opportunity. Operating just outside of Vancouver, EFI produced strong sales numbers even within the first year. The skis were priced to sell at a large premium, and the company made significant investments (initial and ongoing) in research and development. EFI generated a profit in its third year and has achieved strong results since that time. The company's controller is a young CPA who joined EFI soon after receiving her designation and has grown with the company. Financial statements are prepared in accordance with ASPE and are reviewed by JK&L CPAs, a three-partner CPA firm in Vancouver.

EFI does not invest in advertising but relies instead on word-of-mouth referrals. Giulio offers his wealthy clientele not only highly customized skis with a guaranteed exclusive design, but also the highest quality available on the market. In addition, microchips are embedded in each ski to make them easy to locate in case of loss or theft. The company offers a unique level of personalization and free maintenance at the beginning of each ski season; this has won over many prospective clients. Giulio's brother, Antonio, took on the responsibility for the maintenance service and has kept customers happy over the past 15 years.

Giulio's brother-in-law, Marcus, is an EFI shareholder and the ski instructor of choice for wealthy skiers in Whistler, B.C., as well as in Aspen and Vail, Colorado. Marcus has spent his career as a ski patroller, medic, and instructor. He devotes a few days to each client or group of clients and travels between the three resorts as frequently as required, all while promoting EFI skis to his clientele. Each December, Giulio and Haley travel to the famous ski resorts of Europe, where they introduce new designs to influential sponsors and selected clientele. The couple invites those clients who purchased new skis or recommended the new skis to a buying customer to an annual spring skiing event in Whistler, which is partly sponsored by EFI. This event provides EFI's customers with an opportunity to show off their prized possessions ? the exclusive skis ? and enter into new business relationships, all while enjoying the outstanding Whistler-Blackcomb ski terrain and upscale hospitality.

In recent years, EFI has continued to achieve strong and stable sales levels, but the growth rate has slowed. Giulio has begun to explore other options to expand the business and take advantage of new opportunities.

As one option for growth, Giulio's daughter, Lucia, who specializes in accessories design, has proposed that the company diversify into silk and leather ski masks and gloves, which would follow EFI's tradition of exclusive design, high quality, and personalization. The accessories would carry a high unit cost, but Lucia foresees launching the new products as an indirect but excellent investment in advertising for the core of the business, the skis.

Giulio is preparing for a summer strategic planning retreat. He has asked you to assist with developing a process by which EFI can continue to monitor the strategic environment. Due to a slowing growth rate, Giulio is open to exploring other markets (snowboarding or cross-country skiing) in which EFI could expand its product offerings. Giulio would also like to better understand the current consumer spending trends on ski accessories (including poles, goggles, gloves, and outerwear) across the provinces.

Ultimately, he would like an interactive dashboard system that would provide updates on recent statistics as they relate to the ski industry. For now, you have access to the 2013 and 2015 data from the Facts+Stats document provided by the Canadian Ski Council, along with other data that will be useful for this preliminary analysis.

Required:

a) Using Power BI, prepare a dashboard that presents an overview of the Canadian ski industry and skiers' spending habits. The appendix at the end of this project provides instructions on where to retrieve the data and create the dashboard using Power BI. (2 marks) ATTACHED THE PICTURE WITH THE POWE BI DASHBOARD

Prep-PMA-ASN06-PRJ2.Q4 (1) - Power BI Desktop Sign in X File Home Insert Modeling View Help X Cut LA Copy Get Excel Power BI SQL Enter Dataverse Recent Transform Refresh New Text More New Quick Sensitivity Publish Paste Format painter data . workbook datasets Server data sources v data visual box visuals measure measure Data Queries Insert Calculations Sensitivity Share Clipboard View recovered files X Dol Auto recovery contains some recovered files that haven't been opened. Visualizations Fields Hudson Bay Search CANADA Search 2M Activity by province Filters on this page 2013 Median age, 2013 IM O X 2013 Median age Add data fields here ER Py E O _ 2013 number O X 2015 Median age UNITED STATES OM British Columbia Quebec New Brunswick Alberta Manitoba Ontario Saskatchewan L Bing 2021 TomTom, @2021 Microsoft Corporation Jerina Province ... O X 2015 number Filters on all pages 2015 number by Sport and Province Average Income and Accessory cost by Year and Province percentag.. Province . Alberta . British Columnitoba . New Brunswick . Ontario . Quebec . Saskatchewan . Accessory cost Add data fields here O Province Values O Sport Add data fields here Spending 339K (6.349%)- - 306K (5.72%) 0.AM 20K - 304K (5.69%) 525K (9.89%) - E Accessory cost 918K Drill through 223K O E Average Income (4.17%) (17.16%) Sport 0 2... (..) Alpine Cross-report Region Accessory cost Average Income 21K Cross-Country (0.39%) Off O- D E Year O Snowboarder 0.2M 15K 535K (9.) Keep all filters 510K (9.5..) 798K 132K (2.46%) - (14.91% ) On - 0.0M 2000 2005 2010 2015 Add drill-through fields here Year Page 1 + Page 1 of 1 11:55 AM Type here to search O EI 17.C Mostly cloudy ~ 4 ENG 2021-10-23