Context

I made a couple or reports using Power BI and the open data site of Iowa State.

Content

Youw ill have to download the data set from the Iowa's web site. The model have a simple charts and table to visualize the sales of Liquor.

https://data.iowa.gov/Sales-Distribution/Iowa-Liquor-Sales/m3tr-qhgy.

Acknowledgements

Inspiration

Warning: Large file size (over 1GB). Each monthly data set is large (over 4 million rows), but can be viewed in standard software such as Microsoft WordPad (save by right-clicking on the file name and selecting 'Save Target As', or equivalent on Mac OSX). It is then possible to select the required rows of data and copy and paste the information into another software application, such as a spreadsheet. Alternatively, add-ons to existing software, such as the Microsoft PowerPivot add-on for Excel, to handle larger data sets, can be used. The Microsoft PowerPivot add-on for Excel is available from Microsoft http://office.microsoft.com/en-gb/excel/download-power-pivot-HA101959985.aspx Once PowerPivot has been installed, to load the large files, please follow the instructions below. Note that it may take at least 20 to 30 minutes to load one monthly file. 1. Start Excel as normal 2. Click on the PowerPivot tab 3. Click on the PowerPivot Window icon (top left) 4. In the PowerPivot Window, click on the "From Other Sources" icon 5. In the Table Import Wizard e.g. scroll to the bottom and select Text File 6. Browse to the file you want to open and choose the file extension you require e.g. CSV Once the data has been imported you can view it in a spreadsheet. What does the data cover? General practice prescribing data is a list of all medicines, dressings and appliances that are prescribed and dispensed each month. A record will only be produced when this has occurred and there is no record for a zero total. For each practice in England, the following information is presented at presentation level for each medicine, dressing and appliance, (by presentation name): - the total number of items prescribed and dispensed - the total net ingredient cost - the total actual cost - the total quantity The data covers NHS prescriptions written in England and dispensed in the community in the UK. Prescriptions written in England but dispensed outside England are included. The data includes prescriptions written by GPs and other non-medical prescribers (such as nurses and pharmacists) who are attached to GP practices. GP practices are identified only by their national code, so an additional data file - linked to the first by the practice code - provides further detail in relation to the practice. Presentations are identified only by their BNF code, so an additional data file - linked to the first by the BNF code - provides the chemical name for that presentation.

Tabulating and Visualizing Supermarket Data

In this portfolio, I present an analysis of supermarket data, focusing on total sales, product categories, highest-spending customers, states with the highest and lowest sales, top-selling regions, and the most profitable city. This analysis provides valuable insights into supermarket performance and customer behavior.

Total Sales:

This chart illustrates the total sales over a specific time period. It serves as a key indicator of the supermarket's financial performance, showing revenue trends.

Product Categories:

A pie chart displays the distribution of sales across various product categories. It helps identify which product categories are the most popular and which may require additional marketing efforts.

Highest-Spending Customer:

The bar chart reveals the highest-spending customer, allowing the supermarket to recognize and reward loyal customers, while also gaining insights into their preferences.

States with the Highest Sales:

A map or bar chart showcases the states with the highest sales. This data can inform inventory management and marketing strategies.

Top-Selling Regions:

A bar chart displays the regions that generate the most sales, enabling the supermarket to concentrate resources where they are most effective.

Most Profitable City:

The pie chart reveals the city with the highest sales, providing insights into localized market dynamics.

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F17275765%2F79f7c8d799eb9c02366d6d3a88da7f6b%2FEkran%20grnts%202023-10-19%20220624.png?generation=1697742440417896&alt=media" alt="">

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F17275765%2Faadc9f1f51741e5eb5d53e95c0a5d7e3%2FEkran%20grnts%202023-10-19%20220651.png?generation=1697742451758252&alt=media" alt="">

Power BI:

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F17275765%2F8e3494d8976b704e3ce0ca8860373aca%2F1Ekran%20grnts%202023-10-30%20153142.png?generation=1698669303093987&alt=media" alt="">

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F17275765%2Fda1e92460005fdf83274ea677a2f77b3%2F2Ekran%20grnts%202023-10-30%20153202.png?generation=1698669311958193&alt=media" alt="">https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F17275765%2Fa220f12305624790bf61572a8d4dfaaa%2F3Ekran%20grnts%202023-10-30%20153239.png?generation=1698669315324083&alt=media" alt="">

Comprehensive dataset of 17 Power stations in Nebraska, United States as of June, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 14 Power stations in Wyoming, United States as of July, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 40 Hydroelectric power plants in New York, United States as of July, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 12 Power stations in Maine, United States as of July, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 30 Power stations in Tennessee, United States as of July, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 30 Power stations in South Carolina, United States as of July, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 625 Power stations in Iran as of June, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 130 Power stations in Colombia as of July, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 1,245 Power stations in Germany as of June, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 8 Thermal power plants in Michigan, United States as of July, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 1,564 Power stations in Indonesia as of July, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 7 Hydroelectric power plants in Nebraska, United States as of July, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 17 Power stations in Gunma, Japan as of July, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 236 Power stations in Netherlands as of June, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 434 Power stations in Thailand as of June, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 216 Power stations in Switzerland as of June, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

Comprehensive dataset of 305 Power stations in Finland as of June, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.