Power BI report created for Job application tracking(HR analysis) under certain requirements. note: Flat file converted into Star Schema(Data modelling).
-
Updated
Oct 10, 2024
Power BI report created for Job application tracking(HR analysis) under certain requirements. note: Flat file converted into Star Schema(Data modelling).
Using Power Bi to generate a fully star schema out of a single table of Sales.xlsx -- Starting with segmenting the Dimensional tables out of the flat table then I added the analysis measures with DAX so it help me with the final dashboard visualization
An interactive Power BI dashboard analyzing sales performance by region, product, and time. It tracks key metrics, top-selling categories, and sales trends, offering detailed insights to support business decisions.
The project involves creating a data model for HNG Hire, implementing it in MySQL, and building a Power BI dashboard to display hiring statistics.
Sales revenue data analysis using tableau and SQL
Apache Kafka Streamlit application for real-time tracking of pharmacy sales using the start schema data model.
📊🌈🏛 This project develop a data warehouse for a bank using Amazon Redshift, VPC, Glue, S3 and DBT, following a ⭐ Star Schema architecture. The goal is to storage, manage, and optimize data to support decision making and reporting 🏵️
Sales & inventory data for a fictitious chain of toy stores in Mexico called Maven Toys, including information about products, stores, daily transactions, and current inventory levels at each location.
how to do snowflake schema from star schema based on postcard products
A Sales and Product Management Dashboard created using SQL, Power BI and Microsoft Adventureworks2022 data
Here's my first project on PowerBI. The project using Power BI based on DASHBOARD, ANALYSIS, REPORTING (DAR) format to find out the insight about those Vending Machine sale issue at HCM City, data source collected on March, 2021
Database Management System & Datawarehouse
Creating erd using MySQL Workbench, Forward engineering, Dimensional data model, Tableau visualisation
This is a dataware house produced in eclipse using python code, that works with a star schema i produced in order to store sales information for a fictional stationary company.
Its a PowerBI and mySQL linked Project for generating Sales Insights.
This repository is about a project to create a datawarehouse and ETL pipeline on AWS for a music streaming app. They will define Fact and Dimension tables and insert data into new tables. At the end, I'm going to process two analytical queries to check it out the top ten artists and songs.
Add a description, image, and links to the starschema topic page so that developers can more easily learn about it.
To associate your repository with the starschema topic, visit your repo's landing page and select "manage topics."