Analyzing Steemit Data Using Power BI

Power BI a Brief History

In 2010 Microsoft released Power Pivot, the first of the Excel Power Tools.  Power Pivot will allow you analyse multiple tables of data against each other, removing the hell in a cell associated with Excel.  Along with Power Pivot comes a functional language very like Excel formula that can be used to model and carry out complex calculations on the data.

Next, in 2013 Microsoft released Power Query and Power View.  Power Query will allow you connect to multiple sources of data and transform that data into a usable format. Like Power Pivot, Power Query also comes with its own language know as M.

Power View is then use to visualize and tell stories about that data.

These Excel Power Tools became the basis for self-service business intelligence for the end user.

Image from Makeuseof

In 2015 Power BI was released.  Power BI is made up of Power Pivot, Power Query and Power View, but without excel.

Big Data, Business intelligence, actionable insights, and all these words are floating about and you are wondering, How can I use data to get and insights? What data can I use? What software can I use? How much will it cost me?  What skills are required? How can I get started? 

Let me debunk the first myth. High cost of entry.  Business Intelligence, actionable insights, interactive dashboards are within the budget of every company, every business, every brand. 

In 2015 Microsoft released PowerBI to the general public.  The desktop versions is completely free, and there is also a free trial period for PowerBI Services.

The second myth is that a company or business needs a data scientist to make sense out of the data. A company needs someone that understands the business, so when a trend is spotted the business expert knows why and if corrective action is needed. 

PowerBI offers Insights to data by carrying out Microsoft machine learning on your data.  Power BI also offers a suite of Connectors that comes with pre built dashboards, all you need to do is connect to your data. Power Bi is a self-service system, its aim is to allow anyone analyse data to get meaningful insights.

Analyzing Steemit Data with Power BI


To set up the interactive dashboard, I connected to the SQL SteemitDB via Power BI Desktop. This database is kept by @arcange (awesome job by the way!).  I found the log in details on an old post from 10 months ago https://steemit.com/steemit/@arcange/steemsql-com-how-to-create-a-steem-analytic-report-with-microsoft-excel

As I have connected to an SQL server, this data is not live.  However if the database was stored in Azure SQL Database I could run live reports……this is something I would like to do but I would need to fund the Azure account so let’s see how these posts do here on Steemit and see if this is something the community want

In the interactive report, I have only looked at two tables of data available in the database.  This table is Accounts and AccountsTX.  I have filtered these datasets to only include accounts that have been set up from the 1st 1 July 2017 and 11th July.  So the current month.

I do not know SQL, and I also do know the query language M, so I am reliant on the fact the Power BI is self-service.  I found it simple to connect to the database, but there was an element of difficulty when I was transforming the data, especially when I was trying to extract the Profile information such as location and websites.  I haven’t yet read any documentation on the Database, so the information is purely from exploration.

The idea was to look at new users and find out a bit more about them and their activity on Steemit.  However what has stood out to me is the signs of low retention, and I think this warrants more exploration in another post and analysis.

I was very surprised to see that less than 50% of accounts registered with Steemit this month have actually made a post.  I also found it very interesting that new users are not utilizing their profile.  Only 18% have completed the ‘about’ section and less than 9% have included a link back to a website or other social profile.

Anyway this dashboard is interactive, so please do play around with it. (Amended, Steemit does not support the iframe for this interactive dashboard so below is a screen print and you can find a link to the interactive report further down.  I am very disappointed as I had spent the time analyzing the data using this tool because I thought Steemit users would find it of benefit, now I am posting a screenshot with a link….grrrrrrr....click here to open interactive dashboard)

If you would like to learn more about Power BI, I have a free course on my website – Power BI the Ultimate Orientation.  I do intend on creating how to Power BI posts, but in the meantime, please do feel free to sign up for the free course

I would love to hear your comments and feedback on this report and what you think it says about first impressions and retention 


H2
H3
H4
3 columns
2 columns
1 column
12 Comments