Data Analyst Portfolio Project - Final Result - Power BI & SQL
Creating a Data Analyst Portfolio: Summary and Alignment with Resume
Overview of the Series
- Ali introduces himself as a data analytics manager and outlines the purpose of the video, which is to summarize the series on creating a data analyst portfolio from scratch.
- The initial steps included setting up a practice environment with SQL Server, installing SQL Server Management Studio, and restoring two databases for practicing SQL queries.
Key Steps in Portfolio Creation
- The series covered business requests leading to the creation of user stories tied to agile development, essential knowledge for data analysts.
- Data cleaning and transformation were performed using SQL within the practice environment, emphasizing practical skills in handling data.
- Power BI was utilized to connect cleansed tables, resulting in a sales overview dashboard along with additional pages focusing on customers and products.
Finalizing the Portfolio
- Ali discusses structuring elements into a web page using WordPress, making the portfolio accessible online.
- He emphasizes aligning his resume and CV's look with that of his portfolio by using consistent colors and fonts (Overpass for headings and Roboto for body text).
Importance of Consistency
- Ali highlights linking his resume to his portfolio to create a cohesive package that enhances job applications.
- He encourages viewers to learn from these videos and consider creating their own portfolios as they can be beneficial during job pursuits.
Closing Thoughts