Andy Kriebel’s Post

What do you? We offer 2 services. 1. Custom reporting systems with a focus on margin analysis. For example if you are selling online on multiple channels and do not have a clear breakdown of margins, by product, by channel we create you a tool to get you that. That way you can make important decisions in real time about dropping products, raising prices, changing suppliers etc. 2. Advanced data analysis. If you have a pressing business question and your data is a mess we can get you the answers. #2datasense #data #powerbi #excel #etl

Ready to learn an incredibly simple way of using set actions in Tableau to deselect marks? This video will help. I take you through two examples: 1. Using a set action to click on a region and sort a stacked bar chart based on that region, then use a highlight action to deselect the region selected. 2. Using a set action to compare quarterly sales to the sales of a selected quarter. Then use a highlight action to deselect the quarter selected. Check it out → https://lnkd.in/eXCuHp5B How can you put this in to practice this week?

🗓 Day 1: Dynamic Summation 🎉 Welcome to Day 1 of our Excel Mastery Series! Today, we dive into the powerful SUMIFS formula. Whether you're tracking sales, analyzing data, or managing inventory, mastering this formula will supercharge your data analysis skills. 📊 Formula: SUMIFS 🔍 Functionality: Adds up numbers that meet multiple conditions. Example: Calculate total sales for "Product A" in the "North" region for Q1. Formula: =SUMIFS(C2:C50, A2:A50, "Product A", B2:B50, "North", D2:D50, "Q1") Real-World Example: If you have sales data in columns A (Product), B (Region), C (Sales), and D (Quarter), this formula will sum sales for "Product A" in the "North" region for Q1. 💡 Challenge: Can you adjust this formula to calculate total sales for "Product B" in the "South" region for Q2? Share your formula in the comments! 📈 #Excel #DataAnalysis #AdvancedExcel #DataScience #DataVisualization #ExcelTips #BusinessIntelligence #BI #ExcelTricks #DataAnalytics

🚀 **Excited to Share My Latest Project!** 🚀 I recently completed a project where I created a **Sales Dashboard for a Coffee Shop** using **Excel**, with data sourced from the Maven Challenges Maven Analytics. 🎯 📊 The dashboard provides a dynamic overview of sales performance, Top 15 Products.  Key features include: ✅ **Sales Analytics**: Visualized sales trends in different states.   ✅ **Customer Insights**: Identified peak hours and popular products to enhance decision-making. This was a great opportunity to sharpen my Excel skills, working with advanced functions like **pivot tables**, **charts**, **data validation** to make the dashboard user-friendly and insightful. 📈 #Excel #DataAnalytics #SalesDashboard #BusinessIntelligence #MavenChallenges #CoffeeShop #DataVisualization #ExcelTips #DataDriven

COMPANY FINANCIALS ANALYSIS DASHBOARD USING EXCEL I just wrapped up building a financial dashboard using Excel that analyzes key financial metrics for better decision-making! This dashboard provides insights into: 1. Total Sales, Profit, and Units Sold 2. Profit by Segment (from small businesses to government sectors) 3. Sales and Profit Trends by Month 4. Gross Sales by Product 5. Top Products by Units Sold 6. Discounts vs. Gross Sales 7. Manufacturing Price vs. Sales Price The data was sourced from a Kaggle dataset: https://lnkd.in/d5ix6A5u . This dashboard helps companies track performance metrics, identify top-performing products, and analyze sales trends over time. By using slicers, users can filter data by segment, product, and region, making it an interactive and valuable tool for decision-makers. I’m excited to continue building dashboards that provide actionable insights for businesses and professionals. GITHUB LINK TO THE PROJECT: https://lnkd.in/dZY7AhNu #ExcelDashboard #DataVisualization #FinancialAnalysis #BusinessIntelligence #SalesAnalysis #DataDriven #DecisionMaking #DataScience #Finance #DataAnalytics

✅I just finished the Case Study: Net Revenue Management in Excel from Datacamp. I learned about how to make decisions based on data to increase a company´s revenue considering the 5 pillars of net revenue management: 1. Brand portfolio pricing 2. Pack price architecture 3. Mix management. 4. Promotion management. 5. Trade terms management.

I've created a Power BI dashboard that dives deep into monthly sales, analyzing both price and quantity. This data-driven approach offers invaluable insights into product performance, pricing strategies, and customer behavior. By optimizing pricing and inventory based on these findings, hypermarkets can significantly boost revenue and profitability. My Power BI dashboard reveals a fascinating correlation between our recent lottery promotion and increased sales. Average daily sales and the number of transactions exceeding 10 million rials have soared, demonstrating the lottery's effectiveness in attracting high-value customers. This data-driven insight highlights the power of strategic promotions in driving sales growth. #powerbi #dataanalyst #businessanalyst #datadrivendecision #dashboard #businessintelligence

📊 Introducing the SuperStore Analysis Dashboard on Tableau! This project offers a detailed visualization of sales, discounts, and profits from 2014 to 2017. 🚀 Key Insights: 📈 Total Sales Trends: Explore the evolution of our sales over the specified years, highlighting significant changes in these years. 💸 Impact of Discounts: Analyze how discounts influence sales volume and overall revenue. Understand the strategic implications of discounting on profitability. 💰 Total Profit Analysis: Gain insights into our profitability journey across these years, identifying key factors that contributed to financial outcomes.

Goal : To transform the data into a dynamic dashboard that franchise owners can use to identify patterns, trends and oppurtunities for the business OBJECTIVE 1 - Prepare the data for analysis - Added a new column to calculate Revenue (price * quantity) - Added new columns to calculate Month and Day of Week based on the transaction date (BONUS: display them as text (ie “Jan”, “Feb”, “Sun”, “Mon”), instead of numerical values) - Added a new column to extract Hour from the transaction time OBJECTIVE 2 - Explore the data with Pivot Tables - Inserted a PivotTable on a new tab to show revenue by month - Added two more PivotTables (on the same sheet) to show the number of transactions by day of week and by hour of day - Added a PivotTable (on the same sheet) to show the number of transactions by product category, sorted descending by transactions - Added a PivotTable (on the same sheet) to show the number of transactions and revenue by product type, sorted descending and filtered to the Top 15 (by transactions) OBJECTIVE 3 - Build a dynamic dashboard - Added Pivot Charts to show revenue by month as a line chart, transactions by day of week and hour of day as column charts, and transactions by product category as a bar chart - Added a slicer for store location, and connect it to all of the PivotTables on the sheet - Adjusted formatting, alignment and polish to finalize the dashboard Result : Observed interesting patterns or trends and suggested recommendations to improve Maven Roasters operations #excel #dataanalysis #pivottable #businessanalysis

I developed a LEX MARKET Analytics Power BI Dashboard to provide stakeholders with critical insights into sales volume, sales value, and stock balance. By pinpointing key performance indicators, this sophisticated tool enables precise calculations of stock balances alongside sales metrics, ensuring the accurate assessment of sales values.📊 The dashboard has detailed performance charts and metrics, delivering a comprehensive monthly analysis that uncovers deep insights into the LEX market’s sales performance and stock management. This powerful tool supports informed, data-driven decision-making, allowing stakeholders to optimize sales strategies and stock management within the LEX market.📶📈 #PowerBI #DashboardDesign #DataVisualization #DataAnalytics #Project #LEXMarket #SalesAnalysis #StockManagement #Statistics