Data Analyst Portfolio Project - Create Dashboard - Power BI & SQL
🚀 Want the full Sales Analytics project with deeper walkthroughs and more tables? 👉 https://www.portfoliostack.io/?utm_so...
In todays video I focus on loading data into Power BI to create a data model and the dashboard creation process. This is the dashboard I will use in my data analyst portfolio project at the end. It is a bit longer and I decided to keep this fairly unedited to show the moments where I make mistakes as I think it gives better view of the process.
Click here to subscribe! https://bit.ly/3xL8Dm6
Video Content:
0:00 Welcome
1:00 Load Data
2:18 Organize & Prepare Tables
4:30 Connect Tables for Data Model
5:17 Import Fact_Budget
07:18 Calculation Measures
08:58 Dashboard Design
14:37 Import Custom Visual
16:09 Measure Table
19:43 Pie Chart
20:45 Line Chart
22:26 Bar Charts
24:06 Map Graph
25:07 Top 10 Graphs
26:25 Gradient Bar Chart Color
27:24 Customer Details
27:46 Pivot Table
29:15 Publish to Workspace
30:05 Share Report Online
30:44 Wrap Up
You can browse the dashboard here if you want to see it online and try it out. Note that this is the final version which I hade made beforehand:
https://app.powerbi.com/view?r=eyJrIj...
Budget File And More: https://github.com/AnalyzeWithAli/Dat...
A data analyst portfolio project can be a great supplements to a resume when you apply for a job. The resume lists up which skills you have, but the data analyst project can showcase it and be something you can use to your advantage as you are trying to get a job.
Entire series:
#1 - Intro & Setup: • Data Analyst Portfolio Project - Intro & S...
#2 - Business Request & Planning: • Data Analyst Portfolio Project - Business ...
#3 - Data Clean & Transformation: • Data Analyst Portfolio Project - Clean Dat...
#4 - Create Dashboard: • Data Analyst Portfolio Project - Create Da...
#5 - Putting Portfolio Together: • Data Analyst Portfolio Project - Assemble ...
#6 - Final Result & Portfolio Summary: • Data Analyst Portfolio Project - Final Res...
// Ali
________________________
Let’s stay in touch:
📸 Instagram – @iamaliahmadd
🔗 LinkedIn – / aliahmad1987
#DataAnalyst #DataAnalytics #DataAnalysis #Data #Analysis #AliAhmad #PowerBI