1) Stories about our Passion For Data,
2) The DAX TOPN and RANKX in PowerBI,
3) a Sales Lead – Marketing Lead Funnel example
#TOPN #SalesFunnel #Marketing #Sales
00:00 Introductions
2:20 Data Success Story : My SuperWide Printer Data Testing Passion for Data Story Charles Elwood
6:40 Data Success Story Sales and Demand Forecasting : Mean time to failure data. by Tyler Betthauser Product Mix with forecasted failure rate. Predicting the future.
9:57 IoT data is overwhelming data. Slow to analyze.
12:00 Andrew Hoekstra – Fell in love with data in the railroad industry. any industry becomes interesting when you view it from a data pattern perspective. Physics of railroad of steel. Analysis on the rails. Years to learn the old system to create forecast and tweak parameters. Data has power to make life easier and job more fun.
16:17 SAT story – Charles Elwood – picking up patters. Math side was able to pick up patterns in SAT problems. Save thousands of dollars with a good test score. Save 50k in a few seconds over the phone with data.
18:40 Problem Solving skills most important thing Tyler learned in High School.
20:33 battle scars from data trying to tackle hard data problems. business problems are often easier to solve and can help lead to funding and momentum to tackle the large problems.
22:34 Abstraction in multidimensions can be hard to comprehend. So easy to start in PowerBI but can get really abstract and difficult to understand.
24:30 KAGGLE has lots of example real data sets. Marketing funnel data from company in Brazil. Sometimes they define the business process. They have the schema with keys. PowerBI auto created relationships.
29:07 KAGGLE SALES LEAD FUNNEL EXAMPLE : Tyler working on predict which leads will close, distribution of data is even shown on the website.
31:10 Merged the two tables together. Then split into star schema. Structured with two date tables. One for close date and signup date. Then started working through sales rep and sales development rep lookup table.
33:25 example in Python Jupyter. Pandas bring in two tables. merging then in pd.merge command. in python, pass in table that is filtered. example of closed deal.
39:44 Charts from sales funnel data from Kaggle. spike in leads in Dec 2017. Categories that were high in leads. Closed by salesperson. Datediff function to find how long it to close leads.
41:50 Dependencies on previous time frames. Top end insights great launching point for more questions. Want to improve behavior. Forecast cause behavior change but then you need to get a whole new data set because behavior has changed.
44:40 time to close had huge variation. Great spot for TOPN, top 19 are in one industry, is there something different with that industry.
45:26 SALES and MARKETING FUNNEL CREATE YOUR OWN DATASET EXAMPLE : create fake data set with time steps for each stage. remove traceability in many datasets.
46:56 Used Group by, to pick the latest time stamp by client. Now in the funnel, you can see how well the pipeline is filled up.
49:00 How do you get people into the top of the filter, or how to increase conversion at lower steps in the filter. How fast between each stage.
51:00 Oversell and overload production and bottlenecks. Level load the sales funnel steps and conversions. prioritize your work on industry. scoring your leads. increase conversion by picking which ones can convert.
53:51 Working on my own funnel. Landing to Class, to call, to next class, to another call. Using Thinkific to host classes.
55:26 TOPN() and RANKX() : Using AdventureWorks data set. TOPN to filter by 3 products by sales in each country. RankX function to rank sales and check the data in TOPN.
57:00 I use DAX Studio and wrap in evaluate you can visualize your tables. I use for VALUES and TOPN. I then use SUMX or CONCATENATEX to wrap the function into a way to visualize.
59:29 Have PowerBI running first. Select PBI option, then select the File that you have open. 1:00:00 Use Values function to pick out ProductNames. (Distinct). Pandas is Unique.
Network with Charles Elwood Signup for my free BETA PowerBI tutorial on the website! www.solismatica.com https://www.linkedin.com/in/charleselwood/
Connect with Tyler Betthauser at Conaxion https://www.linkedin.com/in/tylerbetthauser/
Connect with Andrew Hoekstra https://www.linkedin.com/in/andrewjhoekstra/
Looking for a data set to work on? Check out Kaggle’s website https://www.kaggle.com/olistbr/marketing-funnel-olist?select=olist_closed_deals_dataset.csv
Want a sample data set to work on related to store operations? : Download Link for the AdventureWorks Dataset https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms
Download DAX Studio here….I use this to visualize my tables in PowerBI. ie VALUES and TOPN functions shown in this video. https://daxstudio.org/