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

🚀 **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

Coffee Sales Data Analysis📊 – Excel Project Completion 💫 I am excited to share that I have successfully completed a Coffee Sales Data Analysis project using Microsoft Excel! This project involved analyzing sales trends, and customer preferences to gain actionable insights. Key Highlights of the Project: ✔ Data Cleaning & Processing – Organized raw sales data for accurate analysis. ✔ Pivot Tables & Charts – Used to visualize sales performance by region, product type, and time period. ✔ Revenue & Profit Analysis – Identified the best-selling coffee products and highest revenue-generating regions. ✔ Trend Analysis – Observed monthly and seasonal sales fluctuations to optimize business strategies. ✔ Dashboard Creation – Designed an interactive and dynamic Excel dashboard for quick insights. This project enhanced my data analytics, Excel automation, and business decision-making skills. Excited to apply these insights to real-world business scenarios!

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

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

✅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.

📊 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.

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