Recently a client came to us to see if we could help them automate their RFP distribution system. Currently the client has an employee manually check several websites for RFPs and alert the appropriate business vertical when a relevant RFP is found. The current system requires manual data scraping, meaning the process is slow and results in RFPs being missed. For the proof of concept phase with the client, we decided to build a machine learning model to classify the RFPs correctly and provide a way to automate the routing of the RFPs. The client wanted to break the project into stages so once the initial Proof of Concept was successful, other parts required to automate the whole process would receive the go-ahead.
Microsoft has just introduced dataflows to Power BI service which they see as the next step in the self-service revolution Microsoft began with Excel. Dataflows incorporate the necessary ETL steps and allows other people to access and work with the dataflow. Think of dataflows as power query on steroids with the capability of multiple users to take advantage of a centralized ETL operation on data.
This dashboard probably looks very familiar to you. You might have five or six dashboards you’re watching for ebbs and flows, spikes and surges. Maybe you have a very advanced process that involves downloading data into Excel and mashing different channels together. But that doesn’t sound very advanced, does it? Manual data entry? Staring at four online dashboards, commenting on "this one is up, or this is down"? There’s nothing advanced here. It doesn’t tell you how people responded, how their interactions lead to anything. Do you let your marketing data impact future creative decisions? If it's not producing marketing intelligence, your marketing data is completely useless.
Up here in the North Country the chill of the fall weather is just starting to set in. Over the next few months we'll hit some bone chilling temperatures and dig out the long-underwear. Nothing warms the heart and soul like a hearty bowl of soup, especially one perfected through the years with a bit of Grandma's love. If Grandma has taught us anything, it's that when you serve her soup you don't use a teaspoon - you use the ladle.
My wife rolls her eyes every time I pull out Microsoft’s Power BI to analyze our personal bank statement data. Perhaps she doesn’t want me to know how much she spends each month on Starbucks Grande Chai Lattes… no whip. The reality is, I utilize Power BI whenever possible. In fact, these days I find it hard to engage in a business intelligence strategy discussion without Power BI being part of the conversation.