Business Metrics for Data-Driven Companies

Successfully completed “Business Metrics for Data-Driven Companies” by Duke University on Coursera. First step in a five step process. The main purpose was to get an understanding of data analysis and what Data Analysts do, because I get many of them on my Advanced Excel and Excel Power Pivot courses.

I am glad I did it, learned a lot that I can use in my own business. I’d recommend it!

Business Metrics for Data-Driven Companies

Signed up for “Business Metrics for Data-Driven Companies” the first course of a 5-course series, the Excel to MySQL: Analytic Techniques for Business Specialization. Enjoyed the Microsoft edX course I did recently, so I thought I’d do more.

Thought it was a fit and should help with the questions I get from Business Analysts on Excel and SharePoint Courses.

Add data to you Power Pivot using Power Query in 25 minutes

Lesson Two

Give me 25 minutes and I will show you how to add data to an existing Power Pivot using Power Query. Add data from Excel and CSV files.

This process is useful if you need to periodically add new data e.g. monthly.

Give me 28 minutes to introduce you to Power Pivot

Make your first step into Business Intelligence tools by using data in Excel worksheets and Power Pivot

Learn how to:
– add to data model
– create relationships
– add calculated columns
– create a pivot table
– see one approach for grouping by dates

Lesson One in a series where I aim to introduce you to the “Power Tools” for Excel 2013 and SharePoint

 

Is your Gum upside-down? The value of SharePoint 2010 Business Intelligence

I have just been catching up on my pod cast listening while cleaning up my office (a task worthy of Time Team and also really  requiring three days). Episode 56 of the SharePoint Pod Show (also available via iTunes) has an interesting interview with Jeff Huckaby. In the interview they discuss the practical application of reports in SharePoint to a nationwide Truck Stop business. Continue reading “Is your Gum upside-down? The value of SharePoint 2010 Business Intelligence”