Business Intelligence

3 Types of Dashboards Executives Need Today

3 Types of Dashboards that Executives Need Now In this blog, we will be doing a quick review of the benefits associated with each of the 3 types of dashboards to determine which is right for your business. The common dashboards are operational, strategic, and tactical. To learn the basics of dashboards, refer to our previous blog detailing the properties of dashboards in Power BI. Operational Dashboards An operational dashboard is a tool that is used to monitor business processes that fluctuate constantly and the current performance metrics vital to your business. These dashboards often update on a minute to minute basis providing the most accurate and up to date information. Operational dashboards frequently used to monitor a company's progress towards a specific metric or goal, usually a specific department or branch. Azure Monitor tracks the usage and capacity of Azure applications IndustrySafe provides up [...]

By |2020-06-05T13:57:54-05:00June 5th, 2020|Business Intelligence, Power BI|Comments Off on 3 Types of Dashboards Executives Need Today

Introduction to Business Dashboards

What are Business Dashboards? Just like your car, a business dashboard collects in one location all of the critical information you need to run your business.  A management or executive dashboard should be easily accessible and like an automotive dashboard organizes and visually displays your data from various sources in one location.  They are critical for business intelligence solutions and enable self-service analytics for your employees.  If your employees do not know how you are performing against KPIs they are unable to make the best decision to improve performance. Why You Need Business Dashboards? Dashboards differ from traditional reporting in many ways.  First they are designed to visually see lots of data in a single location.  Management dashboards mash up data from your various sources to make it easy to for you to monitor your business.  Easily merge KPIs from you various departments into a single organization view.  No [...]

By |2020-06-26T13:51:03-05:00June 2nd, 2020|Business Intelligence|Comments Off on Introduction to Business Dashboards

Trend Analysis with Power BI using MLB Data

Trend Analysis with Power BI Businesses use trend analysis to help improve your business operations.  This is done by monitoring data to identifying areas where your business is performing well so you can duplicate success.  As well as determine areas in your business that is under performing.  One way to improve operations is through trend analysis with Power BI reports and dashboards. Unlock you data's hidden secrets by building powerful visualizations that let you quickly spot trend and patterns.  Using Power BI you can easily connect to data and then build reports with interactive visualizations. Examples for Trend Analysis All businesses can use trend analysis to gain insights into their business.  Common examples include: Call Center Volumes Sales by Customer Expenses by Category Revenue by Product or Service Claim Volume Oil Production Manufacturing CRM Data ERP Data Learn more about Trend Analysis Trend Analysis with [...]

By |2020-06-26T13:09:59-05:00March 11th, 2020|Business Intelligence, Power BI|Comments Off on Trend Analysis with Power BI using MLB Data

Visualize Baltimore Crime Reports with Power BI

Use Power BI to Visualize Baltimore Crime Reports Using Power BI to Visualize Baltimore Crime Reports With Power BI you can take raw data and quickly transform it into easy to use visualizations.  For this example, I will be using data from the Baltimore police crime reports public dataset that has data points back to 1963.  However, most of the data really starts in 2014.  I wanted to see what I could build from the dataset and spent a few hours pulling together the data and then building reports that enable me to see various trends about Baltimore crime reports. Here is a sample of the Baltimore Crime Reports available for download.  As you can see it is difficult to spot trends and outliers in this format.  If you are looking to visualize your crime report [...]

By |2020-06-26T13:49:37-05:00January 5th, 2020|Business Intelligence, Power BI|2 Comments

Attending Microsoft Business Application Summit

I will be in Atlanta for the Microsoft Business Application Summit.  I hoping to get more information on Power BI and how others are leveraging Power BI along with Power Apps.  This should be a great opportunity to meet people and get ideas on best practices and out of the box solutions for data visualizations. If you are interested in meeting please let me know. Microsoft BA Conference

By |2019-11-26T09:55:45-06:00June 2nd, 2019|Business Intelligence|Comments Off on Attending Microsoft Business Application Summit

Better Understand Your Credit Union Members

Increase Membership with Analytics Leverage advanced data visualization tools to better understand your members and increase membership with analytics.  By combining your credit union member information and external postal code level demographic data.  Maps can be created that color code each postal code based on the concentration of members.  For example, in the graph below postal code 78222 has 40 active members.  In addition, there are 3,685 households that earn under $50K dollars.  There are also 2,440 households that earned between $50K and $100K.  As well as 1,096 households that earn over $150K.   There is also information available for each postal code that lets you know the number of people that rent vs buy their homes, how many cars people have, average number of children and age in each household.  By using this information you can market to your existing customers like never before.  In addition, you can better understand [...]

By |2020-05-17T10:50:00-05:00May 23rd, 2018|Business Intelligence|Comments Off on Better Understand Your Credit Union Members

2018 CIO Review Business Intelligence Solution Provider

CDO Advisors included in the Top 20 Business Intelligence Solution Providers We were just included as a 2018 CIO Review Business Intelligence Solution Provider. While data analytics solutions such as BI and predictive analytics have already emerged as an integral factor in bolstering the value chain of big businesses, the Small and Medium Businesses (SMB) are yet far from leveraging their impeccable benefits. The existing rumor that these services are highly expensive, and the challenge of poor data quality and sheer lack of awareness on progressive technology, have become the biggest blocks in preventing SMBs from availing data analytical services. Drawn by the situation, Derek Wilson, an astute entrepreneur endeavored on a journey to aid SMBs to extract maximum value from their data sets. Thus, saw the creation of CDO Advisors, the IT advisory and consultant firm, providing end-to-end data services ranging from data management, business intelligence, predictive analytics, to data [...]

By |2020-05-17T12:15:59-05:00May 6th, 2018|Business Intelligence|Comments Off on 2018 CIO Review Business Intelligence Solution Provider

Speaking at the Global Predictive Analytics Conference

Implementing Predictive Analytics into Operational Workflows I will be presenting on April 3rd 2018 in Santa Clara, CA at the Global Predictive Analytics Conference.  My session focuses on how to build predictive analytics and integrate the model into your business.  I will examine two use cases: Customer Churn and Cross Selling and demonstrate the process to build the model from start to finish.  Where and how to engage with business teams to ensure the success of the project.  In addition, I will show how pilot projects build collaboration between the data science teams and business units to ensure both teams understand what is required for successful projects. For complete information on the conference - Predictive Analytics Conference Homepage

By |2020-06-29T08:05:32-05:00February 27th, 2018|Business Intelligence|Comments Off on Speaking at the Global Predictive Analytics Conference

RapidMiner Text Mining Example for Loch Ness Monster Sightings

RapidMiner Text Mining Text mining is a process to pull words from free form text fields, word documents, or other data sources.  Business use cases for text mining include scrubbing text from survey notes, claim notes, project notes or call center notes.  It is applicable in any situation that requires parsing text to find words and the number of times they appear.  These include uses in various business functions such as Risk Management, Customer Service, Project Management, or Knowledge Management.  RapidMiner text mining enables you gain insight from your business information and transform that into knowledge and actionable insights.  In this example, I will use data collected from the Loch Ness Monster sighting website.  Each sighting is posted with a date and free form text field.  The goal of this example is parse the sighting and determine the most common words by frequency from the information provided. Sample siting from website [...]

By |2020-06-29T13:18:15-05:00September 26th, 2017|Business Intelligence|Comments Off on RapidMiner Text Mining Example for Loch Ness Monster Sightings
Load More Posts