Power BI

/Power BI

CDO Advisors Quick Start Packages

Power BI, Analytics and Data Science Quick Start CDO Advisors Quick Start packages offer businesses a low cost option to explore Power BI, Analytics or data science.  Executives know they need better information from their data and are often confused on what technologies are available to transform their data.  You know your management team is frustrated by their ability to make data driven decisions based on data science and predictive analytics.  Our quick start packages are designed to get you a working proof of concept in as little as 5 or 10 days.  All of our packages leverage your data to provide better reporting, analytics, or data science.  As a result of these packages, see exactly what your business could gain by investing in these technologies with minimal cost. Quick Start Packages: Analytics Quick Start Customer Segmentation Quick Start Power BI Quick Start RapidMiner Quick Start Text Mining Quick Start  

By |2019-05-12T15:24:18+00:00May 12th, 2019|Data Mining, Power BI, RapidMiner|0 Comments

CFO Dashboard with Power BI

Visualize Financial Data with Power BI CFO's require data from across the enterprise to ensure they can make the best financial decisions for the organization.  With data stored in disparate enterprise systems.  Presenting a consolidated view of a companies data is more difficult than ever.  Creating an executive CFO dashboard with Power BI can quickly pull together data and create a comprehension dashboard. Current CFO Challenges Getting a daily, weekly or monthly view of data is time consuming and highly manual Frustrated by limited ability to monitor and measure business performance Limited ability to accurately forecast sales or budget Access to insight into all aspects of business operations is difficult due to disparate systems Power BI Dashboard Solutions Organizations that leverage Power BI to implement executive CFO dashboards can gain the following business insights. Access data from across the enterprise to create a on stop shop for dashboards and reports [...]

By |2019-05-23T20:13:05+00:00February 3rd, 2019|Power BI|0 Comments

Top 5 Reasons Why CFOs Need Dashboards with Microsoft Power BI

How CFO Dashboards are Better with Power BI Imagine having the ability to see the data you need where and when you need it.  Dashboards enable a visual representation of your companies data in a consolidated platform.  This data can be from a variety of sources pulled together into a seamless experience for the management team.  By visualizing your data you can quickly spot trends and anomalies in your operations to take action and improve your operations.  Having a CFO Dashboard in Power BI can save time finding information, enable faster decisions and provide a clear view of your business.  By using Microsoft's Power BI to power your dashboards you get 5 key advantages. Nominal Cost of Licenses - The standard user license is $10 USD per user per month.  Get your team up and running with a minimal investment.  If you are using O365, you may already have a license. [...]

By |2019-04-22T02:06:02+00:00January 21st, 2019|Power BI|0 Comments

Power BI and Sales

Sales Management Dashboard with Power BI The example below creates a Power BI sales dashboard solution to visualize sales data for a sales manager.  The data is loaded into Power BI to create several views that enable everyone from Sales Managers to Sales Reps to gain insights into the performance of the sales team. To see the complete solution - Power BI Sales Dashboard

By |2019-04-22T02:08:23+00:00August 31st, 2018|Power BI|0 Comments

Power BI Data Quality

Build Power BI Data Quality Dashboards Organizations continue to struggle with data quality in their applications.  Finding and cleaning core data elements can often be time consuming and difficult to organize.  Business users need an easy way to see current issues in their data as well as make changes in source applications to see the impact of data corrections.  Business Analyst can create Power BI Data Quality Dashboards directly against source data to uncover data issues. In this Power BI Dashboard for Product Sales, I built data grids and graphs that show sales by Product Type, Retailer Type and Product Line.  Power BI automatically groups the data on the content available in the data.  Below are examples of data issues that popped out as I was building my dashboard. Spotting Data Quality Issues Product Type - The data shows sales for Eye wear and Eyewear, Latern and Laterns, Sun Screen [...]

By |2019-04-22T02:10:44+00:00August 26th, 2018|Power BI|0 Comments

Executive Dashboard with Power BI

Create Executive Dashboards using Power BI Managers need the ability to see data from different areas of the business.  Organizing this data into easy to use visualizations enables you to determine trends and discover insights.  In addition, you can create mashups that pull data from different sources into a single dashboard view.  Executive Dashboard with Power BI Dashboard Benefits Businesses that leverage dashboards gain more value from their data by enabling more employees to view data in an easy to use format.  No longer do you need to export data to Excel and create pivot tables and charts and then email those around the office.  Dashboards created and deployed on PowerBI.com.  Enable users to access data through a browser and securely through their tablet or smartphone using the PowerBI app. The goal of any dashboard is to visually present the most relevant data to the target audience.  By using various [...]

By |2019-04-22T02:12:04+00:00August 6th, 2018|Power BI|0 Comments

Power BI and Capital Projects

Tracking Capital Projects with Power BI This example pulls data related to projects and creates a dashboard that enables users to quickly see actual vs budget and variance.  The status of the projects are shown as well as the breakout of projects by sponsor.  The graphs are interactive and can be filtered by selecting a checkbox on the right such as CapEx or OpEx or by selecting a section on a graph such as Refinery.  There are two pages on this report to provide a comprehensive view of your projects.   To see the complete report - Capital Project Dashboard

By |2019-04-22T02:15:47+00:00July 23rd, 2018|Power BI|0 Comments

Power BI and Credit Union Membership

Credit Union Membership Map in Power BI This example uses membership data for a fictional credit union to map the members by zipcode.  A heatmap is then created to show which zip codes have the most members.  The darker the color the more members are in that zip code.  In addition, the 4 branch locations are added as red pins with a 10 minute drive time.  The map is interactive and clicking on a zip code or push pin will highlight the appropriate data.  This information was also combined with US Census data to show the number of households by income bands to help you determine where to build new locations or target your marketing efforts. Click here for the full interactive report - Credit Union  

By |2019-04-22T02:17:27+00:00July 23rd, 2018|Power BI|0 Comments

Power BI and Retail Sales

Retail Sales Dashboard with Power BI The example below creates a Power BI solution to visualize retail sales data from each store.  The data is loaded into Power BI to create several views that enable everyone from store managers to regional executives to gain insights into the performance of stores and products.  Easily see the percentage of sale by different categories such as Business Segment, Region, Category or Location. To see the complete solution on PowerBI - Retail Sales Dashboard

By |2019-04-22T02:18:25+00:00July 17th, 2018|Power BI|0 Comments

Power BI and Text Mining

  Finding the Loch Ness Monster The example below uses the sighting information from LochNessSightings.com to determine the area that provides your best chance of viewing the Loch Ness Monster.  This report is based on the out of mining the text descriptions using RapidMiner to find the common nouns in the text.  Then the out is stored and visualized with Power BI to produce a heatmap with the sightings.  In your business, you can use this same technique to text mine any description fields such as call center notes, claim notes, part failure information, project notes.  To quickly spot trends or anomalies in your data. View the report here - Loch Ness Monster Sightings in Power BI  

By |2019-04-22T02:21:12+00:00July 9th, 2018|Power BI|0 Comments