Power BI Projects
Capstone: Project 1
Description - In United States, there are many stores in which a survey was conducted based
on students i.e. how much they are spending on different kind of purchases like Video
games, Indoor games, Toys, Books, Gadgets etc. In the data set (Student Survey), Store
setting is the column that explains the Type of location in which the store is present. By using
data set (Student Survey), extracted the meaningful Insights.
Tools & Technologies – Power BI desktop, Power BI Service
Your specific role and contributions to each project –
Used different, visualizations like pie chart, matrix, funnel, scatter plot, sand dance plot,
tabular.
Restricted data access for the users using row level security.
Published the report on Power BI cloud service and designed a Master Dashboard. Then,
created a schedule refresh for six times in every 4 hours for the Dashboard in a day.
Achievement / Result – Gained knowledge and hands on experience regarding Creation of
an interactive Power BI report
Capstone: Project 2
Description –
Use Case 1 - Designed a dashboard to analyse the trend of admissions into state universities.
Use Case 2 - Design a dashboard to analyse the trend of admissions into state universities
Use Case 3 - Top Down and Bottoms Up Analysis to identify Shipping Costs Leakages
Tools & Technologies – Power BI
Your specific role and contributions to each project –
Used Query Editor to perform data modelling by applying transformations like Split Data,
Transpose, Pivot/Un-pivot, Merge, Conditional Columns, Summary Tables etc.
Used expressions and filters to build custom visualizations.
Built a set of visualizations to identify underlying outliers and flipped the same set of
visualizations to perform bottoms up analysis.
Achievement / Result – Gained knowledge and hands on experience regarding data
transformation and advanced visualizations
SQL Projects
Project 1: Querying a Large Relational Database
Description - Worked on downloading a database and restoring it on the server. Then
queried the database to get customer details like name, phone number, email ID, sales made
in a particular month, increase in month-on-month sales and even the total sales made to a
particular customer.
Tools & Technologies – SQL
Your specific role and contributions to each project -
Downloaded the AdventureWorks database and restored it in server. Restored a backup of
the database using SQL Server Management Studio
Used various SQL Operators
Performed various SQL functions
Achievement / Result – Gained knowledge and hands on experience
regarding how to get details about customers by querying a database
Project 2
Description - Used the data to answer a few questions about the customers, especially about
the sales and profit coming from different states, money spent in marketing and various
other factors such as COGS (Cost of Goods Sold), budget profit etc. Using these insights to
find out which items are being sold the most
Tools & Technologies – SQL
Your specific role and contributions to each project –
Used various SQL Operators
Performed various SQL functions
Achievement / Result – Gained knowledge and hands on experience to write fully
functioning SQL queries.
Project 3: Relational Database Design
Description - Worked on converting a relational design that enlists various users, their roles,
user accounts and their statuses into different tables in SQL Server and insert data into them
creating respective foreign keys.
Tools & Technologies – SQL
Your specific role and contributions to each project –
Defined relations/attributes
Defined primary keys
Created foreign keys
Achievement / Result – Gained knowledge and hands on experience regarding how to
convert a relational design into tables in SQL Server