This project involves the creation and management of a database for a fictional cookie business. The primary goal was to demonstrate proficiency in database management and data visualization using Microsoft Access and Power BI.
-
Database Management:
- Created and managed tables
- Formulated and executed queries
- Exported query results for further analysis
- Analyzed data to gain insights
-
Report Generation:
- Generated detailed reports using Microsoft Access
-
Data Visualization:
- Developed an interactive visual dashboard in Power BI
- Utilized DAX (Data Analysis Expressions) for complex calculations
- Leveraged Power Query for data transformation and preparation
- Microsoft Access: For database creation, query formulation, data analysis, and report generation
- Microsoft Excel: For exporting query results from Microsoft Access for further analysis
- Power BI: For developing the visual dashboard, utilizing DAX and Power Query
-
Set Up Microsoft Access:
- Create a new database
- Design and create necessary tables
- Formulate and run queries to extract relevant data
- Export query results to Microsoft Excel for further analysis
-
Set Up Microsoft Excel:
- Import the exported query results from Microsoft Access
- Clean and organize the data as needed
-
Set Up Power BI:
- Import data from Microsoft Excel
- Use Power Query to clean and transform data
- Create calculated columns and measures using DAX
- Design and build the visual dashboard
This project showcases the integration of database management and data visualization tools to provide comprehensive insights for a fictional cookie business. It highlights the capabilities of Microsoft Access, Microsoft Excel, and Power BI in handling data-driven decision-making processes.