In this part, you are required to demonstrate data validation by using Power BI
PART B:
In this part, you are required to demonstrate data validation by using Power BI.
Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.
Download Microsoft Power BI Desktop from https://powerbi.microsoft.com/en-us/downloads/
Download Power BI sample files from https://github.com/apress/pro-power-bi-desktop Download, Zip
Demonstration 1
Open Microsoft Power BI Desktop. Use SalesData.xlsx as the Source Data. This is a worksheet of British car sales. Create the following on one Page Dashboard.
VisualisationFields
MapClient: Town, Sales: Sale Price
MatrixClient: Town, Sales: Sale Price
Clustered Column ChartSales: Cost Price, Make, Sale Price
CardLabor Cost
SlicerMake
Your task:
•Save a screenshot of the Dashboard.
•Select Aston Martin in the slicer and save a 2nd screenshot of the Dashboard.
•Answer the following two questions:
oWhich Town has the most Sale Price (sum) of the Aston Martin?
oHow can you use Power BI to help with global marketing? (1 paragraph)
Demonstration 2
Visit Queensland Government data. https://data.qld.gov.au/
•Select ANZSCO_2DIG_TITLE= ICT Professionals and save a 2nd screenshot of the Dashboard.
•Select Job_title = IT Consultant. Write down the regions where this vacancy exists
•Answer the question: In this demonstration what potential issues present in terms of the source? (1 paragraph)
Hint
"The reasons to use a visualization tool such as Power BI to validate data is that it's a very effective way to find data anomalies. So, by showing users different ways to view the data, users learn effective ways to learn the tool. The users can also learn how to drill into more detail to find out why data anomalies exist and to view the raw data at a transaction level. Also, al...
"The reasons to use a visualization tool such as Power BI to validate data is that it's a very effective way to find data anomalies. So, by showing users different ways to view the data, users learn effective ways to learn the tool. The users can also learn how to drill into more detail to find out why data anomalies exist and to view the raw data at a transaction level. Also, all of these functions help visualize and validate the data while teaching users new techniques with the visualization tool. Power BI can also be a very effective way to document the validation steps.
Using Power BI to help with global marketing
Power BI aims to improve time consuming marketing campaigns analysations and complex on-going task. The solution helps marketers to both monitor available resources and analyze activities by product, service, market segment, customer trends, actions, and sentiment or other criteria. Better reporting of this information can identify new upselling or cross-selling strategies and opportunities for the business as a whole. Comparing complex metrics including revenue, marketing costs, specific campaigns, and channels, calculating ROI in real-time is made easier and enhanced by Web & Social Analytics module. Finally, clients’ marketers can publish the actions detailed in reports to interactive dashboards that can be accessed from anywhere."
Login | Sign Up
