Workshop

ONLY FOR LOGGED-IN USERS

Easy

Text

Text

MS Power BI

11 Lessons

0% Not started

​Workshop Overview

SCENARIO

Joe Joe’s Restaurants is one part of ​fictitious hospitality conglomerate group in the UK. The group operate a national chain of restaurants, hotels, and private dining clubs selling, Asian cuisines, Fusion cuisine, Haute cuisine, Nouvelle cuisine, Note by Note cuisine, Oceanic cuisine, Vegan cuisine, Vegetarian cuisine.


The groups London office stores the business unit’s sales data on an Access database. Business unit’s home nation sales transactions are available as comma separated (CSV) files. Some business units generate their sales data manually others do so through automated processes. Each business unit is responsible for sending their files. These files are held in dedicated folder. To make things as easy as possible these CSV files have the same column structures as the sales table held on a SQL database managed by London head office. 


You have been set the task of analysing Joe Joe’s national sales data for the year 2000 to 2015. Your first step is to bring the data into Power BI Desktop. The next step is to compare Joe Joe’s home countries sales with the home countries population. To achieve this, you will need to import the country population data from a less structured Excel report to Power BI.

​WORKSHOP OVERVIEW

​​Exercise 1: Import Data from Access Database

​W​ORKSHOP QUESTIONS

​​Exercise 2: Import Data from a Folder Containing CSV Files

​WORKSHOP QUESTIONS

​​Exercise 3: Import a Less Structured Data from an Excel File

​WORKSHOP QUESTIONS

Workshop

Follow

About the teacher

Christopher Bird

Building your own Power App, BI solution, or automated workflow can be a mind-blowing experience. It can also be a nightmare. Particularly when you begin with a blank screen. My advice, get professional help as and when you need it. That's what successful people do.

Pen
>