About Me
I’m SISSOKO Moussa
, a data analyst specializing in Power BI and SQL. I turn complex data into clear insights to help businesses make informed decisions. Explore my projects in this portfolio.
Skills
Excel | Tableau | Power Bi | Sas | Python | R studio
Project Spotlight
Power Bi
Finance Dashboard
Creating a financial dashboard to track key financial indicators is essential for both businesses and individuals. With the use of DAX (Data Analysis Expressions) in Power BI or Excel, you can create an efficient and dynamic dashboard to help with budgeting and financial planning.
World Education Insights
Understanding the Economic Impact of Education in Africa: A Data-Driven PerspectiveI'm excited to share my very first Power BI project! As a newcomer to Power BI, I embarked on creating a dashboard to analyze the share of public spending (GDP) on education in Africa, as well as education levels across the continent.Education in Africa is a cause close to my heart, and I wanted to explore how data could help uncover both the opportunities and gaps in the region's educational landscape. My goal was to create a simple yet informative dashboard to visualize some key trends.I'm pleased to share this initial project, which, although simple, has helped me appreciate Power BI's potential for analyzing real-world data. I aim to continue learning and developing more sophisticated projects to contribute positively to areas I care deeply about.
School Completion
School completion rates worldwide are on the rise, indicating significant progress in access to education. However, this positive trend hides a concerning reality: an increasing number of young people are dropping out before finishing their studies. These dropouts present major challenges, particularly in terms of economic and social development, highlighting the need for targeted solutions to support at-risk students.
Professional Certifications
Statistics with R | Delivred by University Paris Saclay
Advanced Excel
Data analysis with Python
Power Bi
Finance Dashboard
Creating a financial dashboard to track key financial indicators is essential for both businesses and individuals. With the use of DAX (Data Analysis Expressions) in Power BI or Excel, you can create an efficient and dynamic dashboard to help with budgeting and financial planning. Here's how you can approach this:1. Define Key Financial Indicators:
Income: Total revenue or earnings.
Expenses: Total costs, which could be broken down into categories like utilities, rent, salaries, etc.
Net Income: Income minus expenses.
Cash Flow: Monitoring the inflow and outflow of cash.
Savings Rate: Percentage of income saved.
Debt-to-Income Ratio: Total debt divided by total income.
2. Data Preparation:
Collect and organize your financial data in a table format. This might include transactions, categories, dates, and amounts.
Ensure that the data is clean and formatted correctly for analysis in DAX.
3. Creating Measures in DAX:
Use DAX to create calculated measures for your key indicators.Total Income:
DAX
Total Income = SUM(Transactions[Amount])
Total Expenses:
DAX
Total Expenses = CALCULATE(SUM(Transactions[Amount]), Transactions[Category] = "Expense")
Net Income:
DAXNet Income = [Total Income] - [Total Expenses]
Cash Flow:
DAX
Cash Flow = [Total Income] - SUM(Transactions[Amount]) WHERE Transactions[Category] = "Outflow"
Savings Rate:
DAX
Savings Rate = DIVIDE([Total Income] - [Total Expenses], [Total Income])
Debt-to-Income Ratio:
DAX
Debt-to-Income Ratio = DIVIDE(SUM(Transactions[Amount]) WHERE Transactions[Category] = "Debt", [Total Income])
4. Dashboard Design:
Income vs. Expenses: A simple bar or column chart showing income and expenses over time.
Net Income Trend: A line chart displaying net income over time, providing a visual of profitability.
Cash Flow Overview: A line or bar chart showing cash flow, highlighting periods of cash surplus or deficit.
Savings Rate: A gauge or percentage indicator showing the savings rate.
Debt-to-Income Ratio: A gauge or bar to represent the ratio, helping assess debt levels.
5. Interactive Elements:
Filters/Slicers: Add filters for time periods, categories, or specific accounts to drill down into the data.
KPIs: Highlight key performance indicators to quickly assess financial health.
6. Final Adjustments:
Ensure that the dashboard is intuitive and easy to interpret. Use clear labels, color coding, and concise titles.
Test the dashboard with different data sets to ensure accuracy and reliability.
This approach will give you a robust financial dashboard, enabling effective budgeting and financial management. The flexibility of DAX allows for dynamic calculations and the ability to adapt the dashboard to changing financial data.