Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
02-07-2022 02:36 AM
The Dashboard shows sales analysis using data from Amazon Redshift.
Card Visuals:
The visuals are designed to show the performance of different KPIs. It was developed using Time-Intelligence DAX Functions. It takes the latest month's data and compares it with the previous month's data (latest month - 1). Color coding helps to get a quick difference in performance.
Stacked Bar Charts:
The visuals compare revenue (Profit + Commission) with other categories/Events. Top 10 Highest Revenue by Venue City visual is based on the weightage of the Average ticket sold. Technically, this visual shows, top 10 highest ticket sold and revenue generated cities.
Map:
It gives insight on the number of events by the city in each event category and helps to quickly identify the cities where the most of events are scheduled/happened.
Area Chart:
Smart Narrative:
Nice small text content shows quick insights by analyzing the visuals on the page. It is interactive with other visuals and filters. It can be customized further to get most of it.
Hope you like this work. Happy to hear your comments!
Check out our Blogs on Power BI - http://www.cittabase.com/category/power-bi/
Thanks,
Siva Mani
Proud to be a Super User!
https://www.linkedin.com/in/siva-mani/
eyJrIjoiMmNhYjEzOTYtMTQzZS00OGZiLWE0Y2MtZDgxYjc0ZDhlNzdjIiwidCI6IjQ4OGQwYmFlLTc1NWUtNGQzMC05ZmI4LWUwYzU0OTU2NTRjNCJ9
The post is useful.
Could you please specify that this dataset uses Direct/Import mode.
I have a problem using Direct Query with Redshift.
@nguyenhieubis , Thanks for the comments. It is based on Import Model. I have another version of the same report with DirectQuery mode. It works fine as well.
Nice work 🙂