About Jakob Wilson

I am currently in college and will be attending the University of Houston in the fall of 2020. I focus on Power BI related initiatives with CDO Advisors. In addition to writing blog posts, I perform inside sales to help identify customers and accounts that can use our consulting and training expertise.

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

How to Model Power BI Covid 19 Data

How to Model Covid-19 Data using Power BI This is the second in my series on helping you turn the Covid data on GitHub into information.  In this post, I show you step by step on how to model Power BI Covid data using Power BI, Power Query and DAX formulas.  If you are new to Power BI or just interested in how to use Power BI to build your own Covid report this guide was designed for you. Getting up to Speed - Model Power BI Covid In the last guide (link below) we took GitHub data and transformed it into a model showing the cumulative Covid-19 cases. In today's guide we will be enhancing the model to make it easier to use.  Let's get started and Model Power BI Covid data. Build Power BI Covide Reports from [...]

By |2020-06-26T11:43:33-05:00April 1st, 2020|Power BI|Comments Off on How to Model Power BI Covid 19 Data

Build Power BI Covid Reports from GitHub Data

A Step by Step Guide to Build Power BI Covid Data Reports from GitHub Covid-19 is top of mind and getting to the data can be easy if you know how.  Currently, there is the Johns Hopkins Covid GitHub project that is collecting data around Covid-19 on cases based on countries from around the world.  In this step by step guide, I show you how to use Microsoft Power BI and the Web Connector to access the time-series data.  The same process can be used for any GitHub repository if you have the proper URL.  Follow the steps below or watch my video to see exactly what you need to do for access to this dataset.  By the end of the guide you can build a Power BI Covid 19 report from the GitHub data. Many are familiar with the Johns Hopkins Coronavirus online tool.  Learning these skills you can make your [...]

By |2020-06-26T08:56:13-05:00March 30th, 2020|Power BI|Comments Off on Build Power BI Covid Reports from GitHub Data