Creating a Data Model for Seven Tea Company using Power BI

Udacity project in collaboration with TechUp

Retrieving data using “Get Data” feature to perform Extract, Transform and Load procedure.- Cleaning and formatting data to ensure clean structures.- Building date tables with fiscal years - Building Data models and relationships between tables with appropriate cardinality.- Calculating calculated columns and measures for filtering and analysis respectively.- Simple visuals to show findings- Retrieving data using “Get Data” feature to perform Extract, Transform and Load procedure. - Cleaning and formatting data to ensure clean structures. - Building date tables with fiscal years - Building Data models and relationships between tables with appropriate cardinality. - Calculating calculated columns and measures for filtering and analysis respectively. - Simple visuals to show findings

Skills: Date tables · Data Modeling · Extract, Transform, Load (ETL) · Format and clean · M code