The primary objective of this project is to conduct an analysis of Health Co patient data to advise the Analytics General Manager for his upcoming board meeting.
- 🤓 Description
- 💻 Dataset Overview
- 📊 Exploratory Data Analysis
- 🚀 Business Questions
- 📗 Notebooks
- 📧 Contact Information
The General Manager of Analytics at Health Co has urgently requested help analysing their user_logs dataset.
We have been asked to quickly analyse the dataset and answer questions about active users for an upcoming board meeting.
The primary goal of this undertaking is to comprehensively investigate the provided dataset and furnish well-informed responses, driven by data, to the questions posed by our client.
The Records Department have supplied the user_logs dataset in an excel csv format. The file can be accessed through the following link:
The provided user_logs dataset contains the following variables:
| id | log_date | measure | measure_value | systolic | diastolic |
|---|
Dataset preparation
For this analysis the excel file was imported in Microsoft SQL Server and MSSQL queries were used to explore the data. A health database was created with user_logs table.
See the following steps for more detailed procedure for importing Excel files into SQL Server to create databases.
Step 1: Prepare Your Excel File
Ensure your Excel file is organized with a header row and data in subsequent rows. Verify that the column names and data types in the Excel file match the table structure you want to create in SQL Server.
Step 2: Set Up SQL Server
Ensure you have SQL Server installed and configured on your system. Create a new database or identify an existing one where you want to import the data.
Step 3: Install Required Drivers
Check if you have the necessary ODBC or OLE DB drivers installed on your system. If not, you may need to install them. You can usually find these drivers in the SQL Server installation package.
Step 4: Open SQL Server Management Studio (SSMS)
Launch SQL Server Management Studio (SSMS) on your computer.
Step 5: Connect to SQL Server
Connect to your SQL Server instance by providing the server name and appropriate authentication method (Windows or SQL Server Authentication).
Step 6: Import Data Using the SQL Server Import and Export Wizard
In SSMS, right-click on the database where you want to import the data, and choose "Tasks" > "Import Data."
Step 7: SQL Server Import and Export Wizard - Introduction
In the SQL Server Import and Export Wizard, you'll see an introduction screen. Click "Next" to proceed.
Step 8: Data Source
Choose the "Data Source" as "Microsoft Excel." Click "Browse" to locate your Excel file. Specify the version of the Excel file (Excel 97-2003 or Excel 2007+). Select the appropriate Excel worksheet if your file contains multiple sheets. Click "Next."
Step 9: Destination
Choose the "Destination" as "SQL Server Native Client." Enter your SQL Server connection details, including the server name, authentication method, and database name. Click "Next" to proceed.
Step 10: Copy Data from Excel
In the "Copy data from one or more tables or views" section, you can choose to copy data from the Excel file into an existing table in your database or create a new table. If creating a new table, you can map the Excel columns to SQL Server table columns. Ensure that data types match correctly. You can also set options for handling duplicate records. Click "Next" to continue.
Step 11: Review and Execute
Review the settings you've configured. If everything looks correct, click "Next."
Step 12: Complete the Wizard
The wizard will now run the import process, and you'll see a summary of the operation. Check for any error messages or warnings. If there are any issues, you can review the details and correct them. Once the import is successful, click "Finish" to complete the wizard.
Step 13: Verify Data
Open SSMS, connect to your SQL Server database, and query the newly imported data to ensure it has been successfully transferred. Your Excel data is now available in your SQL Server database, and you can use it to create tables, views, or perform other necessary operations. After importing, consider any additional data cleaning or transformation tasks as required for your specific use case.
The database was accessed and explored using Python and SQL SERVER.
Let’s cover the business questions that we need to help the GM answer!
- How many unique users exist in the logs dataset?
- How many total measurements do we have per user on average?
- What about the median number of measurements per user?
- How many users have 3 or more measurements?
- How many users have 1,000 or more measurements?
Looking at the logs data - what is the number and percentage of the active user base who:
- Have logged blood glucose measurements?
- Have at least 2 types of measurements?
- Have all 3 measures - blood glucose, weight and blood pressure?
For users that have blood pressure measurements:
- What is the median systolic/diastolic blood pressure values?
The Notebook for the "Exploratory Data Analysis" can be accessed below:
The Notebook for the "Business Questions" can be accessed below:
- Email: [email protected]
- LinkedIn: Sean Dhanasar