Need advanced data analytics techniques to analyze profitability data
Here’s an example of how customer segmentation helped identify some low margin service offerings:
I was live tweeting during our monthly PASS Business Analytics VC meeting, Here are the tweets to learn about 13 Excel Tips!
Thanks everyone who attended, I hope it was helpful!
Here are some ways to follow the Virtual Chapter:
Asset (Volunteers, Field offices & Equipments) management & planning for a global crisis response team.
Working in a team, we created statistical surveys for field works to collect data about current state & estimated future needs. We also helped them with data gathering & cleaning tasks. After that, we helped them analyze & visualize the data to find actions for executives leading the global crisis response team.
Here’s a mockup of one of the ten data visualization created for them:
This post is a quick summary for all Business Analytics related updates that I saw at PASS Summit’14:
1. Theme of the Keynote(s)/Session(s) seemed to be around educating the community about the benefits of the NEW(er) tools. I saw demos/material for cloud-based tools like SQL databases, Azure stream analytics, Azure DocumentDB, AzureHDInsight & Azure Machine learning. The core message was pretty clear: A data professional does two things – 1) Guards data OR 2) helps to generate Insights from Data – And they will need to keep up-to-date on the new tools to future-proof their career.
2. Coming soon: Power BI will be able to connect to on-premise SSAS data sources (multi-dim & tabular).
3. Coming soon: A better experience to create Power BI dashboards.
— Eric Flamm (@eflamm) November 5, 2014
Read more about Power BI updates here: http://www.jenunderwood.com/2014/11/05/pass-summit-2014-bi-news/
4. Azure Machine Learning adds a free-tier! You won’t need a credit-card/subscription to sign up for this.
5. I also saw sessions proposing new way of thinking about an architecture for “Self Service BI” and “Big Data” which might be worth following because since these are newer tools, it’s definitely worth considering an architecture that’s designed to make the most of the investments in these new tools. That’s it & I’ll leave you with a quote from James Phillips from Day 1′s keynote:
— Paras Doshi (@paras_doshi) November 5, 2014
Need a daily report delivered in sales team’s inbox that shows Sales Team’s Bookings vs Quota for current & next month.
Ability to see Bookings vs Quota in near real-time is a key to effectively manage performance for any sales team. Before the project, analyst(s) would have to manually put together this report and since the report took more than a day to put together they couldn’t afford to run it daily and so they delivered this report bi-weekly/monthly basis to the sales team. After the project, the process was automated and the sales team received an email with a report on a daily basis and this helped them see Bookings vs Quota in near real-time. As a famous saying goes “if you can’t measure it, you can’t improve it” (by Peter Drucker) – in this case, the report helped them measure their actual numbers against their goals and helping them improve their sales numbers which directly hits their top-line!
Tools used: SharePoint report subscription, SQL server analysis services, SQL Server Integration services, SQL server reporting services & Excel.
Note: Drill down reports are not shown and the numbers are made up.
In this post, I’ll list few examples from various industries to help you differentiate between business intelligence and data science problems.
Sometime back, I blogged about “Business Analytics Continuum” and in the post we saw that Every Organization has DATA but they use their business data at different levels because of their maturity level. Excel (or other transactional reporting tools) is usually the starting point for any organization – it helps them see WHAT happened. They advance to the next stage, where they get capabilities to slice and dice their data – To find out WHY – and usually this capability is delivered using Business Intelligence tools & techniques. Once the data culture spreads – Thanks to a successful Business Intelligence project – then they soon start to outgrow their business intelligence capabilities by asking problems that need predictive capabilities. This is advanced analytics and Data Science stage. To that end, here are 5 examples to help you differentiate between business intelligence and data science problems:
|Business Intelligence.(WHAT & WHY)||Data Science & advanced analytics.|
||Can you predict bike rentals on an hourly basis?|
||Can you predict the credit risk of the customer during contract negotiations stage?|
|Customer relationship management||
||Can you predict customer churn?|
||Can you predict whether a scheduled flight will be delayed by more than 15 minutes?|
||Can you classify a customer feedback comment into “positive”, “negative” or “neutral”?|
I hope this helps!
you are analyzing a dataset and before modeling/analyzing you need to generate descriptive statistics on a field. you have the data loaded in Excel and wondered if there’s a way to do that in Excel.
There’s an out of the box solution that will support your needs to generate descriptive statistics on a field. Here are the steps:
Note: for the purpose of this blog post, I am using Excel 2013 but data analysis toolpak is available in Excel 2007+.
1. Active “Data Analysis” toolpak.
Follow this steps: File > Options > Add-ins > Manage: Excel Addins > “GO”
2. make sure to check the “analysis toolpak” checkbox.
3. Now you should see a “data analysis” option under the “Data” pane:
4. Now click on “Data Analysis” and select one of the following options:
Anova, Correlation, Covariance, Descriptive Statistics, Exponential Smoothing, F-Test Two-Sample for Variances, Fourier Analysis, Histogram, Moving Average, Random Number Generation, Rank and Percentile, Regression, Sampling, t-Test, z-Test.
in this case, let’s go with descriptive statistics but you can see that you can perform other tasks as well.
5. Once you click on the descriptive statistics, a dialog box will show up and you will have to enter some data like your input range to generate descriptive statistics. Once you have filled the data needed, click on OK and it should generate descriptive statistics for you in EXCEL!
I hope that helps!
In this post, we saw how to generate descriptive statistics in Microsoft Excel.
Author: Paras Doshi
Profitability equals revenue minus costs – To that end, A supply chain executive is mostly focused on optimizing cost elements to drive profitability. Here’s a mock up of a dashboard created for an executive to help him keep an eye on the overall health while making sure he gets alerted for key cost categories.
The Dashboard was created using profitability data-set & also had drill down capabilities to analyze numbers for cost buckets like Raw materials, manufacturing & logistics.
Dan English and I got the “PASS Outstanding Award” for our work with Business Analytics Virtual Chapter. Thanks & Congrats Dan, It’s great to have you on the virtual chapter’s leadership team :)
Originally posted on Dan English's BI Blog:
Just a couple of weeks ago I received an email notifying me that I had been nominated as one of the PASS Outstanding Volunteers for September 2014! The official email stated that Paras Doshi, the PASS Business Analytics Virtual Chapter co-lead were selected for our excellent work with the Business Analytics Virtual Chapter.
The official list for the PASS Outstanding Volunteer nominations is listed here –> Outstanding Volunteers
Dan English and Paras Doshi – Dan and Paras are model Virtual Chapter leaders. They have taken the BA VC to a new level in terms of activity and audience and have done wonderful, innovative work when it comes to posting session recordings on YouTube. Through their efforts they promote growth for PASS in terms of audience and the range of content offered – not just SQL server, but the holistic data platform. They have gone from being completely new VC…
View original 83 more words